[GENERAL] libpq error codes

Hello all, I try to add automatical connection restoring possibility to my app. And I have the following problem: When I execute query I have: query: 1024: 'select count(*) from pg_class' ResStatus: PGRES_TUPLES_OK Status: 0 ResStatus is the result of PQresultStatus, Status is the result of PQ

Re: [GENERAL] Sequences do not obey transactions...

Haroldo Stenger wrote: > And I add one of my own: It is not really necessary to have continuity in nearly > all apps. Your question is valid anyhow, but ask yourself: How does Oracle > resolve this? How would I program it myself by hand? And there you'll understand > the issue deeply. How funny i

Re: [GENERAL] Sequences do not obey transactions...

Ryan Kirkpatrick wrote: > Ryan, This issue has been asked & answered MANY times, once a week perhaps. I'll copy here what a folk answered once "You can't. Sequences are not designed for continuity, they are designed for uniqueness. If you want to have a set of contiguous numbers, in ascendi

Re: [GENERAL] ODBC drivers for Macintosh?

> Do the ODBC drivers compile for Macintosh? Actually, I've looked > at the source and it doesn't look like Mac was taken into > account, but, before my Macintosh CodeWarrior C compiler arrives > and I start hacking, has anyone attempted this? I think not. But we would welcome compatible patches

Re: [GENERAL] Sequences do not obey transactions...

That is not a bug, it is well documented behavior. PostgreSQL will NOT roll back a sequence for any reason, regardless of whether it is in a transaction that has been rolled back. Think of how you would have to code a sequence to support that type of behavior. In the case of multiple clients drawi

[GENERAL] Sequences do not obey transactions...

Either I am missing something or I found a bug in PostgreSQL. Hopefully it is the former. :) Simply, I am trying to use a sequence to generate unique id numbers for a table. Now, a number of the fields in this table have 'check constraints'. What happens, is if I attempt to insert

[GENERAL] Postgres with php3

Hello, I have setup a RH 6.2 box with postgres. The httpd (apache) has support for php3. But I don't know if the rh installation builds in the php3 support in postgres. I installed the pgadmin 2.0.2 but it did not find any database. Maybe this is becuase rh installs in different directories t

Re: [GENERAL] Bigger sequences (int8)

> Can I make a sequence use an int8 instead of int4? > > I have an application where, over a few years, it's quite possible to hit > the ~2 billion limit. (~4 billion if I start the sequence at -2 > billion.) > > There won't be that many records in the table, but there will be that many > inserts

Re: [GENERAL] Backend died while dropping index

> 1) Postgres 6.5.3 is a known quantity, and there are more people familiar > with > the common, critical problems, so there are more people who can help solve > problems. > 2) 7.0.2 undoubtedly has some new bugs and problems that are not >apparent yet - bugs that could sink a commercial bus

Re: [GENERAL] Backend died while dropping index

I respectfully disagree Tom, for various reasons: 1) Postgres 6.5.3 is a known quantity, and there are more people familiar with the common, critical problems, so there are more people who can help solve problems. 2) 7.0.2 undoubtedly has some new bugs and problems that are not apparent yet -

[GENERAL]

Dear friends, Can anyone tell me how to import tables stored in form of *.dbf files to tables in postgreSQL. thanks in advance, Gagan

[GENERAL] pg_hba.conf password authentication problem

Hi, I am using postgresql7.0.2 compiled using cygwinb20 on WinNT.Previously I was using postgres-6.5.3. The password based authentication is not working anymore.while checking the mail archive I noticed someone else also had this problem. So far I didn't see any workaround in the mail archiv

[GENERAL] Bigger sequences (int8)

Can I make a sequence use an int8 instead of int4? I have an application where, over a few years, it's quite possible to hit the ~2 billion limit. (~4 billion if I start the sequence at -2 billion.) There won't be that many records in the table, but there will be that many inserts. In othe

[GENERAL] ODBC drivers for Macintosh?

Do the ODBC drivers compile for Macintosh? Actually, I've looked at the source and it doesn't look like Mac was taken into account, but, before my Macintosh CodeWarrior C compiler arrives and I start hacking, has anyone attempted this? Oh, and can I directly post to pgsql-patches or is that a c

Re: [GENERAL] Perl interface

Hi Thomas, Web programming is usually done with CGI.pm, which works nicely with DBI.pm. This list is for postgres so I'll just point you to a website that might get you started. Try to get started. It takes a little getting used to, especia

[GENERAL] Please help - installation problem - configure output included

loading cache ./config.cachechecking host system type... i686-pc-linux-gnuchecking echo setting...checking setting template to... linux_i386checking whether to support locale... disabledchecking whether to support cyrillic recode... disabledchecking whether to support multibyte... disabledch

follow up RE: [GENERAL] Trigger with delete

you need to enable plpgsql AND use it as the lang of your function so LANGUAGE 'plpgsql'; thanks -Original Message- From: Marc Britten Sent: Tuesday, June 20, 2000 10:11 AM To: 'Matthias Teege'; [EMAIL PROTECTED] Subject: RE: [GENERAL] Trigger with delete 2 things one, you need to en

RE: [GENERAL] Trigger with delete

2 things one, you need to enable plpgsql as a lang see http://www.postgresql.org/docs/programmer/xplang.htm#XPLANG-TITLE for details two , triggers need to call functions that return 'opaque'. so after delete add return NEW; -Original Message- From: Matthias Teege [mailto:[EMAIL PROTE