Re: [BUGS] BUG #4520: Cases where a forign key constraint is not inforced and when it is incorrectly inforced.

2008-11-11 Thread Tom Lane
"Adam Terrey" <[EMAIL PROTECTED]> writes: > There are two bugs I wish to report they are: See "Caveats" at the bottom of http://www.postgresql.org/docs/8.3/static/ddl-inherit.html Don't hold your breath waiting for a fix --- no one knows how to make this work nicely. rega

[BUGS] BUG #4520: Cases where a forign key constraint is not inforced and when it is incorrectly inforced.

2008-11-11 Thread Adam Terrey
The following bug has been logged online: Bug reference: 4520 Logged by: Adam Terrey Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.4 Operating system: Linux Debian 2.6.18-6-amd64 Description:Cases where a forign key constraint is not inforced and when it i

Re: [BUGS] BUG #4509: array_cat's null behaviour is inconsistent

2008-11-11 Thread Peter Eisentraut
Tom Lane wrote: It's really all kind of messy ... we need to trade off simplicity of definition, ease of use, backwards compatibility, and standards compliance (though the standard has only 1-D arrays so it's of just limited help here). AFAICT, the standard would certainly allow a type specific

[BUGS] SHARED LIBRARY IS NOT CREATED:Postgres could not create support for plperl

2008-11-11 Thread Dey, Sutapa
Hi All, I am trying to build/enable plperl support for postgres. 1. The system info is : # uname -a HP-UX unknown B.11.23 U 9000/800 1178464650 unlimited-user license 2. The steps I followed: a) In postgres user's .profile file I had set : export LD_LIBRARY_PATH=/opt/pgsql/lib/:/

[BUGS] possible array parsing bug

2008-11-11 Thread Jeff Davis
This does not look right to me: =# select regexp_split_to_array('dsf,sdfsdf',',')::text[][100]; regexp_split_to_array --- {dsf,sdfsdf} (1 row) Is this known? Regards, Jeff Davis -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make change

Re: [BUGS] possible array parsing bug

2008-11-11 Thread Tom Lane
Jeff Davis <[EMAIL PROTECTED]> writes: > This does not look right to me: > =# select regexp_split_to_array('dsf,sdfsdf',',')::text[][100]; Perhaps you meant to write select (regexp_split_to_array('dsf,sdfsdf',',')::text[])[100]; As-is, the [10] is just useless decoration on the c

[BUGS] SHARED LIBRARY IS NOT CREATED:Postgres could not create support for plperl

2008-11-11 Thread Dey, Sutapa
Hi All, I am trying to build/enable plperl support for postgres. 1. The system info is : # uname -a HP-UX unknown B.11.23 U 9000/800 1178464650 unlimited-user license 2. The steps I followed: a) In postgres user's .profile file I had set : export LD_LIBRARY_PATH=/opt/pgsql/lib/:/