Hello! We have chosen another item from the list: "Allow ALTER TABLE to change constraint deferrability and actions"
Is this already done? If yes, can you recommend any task which is appropriate for beginners in open-source software? Thanks in advance, Chris & Viktor 2010/8/4 Bruce Momjian <br...@momjian.us> > Tom Lane wrote: > > Viktor Valy <vili0...@gmail.com> writes: > > > We are 2 Students from the Technical University of Vienna. At our > internship > > > we would like to develop the item of the TODO list: "Allow SET > CONSTRAINTS > > > to be qualified by schema/table name". > > > Is anyone working on it? > > > > Uh, it was done years ago, AFAICS, unless the Todo entry means something > > non-obvious. > > > > regression=# create schema foo; > > CREATE SCHEMA > > regression=# create table foo.bar (f1 int unique deferrable); > > NOTICE: CREATE TABLE / UNIQUE will create implicit index "bar_f1_key" > for table "bar" > > CREATE TABLE > > regression=# set constraints foo.bar_f1_key deferred; > > SET CONSTRAINTS > > regression=# set constraints foo.bar_f1_key immediate; > > SET CONSTRAINTS > > regression=# > > > > Bruce, do you remember what that entry was really about? > > Yep, that was it. I have remove that TODO item. Thanks. > > -- > Bruce Momjian <br...@momjian.us> http://momjian.us > EnterpriseDB http://enterprisedb.com > > + It's impossible for everything to be true. + >