On May 22, 2007, at 14:57 , ;John D. Tiedeman wrote:
The following bug has been logged online:
Bug reference: 3297
Logged by: ;John D. Tiedeman
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.4
Operating system: Linux (Kubuntu 7.4)
Description:psql won't ope
adam terrey <[EMAIL PROTECTED]> writes at
http://archives.postgresql.org/pgsql-bugs/2007-05/msg00187.php
> Anyway, mybug: I have a test SELECT statement (Listing A - see "sql
> listings.txt") wich produces different results under two simular setups
> (Listing B and Listing C). Each setup should
adam terrey wrote:
> The second setup (Listing C) is identicle to the first execpt that the
> table "items" has an extra field and a primary key index. The goal of this
> setup is to produce a cirtian query plan that I beleive is broken, where
> it seems that the "Nested Loop Left Join" has for
The following bug has been logged online:
Bug reference: 3297
Logged by: ;John D. Tiedeman
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.4
Operating system: Linux (Kubuntu 7.4)
Description:psql won't open
Details:
Errer message says at least one client pack
On Tue, 22 May 2007, Max Khon wrote:
> Stephan Szabo wrote:
>
> > "delete from foo" fails:
> > ERROR: update or delete on table "bar" violates foreign key constraint
> > "foobar_fk0" on table "foobar"
> > SQL state: 23503
> > Detail: Key (bar_id)=(1) is still referenced from ta
"S. Robert James" <[EMAIL PROTECTED]> writes:
> If a FK is set to ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, it does
> not honor the defer.
> That is, if you DELETE a record and then INSERT it back, you still get a FK
> deletion of the referencing record. This seems to ignore DEFERRED.
Act
Hay all :)
Firstly, just wanted to say how much I appreceate all the hard work that
has gorn into postgres. It really is a fine system.
Anyway, mybug: I have a test SELECT statement (Listing A - see "sql
listings.txt") wich produces different results under two simular setups
(Listing B and Lis
The following bug has been logged online:
Bug reference: 3296
Logged by: S. Robert James
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Linux
Description:CASCADING FKs dont DEFER
Details:
If a FK is set to ON DELETE CASCADE DEFERRABLE INI
Stephan Szabo wrote:
> "delete from foo" fails:
> ERROR: update or delete on table "bar" violates foreign key constraint
> "foobar_fk0" on table "foobar"
> SQL state: 23503
> Detail: Key (bar_id)=(1) is still referenced from table "foobar".
> Context: SQL statement "DELETE
