Hi all, I have a quick question...
In function definitions one can dereference the type of some
relation's column using the %TYPE syntax. This is a very useful
feature that helps prevent type mismatch problems in databases that
are frequently changing (for example in a scientific environment
where tables are being added often, and the re-use of an already
defined function is then simple).
It would also be useful to have the same functionality in the CREATE
TABLE statement, in particular when defining a FOREIGN KEY
constraint. For example, something along these lines:
CREATE TABLE foo (attribute_1 other_table.attribute_pk%TYPE
or the even simpler:
CREATE TABLE foo (attribute_1 REFERENCES other_table.attribute_pk);
However, this doesn't seem possible. Now, under the assumption that
many people have encountered this in the past, I'm curious about the
different solutions/workarounds most have employed successfully.
Thanks for any insight on this,
pgsql-novice by date
|Next:||From: Sean Davis||Date: 2006-03-23 21:24:09|
|Subject: Re: foreign key data type dereferencing|
|Previous:||From: Guido Barosio||Date: 2006-03-23 18:18:24|
|Subject: Re: Problems using PostgreSQL command line tools|