[BUGS] BUG #3886: pgsql NEW dinamic columns change

2008-01-18 Thread ing. Ovidiu Tanasiciuc
The following bug has been logged online: Bug reference: 3886 Logged by: ing. Ovidiu Tanasiciuc Email address: [EMAIL PROTECTED] PostgreSQL version: 8.25 Operating system: Windows Xp Description:pgsql NEW dinamic columns change Details: Hi. I want to make a trigger

Re: [BUGS] BUG #3881: lo_open leaks memory

2008-01-18 Thread Tom Lane
Michael Akinde <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Hmm, I cannot replicate any memory leak with your example. >> I'm testing 8.2.6 (well, really 8.2 branch tip) not 8.2.5, but I >> don't recall that there were any recent fixes in this area. >> Perhaps there is some contributing factor

Re: [BUGS] BUG #3881: lo_open leaks memory

2008-01-18 Thread Michael Akinde
Tom Lane wrote: "Michael Akinde" <[EMAIL PROTECTED]> writes: Description:lo_open leaks memory Hmm, I cannot replicate any memory leak with your example. I'm testing 8.2.6 (well, really 8.2 branch tip) not 8.2.5, but I don't recall that there were any recent fixes in this area.

Re: [BUGS] BUG #3883: Autovacuum deadlock with truncate?

2008-01-18 Thread Tom Lane
"Steven Flatt" <[EMAIL PROTECTED]> writes: > (gdb) p *bufHdr > $1 = {tag = {rnode = {spcNode = 1663, dbNode = 16384, relNode = 85707}, > blockNum = 0}, flags = 70, usage_count = 5, refcount = 2, > wait_backend_pid = 35775, buf_hdr_lock = 0 '\0', buf_id = 14407, > freeNext = -2, io_in_progre

Re: [BUGS] BUG #3883: Autovacuum deadlock with truncate?

2008-01-18 Thread Steven Flatt
On 1/17/08, Tom Lane <[EMAIL PROTECTED]> wrote: > Do you still have the hung processes available? It would be really > useful to take a look at the buffer header that the autovac process's > LockBufferForCleanup() is working on. (In gdb, "f 3" then "p *bufHdr") Well I just lost the hung processe

[BUGS] BUG #3885: cant create database

2008-01-18 Thread sharvari
The following bug has been logged online: Bug reference: 3885 Logged by: sharvari Email address: [EMAIL PROTECTED] PostgreSQL version: dont know Operating system: linux Description:cant create database Details: actually first time db was created but after restarting

Re: [BUGS] Minor mathematical error in documentation

2008-01-18 Thread Russell Smith
Tom Lane wrote: Russell Smith <[EMAIL PROTECTED]> writes: In-equality transformations do not guarantee that y > 1.5x == y/x > 1.5. This is only true for x>0, y < 1.5*x for x<0. I have not posted a patch as I'm not sure what is the best way to change the example. Seems a bit nit-pick