[BUGS] Seems bug in postgres_fdw?

Поиск
Список
Период
Сортировка
От Sachin Kotwal
Тема [BUGS] Seems bug in postgres_fdw?
Дата
Msg-id CA+N_YAei=PCQGcED_q_6YBpzFOTazbagntDppO9ZKEA_3VtFGQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: [BUGS] Seems bug in postgres_fdw?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Hi All,

Below are findings for postgres_fdw related to timezone.

-- Remote Sever


Server A (timezone = 'US/Eastern')

Create table public.test_timestamp(
                col1 varchar,
                ins_ts timestamp without time zone not null default current_timestamp
) without oids;
 
( Assume time is 10:00:00 AM EST ) insert into public.test_timestamp( col1 ) values ('foo');
select ins_ts from public.test_timestamp;
--- Returns 10:00:00
 
delete from public.test_timestamp;
 
-- Local Server
Server B (timezone = 'US/Eastern')

CREATE SERVER server_1 FOREIGN DATA WRAPPER postgres_fdw OPTIONS (port '5433', dbname 'pgbench');

CREATE USER MAPPING FOR PUBLIC SERVER server_1 OPTIONS (password '');

Create foreign table public.foreign_table(
                col1 varchar
)  SERVER server_1
   OPTIONS (schema_name 'public', table_name 'test_timestamp');
 
( Assume time is 10:00:00 AM EST ) insert into public.foreign_table( col1 ) values ('from remote');
 


Now, on Server A, again issue
select ins_ts from public.test_timestamp;
--- Returns 15:00:00


Here , Why postgresql takes different time when remote table and foreign table have different definition for timestamp column?

I think create foreign table should not allowed , If allowed it should give same result.



--

Thanks and Regards,
Sachin Kotwal

В списке pgsql-bugs по дате отправления:

Предыдущее
От: adrian.mondaca13@gmail.com
Дата:
Сообщение: [BUGS] BUG #14570: Validation error
Следующее
От: digoal@126.com
Дата:
Сообщение: [BUGS] BUG #14571: 10.0 devel hang when create subscription