Re: [BUGS] BUG #6363: pgp_sym_encrypt() broken between 8.4 and 9.1

2011-12-29 Thread Alvaro Herrera
Excerpts from dean.w.schulze's message of mié dic 28 20:21:08 -0300 2011: > The following worked in 8.4, but fails in 9.1. (pgpcrypto is installed.) > > In 9.1 it looks like it doesn't recognize strings. > > insert into credentials values('demo', pgp_sym_encrypt('password', > 'longpassword'));

Re: [BUGS] BUG #6363: pgp_sym_encrypt() broken between 8.4 and 9.1

2011-12-29 Thread Magnus Hagander
On Thu, Dec 29, 2011 at 14:14, Alvaro Herrera wrote: > > Excerpts from dean.w.schulze's message of mié dic 28 20:21:08 -0300 2011: > >> The following worked in 8.4, but fails in 9.1.  (pgpcrypto is installed.) >> >> In 9.1 it looks like it doesn't recognize strings. >> >> insert into credentials v

[BUGS] BUG #6365: Memory leak in insert and update

2011-12-29 Thread havasvolgyi . otto
The following bug has been logged on the website: Bug reference: 6365 Logged by: Otto Havasvölgyi Email address: havasvolgyi.o...@gmail.com PostgreSQL version: 9.1.2 Operating system: Win XP SP2 x86; Linux Debian 2.6.32 kernel x64 Description: The bug can be reproduce

Re: [BUGS] BUG #6365: Memory leak in insert and update

2011-12-29 Thread Tom Lane
havasvolgyi.o...@gmail.com writes: > The following bug has been logged on the website: > Bug reference: 6365 > Logged by: Otto Havasvölgyi > Email address: havasvolgyi.o...@gmail.com > PostgreSQL version: 9.1.2 > Operating system: Win XP SP2 x86; Linux Debian 2.6.32 kernel x64

Re: [BUGS] BUG #6365: Memory leak in insert and update

2011-12-29 Thread Merlin Moncure
On Thu, Dec 29, 2011 at 2:10 PM, Tom Lane wrote: > havasvolgyi.o...@gmail.com writes: >> The following bug has been logged on the website: >> Bug reference:      6365 >> Logged by:          Otto Havasvölgyi >> Email address:      havasvolgyi.o...@gmail.com >> PostgreSQL version: 9.1.2 >> Operating

Re: [BUGS] with hold cursor, cause function execute twice and wrong result

2011-12-29 Thread Merlin Moncure
2011/12/27 wcting163 : > postgres=# select version(); >   version > > --- >  PostgreSQL 9.0alpha5 on x86_64-unknown-linux-

Re: [BUGS] BUG #6365: Memory leak in insert and update

2011-12-29 Thread Tom Lane
Merlin Moncure writes: > On Thu, Dec 29, 2011 at 2:10 PM, Tom Lane wrote: >> I see no memory leak with this example. > This is by the way a FAQ: > http://wiki.postgresql.org/wiki/FAQ#Why_does_PostgreSQL_use_so_much_memory.3F Well, to be fair, the FAQ entry didn't mention this behavior of report

Re: [BUGS] BUG #6365: Memory leak in insert and update

2011-12-29 Thread Havasvölgyi Ottó
Thanks for the quick response. Linux's top fooled me quite a bit. Excuse me for the false report. Best regards, Otto 2011/12/29 Tom Lane > havasvolgyi.o...@gmail.com writes: > > The following bug has been logged on the website: > > Bug reference: 6365 > > Logged by: Otto Havasvöl