From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | infotodaniel(at)gmail(dot)com |
Subject: | BUG #17024: ERROR: column c.relhasoids does not exist at character 245 |
Date: | 2021-05-19 10:48:53 |
Message-ID: | 17024-a1a1495f5ded3b61@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 17024
Logged by: Daniel Prince
Email address: infotodaniel(at)gmail(dot)com
PostgreSQL version: 12.5
Operating system: CENT OS - 7
Description:
Hi Folks,
I have setup DB Link from Postgres 12.5 Version (EC2 instances) to Oracle
DB.
isql is working fine,
oracle(DEVDB)- LOOBI)> /ora/dev/postgres/unixodbc/2.3.9/bin/isql -v
hopsd_link
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> SELECT count(1) from pg_tables;
+---------------------+
| count |
+---------------------+
| 130 |
+---------------------+
SQLRowCount returns 1
1 rows fetched
But when I connect from Oracle DB and trying to query PostgrSQL tables
am getting below error :
SQL> SELECT DISTINCT "table_catalog", "table_schema" FROM
"information_schema"."tables"@hopsd_link.MYGROUP.COM;
SELECT DISTINCT "table_catalog", "table_schema" FROM
"information_schema"."tables"@hopsd_link.MYGROUP.COM
*
ERROR at line 1:
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1530))(CONNECT_DATA=(SID=hopsd_link)))
ORA-02063: preceding line from HOPSD_LINK
Process ID: 12230
Session ID: 44 Serial number: 42705
FROM PostgrSQL DB logs am getting below error :
2021-05-18 08:04:33 EDT:192.16.8.11(43364):hgappotu(at)hopsd:[5312]:ERROR:
column c.relhasoids does not exist at character 245
2021-05-18 08:04:33 EDT:192.16.8.11(43364):hgappotu(at)hopsd:[5312]:STATEMENT:
select n.nspname, c.relname, a.attname, a.atttypid,
t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules,
c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid),
case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod,
c.relhasoids from (((pg_catalog.pg_class c inner
join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like
'thgotu_order_entry' and n.nspname like 'hgappotu')
inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum >
0 and a.attrelid = c.oid) inner join pg_catalog.pg_type
t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and
d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname,
c.relname, attnum
Any idea how to resolve this issue ?
Thanks in Advance.
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Kort | 2021-05-19 10:55:20 | RE: Query with straightforward plan changes and becomes 6520 times slower after VACUUM ANALYZE |
Previous Message | PG Bug reporting form | 2021-05-19 09:33:57 | BUG #17023: wal_log_hints not configured even if it on |