Version strin= g: PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.= 8.5 20150623 (Red Hat 4.8.5-4), 64-bit

Please let me know if = anyone knows how to fix this. below query works fine in version 9.4.=

schema= Backup file attached.

select * from connectby('emp',= 'empid','mgrid','1',0)
AS t(keyid text, parent_keyid text, level int);

ERROR: invalid return type DETAIL: SQL key field type text d= oes not match return key field type integer. ********** Error ********** ER= ROR: invalid return type SQL state: 42804 Detail: SQL key field type text d= oes not match return key field type integer.

CREATE TABLE public.emp
(
empid integer NOT NULL,
name text,
mgrid integer,
CONSTRAINT emp_pkey PRIMARY KEY (empid)
)

insert into emp(emp= id,mgrid,name)
values(1,0,'emp1');
insert into emp(empid,mgrid,name)
values(2,1,'emp1');
insert into emp(empid,mgrid,name)
values(3,1,'emp1');insert into emp(= empid,mgrid,name)
values(4,2,'emp1');
insert into emp(empid,mgrid,name)
values(5,2,'emp1');

<= /span>

Thanks&Regards,
M= .Bujji Babu.

= ------=_Part_1542364_1096289412.1475749392419-- ------=_Part_1542363_1481084027.1475749392418 Content-Type: application/x-trash; name=test.pgsql.bak Content-Disposition: attachment; filename=test.pgsql.bak Content-Transfer-Encoding: base64 UEdETVABDAAECAEBAQAAAAAPAAAAAAMAAAAACwAAAAAGAAAAAAkAAAAAdAAA AAABAAAAAAQAAAB0ZXN0AAUAAAA5LjUuNAAFAAAAOS41LjQADQAAAADiCwAA AAAAAAAAAQAAADAAAQAAADAACAAAAEVOQ09ESU5HAAgAAABFTkNPRElORwAC AAAAAB4AAABTRVQgY2xpZW50X2VuY29kaW5nID0gJ1VURjgnOwoAAAAAAAEB AAAAAQEAAAABAQAAAAAAAAAAAAUAAABmYWxzZQEBAAAAAwAAAAAAAAAAAOML AAAAAAAAAAABAAAAMAABAAAAMAAKAAAAU1REU1RSSU5HUwAKAAAAU1REU1RS SU5HUwACAAAAACgAAABTRVQgc3RhbmRhcmRfY29uZm9ybWluZ19zdHJpbmdz ID0gJ29uJzsKAAAAAAABAQAAAAEBAAAAAQEAAAAAAAAAAAAFAAAAZmFsc2UB AQAAAAMAAAAAAAAAAADkCwAAAAAAAAAABAAAADEyNjIABwAAADY4MDA2NDEA BAAAAHRlc3QACAAAAERBVEFCQVNFAAIAAAAAdgAAAENSRUFURSBEQVRBQkFT RSB0ZXN0IFdJVEggVEVNUExBVEUgPSB0ZW1wbGF0ZTAgRU5DT0RJTkcgPSAn VVRGOCcgTENfQ09MTEFURSA9ICdlbl9HQi5VVEYtOCcgTENfQ1RZUEUgPSAn ZW5fR0IuVVRGLTgnOwoAFAAAAERST1AgREFUQUJBU0UgdGVzdDsKAQEAAAAB AQAAAAEBAAAAAAgAAABwb3N0Z3JlcwAFAAAAZmFsc2UBAQAAAAMAAAAAAAAA AAAHAAAAAAAAAAAABAAAADI2MTUABAAAADIyMDAABgAAAHB1YmxpYwAGAAAA U0NIRU1BAAIAAAAAFgAAAENSRUFURSBTQ0hFTUEgcHVibGljOwoAFAAAAERS T1AgU0NIRU1BIHB1YmxpYzsKAQEAAAABAQAAAAEBAAAAAAgAAABwb3N0Z3Jl cwAFAAAAZmFsc2UBAQAAAAMAAAAAAAAAAADlCwAAAAAAAAAAAQAAADAAAQAA ADAADQAAAFNDSEVNQSBwdWJsaWMABwAAAENPTU1FTlQAAQAAAAA2AAAAQ09N TUVOVCBPTiBTQ0hFTUEgcHVibGljIElTICdzdGFuZGFyZCBwdWJsaWMgc2No ZW1hJzsKAAAAAAABAQAAAAEBAAAAAQEAAAAACAAAAHBvc3RncmVzAAUAAABm YWxzZQABAAAANwEBAAAAAwAAAAAAAAAAAOYLAAAAAAAAAAABAAAAMAABAAAA MAAGAAAAcHVibGljAAMAAABBQ0wAAQAAAACiAAAAUkVWT0tFIEFMTCBPTiBT Q0hFTUEgcHVibGljIEZST00gUFVCTElDOwpSRVZPS0UgQUxMIE9OIFNDSEVN QSBwdWJsaWMgRlJPTSBwb3N0Z3JlczsKR1JBTlQgQUxMIE9OIFNDSEVNQSBw dWJsaWMgVE8gcG9zdGdyZXM7CkdSQU5UIEFMTCBPTiBTQ0hFTUEgcHVibGlj IFRPIFBVQkxJQzsKAAAAAAABAQAAAAEBAAAAAQEAAAAACAAAAHBvc3RncmVz AAUAAABmYWxzZQABAAAANwEBAAAAAwAAAAAAAAAAAAEAAAAAAAAAAAAEAAAA MzA3OQAFAAAAMTMyNzYABwAAAHBscGdzcWwACQAAAEVYVEVOU0lPTgACAAAA AD8AAABDUkVBVEUgRVhURU5TSU9OIElGIE5PVCBFWElTVFMgcGxwZ3NxbCBX SVRIIFNDSEVNQSBwZ19jYXRhbG9nOwoAGAAAAERST1AgRVhURU5TSU9OIHBs cGdzcWw7CgEBAAAAAQEAAAABAQAAAAAAAAAAAAUAAABmYWxzZQEBAAAAAwAA AAAAAAAAAOcLAAAAAAAAAAABAAAAMAABAAAAMAARAAAARVhURU5TSU9OIHBs cGdzcWwABwAAAENPTU1FTlQAAQAAAABAAAAAQ09NTUVOVCBPTiBFWFRFTlNJ T04gcGxwZ3NxbCBJUyAnUEwvcGdTUUwgcHJvY2VkdXJhbCBsYW5ndWFnZSc7 CgAAAAAAAQEAAAABAQAAAAEBAAAAAAAAAAAABQAAAGZhbHNlAAEAAAAxAQEA AAADAAAAAAAAAAAAAgAAAAAAAAAAAAQAAAAzMDc5AAcAAAA2ODAwNjU4AAkA AAB0YWJsZWZ1bmMACQAAAEVYVEVOU0lPTgACAAAAAD0AAABDUkVBVEUgRVhU RU5TSU9OIElGIE5PVCBFWElTVFMgdGFibGVmdW5jIFdJVEggU0NIRU1BIHB1 YmxpYzsKABoAAABEUk9QIEVYVEVOU0lPTiB0YWJsZWZ1bmM7CgEBAAAAAQEA AAABAQAAAAAAAAAAAAUAAABmYWxzZQABAAAANwEBAAAAAwAAAAAAAAAAAOgL AAAAAAAAAAABAAAAMAABAAAAMAATAAAARVhURU5TSU9OIHRhYmxlZnVuYwAH AAAAQ09NTUVOVAABAAAAAGAAAABDT01NRU5UIE9OIEVYVEVOU0lPTiB0YWJs ZWZ1bmMgSVMgJ2Z1bmN0aW9ucyB0aGF0IG1hbmlwdWxhdGUgd2hvbGUgdGFi bGVzLCBpbmNsdWRpbmcgY3Jvc3N0YWInOwoAAAAAAAEBAAAAAQEAAAABAQAA AAAAAAAAAAUAAABmYWxzZQABAAAAMgEBAAAAAwAAAAAAAAAAALYAAAAAAAAA AAAEAAAAMTI1OQAHAAAANjgwMDY1MAADAAAAZW1wAAUAAABUQUJMRQACAAAA AFMAAABDUkVBVEUgVEFCTEUgZW1wICgKICAgIGVtcGlkIGludGVnZXIgTk9U IE5VTEwsCiAgICBuYW1lIHRleHQsCiAgICBtZ3JpZCBpbnRlZ2VyCik7CgAX AAAARFJPUCBUQUJMRSBwdWJsaWMuZW1wOwoBAQAAAAAGAAAAcHVibGljAAAA AAAACAAAAHBvc3RncmVzAAUAAABmYWxzZQABAAAANwEBAAAAAwAAAAAAAAAA AN8LAAAAAQAAAAABAAAAMAAHAAAANjgwMDY1MAADAAAAZW1wAAoAAABUQUJM RSBEQVRBAAMAAAAAAAAAAAAAAAAAACoAAABDT1BZIGVtcCAoZW1waWQsIG5h bWUsIG1ncmlkKSBGUk9NIHN0ZGluOwoABgAAAHB1YmxpYwEBAAAAAAgAAABw b3N0Z3JlcwAFAAAAZmFsc2UAAwAAADE4MgEBAAAAArUKAAAAAAAAAGwLAAAA AAAAAAAEAAAAMjYwNgAHAAAANjgwMDY1NwAIAAAAZW1wX3BrZXkACgAAAENP TlNUUkFJTlQABAAAAABGAAAAQUxURVIgVEFCTEUgT05MWSBlbXAKICAgIEFE RCBDT05TVFJBSU5UIGVtcF9wa2V5IFBSSU1BUlkgS0VZIChlbXBpZCk7CgA2 AAAAQUxURVIgVEFCTEUgT05MWSBwdWJsaWMuZW1wIERST1AgQ09OU1RSQUlO VCBlbXBfcGtleTsKAQEAAAAABgAAAHB1YmxpYwAAAAAAAAgAAABwb3N0Z3Jl cwAFAAAAZmFsc2UAAwAAADE4MgADAAAAMTgyAQEAAAADAAAAAAAAAAABAN8L AAAAJQAAAHicM+RMzS0w5DTgMoIwDLmMYQwTCMOIyxTGiNHj4uICABkXCmkA AAAAAA== ------=_Part_1542363_1481084027.1475749392418 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql ------=_Part_1542363_1481084027.1475749392418--