PgSql

[HACKERS] Postgres 9.0 Alpha, GIN indexes, and intarray contrib module, and SQL Functions
Greetings, I'm using the intarray contrib module[1] gin indexes on arrays (obviously) with postgres 9 alpha 4. I am querying to see the existence of an element. When I do the query normally, it performs as I'd expect (very fast). The explain plan looks like what I'd expect, using the index and whatnot. When ... 26 Mar 2010 11:58

Proposal: access control jails (and introduction as aspiring GSoC student)
On 3/26/10 5:42 AM +0200, Joseph Adams wrote: // New libpq function pg_set('current_user', 'bob'); $result = pg_query_params( 'SELECT answer FROM secrets WHERE user=current_user AND question=$1', array('Birth place')); What this really does is something like: $result = pg_query_params... 26 Mar 2010 10:23

Ask help for putting SP-Gist into postgresql
Pei He wrote: I am trying to put the SP-Gist package, a general index framework for space partitioning trees , into Postgresql source code. SP-Gist was developed for postgresql 8.0. However, now it does not work with the new version. So, for the submitted patch, what version of postgresql is requ... 26 Mar 2010 04:41

[HACKERS] Remove ROW | ROWS from OFFSET and FETCH
Hi, I was wondering if it might be worth making ROW/ROWS optional for OFFSET and FETCH clauses? And can ONLY be optional too? So: OFFSET start { ROW | ROWS } FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY Would become OFFSET start [ ROW | ROWS ] FETCH { FIRST | NEXT } [ count ] [ ROW | ROWS ] [... 25 Mar 2010 20:54

question (or feature-request): over ( partition by ... order by LIMIT N)
On Thu, Mar 25, 2010 at 5:17 PM, David Fetter <david(a)fetter.org> wrote: On Wed, Mar 24, 2010 at 06:31:59PM +0100, A. Kretschmer wrote: Hello @all, I know, i can do: select * from (select ... row_number() over (...) ...) foo where row_number < N to limit the rows per group, but the inn... 25 Mar 2010 23:11

question (or feature-request): over ( partition by ...order by LIMIT N)
On Wed, Mar 24, 2010 at 06:31:59PM +0100, A. Kretschmer wrote: Hello @all, I know, i can do: select * from (select ... row_number() over (...) ...) foo where row_number < N to limit the rows per group, but the inner select has to retrieve the whole set of records and in the outer select mo... 25 Mar 2010 17:26

Conditional trigger missing from pg_dump
Josh Berkus <josh(a)agliodbs.com> writes: It looks like pg_dump was never modified to include conditional triggers. If you look in pg_dump.c, there's no provision to dump the FOR UPDATE OF part of the trigger declaration. That proves nothing; it could be relying on server-side code to produce the declaratio... 25 Mar 2010 14:59

[HACKERS] Ask help for putting SP-Gist into postgresql
Hi, I am trying to put the SP-Gist package, a general index framework for space partitioning trees , into Postgresql source code. SP-Gist was developed for postgresql 8.0. However, now it does not work with the new version. So, for the submitted patch, what version of postgresql is required? And, is there any... 25 Mar 2010 10:17

pgsql: Make standby server continuouslyretry restoring the next WAL
Simon Riggs wrote: On Thu, 2010-03-25 at 11:08 +0900, Fujii Masao wrote: And if the trigger file is found, I think that the startup process should emit a FATAL, i.e., the server should exit immediately, to prevent the server from becoming the primary in a half-finished state. Please remember ... 25 Mar 2010 06:52

pgsql: Make standby servercontinuously retry restoring the next WAL
On Thu, 2010-03-25 at 10:11 +0200, Heikki Linnakangas wrote: PANIC seems like the appropriate solution for now. It definitely is not. Think some more. -- Simon Riggs www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscrip... 25 Mar 2010 16:13