[HACKERS] FK column doesn't exist error message could use more detail

2009-01-26 Thread decibel
create table a(a_id serial primary key, a int); create table b(b_id serial primary key, a_id int not null references a (id), b int, c_id int not null references c(id)); NOTICE: CREATE TABLE will create implicit sequence b_id_seq for serial column b.b_id NOTICE: CREATE TABLE / PRIMARY KEY

Re: [HACKERS] FK column doesn't exist error message could use more detail

2009-01-26 Thread Tom Lane
decibel deci...@decibel.org writes: How can I tell which FK constraint that's for? Could we have backend/ tablecmds.c:transformColumnNameList() report the constraint name? If it has a name at all, the name was probably made up from the given column names, so this seems a mite useless. At