Re: foreign key on views - Mailing list pgsql-general

"Josh Harrison" <joshques@gmail.com> writes:
> I just wanted to know where is this error message thrown in the source
> code.?

"\set VERBOSITY verbose" would help...

regression=# create view v as select * from int4_tbl;
CREATE VIEW
regression=# \set VERBOSITY verbose
regression=# create table t (f1 int references v);
ERROR:  42809: referenced relation "v" is not a table
LOCATION:  ATAddForeignKeyConstraint, tablecmds.c:3949

            regards, tom lane