Re: [GENERAL] PostgreSQL and distributed transactions

2010-07-31 Thread Joshua Tolley
On Thu, Jul 29, 2010 at 11:42:14AM +0200, Dimitri Fontaine wrote: > Jayadevan M writes: > > But the initial setup for the client is done by 'Admin' and in that > > work-flow, we need distributed transactions. The transaction will start > > from the 'Admin" server, do some inserts on the 'Client'

Re: [GENERAL] select a list of column values directly into an array

2010-07-31 Thread Merlin Moncure
On Fri, Jul 30, 2010 at 11:50 AM, Merlin Moncure wrote: > On Fri, Jul 30, 2010 at 10:34 AM, Derrick Rice wrote: >> Is it possible to use the ARRAY(select ...) syntax as a substitute for >> array_agg on versions of postgresql that don't have it? (8.2)  It works >> simply enough when only selecting

Re: [GENERAL] Centos 5.5 and Postgres 9.0.beta3 install errors

2010-07-31 Thread Devrim GÜNDÜZ
On Fri, 2010-07-23 at 11:48 +0100, Tom Robst wrote: > > Thank you for your reply...I've run an yum clean all and re-installed > the pgdg-centos-9.0-2.noarch rpm but now I'm getting this error: > > http://yum.pgrpms.org/9.0/redhat/rhel-5-i386/postgresql-libs-9.0-beta3_1PGDG.rhel5.i386.rpm: > >