Re: [BUGS] Deferred Referential Constraint: Changing Referenced Key

2005-06-29 Thread Stephan Szabo
> -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi there, > > I was wondering if it is a bug or a feature. When I change a key on a > referenced table, and there is a foreign key deferred constraint, it > triggers imediately, not at the end of transaction. > > If I change the reference first

[BUGS] Deferred Referential Constraint: Changing Referenced Key

2005-06-29 Thread Daniel Cristian Cruz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi there, I was wondering if it is a bug or a feature. When I change a key on a referenced table, and there is a foreign key deferred constraint, it triggers imediately, not at the end of transaction. If I change the reference first, it works as expe

Re: [BUGS] BUG #1736: endless loop in PQconnectdb

2005-06-29 Thread Karsten Desler
* Bruce Momjian wrote: > Yes, please --- the patch is at: > > http://archives.postgresql.org/pgsql-patches/2005-06/msg00486.php Thanks. I've applied the patch now, and I'll keep you posted. Best regards, Karsten Desler ---(end of broadcast)

[BUGS] BUG #1739: memory leak in pl/perl with spi_exec_query

2005-06-29 Thread Jean-Max Reymond
The following bug has been logged online: Bug reference: 1739 Logged by: Jean-Max Reymond Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Linux Ubuntu Description:memory leak in pl/perl with spi_exec_query Details: whith this code 1, pos

Re: [BUGS] BUG #1735: row number -1 is out of range 0..-1 error

2005-06-29 Thread Michael Fuhr
On Tue, Jun 28, 2005 at 07:03:06PM +0200, Andreas Pflug wrote: > > "3";"12";"0";"7 days > > is the result I'm getting in pgadmin. Same here in psql: id | seconds | accumulate | period +-++ 3 | 12 | 0 | 7 days (1 row) Borislav, apparently somethi