[ADMIN] Is it possible to create a CHECK constraint for my use case?

2012-01-31 Thread Gnanakumar
Hi, Our Production server is running PostgreSQL v8.2.22 on CentOS5.2. We want to enable a specific CHECK constraint for our application table as explained below: There are 2 columns in the table: managertype numeric(1) and managerid numeric(10). managertype accepts only 2 valid values, either

Re: [ADMIN] Is it possible to create a CHECK constraint for my use case?

2012-01-31 Thread Thomas Kellerer
Gnanakumar, 31.01.2012 09:11: Hi, Our Production server is running PostgreSQL v8.2.22 on CentOS5.2. You know that 8.2 is end-of-live? http://www.postgresql.org/support/versioning/ There are 2 columns in the table: managertype numeric(1) and managerid numeric(10). managertype accepts only

Re: [ADMIN] Is it possible to create a CHECK constraint for my use case?

2012-01-31 Thread Walter Hurry
On Tue, 31 Jan 2012 13:41:00 +0530, Gnanakumar wrote: Hi, Our Production server is running PostgreSQL v8.2.22 on CentOS5.2. We want to enable a specific CHECK constraint for our application table as explained below: There are 2 columns in the table: managertype numeric(1) and managerid