Re: [RFC] ideas for a new Python DBAPI driver (was Re: [HACKERS] libpq test suite)

2013-02-17 Thread P. Christeas
On Thursday 14 February 2013, Manlio Perillo wrote: > Il 14/02/2013 14:06, Albe Laurenz ha scritto: > > Manlio Perillo wrote: > >> Sorry for the question, but where can I find the libpq test suite? > >> I can not find it in the PostgreSQL sources; it seems that there are > >> only some examples, in

Re: [HACKERS] pg_top

2012-12-20 Thread P. Christeas
On Thursday 20 December 2012, Brett Maton wrote: > Hi List, > > > > This might not be the right place to post, but I've got a minor patch for > pg_top and would like to submit it for review. > > This project lies on Github: https://github.com/markwkm/pg_top/ I think, this commit had fixed t

Re: [HACKERS] Re: [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows

2012-10-21 Thread P. Christeas
On Sunday 21 October 2012, Vik Reykja wrote: > On Sun, Oct 21, 2012 at 6:20 PM, Abhijit Menon-Sen wrote: > > Note: "INSERT … RETURNING" doesn't accept an ORDER BY clause. > > Would anyone be opposed to somebody - say, me - writing a patch to allow > that? It would take me a lot longer than an ex

Re: [HACKERS] [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows

2012-10-21 Thread P. Christeas
On Sunday 21 October 2012, Andres Freund wrote: > On Sunday, October 21, 2012 07:24:52 PM Andrew Dunstan wrote: > > why does the client have to be involved, exactly? > Suppose you have something like > > CREATE TABLE positionlog( > ... > And you want to insert multiple values in one roundtrip *and

Re: [HACKERS] Re: [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows

2012-10-21 Thread P. Christeas
On Sunday 21 October 2012, Abhijit Menon-Sen wrote: > At 2012-10-21 11:49:26 -0400, cbbro...@gmail.com wrote: > > If there is a natural sequence (e.g. - a value assigned by nextval()), > > that offers a natural place to apply the usual order-imposing ORDER BY > > that we are expected to use elsewhe

Re: [HACKERS] [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows

2012-10-17 Thread P. Christeas
On Wednesday 17 October 2012, you wrote: > "P. Christeas" writes: > > It has been a fact that the RETURNING clause on an INSERT will return > > multiple rows with the same order as multiple VALUES have been fed. > > I don't believe this is a good idea

[HACKERS] [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows

2012-10-17 Thread P. Christeas
It has been a fact that the RETURNING clause on an INSERT will return multiple rows with the same order as multiple VALUES have been fed. eg: INSERT INTO tbl1(code) VALUES ('abc'), ('def'), ('agh') RETURNING id, code; is expected to yield: id | code --- 1 | abc 2 |