Re: [GENERAL] Fwd: Re: Dynamic update of a date field

2012-02-19 Thread Jasen Betts
On 2012-02-17, Steve Crawford wrote: > On 02/16/2012 02:45 PM, John R Pierce wrote: >> On 02/16/12 2:34 PM, David Salisbury wrote: >>> >>> Would it not be advantageous to replicate information in the above >>> form if you wanted to, say, get all records in the month of May, and >>> therefore creat

Re: [GENERAL] Fwd: Re: Dynamic update of a date field

2012-02-19 Thread Jasen Betts
On 2012-02-16, David Salisbury wrote: > > > On 2/16/12 7:27 AM, Andreas Kretschmer wrote: >> Musial, Jan (GIUB) wrote: >>> smallint,month smallint,day smallint,time_stamp date); I would like to >> >> That's silly, use one (and only one) field, timestamp (or timestamptz) >> Don't use never ever mu

Re: [GENERAL] Easy form of "insert if it isn't already there"?

2012-02-19 Thread Jasen Betts
On 2012-02-15, Chris Angelico wrote: > Periodically I find myself wanting to insert into some table, > specifying the primary key column(s), but to simply ignore the request > if it's already there. Currently I have two options: > > 1) Do the insert as normal, but suppress errors. > SAVEPOINT foo;

[GENERAL] Postgres 9.1 package for i.MX51X processor from Freescale

2012-02-19 Thread Jayashankar K B
Hi, Is there a ready postgres 9.1 Package for the i.MX51X processor (ARM Cortex architecture) available or do I need to compile the Postgres source myself ? I need it for a board having the i.MX51 processor and Linux (a variant of Debian distribution based on Linux kernel 2.6.35). If I need to c

Re: [GENERAL] Question on Rules

2012-02-19 Thread David Johnston
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of mgo...@isstrucksoftware.net Sent: Saturday, February 18, 2012 5:17 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Question on Rules I am creating a rule which will

Re: [GENERAL] [GENERA]: Postgresql-9.1.1 synchronous replication issue

2012-02-19 Thread Venkat Balaji
On Thu, Feb 16, 2012 at 8:14 PM, Adrian Klaver wrote: > On Wednesday, February 15, 2012 10:21:02 pm Venkat Balaji wrote: > > Andrian, > > > > Thanks a lot ! > > > > So in this case you are not waiting for confirmation of the commit being > > > > > flushed > > > to disk on the standby. It that cas