FAQ

Search Discussions

458 discussions - 1,595 posts

  • Hi, I try to optimize our databases and I find a query that's not very optimal : sitefr=# explain select nomsession from session where nomsession='xxx'; NOTICE: QUERY PLAN: Seq Scan on session ...
    Jean-Christophe BoggioJean-Christophe Boggio
    Feb 17, 2001 at 12:35 am
    Feb 24, 2001 at 4:14 am
  • I've been using PostgreSQL for a few years now in various projects, and I've been very happy with its features and performance. I have a client who wants to know how PostgreSQL (7) will perform over ...
    Shaw TerwilligerShaw Terwilliger
    Feb 9, 2001 at 10:57 pm
    Feb 16, 2001 at 4:01 pm
  • Does pgsql support this and how would I do it? david
    David ReidDavid Reid
    Feb 14, 2001 at 3:04 pm
    Feb 17, 2001 at 6:50 pm
  • I have tried to install experimental Debian packages of Postgresql 7.1beta4, but get a dependency error with libssl09. My system is Debian inestable. I have a installed package of name libssl096, but ...
    DaVinciDaVinci
    Feb 6, 2001 at 9:41 am
    Feb 14, 2001 at 11:05 pm
  • Following the 'new type proposal' discussion recently I decided to have a play at creating an automatic trigger generator. Attached is the sql and an example of its use. Basically you call a ...
    Richard HuxtonRichard Huxton
    Feb 8, 2001 at 10:34 am
    May 9, 2001 at 10:52 am
  • Greetings. I'm working with a product provided by a third part that interfaces to data housed in a database of your choice. Previously, my choice was MySQL - apparently it handled certain queries too ...
    Brice RuthBrice Ruth
    Feb 6, 2001 at 5:04 am
    Feb 12, 2001 at 8:05 pm
  • I've been thinking on some new pesudo-types like SERIAL. 1) LAST_MODIFIED is the timestamp of that last time this row was modified. Easy enough to do currently with triggers. 2) TIME_CREATED is the ...
    Joseph ShraibmanJoseph Shraibman
    Feb 6, 2001 at 8:43 pm
    Feb 7, 2001 at 11:10 am
  • They're also archived on GeoCrawler: http://www.geocrawler.com/lists/3/Databases/ All the lists are there (-general, -novice, -hackers, etc), although I don't know how far back the archive goes. HTH, ...
    Neil ConwayNeil Conway
    Feb 23, 2001 at 3:15 am
    Feb 23, 2001 at 11:49 am
  • I am very new to PostgreSQL and have installed v7.03 on a Red Hat Linux Server (v6.2), I am accessing the files using JDBC from a Windows 2000 PC. I have created a small file as follows: CREATE TABLE ...
    Stephen LiveseyStephen Livesey
    Feb 27, 2001 at 1:04 pm
    May 31, 2001 at 8:13 pm
  • I can post info to PostgreSQL from a webform via JSP, and I can post reports from PostgreSQL to a webpage. Can anyone tell me how I might format a PostgreSQL report to a web page so that it will ...
    Richard EhrlichRichard Ehrlich
    Feb 20, 2001 at 8:00 pm
    Feb 22, 2001 at 7:20 pm
  • I am not sure how many people have looked at my book on Amazon.com, but I have received my first negative book review: ...
    Bruce MomjianBruce Momjian
    Feb 14, 2001 at 7:06 am
    Feb 16, 2001 at 6:18 pm
  • I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems to be the problem?
    <No Name><No Name>
    Feb 2, 2001 at 2:50 pm
    Feb 19, 2001 at 9:07 pm
  • I used to keep stuff in emails in mailbox until I saw someone reply, then I would delete it from my mailbox. Now, in the morning, when I have lots of emails, I can easily see if no one has replied ...
    Bruce MomjianBruce Momjian
    Feb 16, 2001 at 4:16 pm
    Feb 27, 2001 at 3:42 am
  • Are there any plans to provide a regular expression substitution function, similar to translate but allowing more complex substitutions? This is an example of what I want to use it for. I am using a ...
    Bruno Wolff IIIBruno Wolff III
    Feb 15, 2001 at 3:49 pm
    Feb 15, 2001 at 5:15 pm
  • Is there a way to check the last time a table was UPDATEd or INSERTEd? Is there a timestamp somewhere in the system tables? (If not that would be really useful to help in web page cacheing and ...
    Louis-David MitterrandLouis-David Mitterrand
    Feb 15, 2001 at 3:00 pm
    Mar 2, 2001 at 4:00 pm
  • As many of you know, I wrote a PostgreSQL book last year. It is selling very well. (http://www.postgresql.org/docs/awbook.html) Addison-Wesley is looking for more authors to write PostgreSQL books. ...
    Bruce MomjianBruce Momjian
    Feb 27, 2001 at 10:29 pm
    Mar 1, 2001 at 3:34 pm
  • Hi, In Oracle, there are 2 ways to do the equivalent of vacuum analyze : * analyze table xx compute statitics * analyze table xx estimate statistics In the second form, you can tell on what ...
    Jean-Christophe BoggioJean-Christophe Boggio
    Feb 20, 2001 at 9:30 am
    Feb 21, 2001 at 4:20 pm
  • A friend asked me to figure out how to access PostgreSQL from Tcl via ODBC. For posterity, here's the step by step "how I did it" that I emailed to him. I don't know Tcl, this was just about getting ...
    Dan LykeDan Lyke
    Feb 19, 2001 at 10:59 pm
    Feb 25, 2001 at 6:19 am
  • Is there any chance of adding a note about this to the docs? It does not seem to be documented anywhere! Maybe a note in ALTER TABLE (sql-altertable.htm) and changing the FAQ slightly to mention what ...
    Trewern, BenTrewern, Ben
    Feb 13, 2001 at 9:35 am
    Feb 14, 2001 at 3:58 pm
  • Hi, OK full text searching. Will the full text index catch changes in verb tense? i.e. will a search for woman catch women? I'm researching before I dive in to this later in the week so please excuse ...
    Culley HarrelsonCulley Harrelson
    Feb 5, 2001 at 3:22 pm
    Feb 8, 2001 at 3:42 pm
  • and according to the automatic_upgrade.log file elsewhere, it first balked at datatypes needing explicit casts (as if reading a sql source file from a database dump, which i can't seem to find) and ...
    Will trillichWill trillich
    Feb 28, 2001 at 6:27 am
    Feb 28, 2001 at 10:31 pm
  • The following query: SELECT tblSIDEDrugLink.DrugID, tblSIDEDrugLink.MedCondID, tblMedCond.PatientName AS MedCondPatientName, tblMedCond.ProfessionalName AS MedCondProfessionalName, ...
    Brice RuthBrice Ruth
    Feb 8, 2001 at 4:00 pm
    Feb 8, 2001 at 6:51 pm
  • Hi, I'm fairly new to PostreSQL, coming from MySQL. My Python application generates these MySQL commands: drop database if exists Foo; create database Foo; use Foo; Using the PostgreSQL online docs, ...
    Chuck EsterbrookChuck Esterbrook
    Feb 6, 2001 at 4:44 pm
    Feb 7, 2001 at 9:44 am
  • I've installed 7.1beta4 on a system that has never had PostgreSQL installed on it. configure, gmake, and gmake install, all worked fine. However, when I su over to postgres and run "initdb -D ...
    Tim BarnardTim Barnard
    Feb 4, 2001 at 9:53 pm
    Feb 6, 2001 at 3:28 pm
  • Hello pgsql-general, i need to calculate the memory requirement if i am using apache+pgsql. Lets assume that i want 160.000 hits a day and pgsql takes 3 seconds to work for each client, how much ram ...
    BorisBoris
    Feb 4, 2001 at 4:10 pm
    Feb 5, 2001 at 8:04 am
  • Hi, I have some questions regarding vacuum and backup... 1) Do we need to stop the postmaster process before we do a nightly vacuum analyze or pg_dump in version 7.0.3 of PostgreSQL? (I read ...
    Colleen WilliamsColleen Williams
    Feb 24, 2001 at 4:14 am
    Mar 2, 2001 at 1:26 pm
  • Help! I've recompiled pg. Here is what I did to correct 'too many clients' error I just change the following line in src/configure #define DEF_MAXBACKENDS 32 to #define DEF_MAXBACKENDS 100 Did I do ...
    NewsreaderNewsreader
    Feb 19, 2001 at 2:09 am
    Feb 19, 2001 at 5:42 am
  • create table vals ( x float, y float ); insert into vals values (2,4); insert into vals values (2,2); insert into vals values (2,1); insert into vals values (2,0); select x/y from vals where y 0 and ...
    Patrick WelchePatrick Welche
    Feb 16, 2001 at 6:25 pm
    Feb 17, 2001 at 2:07 am
  • Hello I need to make a program that uses pq++, before starting I made a little program to see if I understood correctly how to use pq++, however I have a problem: The program can't connect to the DB. ...
    Aristide AragonAristide Aragon
    Feb 26, 2001 at 2:34 pm
    Mar 6, 2001 at 4:44 pm
  • Hi I need some help with PostgreSQL installation over RedHat 7.0. I had a previously installed version of PostgreSQL server (postgresql-server-7.0.2-17.i386.rpm). I had though a problem with the RPM ...
    Paulo ParolaPaulo Parola
    Feb 22, 2001 at 7:06 pm
    Mar 1, 2001 at 12:43 pm
  • Hi people, I'm wondering if postgres could be capable of acting as a mail storage. This would imply storing messages, from 1KB to 100MB in size. The expected volume is 4000 messages a day, and the ...
    Morten W. PetersenMorten W. Petersen
    Feb 27, 2001 at 1:05 pm
    Feb 27, 2001 at 2:30 pm
  • Hi, I happenned to come across the following in the documentation on WAL implementation in v7.1 - ***************************************************** Before WAL, any crash during writing could ...
    Rini DuttaRini Dutta
    Feb 22, 2001 at 7:57 pm
    Feb 24, 2001 at 4:22 am
  • Actually, I responded a bit too hastily. That looks like a bug in psql to me. I see it in 7.0.3 as well. The query that psql is generating is incorrect: SELECT relhasindex, relkind, relchecks, ...
    Mike MascariMike Mascari
    Feb 16, 2001 at 3:50 am
    Feb 23, 2001 at 5:47 pm
  • Where can I download PostgreSQL v7.1? Please forward me to the URL where I can download it. Is there already binaries or do I have to compile it? TIA, Paulo
    Paulo ParolaPaulo Parola
    Feb 22, 2001 at 3:03 pm
    Feb 23, 2001 at 9:56 am
  • I'm having a problem here. I'm using Postgres 7.0.3 on a FreeBSD 4.2-RELEASE machine... it's a Pentium II/450 w/ 128MB of RAM (not nearly enough, but there'll be an upgrade soon). Anyway, I have a ...
    Dave EdmondsonDave Edmondson
    Feb 16, 2001 at 6:32 pm
    Feb 20, 2001 at 8:49 pm
  • Hello, I'm a bit new to postgres. Is there anyway to tell the current number of connections on a database or server? I'm having a connection closing problem and would like to debug it somehow. I know ...
    Steve McAteeSteve McAtee
    Feb 16, 2001 at 6:17 pm
    Feb 17, 2001 at 12:35 am
  • hi guys I posted this a few days back.. Reposting because i didnt get any answer.. Can any one point out whats wrong or if any has been facing a similar problem.. Thanx Anand ----- Forwarded message ...
    Anand RamanAnand Raman
    Feb 13, 2001 at 11:09 am
    Feb 16, 2001 at 1:35 pm
  • Has anybody used http://sourceforge.net/projects/pgsql ? I maintain production system based on Python and PostgreSQL. I currently use PoPy, but for a few reasons it doesn't satysfy me fully. The ...
    Marek PętlickiMarek Pętlicki
    Feb 28, 2001 at 6:19 pm
    Mar 9, 2001 at 5:26 pm
  • Any utilities around which would ease the pain involved in migrating an m$ sql6.5 database running on WinNT box to postgres running on a Linux box?? If no such utilities around - any advice on ...
    Steve O'HaganSteve O'Hagan
    Feb 26, 2001 at 2:38 pm
    Mar 2, 2001 at 2:26 pm
  • Hi, Can anyone help with the following error message in the output: pq_recvbuf: unexpected EOF on client connection Server process (pid 2087) exited with status 139 at Tue Feb 13 15:38:08 2001 ...
    Mark AllibanMark Alliban
    Feb 13, 2001 at 4:08 pm
    Mar 1, 2001 at 10:02 pm
  • Hi, I have managed to change the length of a varchar field to 100 using: update pg_attribute set atttypmod = 104 where attname = 'field_name' and attrelid = (select oid from pg_class where relname = ...
    TamsinTamsin
    Feb 1, 2001 at 3:46 pm
    Feb 28, 2001 at 9:11 am
  • I have the following query running on two different servers. It works on 7.0.3 and gives the following error on 7.1beta4. ERROR: Attribute 'last_name' not found Your SQL statement: SELECT first_name, ...
    Dan WilsonDan Wilson
    Feb 26, 2001 at 6:35 am
    Feb 26, 2001 at 4:54 pm
  • Just today I started to receive the below errors. Now that I've stopped and restarted mod_perl server and postmaster none the scripts which rely on DBI work anymore. Can someone help me?? At first ...
    NewsreaderNewsreader
    Feb 21, 2001 at 9:45 pm
    Feb 22, 2001 at 4:53 am
  • Hello, we have got a problem when executing some queries of tpch benchmark on PostgreSQL. For instance, the postgres parser do not accept the syntax of the query number 9: select nation2 , o_year, ...
    Victor Muntes MuteroVictor Muntes Mutero
    Feb 15, 2001 at 8:48 am
    Feb 19, 2001 at 3:48 pm
  • We are having what seems like a baffling problem to me. On occasion, our SELECTs will return zero rows when we know with certainty that they should be returning at least some rows. No error occurs, ...
    Matt FriedmanMatt Friedman
    Feb 13, 2001 at 7:54 pm
    Feb 17, 2001 at 11:58 pm
  • Hey guys, another strange question here.. If I query and order by a field and there are duplicate values in that field, what makes one return before the other? Just the first one that PG comes to on ...
    Mitch VincentMitch Vincent
    Feb 13, 2001 at 10:54 pm
    Feb 16, 2001 at 11:27 am
  • Any suggestions on how to select a random record from any given table? Culley
    Culley HarrelsonCulley Harrelson
    Feb 6, 2001 at 8:11 pm
    Feb 11, 2001 at 9:00 am
  • Hi, I am having problems with the number of open files on Redhat 6.1. The value of /proc/sys/fs/file-max is 4096 (the default), but this value is reached with about 50 ODBC connections. Increasing ...
    Mark AllibanMark Alliban
    Feb 6, 2001 at 1:30 pm
    Feb 8, 2001 at 1:04 am
  • Hi, Me and others are planning to move PG to ISO19100 compliance. ISO19100 is the future standard that is describing GIS systems. If you visit FMaps.sourceforge.net and go in the CVS you will see in ...
    Franck MartinFranck Martin
    Feb 1, 2001 at 10:23 pm
    Feb 6, 2001 at 11:26 pm
  • I have the following: CREATE FUNCTION RegistrarConexion(char(8),char(16),char(20)) RETURNS integer AS ' DECLARE ret integer; BEGIN INSERT INTO BitacoraConexion(username, IPmaquina, nombremaquina, ...
    Alfonso PenicheAlfonso Peniche
    Feb 2, 2001 at 12:21 am
    Feb 6, 2001 at 4:32 pm
Group Navigation
period‹ prev | Feb 2001 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions458
posts1,595
users399
websitepostgresql.org
irc#postgresql

399 users for February 2001

Tom Lane: 165 posts Bruce Momjian: 53 posts Peter Eisentraut: 46 posts Richard Huxton: 42 posts Stephan Szabo: 40 posts Mitch Vincent: 29 posts Joseph Shraibman: 27 posts Anand Raman: 21 posts Brett W. McCoy: 21 posts Brice Ruth: 21 posts Renaud Tthonnart: 21 posts Oliver Elphick: 18 posts Peniche Lopez Alfonso Jose: 18 posts David Wheeler: 16 posts Lincoln Yeoh: 16 posts Alex Pilosov: 14 posts Dan Wilson: 14 posts Gregory Wood: 14 posts Will trillich: 14 posts Newsreader: 13 posts
show more
Archives