[BUGS] BUG #6059: Out of tree build fails using Make 3.82

2011-06-14 Thread Perry Smith
The following bug has been logged online: Bug reference: 6059 Logged by: Perry Smith Email address: pedz...@gmail.com PostgreSQL version: 9.0.4 Operating system: AIX 5.3 and Mac 10.6.7 Description:Out of tree build fails using Make 3.82 Details: The failure is: /Us

Re: [BUGS] BUG #6057: regexp_replace & back references

2011-06-14 Thread Alvaro Herrera
Excerpts from Marc Mamin's message of mar jun 14 12:31:34 -0400 2011: > > The following bug has been logged online: > > Bug reference: 6057 > Logged by: Marc Mamin > Email address: m...@intershop.de > PostgreSQL version: 9.0.4 > Operating system: Windows > Description:

[BUGS] BUG #6058: psql password prompt

2011-06-14 Thread Rikard Pavelic
The following bug has been logged online: Bug reference: 6058 Logged by: Rikard Pavelic Email address: rikard.pave...@zg.htnet.hr PostgreSQL version: 9.1 beta2 Operating system: Windows 7 64 Description:psql password prompt Details: psql doesn't hide password in pro

[BUGS] BUG #6057: regexp_replace & back references

2011-06-14 Thread Marc Mamin
The following bug has been logged online: Bug reference: 6057 Logged by: Marc Mamin Email address: m...@intershop.de PostgreSQL version: 9.0.4 Operating system: Windows Description:regexp_replace & back references Details: select regexp_replace ('a','(a)','\\1'||sub

Re: [BUGS] BUG #5798: Some weird error with pl/pgsql procedure

2011-06-14 Thread Tom Lane
Merlin Moncure writes: > I bumped into the 'virtual tuple' error on 9.0.3 on a completely > unrelated query: > create table foo(a int, b int); > insert into foo select 1, 1 where not exists (select 1 from foo where > a = 1 for update); > 9.0.4 got rid of the error, but as there are no triggers o

Re: [BUGS] BUG #5798: Some weird error with pl/pgsql procedure

2011-06-14 Thread Merlin Moncure
On Mon, Feb 21, 2011 at 6:31 PM, Tom Lane wrote: > I wrote: >> Ugh.  That quick little "ExecRemoveJunk" is a lot more dangerous than it >> looks.  I had actually looked at this before, but concluded it was OK >> because I couldn't reproduce the problem with a trigger in place. >> I guess I wasn't

Re: [BUGS] BUG #6056: sorting issues

2011-06-14 Thread Itagaki Takahiro
On Tue, Jun 14, 2011 at 21:28, Michael Hepworth wrote: > Thanks for the response.  I have created a database with lc_collate = > en_US.utf8.  This doesn't seem to work.  I does however allow me to sort my > non english names correctly.  If I drop the database and recreate it with > lc_collate = C

Re: [BUGS] BUG #6056: sorting issues

2011-06-14 Thread hubert depesz lubaczewski
On Mon, Jun 13, 2011 at 09:52:06PM +, Mike Hepworth wrote: > I execute the following sql statment: > > select * from (values('HALL, ANDY'),('HALLBERG, FRANK'),('HALLDEN, > DOUGLAS'),('HALL, DOUGLAS') ) x ORDER BY 1; > > and get the following results > > HALL, ANDY > HALLBERG, FRANK > HALLDEN