Re: postgres_fdw foreign tables and serial columns - Mailing list pgsql-hackers

Tom Lane wrote:
> "Nicholson, Brad (Toronto, ON, CA)" <bnicholson@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