Re: [BUGS] BUG #5607: memmory leak in ecpg

2010-08-06 Thread Michael Meskes
I guess the described problems are identical. Feel free to apply the memleal patch. Michael "Kevin Grittner" schrieb: >"Marcelo Mas" wrote: > >> Valgrind reports memmory leak when getting decimal data. > >I wonder how much overlap there is between this and the patch for >fixing ECPG memor

Re: [BUGS] BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same

2010-08-06 Thread Frank Heikens
The manual looks fine, I found the information as well. I started using the wiki, that's why I got confused. Thanks! Frank -Oorspronkelijk bericht- Van: Tom Lane [mailto:t...@sss.pgh.pa.us] Verzonden: vrijdag 6 augustus 2010 17:04 Aan: Frank Heikens CC: pgsql-bugs@postgresql.org Onderwe

Re: [BUGS] BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same

2010-08-06 Thread Frank Heikens
Hi Tom, The wikipage says > a deferrable constraint CAN be checked at the end of a > transaction. You still have to ask PostgreSQL to defer it. http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.0#DEFERRABLE_UNIQUE_CONSTRAINTS I don't have to ask PostgreSQL to defer, it works in the sec

Re: [BUGS] BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same

2010-08-06 Thread Tom Lane
Dean Rasheed writes: > On 6 August 2010 16:25, Tom Lane wrote: >> I edited that wiki section, see what you think. > Yes, that's much better. I didn't read this page until just now. > I did, however, read the release notes, and I didn't spot a similar error > there: > """ > This allows UPDATE

Re: [BUGS] BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same

2010-08-06 Thread Dean Rasheed
On 6 August 2010 16:25, Tom Lane wrote: > Frank Heikens writes: >>> http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.0#DEFERRABLE_UNIQUE_CONSTRAINTS > >>> I don't have to ask PostgreSQL to defer, it works in the second test >>> as well in the third test without any changes. I guess th

Re: [BUGS] BUG #5605: round(attr_name,int) works bad

2010-08-06 Thread Tom Lane
Alex Hunsaker writes: > On Fri, Aug 6, 2010 at 02:12, Adam Radlowski >> select round(any_numeric_field*something,2) from any_table; >> I get information, that the function dos not exist. > Can we get the exact *input* and the error? I cant replicate it here: > select round(100::numeric*100, 2);

Re: [BUGS] BUG #5605: round(attr_name,int) works bad

2010-08-06 Thread Alex Hunsaker
On Fri, Aug 6, 2010 at 02:12, Adam Radlowski wrote: > PostgreSQL version: 8.4.4 > Operating system:   Gentoo 64 bit (PSQL 8.4.4), Fedora 12 32 bit (PSQL > 8.4.1) > select round(any_numeric_field*something,2) from any_table; > I get information, that the function dos not exist. Can we get the exa

Re: [BUGS] BUG #5607: memmory leak in ecpg

2010-08-06 Thread Kevin Grittner
"Marcelo Mas" wrote: > Valgrind reports memmory leak when getting decimal data. I wonder how much overlap there is between this and the patch for fixing ECPG memory leaks offered by Zoltán Böszörményi three days ago. There was much discussion about the dynamic UPDATE/DELETE WHERE CURRENT OF p

Re: [BUGS] BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same

2010-08-06 Thread Tom Lane
Frank Heikens writes: >> http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.0#DEFERRABLE_UNIQUE_CONSTRAINTS >> I don't have to ask PostgreSQL to defer, it works in the second test >> as well in the third test without any changes. I guess the example in >> the wiki isn't correct, right?

Re: [BUGS] BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same

2010-08-06 Thread Tom Lane
Frank Heikens writes: > The wikipage says >> a deferrable constraint CAN be checked at the end of a >> transaction. You still have to ask PostgreSQL to defer it. > http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.0#DEFERRABLE_UNIQUE_CONSTRAINTS > I don't have to ask PostgreSQL to defe

[BUGS] BUG #5607: memmory leak in ecpg

2010-08-06 Thread Marcelo Mas
The following bug has been logged online: Bug reference: 5607 Logged by: Marcelo Mas Email address: m...@atg.com.uy PostgreSQL version: 8.4.4 Operating system: Suse 10 Description:memmory leak in ecpg Details: Valgrind reports memmory leak when getting decimal data.

Re: [BUGS] BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same

2010-08-06 Thread Tom Lane
"Frank Heikens" writes: > Description:DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the > same This test proves no such thing. You are supposing that a deferrable unique index has the exact same behavior as a nondeferrable one. Actually, a DEFERRABLE IMMEDIATE index enforces its chec

[BUGS] BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same

2010-08-06 Thread Frank Heikens
The following bug has been logged online: Bug reference: 5606 Logged by: Frank Heikens Email address: f.heik...@anva.nl PostgreSQL version: PostgreSQL9.0b4 Operating system: WinXP Description:DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same Details: Today

[BUGS] Re: BUG #5602: Recovering from Hot-Standby file backup leads to the currupted indexes

2010-08-06 Thread Chris
Hi all, the procedure that waits for the checkpoint location change looks like:: function wait_for_checkpoint_location_change() { PRE_WAIT=$( pg_controldata $PGDATA | awk -F: '/Latest checkpoint location/ { print $2 }' ) log "Waiting for checkpoint" while true ; do sleep 5

[BUGS] BUG #5605: round(attr_name,int) works bad

2010-08-06 Thread Adam Radlowski
The following bug has been logged online: Bug reference: 5605 Logged by: Adam Radlowski Email address: ad...@informatyka.gdansk.pl PostgreSQL version: 8.4.4 Operating system: Gentoo 64 bit (PSQL 8.4.4), Fedora 12 32 bit (PSQL 8.4.1) Description:round(attr_name,int) wo