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

2010-07-21 Thread Achilleas Mantzios
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

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

2010-07-21 Thread 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 speed). We've been doing that across the project infrastructure for 10 y

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

2010-07-21 Thread Achilleas Mantzios
Στις 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

[SQL] UUID for Postgresql 8.4

2010-07-21 Thread 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. -- Regards, -- Trinath Somanchi,

Re: [SQL] UUID for Postgresql 8.4

2010-07-21 Thread A. Kretschmer
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

Re: [SQL] UUID for Postgresql 8.4

2010-07-21 Thread MIkhail Puzanov
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

2010-07-21 Thread Kenneth Marshall
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, >

[SQL] Aggregates (last/first) not behaving

2010-07-21 Thread Wes Devauld
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