[GENERAL] (check) constraints on composite type

2012-01-10 Thread Ralph Graulich
Hi! As of PostgreSQL 9.1 it is not possible to declare check constraints on composite types, according to http://www.postgresql.org/docs/9.1/interactive/rowtypes.html. I cannot use domains in that particular context, because I want to have the check constraint check for a combination of

Re: [GENERAL] (check) constraints on composite type

2012-01-10 Thread David Johnston
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ralph Graulich Sent: Tuesday, January 10, 2012 2:30 PM To: pgsql-general@postgresql.org Subject: [GENERAL] (check) constraints on composite type Are there any plans to have

Re: [GENERAL] (check) constraints on composite type

2012-01-10 Thread Merlin Moncure
On Tue, Jan 10, 2012 at 1:44 PM, David Johnston pol...@yahoo.com wrote: Sorry for not answering the main question but you really need to avoid phrases like near future.  That said, new features are only released during major releases and so at best you would have to wait for 9.2 which is

Re: [GENERAL] (check) constraints on composite type

2012-01-10 Thread Ralph Graulich
Hi David! Sorry for not answering the main question but you really need to avoid phrases like near future. That said, new features are only released during major releases and so at best you would have to wait for 9.2 which is probably 9+ months out since 9.1 was just recently released. The

Re: [GENERAL] (check) constraints on composite type

2012-01-10 Thread David Johnston
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ralph Graulich Sent: Tuesday, January 10, 2012 3:47 PM To: David Johnston Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] (check) constraints on composite type