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
<bruce@momjian.us>Tom Lane wrote:
> Viktor Valy <
vili0121@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?
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +