On 2017-02-08 23:25, Petr Jelinek wrote:
0001-Use-asynchronous-connect-API-in-libpqwalreceiver-v2.patch
0002-Always-initialize-stringinfo-buffers-in-walsender-v2.patch
0003-Fix-after-trigger-execution-in-logical-replication-v2.patch
0004-Add-RENAME-support-for-PUBLICATIONs-and-SUBSCRIPTION-v2.patch
0001-Logical-replication-support-for-initial-data-copy-v4.patch
test 'object_address' fails, see atachment.
That's all I found in a quick first trial.
thanks,
Erik Rijkers
*** /home/aardvark/pg_stuff/pg_sandbox/pgsql.logical_replication/src/test/regress/expected/object_address.out 2017-02-09 00:51:30.345519608 +0100
--- /home/aardvark/pg_stuff/pg_sandbox/pgsql.logical_replication/src/test/regress/results/object_address.out 2017-02-09 00:54:11.884715532 +0100
***************
*** 38,43 ****
--- 38,45 ----
TO SQL WITH FUNCTION int4recv(internal));
CREATE PUBLICATION addr_pub FOR TABLE addr_nsp.gentable;
CREATE SUBSCRIPTION addr_sub CONNECTION '' PUBLICATION bar WITH (DISABLED, NOCREATE SLOT);
+ ERROR: could not connect to the publisher: FATAL: no pg_hba.conf entry for replication connection from host "[local]", user "aardvark", SSL off
+
-- test some error cases
SELECT pg_get_object_address('stone', '{}', '{}');
ERROR: unrecognized object type "stone"
***************
*** 409,463 ****
pg_identify_object_as_address(classid, objid, subobjid) ioa(typ,nms,args),
pg_get_object_address(typ, nms, ioa.args) as addr2
ORDER BY addr1.classid, addr1.objid, addr1.subobjid;
! type | schema | name | identity | ?column?
! ---------------------------+------------+-------------------+----------------------------------------------------------------------+----------
! default acl | | | for role regress_addr_user in schema public on tables | t
! default acl | | | for role regress_addr_user on tables | t
! type | pg_catalog | _int4 | integer[] | t
! type | addr_nsp | gencomptype | addr_nsp.gencomptype | t
! type | addr_nsp | genenum | addr_nsp.genenum | t
! type | addr_nsp | gendomain | addr_nsp.gendomain | t
! function | pg_catalog | | pg_catalog.pg_identify_object(pg_catalog.oid,pg_catalog.oid,integer) | t
! aggregate | addr_nsp | | addr_nsp.genaggr(integer) | t
! sequence | addr_nsp | gentable_a_seq | addr_nsp.gentable_a_seq | t
! table | addr_nsp | gentable | addr_nsp.gentable | t
! table column | addr_nsp | gentable | addr_nsp.gentable.b | t
! index | addr_nsp | gentable_pkey | addr_nsp.gentable_pkey | t
! view | addr_nsp | genview | addr_nsp.genview | t
! materialized view | addr_nsp | genmatview | addr_nsp.genmatview | t
! foreign table | addr_nsp | genftable | addr_nsp.genftable | t
! foreign table column | addr_nsp | genftable | addr_nsp.genftable.a | t
! role | | regress_addr_user | regress_addr_user | t
! server | | addr_fserv | addr_fserv | t
! user mapping | | | regress_addr_user on server integer | t
! foreign-data wrapper | | addr_fdw | addr_fdw | t
! access method | | btree | btree | t
! operator of access method | | | operator 1 (integer, integer) of pg_catalog.integer_ops USING btree | t
! function of access method | | | function 2 (integer, integer) of pg_catalog.integer_ops USING btree | t
! default value | | | for addr_nsp.gentable.b | t
! cast | | | (bigint AS integer) | t
! table constraint | addr_nsp | | a_chk on addr_nsp.gentable | t
! domain constraint | addr_nsp | | domconstr on addr_nsp.gendomain | t
! conversion | pg_catalog | ascii_to_mic | pg_catalog.ascii_to_mic | t
! language | | plpgsql | plpgsql | t
! schema | | addr_nsp | addr_nsp | t
! operator class | pg_catalog | int4_ops | pg_catalog.int4_ops USING btree | t
! operator | pg_catalog | | pg_catalog.+(integer,integer) | t
! rule | | | "_RETURN" on addr_nsp.genview | t
! trigger | | | t on addr_nsp.gentable | t
! operator family | pg_catalog | integer_ops | pg_catalog.integer_ops USING btree | t
! policy | | | genpol on addr_nsp.gentable | t
! collation | pg_catalog | "default" | pg_catalog."default" | t
! transform | | | for integer on language sql | t
! text search dictionary | addr_nsp | addr_ts_dict | addr_nsp.addr_ts_dict | t
! text search parser | addr_nsp | addr_ts_prs | addr_nsp.addr_ts_prs | t
! text search configuration | addr_nsp | addr_ts_conf | addr_nsp.addr_ts_conf | t
! text search template | addr_nsp | addr_ts_temp | addr_nsp.addr_ts_temp | t
! subscription | | addr_sub | addr_sub | t
! publication | | addr_pub | addr_pub | t
! publication relation | | | gentable in publication addr_pub | t
! (45 rows)
!
---
--- Cleanup resources
---
--- 411,417 ----
pg_identify_object_as_address(classid, objid, subobjid) ioa(typ,nms,args),
pg_get_object_address(typ, nms, ioa.args) as addr2
ORDER BY addr1.classid, addr1.objid, addr1.subobjid;
! ERROR: subscription "addr_sub" does not exist
---
--- Cleanup resources
---
***************
*** 465,470 ****
--- 419,425 ----
DROP FOREIGN DATA WRAPPER addr_fdw CASCADE;
DROP PUBLICATION addr_pub;
DROP SUBSCRIPTION addr_sub NODROP SLOT;
+ ERROR: subscription "addr_sub" does not exist
DROP SCHEMA addr_nsp CASCADE;
DROP OWNED BY regress_addr_user;
DROP USER regress_addr_user;
======================================================================
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
