Re: Re[BUGS] g: 25P02, current transaction is aborted, commands ignored until end of transaction block

2009-09-30 Thread Robert Haas
On Wed, Sep 30, 2009 at 5:23 AM, ajay labade wrote: >>     I am trying to port my application from Oracle to PostGREs. I have a >> problem while doing so. In my application i need to update record if the >> delete on the respective record is failed due to Constraint Violation. But >> SQL Error: 0,

Re: [BUGS] Bus Error in psql command history

2009-09-30 Thread Tom Lane
Alvaro Herrera writes: > I think Mac OS X ships a broken libreadline. What happens if you > compile with a stock one? FWIW, it's still broken in Snow Leopard :-(. Stack trace is (gdb) bt #0 0x000100097ccc in re_putc () #1 0x0001000981f6 in re_refresh () #2 0x000100097b67 in el_g

Re: [BUGS] BUG #5088: community account not working

2009-09-30 Thread Robert Haas
On Tue, Sep 29, 2009 at 11:15 PM, Ian Small wrote: > > The following bug has been logged online: > > Bug reference:      5088 > Logged by:          Ian Small > Email address:      i...@omniconnect.com.au > PostgreSQL version: any > Operating system:   any > Description:        community account no

Re: [BUGS] Bus Error in psql command history

2009-09-30 Thread Alvaro Herrera
Isaac Morland wrote: > I run psql on Mac OS X: > Please advise if you would like any more details about the > behaviour. I can think of a few things to investigate but none that > jumps out as the obvious thing to look into. I think Mac OS X ships a broken libreadline. What happens if you comp

[BUGS] Bus Error in psql command history

2009-09-30 Thread Isaac Morland
I run psql on Mac OS X: psql (8.4.1, server 8.4.0) Then paste the following in, having been copied from an XCode editor window: CREATE OR REPLACE FUNCTION compute_mw_realname ( nicknames text, givennames text, surname text ) RETURNS text AS $$ DECLARE first text;

Re: [BUGS] Weird behaviour of = ANY ( SUBQUERY ) ?

2009-09-30 Thread Tom Lane
hubert depesz lubaczewski writes: > Why this doesn't work: > # SELECT 1 = ANY( ( SELECT '{1,2}'::int4[]) ); > ERROR: operator does not exist: integer = integer[] > LINE 1: SELECT 1 = ANY( ( SELECT '{1,2}'::int4[]) ); > ^ Why would you expect it to work? The datatypes aren't co

[BUGS] BUG #5090: erro

2009-09-30 Thread Edinei
The following bug has been logged online: Bug reference: 5090 Logged by: Edinei Email address: edi...@guaporepecuaria.com.br PostgreSQL version: 8.4 Operating system: Windows XP Description:erro Details: gerencio uma uma aplicação que tem como sgbd o postgresql 8.0,

Re: Re[BUGS] g: 25P02, current transaction is aborted, commands ignored until end of transaction block

2009-09-30 Thread ajay labade
hi i am useing PostgreSQL 8.2 i got this error on console if any Solution Please try to contact me or send me any Solution fro that ajaylab...@gmail.com 2009-09-30 12:34:56,281 [org.springframework.orm.hibernate3.HibernateTemplate] DEBUG - Not closing pre-bound Hibernate Session after Hibernat

Re: Re[BUGS] g: 25P02, current transaction is aborted, commands ignored until end of transaction block

2009-09-30 Thread ajay labade
bhavani gade wrote: > > Dear all, > > I am trying to port my application from Oracle to PostGREs. I have a > problem while doing so. In my application i need to update record if the > delete on the respective record is failed due to Constraint Violation. But > SQL Error: 0, SQLState: 25P02

[BUGS] BUG #5089: not supported plpsql

2009-09-30 Thread Yamashkin Alex
The following bug has been logged online: Bug reference: 5089 Logged by: Yamashkin Alex Email address: defa...@smart-soft.ru PostgreSQL version: 8.4.0.1 Operating system: windows XP Embeded Description:not supported plpsql Details: good day. installing Postgresql 8.

[BUGS] BUG #5091: sqlDescribeCol incorrectly setting null flag for projection of a view

2009-09-30 Thread the6campbells
The following bug has been logged online: Bug reference: 5091 Logged by: the6campbells Email address: the6campbe...@gmail.com PostgreSQL version: 8.4.1 Operating system: windows Description:sqlDescribeCol incorrectly setting null flag for projection of a view Details:

[BUGS] Weird behaviour of = ANY ( SUBQUERY ) ?

2009-09-30 Thread hubert depesz lubaczewski
Version - 8.5devel. Why this doesn't work: # SELECT 1 = ANY( ( SELECT '{1,2}'::int4[]) ); ERROR: operator does not exist: integer = integer[] LINE 1: SELECT 1 = ANY( ( SELECT '{1,2}'::int4[]) ); ^ HINT: No operator matches the given name and argument type(s). You might need to