Re: [HACKERS] [PATCH] SQL assertions prototype

2013-11-24 Thread Andrew Tipton
an error if any rows were present. That should be a very quick operation. No need to invent some sort of get access to the changed rows mechanism especially for CREATE ASSERTION. Kind regards, Andrew Tipton -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Add CREATE support to event triggers

2013-11-24 Thread Andrew Tipton
, which can be accessed from within the event trigger by calling a special function. For example, the relation_alter event supplies the relation Oid and the old and new pg_class rows. It's easy to then examine the old vs. new rows and determine what has changed. Kind regards, Andrew Tipton

[HACKERS] BackgroundWorkerInitializeConnection(NULL, ...) doesn't work

2013-08-10 Thread Andrew Tipton
in InitPostgres expects MyDatabaseId to be set to something useful. Regards, Andrew Tipton

Re: [HACKERS] BackgroundWorkerInitializeConnection(NULL, ...) doesn't work

2013-08-10 Thread Andrew Tipton
-- for the details. Regards, Andrew Tipton bgworker-shared-catalogs-v1.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] question about HTTP API

2013-08-09 Thread Andrew Tipton
database, but it isn't generic -- you have to configure it for each URL that should be handled. Regards, Andrew Tipton

Re: [HACKERS] question about HTTP API

2013-08-09 Thread Andrew Tipton
. Regards, Andrew Tipton

Re: [HACKERS] question about HTTP API

2013-08-09 Thread Andrew Tipton
is being compiled for each request, of course...) This is going to be a very long series of patches, but IMHO we have to start somewhere! For some applications, performance is far less important than ease-of-use and ease-of-deployment. Regards, Andrew Tipton

Re: [HACKERS] how to pass data (tuples) to worker processes?

2013-08-03 Thread Andrew Tipton
with the dynamic bgworkers after they had been launched was next on your agenda... Regards, Andrew Tipton

Re: [HACKERS] Add json_typeof() and json_is_*() functions.

2013-08-02 Thread Andrew Tipton
constructing their check expression. Regards, Andrew Tipton

[HACKERS] Add json_typeof() and json_is_*() functions.

2013-07-29 Thread Andrew Tipton
manner. JSON object and JSON array refer to parameters which must be an object or an array or to results which are always an object or an array. JSON value refers to parameters or results which may be any kind of JSON. Regards, Andrew Tipton json_typeof_v1.patch Description: Binary data

Re: [HACKERS] Patch: add GiST support for BOX @ POINT queries

2011-06-17 Thread Andrew Tipton
On Fri, Jun 10, 2011 at 22:16, Hitoshi Harada umi.tan...@gmail.com wrote: I reviewed the patch and worried about hard-wired magic number as StrategyNumber. At least you should use #define to indicate the number's meaning. In addition, the modified gist_box_consistent() is too dangerous;

Re: [HACKERS] foreign keys for array/period contains relationships

2011-03-20 Thread Andrew Tipton
On Mon, Oct 25, 2010 at 15:11, Peter Eisentraut pete...@gmx.net wrote: Example #4: PK is period, FK is timestamp. FK must be contained in some PK period. CREATE TABLE pk (a period PRIMARY KEY, ...); CREATE TABLE fk (x timestamp REFERENCES pk (a), ...); As above, we can probably arrange

[HACKERS] Patch: add GiST support for BOX @ POINT queries

2011-02-23 Thread Andrew Tipton
While playing around with the BOX and POINT datatypes, I was surprised to note that BOX @ POINT (and likewise POINT @ BOX) queries were not using the GiST index I had created on the BOX column. The attached patch adds a new strategy @(BOX,POINT) to the box_ops opclass. Internally,