PgSql

Fix for memory leak in dblink
On 01/11/2010 07:43 PM, Takahiro Itagaki wrote: There is a memory leak in dblink when we cancel a query during returning tuples. It could leak a PGresult because memory used by it is not palloc'ed one. I wrote a patch[1] before, but I've badly used global variables to track the resource. The attached... 21 Jan 2010 20:19

[HACKERS] bug in integration SQL parser to plpgsq
Hello it doesn't support EXPLAIN as possible begin of SQL statement: postgres=# create or replace function foo(_a int) returns void as $$declare s varchar; begin for s in explain select * from omega where a = _a loop raise notice '%', s; end loop; return; end; $$ language plpgsql; CREATE FUNCTION postgres=# ... 12 Jan 2010 08:08

NOT NULL violation and error-message
Andreas Joseph Krogh <andreak(a)officenet.no> wrote: ERROR: null value in column "created" violates not-null constraint It is easy to add the table name to the message, but ... ERROR: null value in column "public"."mytable"."created" violates not-null constraint Oracle does this btw... Do we have any... 12 Jan 2010 14:05

[HACKERS] planner or statistical bug on 8.5
Hello I checked query and I was surprised with very strange plan: postgres=# create table a(a int primary key); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "a_pkey" for table "a" CREATE TABLE postgres=# create table b(b int primary key); NOTICE: CREATE TABLE / PRIMARY KEY will create impl... 12 Jan 2010 08:08

[HACKERS] Fix for memory leak in dblink
There is a memory leak in dblink when we cancel a query during returning tuples. It could leak a PGresult because memory used by it is not palloc'ed one. I wrote a patch[1] before, but I've badly used global variables to track the resource. The attached is a cleaned up patch rewritten to use a tuplestore (SFRM_M... 12 Jan 2010 08:08

8.5alpha3 bug in information_schema.table_privileges
Robert Treat <xzilla(a)users.sourceforge.net> writes: pagila=# select * from information_schema.table_privileges; TRAP: FailedAssertion("!(idx[0] < (((int *) (((char *) (acl)) + sizeof(ArrayType)))[0]))", File: "acl.c", Line: 1740) server closed the connection unexpectedly This probably means the ... 12 Jan 2010 08:08

[COMMITTERS] pgsql: Also update ChangerLogfile.
Tom Lane wrote: Michael Meskes <meskes(a)postgresql.org> writes: On Fri, Jan 08, 2010 at 03:41:10PM +0100, Stefan Kaltenbrunner wrote: Hmm not sure I find that commit message really helpful - but is it actually of any use to maintain a Changelog file specifically for ECPG? Makes it easi... 12 Jan 2010 08:08

dbt2-shell script problem
On Mon, Jan 11, 2010 at 4:18 PM, Jonas J <autoramajj(a)gmail.com> wrote: I get the dbt2 project from the git tree. And i'm trying to make it work with postgres. The problem is in one of the dbt2 shell scripts. Since I dont understand of Shell Script Programing, here is my problem: (I will post the script on t... 14 Jan 2010 16:56

Compression Library and Usages
Dimitri Fontaine <dfontaine(a)hi-media.com> wrote: The topic came on IRC and it might be that the later attempts at using another library missed one of the offering, namely FastLZ. It's made for being quick rather than minimize size, it's MIT licenced, 551 lines of portable ansi-C code, already tested on a... 12 Jan 2010 08:08

[HACKERS] Compression Library and Usages
Hi, The topic came on IRC and it might be that the later attempts at using another library missed one of the offering, namely FastLZ. It's made for being quick rather than minimize size, it's MIT licenced, 551 lines of portable ansi-C code, already tested on a host of systems and compilers. http://www.fastlz... 11 Jan 2010 16:30