Re: postgres_fdw foreign tables and serial columns

Sent from my iPad

On 15-May-2013, at 18:56, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "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?
>
>
>
>
>

+1 for the HINT message addition.

Regards,

Atri