Re: [BUGS] temporary tables, and lots of 0 byte files

2010-11-22 Thread Tom Lane
Jon Nelson writes: > Here is the problem: When I started benchmarking this application, I > noticed it (postgresql) started chewing up inodes on the logical > volume which houses /var/lib/pgsql. It chewed up a few thousand > inodes, and then a few thousand more, and then there were no more. > I

[BUGS] temporary tables, and lots of 0 byte files

2010-11-22 Thread Jon Nelson
I have an application which, during the normal course of its operation, creates a single temporary table. BEGIN; -- bunch of stuff here CREATE TEMPORARY TABLE results ON COMMIT DROP AS SELECT -- a bit more stuff here ROLLBACK; In this case, *every* transaction ends in a rollback. Here is the pr

[BUGS] BUG #5762: ecpg

2010-11-22 Thread Joaquim Salles
The following bug has been logged online: Bug reference: 5762 Logged by: Joaquim Salles Email address: joaquimsal...@gmail.com PostgreSQL version: 1.8.3 Operating system: linux - Centos 5.3 Description:ecpg Details: I'm porting a pro * c (oracle) to ecpg. In oracl

Re: [BUGS] BUG #5761: In 'dblink' function connection string truncated

2010-11-22 Thread Tom Lane
"dp" writes: > Description:In 'dblink' function connection string truncated > Details: > The connection info string in 'dblink' function truncated to 62 characters. > On execution: 'NOTICE: identifier "dbname=somebase host=xx.xxx.xx.xx > user=iamuser password=somepassword77 port=5432" w

[BUGS] BUG #5761: In 'dblink' function connection string truncated

2010-11-22 Thread dp
The following bug has been logged online: Bug reference: 5761 Logged by: dp Email address: priko...@gmail.com PostgreSQL version: 8.3.12 Operating system: Fedora release 14 (Laughlin) Description:In 'dblink' function connection string truncated Details: The connecti