Re: postgresql_fdw doesn't handle defaults correctly

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