Re: [GENERAL] foreign key from array element

2012-09-23 Thread Gabriele Bartolini
Hi Rafal, Il 24/09/12 07:54, Rafal Pietrak ha scritto: I did what I could - the review is on the hackers list. Thanks! That's much appreciated. Should I do anything else to finilize this review, like "linking" it to the pending patch? somehow? -R You should update the commitfest.postgresq

Re: [GENERAL] foreign key from array element

2012-09-23 Thread Rafal Pietrak
On Tue, 2012-09-18 at 09:37 +0200, Albe Laurenz wrote: > Rafal Pietrak wrote: > > On Mon, 2012-09-17 at 14:31 -0500, Merlin Moncure wrote: > > > On Mon, Sep 17, 2012 at 7:24 AM, Rafal Pietrak > > > wrote: [] > > > > Who can review that patch? > > You :^) > I did what I could - the r

Re: [GENERAL] foreign key from array element

2012-09-20 Thread Chris Travers
On Thu, Sep 20, 2012 at 12:18 AM, Gabriele Bartolini < gabriele.bartol...@2ndquadrant.it> wrote: > Hi Chris, > >thank you very much for taking the time to read the article and get > into the features proposed with our patch. You are welcome. Also in case there is ambiguity, the feature I wa

Re: [GENERAL] foreign key from array element

2012-09-20 Thread Gabriele Bartolini
Hi Chris, thank you very much for taking the time to read the article and get into the features proposed with our patch. On Tue, 18 Sep 2012 17:17:56 -0700, Chris Travers wrote: So those are the cautions and why I don't think a feature like this is suitable for routine usage, but truth b

Re: [GENERAL] foreign key from array element

2012-09-19 Thread Rafal Pietrak
On Tue, 2012-09-18 at 18:39 -0400, Tom Lane wrote: > Rafal Pietrak writes: > > postmaster/postmaster.o: In function `PostmasterMain':^M > > postmaster.c:(.text+0x4bc8): undefined reference to `optreset'^M > > tcop/postgres.o: In function `process_postgres_switches':^M > > postgres.c:(.text+0x1422)

Re: [GENERAL] foreign key from array element

2012-09-19 Thread Gabriele Bartolini
Ciao Rafal, You can download the refreshed version of the patch: http://archives.postgresql.org/message-id/1347983571.11539.14.ca...@greygoo.devise-it.lan 5. where do I get current-v9.3 from? git clone git://git.postgresql.org/git/postgresql.git cd postgresql git checkout -b aefk bzcat Arra

Re: [GENERAL] foreign key from array element

2012-09-18 Thread Chris Travers
On Tue, Sep 18, 2012 at 6:12 AM, Gabriele Bartolini < gabriele.bartol...@2ndquadrant.it> wrote: > Hi Rafal, > > Il 18/09/12 13:00, Rafal Pietrak ha scritto: > > I did have a look, and feel slightly encouraged reading: "Many people >> feel that they're not qualified"; yes, that's me all right. Ser

Re: [GENERAL] foreign key from array element

