"Nicholson, Brad (Toronto, ON, CA)" <bnicholson(at)hp(dot)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?
regards, tom lane