[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, ei

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" accept

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 >