[BUGS] BUG #6003: Cannot have a constraint foreign key on master class with inheritance

2011-05-03 Thread David carlos Manuelda
The following bug has been logged online: Bug reference: 6003 Logged by: David carlos Manuelda Email address: stormb...@gmail.com PostgreSQL version: 9.0.3 Operating system: Gentoo Linux Description:Cannot have a constraint foreign key on master class with inheritance

[BUGS] Plperl trigger variables no longer global

2011-05-03 Thread Greg Sabino Mullane
This works in 9.0 but not in git/9.1 beta: CREATE FUNCTION wheredidmytdgo() RETURNS TRIGGER LANGUAGE plperlu AS $bc$ use strict; use warnings; my $new = $_TD->{new}; return; $bc$; The error is: ERROR: Global symbol "$_TD" requires explicit package name at line 3. CONTEXT: compilati

Re: [BUGS] BUG #6003: Cannot have a constraint foreign key on master class with inheritance

2011-05-03 Thread hubert depesz lubaczewski
On Tue, May 03, 2011 at 10:12:53PM +, David carlos Manuelda wrote: > Is it a duplicate of what is in TODO and I understood it bad, or is this a > new issue? well, possibly neither. It's limitation well known, and described in docs: http://www.postgresql.org/docs/9.0/interactive/ddl-inherit.htm