Hi. On 2018/06/24 2:23, Pavel Stehule wrote: > 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;
It seems you missed using OPTIONS (import_default 'true') here. create schema foo; create table foo.foo (a serial primary key, b date default current_date not null, c int); import foreign schema foo from server loopback into public options (import_default 'true'); insert into public.foo (c) values (1); select * from public.foo; a | b | c ---+------------+--- 1 | 2018-06-25 | 1 (1 row) insert into foo.foo (c) values (2); select * from public.foo; a | b | c ---+------------+--- 1 | 2018-06-25 | 1 2 | 2018-06-25 | 2 (2 rows) Thanks, Amit
