Re: [GENERAL] Verifying a timestamp is null or in the past

2011-12-31 Thread Raymond O'Donnell
On 31/12/2011 06:15, Alexander Farber wrote: > Hello again, > >> On Fri, Dec 30, 2011 at 2:07 PM, Alban Hertroys wrote: >>> select 1 from pref_users where id=_from and vip > current_timestamp + >>> interval '1 week'; >>> >>> if not found then >>>return; >>> end if; >>> > > unfortunately I g

Re: [GENERAL] pgoledb transaction error

2011-12-31 Thread gato pardo
Thanks David Complying with your requirements: "Tip 1: Provide the SQL statements you are trying to execute when you get the error; given that is it a "commit"-type error the entire transaction is useful." I copy some of the code used: MyConnectionString = "Provider=PostgreSQL OLE DB Provid

[GENERAL] Streaming replication failover

2011-12-31 Thread Ben Chobot
I'm in the process of setting up a 9.1-based SR cluster, and I've got a question on how failover is expected to work in the case of multiple slaves. http://www.postgresql.org/docs/9.1/static/warm-standby-failover.html says: "Some people choose to use a third server to provide backup for the new

Re: [GENERAL] Streaming replication failover

2011-12-31 Thread Tatsuo Ishii
> I'm in the process of setting up a 9.1-based SR cluster, and I've got a > question on how failover is expected to work in the case of multiple slaves. > http://www.postgresql.org/docs/9.1/static/warm-standby-failover.html says: > > "Some people choose to use a third server to provide backup fo