Re: [GENERAL] 8.4.0 bug - failure to enforce a foreign key constraint

2009-08-14 Thread Radoslaw Zielinski *EXTERN*
Albe Laurenz [2009-08-14 07:34]: > Radoslaw Zielinski wrote: [...] >> The "orphans" count should be 0, obviously. > Just to make sure that there is really an inconsistency: > Could you pg_dump both tables and try to load them into > another database? If that works

Re: [GENERAL] 8.4.0 bug - failure to enforce a foreign key constraint

2009-08-13 Thread Radoslaw Zielinski
Grzegorz Jaśkiewicz [2009-08-13 14:23]: > On Thu, Aug 13, 2009 at 12:36 PM, Radoslaw Zielinski > wrote: [...] >>      "kandydaci_fk_id_rekordu" FOREIGN KEY (id_rekordu) REFERENCES >> rekordy(id) ON DELETE CASCADE [...] > since you do LEFT JOIN, indeed you can g

[GENERAL] 8.4.0 bug - failure to enforce a foreign key constraint

2009-08-13 Thread Radoslaw Zielinski
Hello, I have reported this yesterday via WWW as bug 4979, but I can't see it in the -bugs archive. Has it been lost or are the bug reports being moderated...? Anyway. Pg 8.4.0 from yum.postgresql.org running on 64bit RHEL 5.3. radek=# \d kandydaci Table "public.kandydaci"

Re: [GENERAL] Fwd: sql_type tinterval not supported by DBD::Pg

2008-05-23 Thread Radoslaw Zielinski
Filip Rembiałkowski <[EMAIL PROTECTED]> [23-05-2008 10:58]: [...] > the same with interval type: [...] > calling bind_param( 6, '14 days', { 'pg_type' => 1186 } ) > Cannot bind 6, sql_type interval not supported by DBD::Pg http://rt.cpan.org/Ticket/Display.html?id=36138 -- Radosław Zieliński <[E