2012-09-18 Thread Tom Lane
Rafal Pietrak writes: > postmaster/postmaster.o: In function `PostmasterMain':^M > postmaster.c:(.text+0x4bc8): undefined reference to `optreset'^M > tcop/postgres.o: In function `process_postgres_switches':^M > postgres.c:(.text+0x1422): undefined reference to `optreset'^M > utils/misc/ps_status.

Re: [GENERAL] foreign key from array element

2012-09-18 Thread Rafal Pietrak
On Tue, 2012-09-18 at 15:38 -0500, Kevin Grittner wrote: > Rafal Pietrak wrote: > > where do I get current-v9.3 from? > > At this point 9.3 just means the HEAD of the master branch of the > git repository, which is where development for the next major > release of software is always done. For d

Re: [GENERAL] foreign key from array element

2012-09-18 Thread Kevin Grittner
Rafal Pietrak wrote: > where do I get current-v9.3 from? At this point 9.3 just means the HEAD of the master branch of the git repository, which is where development for the next major release of software is always done. For details of the public git repository see: http://git.postgresql.org/

Re: [GENERAL] foreign key from array element

2012-09-18 Thread Rafal Pietrak
Hi, On Tue, 2012-09-18 at 15:12 +0200, Gabriele Bartolini wrote: > Hi Rafal, [] > > It is such a coincidence that yesterday I had started to write this > article > (http://blog.2ndquadrant.com/postgresql-9-3-development-array-element-foreign-keys/) > > about this feature for 9.3

Re: [GENERAL] foreign key from array element

2012-09-18 Thread Gabriele Bartolini
Hi Rafal, Il 18/09/12 13:00, Rafal Pietrak ha scritto: I did have a look, and feel slightly encouraged reading: "Many people feel that they're not qualified"; yes, that's me all right. Serously, I will try to do by best ... by the weekend, when I get some spare time. It is such a coincidence

Re: [GENERAL] foreign key from array element

2012-09-18 Thread Rafal Pietrak
On Tue, 2012-09-18 at 09:37 +0200, Albe Laurenz wrote: > Rafal Pietrak wrote: [--] > > > > Who can review that patch? > > You :^) ;7 OK. (still smiling a little) [---] > Here is information about what is required: > http://wiki.postgresql.org/wiki/Reviewing_a_Patch

Re: [GENERAL] foreign key from array element

2012-09-18 Thread Chris Travers
On Tue, Sep 18, 2012 at 12:37 AM, Albe Laurenz wrote: > > > You :^) > > The list of patches for the commitfest is here: > https://commitfest.postgresql.org/action/commitfest_view?id=15 > > There is no reviewer for "Array ELEMENT Foreign Keys" yet. > > Silly question perhaps better saved for the re

Re: [GENERAL] foreign key from array element

2012-09-18 Thread Albe Laurenz
Rafal Pietrak wrote: > On Mon, 2012-09-17 at 14:31 -0500, Merlin Moncure wrote: > > On Mon, Sep 17, 2012 at 7:24 AM, Rafal Pietrak > > wrote: > > > On Mon, 2012-09-17 at 19:58 +0800, Craig Ringer wrote: > > >> On 09/17/2012 04:46 PM, Rafal Pietrak wrote: > > > [--] > > >> There was so

Re: [GENERAL] foreign key from array element

2012-09-18 Thread Rafal Pietrak
On Mon, 2012-09-17 at 14:31 -0500, Merlin Moncure wrote: > On Mon, Sep 17, 2012 at 7:24 AM, Rafal Pietrak > wrote: > > On Mon, 2012-09-17 at 19:58 +0800, Craig Ringer wrote: > >> On 09/17/2012 04:46 PM, Rafal Pietrak wrote: > > [--] > >> There was some quite recent discussion on ELEME

Re: [GENERAL] foreign key from array element

2012-09-17 Thread Merlin Moncure
On Mon, Sep 17, 2012 at 7:24 AM, Rafal Pietrak wrote: > On Mon, 2012-09-17 at 19:58 +0800, Craig Ringer wrote: >> On 09/17/2012 04:46 PM, Rafal Pietrak wrote: > [--] >> There was some quite recent discussion on ELEMENT foreign keys on the >> -hackers list. Try searching pgsql-hackers f

Re: [GENERAL] foreign key from array element

2012-09-17 Thread Rafal Pietrak
On Mon, 2012-09-17 at 19:58 +0800, Craig Ringer wrote: > On 09/17/2012 04:46 PM, Rafal Pietrak wrote: [--] > There was some quite recent discussion on ELEMENT foreign keys on the > -hackers list. Try searching pgsql-hackers for ELEMENT foreign key. > > See: >https://commitfest.pos

Re: [GENERAL] foreign key from array element

2012-09-17 Thread Craig Ringer
On 09/17/2012 04:46 PM, Rafal Pietrak wrote: Hello the list, recently I'm cooking a database for an application, that I feel is best implemented with tables containing arrays. I have found some related info here: http://archives.postgresql.org/pgsql-hackers/2008-09/msg01356.php although the in

[GENERAL] foreign key from array element

2012-09-17 Thread Rafal Pietrak
Hello the list, recently I'm cooking a database for an application, that I feel is best implemented with tables containing arrays. I have found some related info here: http://archives.postgresql.org/pgsql-hackers/2008-09/msg01356.php although the initial advice in that thread was: not to use ar