Re: [HACKERS] CHECK constraint names

2000-12-20 Thread Stephan Szabo
The constraint naming isn't really terribly sensible right now. The names generated should be unique within I think schema according to the spec and I think that should be true even if users name a constraint such that it would cause a collision (so, if i name a constraint what an automatic cons

[HACKERS] CHECK constraint names

2000-12-19 Thread Christopher Kings-Lynne
Hi, Is it correct behaviour that unnamed table-level check constraints get the names '$1', '$2', '$3', etc. in Postgres 7.0.3??? Eg, using table constraints: test=# create table test (temp char(1) NOT NULL, CHECK (temp IN ('M', 'F'))); CREATE test=# select rcname fr