[HACKERS] ROLLBACK TO SAVEPOINT The note at the end of; http://www.postgresql.org/docs/8.4/static/sql-savepoint.html Lead us to believe that if you roll back to the same savepoint name twice in a row, that you might start walking back through the savepoints. I guess I missed the note on ROLLBACK TO SAVEPOINT that that is not how it works. ... 25 May 2010 00:31
(9.1) btree_gist support for searching on "notequals" On Sat, 2010-05-22 at 01:02 +0300, Marko Tiikkaja wrote: On 5/21/10 11:47 PM +0300, Jeff Davis wrote: It also allows you to enforce the constraint that only one tuple exists in a table by doing something like: create table a ( i int, exclude using gist (i with<>), ... 25 May 2010 00:31
Regression testing for psql * Stephen Frost (sfrost(a)snowman.net) wrote: Add regression testing for psql backslash commands This patch adds rather extensive regression testing of the psql backslash commands. Hopefully this will minimize issues such as the one which cropped up recently with \h segfaulting... 29 May 2010 21:11
[HACKERS] Clearing psql's input buffer after auto-reconnect We determined that $SUBJECT would be a good idea in this thread: http://archives.postgresql.org/pgsql-bugs/2010-05/msg00159.php I looked a bit at what it would take to make this happen. The difficulty is that the input buffer is a local variable in MainLoop(), and so are a bunch of other subsidiary variables tha... 24 May 2010 23:26
[HACKERS] libpq, PQexecPrepared, data size sent to FE vs. FETCH_COUNT I have some libpq-using application code, in which fetching the data follows this logic (after a statement has been prepared): ---------------------------------------- PQexecPrepared(pg_result, pg_conn, pg_statement_name, input_param_cnt, param_values, param_lengths, param_formats, result_for... 24 May 2010 13:28
[HACKERS] Synchronization levels in SR Hi, I'm now designing the "synchronous" replication feature based on SR for 9.1, while discussing that at another thread. http://archives.postgresql.org/pgsql-hackers/2010-04/msg01516.php At the first design phase, I'd like to clarify which synch levels should be supported 9.1 and how it should be specified by... 24 May 2010 10:07
Exposing the Xact commit order to the user -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 Exposing the data will be done via a set returning function. The SRF takes two arguments. The maximum number of rows to return and the last serial number processed by the reader. The advantage of such SRF is that the result can be used in a query tha... 14 Jun 2010 17:22
[HACKERS] Exposing the Xact commit order to the user In some systems (data warehousing, replication), the order of commits is important, since that is the order in which changes have become visible. This information could theoretically be extracted from the WAL, but scanning the entire WAL just to extract this tidbit of information would be excruciatingly painful. ... 23 May 2010 16:51
[PATCH] Move 'long long' check to c.h Stephen Frost <sfrost(a)snowman.net> writes: While reviewing bfba40e2c7b3909d3de13bd1b83b7e85fa8dfec2 (mmm, we like git diff -p), I noted that c.h is already included by both extern.h and ecpg.header through postgres_fe.h. Given this and that we're already doing alot of similar #define's there (unlik... 24 May 2010 15:42
mapping object names to role IDs And of course I meant for the subject line to be "mapping object names to OIDs", not "role IDs". Sigh. ....Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers ... 26 May 2010 15:49 |