PgSql
in [SQL]
|
[HACKERS] Partitioning/inherited tables vs FKs Hi, we came across an interesting problem. =# create table parent (id serial primary key, t text); NOTICE: CREATE TABLE will create implicit sequence "parent_id_seq" for serial column "parent.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parent_pkey" for table "parent" CREATE TABLE =#... 6 May 2010 05:16
possible memory leak with SRFs Hi, Continuing on this: Can someone please explain why we do not reset the expression context if an SRF is involved during execution? Once the current result from the SRF has been consumed, I would think that the ecxt_per_tuple_memory context should be reset. As its name suggests, it is supposed to a per tupl... 8 May 2010 13:24
On a somewhat disappointing correspondence Bruce Momjian wrote: We are not very good at _removing_ functionality/GUCs, and based on the discussion so far, I think there is a very slim chance we would get it right for 9.0, which is why I suggested converting it to a boolean and revisiting this for 9.1. There's some feedback you can only get ... 6 May 2010 00:55
construct_array() use with PQexec with binary data Kenneth Marshall <ktm(a)rice.edu> writes: I am working on adapting a regular PQexec() call to use binary transmission of the parameters. One of the parameters is an array of BIGINT. Looking in include/utils/array.h, it appears that construct_array() will do exactly what I need to get an array to pass in wi... 5 May 2010 21:36
[HACKERS] construct_array() use with PQexec with binary data Dear PostgreSQL development community, I am working on adapting a regular PQexec() call to use binary transmission of the parameters. One of the parameters is an array of BIGINT. Looking in include/utils/array.h, it appears that construct_array() will do exactly what I need to get an array to pass in with the PQ... 5 May 2010 21:36
On a somewhat disappointing correspondence (was:max_standby_delay considered harmful) Kevin Grittner wrote: Simon Riggs <simon(a)2ndQuadrant.com> wrote: I've refrained from comment on max_standby_delay because I have neither read the patch nor am likely to be an early adopter of HS; however, as a potential eventual user I have to say that the semantics for this GUC proposed by Simon se... 5 May 2010 20:30
[HACKERS] LD_LIBRARY_PATH versus rpath Over at http://archives.postgresql.org/pgsql-general/2010-05/msg00091.php we have a complaint about "make check" failing when the install is intended to overwrite existing libraries (in particular, replacing 8.4 with 9.0 libpq). I've done some off-list investigation and found that this appears to be a generic iss... 5 May 2010 19:24
[HACKERS] On a somewhat disappointing correspondence (was: max_standby_delay considered harmful) Simon Riggs <simon(a)2ndQuadrant.com> wrote: I've refrained from comment on max_standby_delay because I have neither read the patch nor am likely to be an early adopter of HS; however, as a potential eventual user I have to say that the semantics for this GUC proposed by Simon seem sane and useful to me. Certai... 5 May 2010 18:16
[HACKERS] patch: to_string, to_array functions Hello attached patch contains to_string and to_array functions. These functions are equivalent of array_to_string and string_to_array function with maybe more correct NULL handling. postgres=# select to_array('1,2,3,4,,6',','); to_array ------------------ {1,2,3,4,NULL,6} (1 row) postgres=# select ... 5 May 2010 14:54
[HACKERS] Upcoming back-branch updates The core team has agreed that the data-corruption bug fixed here http://archives.postgresql.org/pgsql-committers/2010-05/msg00016.php is serious enough to justify a prompt update release. Although that bug only affects 8.4 and HEAD, we have some other significant bug fixes pending in the older back branches, so we... 5 May 2010 13:47 |