Re: [BUGS] BUG #5770: Foreign key violation after insert

2010-11-26 Thread Martin Edlman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Tom, > "Martin Edlman" writes: >> I encountered this problem during migration of the database from PgSQL 8.4 >> (where it works) to PgSQL 9.0.1. > > For me, this example fails on both 8.4 and 9.0. It works on both after > removing the ill-consid

[BUGS] memory leak in xml2 contrib module

2010-11-26 Thread tv
Hi, one of my colleagues found ugly memory leak in the xml2 contrib module. Try this: select xpath_number('' || generate_series || '','/data') from generate_series(1,50); This will allocate arbitrary amount of memory, and it won't release it until the backend exits (user disconnects). We've

Re: [BUGS] BUG #5771: C:\Program Files\PostgreSQL\8.3\Data is not accessible.

2010-11-26 Thread Kevin Grittner
"Shafqat Ali" wrote: > Operating system: XP Professional SP3 > Description: C:\Program Files\PostgreSQL\8.3\Data is not > accessible. >From what little information you provided, this sounds more likely to be a permissions issue under Windows security than anything else. If you don't think it

[BUGS] BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme

2010-11-26 Thread Bala Murugan
The following bug has been logged online: Bug reference: 5773 Logged by: Bala Murugan Email address: b...@a-cti.com PostgreSQL version: 9.0.1 Operating system: Ubuntu Description:DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signa

Re: [BUGS] BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme

2010-11-26 Thread Craig Ringer
On 11/27/2010 02:06 AM, Bala Murugan wrote: The following bug has been logged online: Bug reference: 5773 Logged by: Bala Murugan Email address: b...@a-cti.com PostgreSQL version: 9.0.1 From ubuntu packages? compiled yourself? from 3rd party repository? Operating system: