Search Postgresql Archives

Re: foreign key on views

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Josh Harrison" <joshques@xxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux