Tom Lane wrote: > "Nicholson, Brad (Toronto, ON, CA)" <bnichol...@hp.com> writes: >> [ this error message sucks: ] >> test=# create foreign table local_foo (id serial) server test_server options >> (table_name 'foo'); >> ERROR: referenced relation "local_foo" is not a table > > Yeah, I'd noticed that myself. We could probably tweak the code to > issue a different error message and/or add a HINT if the serial's > parent relation is a foreign table. I'm not exactly sure what it > should say though. Thoughts?
HINT: Serial columns can only be defined for local tables. Use "integer" or "bigint" instead. Yours, Laurenz Albe -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
