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

2009-08-14 Thread Radoslaw Zielinski *EXTERN*
Albe Laurenz laurenz.a...@wien.gv.at [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 without errors

[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] 8.4.0 bug - failure to enforce a foreign key constraint

2009-08-13 Thread Radoslaw Zielinski
Grzegorz Jaśkiewicz gryz...@gmail.com [2009-08-13 14:23]: On Thu, Aug 13, 2009 at 12:36 PM, Radoslaw Zielinskira...@pld-linux.org wrote: [...]      kandydaci_fk_id_rekordu FOREIGN KEY (id_rekordu) REFERENCES rekordy(id) ON DELETE CASCADE [...] since you do LEFT JOIN, indeed you can get r.id

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 [EMAIL