[SQL] Aggregates (last/first) not behaving

I have PostgreSQL 8.3.9 [PostgreSQL 8.3.9 on i386-apple-darwin10.3.0, compiled by GCC i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5646) (dot 1)] and the custom first and last aggregates from: http://wiki.postgresql.org/wiki/First_(aggregate) http://wiki.postgresql.org/wiki/Last_(a

Re: [SQL] UUID for Postgresql 8.4

On Wed, Jul 21, 2010 at 05:49:53PM +0530, Trinath Somanchi wrote: > Hi All, > > I have a column in my Postgresql database tables which need UUID. > > Is there any function in Pgsql for UUID generation. Please help me in this > regard. > > -- > Regards, >

Re: [SQL] UUID for Postgresql 8.4

There's contrib module for it, uuid-ossp. It should be available as a package for most OSes and distributions, I guess. Hi All, > > I have a column in my Postgresql database tables which need UUID. > > Is there any function in Pgsql for UUID generation. Please help me in this > regard. > > -- > R

Re: [SQL] UUID for Postgresql 8.4

In response to Trinath Somanchi : > Hi All, > > I have a column in my Postgresql database tables which need UUID. > > Is there any function in Pgsql for UUID generation. Please help me in this > regard. http://www.postgresql.org/docs/8.4/static/uuid-ossp.html Andreas -- Andreas Kretschmer Kont

[SQL] UUID for Postgresql 8.4

Hi All, I have a column in my Postgresql database tables which need UUID. Is there any function in Pgsql for UUID generation. Please help me in this regard. -- Regards, -- Trinath Somanchi,

Re: [SQL] PostgreSQL ontop of FreeBSD jails, maybe there is still hope!

Στις Wednesday 21 July 2010 10:57:45 ο/η Dave Page έγραψε: > On Wed, Jul 21, 2010 at 7:47 AM, Achilleas Mantzios > wrote: > > It seems there are certain projects running at the moment that will > > eventually make possible > > to run PostgreSQL on FreeBSD's jail (virtual server on plain iron spee

Re: [SQL] PostgreSQL ontop of FreeBSD jails, maybe there is still hope!

On Wed, Jul 21, 2010 at 7:47 AM, Achilleas Mantzios wrote: > It seems there are certain projects running at the moment that will > eventually make possible > to run PostgreSQL on FreeBSD's jail (virtual server on plain iron speed). We've been doing that across the project infrastructure for 10 y

[SQL] PostgreSQL ontop of FreeBSD jails, maybe there is still hope!

It seems there are certain projects running at the moment that will eventually make possible to run PostgreSQL on FreeBSD's jail (virtual server on plain iron speed). Pre jail resource limits: http://freebsdfoundation.blogspot.com/2010/07/resource-containers-project.html Further generalization i