[BUGS] FATAL: could not reattach to shared memory (key=412, addr=03C00000): 487

2008-09-09 Thread Daniel René Thul
Hello, my log files contains the following error message: ... 2008-09-09 11:03:36 CEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2008-09-09 11:03:38 CEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2008-09-09 11:03:38 CEST LOG: loaded library "$libdir/plugins/p

[BUGS] issue with postgres/xml

2008-09-09 Thread Cindy Moore
I looked through the lists and couldn't figure out where else to put this. I'm trying to create indices on xpath expressions for columns of type xml. I'm running postgres version 8.3.3, running on solaris. Text=# create index trclass on lsj_xml ((xpath ('//[EMAIL PROTECTED]"tr"]/text()', entry):

[BUGS] a question on postgres/xml

2008-09-09 Thread Cindy
I looked through the lists and couldn't figure out where else to put this. I'm trying to create indices on xpath expressions for columns of type xml. I'm running postgres version 8.3.3, running on solaris. Text=# create index trclass on lsj_xml ((xpath ('//[EMAIL PROTECTED]"tr"]/text()', entry)::

[BUGS] BUG #4412: Check constraints cannot be added to the table for fields that are mixed case

2008-09-09 Thread Kevin
The following bug has been logged online: Bug reference: 4412 Logged by: Kevin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.15 Operating system: Gentoo Linux Description:Check constraints cannot be added to the table for fields that are mixed case Details:

Re: [BUGS] BUG #4412: Check constraints cannot be added to the table for fields that are mixed case

2008-09-09 Thread Jaime Casanova
On Tue, Sep 9, 2008 at 3:11 PM, Kevin <[EMAIL PROTECTED]> wrote: > Description:Check constraints cannot be added to the table for > fields that are mixed case > Details: > > Check constraints cannot be added to the table for fields that are mixed > case. > > Example - field employeeName in

[BUGS] BUG #4413: LEFT JOIN not working as expected

2008-09-09 Thread David Jaquay
The following bug has been logged online: Bug reference: 4413 Logged by: David Jaquay Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Ubuntu Heron Description:LEFT JOIN not working as expected Details: I'm seeing a problem with a LEFT JO

Re: [BUGS] BUG #4412: Check constraints cannot be added to the table for fields that are mixed case

2008-09-09 Thread Stephan Szabo
On Tue, 9 Sep 2008, Kevin wrote: > The following bug has been logged online: > > Bug reference: 4412 > Logged by: Kevin > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.15 > Operating system: Gentoo Linux > Description:Check constraints cannot be added to

Re: [BUGS] BUG #4413: LEFT JOIN not working as expected

2008-09-09 Thread Jaime Casanova
On Tue, Sep 9, 2008 at 3:28 PM, David Jaquay <[EMAIL PROTECTED]> wrote: > > Description:LEFT JOIN not working as expected > Details: > > I'm seeing a problem with a LEFT JOIN. The sql below demonstrates the > issue. > > What I expect to see is no rows in the output, i.e. the LEFT JOIN shou

Re: [BUGS] BUG #4413: LEFT JOIN not working as expected

2008-09-09 Thread Tom Lane
"David Jaquay" <[EMAIL PROTECTED]> writes: > I'm seeing a problem with a LEFT JOIN. The sql below demonstrates the > issue. Yeah, this is a known bug: http://archives.postgresql.org/pgsql-bugs/2008-06/msg00175.php It's fixed in CVS but we haven't made a new release since then. If you don't mind