Hi
I have a table boo
create table boo(id serial primary key, inserted date default current_date,
v varchar);
I imported this table via simple
IMPORT FOREIGN SCHEMA public FROM SERVER foreign_server INTO public;
The command insert into boo(v) values('ahoj'); is working in original
database, but in second database with foreign table this fails
postgres=# insert into boo(v) values('ahoj');
ERROR: null value in column "id" violates not-null constraint
DETAIL: Failing row contains (null, null, ahoj).
CONTEXT: remote SQL command: INSERT INTO public.boo(id, inserted, v)
VALUES ($1, $2, $3)
It does unwanted transformation to insert of all columns.
Is it expected behave?
Regards
Pavel