Re: Inserting into foreign table with sequences and default values

"peter(dot)borissow(at)kartographia(dot)com" <peter(dot)borissow(at)kartographia(dot)com> writes:
> I guess the FDW is not "seeing" the default value for status and the bigserial sequence for the id column. Is there anyway around this?

The idea is that you should attach default clauses to the foreign
table definition. A remote serial column is a hard case for that,
though, since you don't have ready access to the remote sequence.
Because of that and some related examples, we don't currently
expect that IMPORT FOREIGN SCHEMA should import the defaults that
exist on the remote server.

Using a view or trigger on the remote side is currently the best
way around that for cases where you can't set up a suitable
default on the local table.

regards, tom lane