Skip to content

Commit 6f51beb

Browse files
committed
feat: add USER_CONS_COLUMNS view to ivorysql_ora sysview
1 parent 91e0b82 commit 6f51beb

File tree

14 files changed

+42435
-56
lines changed

14 files changed

+42435
-56
lines changed

contrib/ivorysql_ora/ivorysql_ora--1.0.sql

Lines changed: 14409 additions & 0 deletions
Large diffs are not rendered by default.

logfile

Lines changed: 46 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,46 @@
1+
2026-03-11 11:14:54.169 CST [35009] LOG: starting PostgreSQL 18beta1 (IvorySQL 5beta1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit
2+
2026-03-11 11:14:54.169 CST [35009] LOG: listening on IPv4 address "127.0.0.1", port 5432
3+
2026-03-11 11:14:54.176 CST [35009] LOG: listening on IPv4 address "127.0.0.1", port 1521
4+
2026-03-11 11:14:54.182 CST [35009] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
5+
2026-03-11 11:14:54.194 CST [35009] LOG: listening on Unix socket "/tmp/.s.PGSQL.1521"
6+
2026-03-11 11:14:54.208 CST [35015] LOG: database system was shut down at 2026-03-11 11:14:12 CST
7+
2026-03-11 11:14:54.244 CST [35009] LOG: database system is ready to accept connections
8+
2026-03-11 11:16:44.505 CST [35022] ERROR: invalid LC_COLLATE locale name: "zh_CN.UTF-8"
9+
2026-03-11 11:16:44.505 CST [35022] STATEMENT: CREATE DATABASE ivory_dev
10+
WITH
11+
OWNER = postgres
12+
ENCODING = 'UTF8'
13+
LC_COLLATE = 'zh_CN.UTF-8'
14+
LC_CTYPE = 'zh_CN.UTF-8';
15+
2026-03-11 11:19:28.515 CST [35054] ERROR: new collation (C.utf8) is incompatible with the collation of the template database (C.UTF-8)
16+
2026-03-11 11:19:28.515 CST [35054] HINT: Use the same collation as in the template database, or use template0 as template.
17+
2026-03-11 11:19:28.515 CST [35054] STATEMENT: CREATE DATABASE ivory_dev
18+
WITH
19+
OWNER = postgres
20+
ENCODING = 'UTF8'
21+
LC_COLLATE = 'C.utf8'
22+
LC_CTYPE = 'C.utf8';
23+
2026-03-11 11:20:07.936 CST [35013] LOG: checkpoint starting: time
24+
2026-03-11 11:22:14.638 CST [35013] LOG: checkpoint complete: wrote 1201 buffers (7.3%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 1 recycled; write=125.952 s, sync=0.704 s, total=126.702 s; sync files=332, longest=0.007 s, average=0.003 s; distance=5844 kB, estimate=5844 kB; lsn=0/29F1E40, redo lsn=0/24A8ED8
25+
2026-03-11 11:34:24.587 CST [37334] ERROR: database "ivory_demo" already exists
26+
2026-03-11 11:34:24.587 CST [37334] STATEMENT: CREATE DATABASE ivory_demo OWNER = postgres;
27+
2026-03-11 11:35:09.346 CST [37334] ERROR: database "ivory_demo" already exists
28+
2026-03-11 11:35:09.346 CST [37334] STATEMENT: CREATE DATABASE ivory_demo OWNER = postgres;
29+
2026-03-11 11:36:32.243 CST [37334] ERROR: database "ivory_demo" already exists
30+
2026-03-11 11:36:32.243 CST [37334] STATEMENT: CREATE DATABASE ivory_demo OWNER = postgres;
31+
2026-03-11 11:37:29.286 CST [38180] ERROR: type "number" does not exist at character 28
32+
2026-03-11 11:37:29.286 CST [38180] STATEMENT: CREATE TABLE user_info (id NUMBER(10) PRIMARY KEY, username VARCHAR2(50) NOT NULL, email VARCHAR2(100), create_time DATE DEFAULT SYSDATE);
33+
2026-03-11 11:38:06.115 CST [38180] ERROR: extension "orafce" is not available
34+
2026-03-11 11:38:06.115 CST [38180] HINT: The extension must first be installed on the system where PostgreSQL is running.
35+
2026-03-11 11:38:06.115 CST [38180] STATEMENT: CREATE EXTENSION IF NOT EXISTS orafce;
36+
2026-03-11 11:46:12.050 CST [35013] LOG: checkpoint starting: time
37+
2026-03-11 11:48:14.378 CST [35013] LOG: checkpoint complete: wrote 1153 buffers (7.0%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=121.526 s, sync=0.763 s, total=122.329 s; sync files=324, longest=0.006 s, average=0.003 s; distance=5423 kB, estimate=5802 kB; lsn=0/29F4D38, redo lsn=0/29F4CA8
38+
2026-03-11 12:06:38.699 CST [35009] LOG: received fast shutdown request
39+
2026-03-11 12:06:38.704 CST [35009] LOG: aborting any active transactions
40+
2026-03-11 12:06:38.720 CST [35022] FATAL: terminating connection due to administrator command
41+
2026-03-11 12:06:38.723 CST [35057] FATAL: terminating connection due to administrator command
42+
2026-03-11 12:06:38.723 CST [35009] LOG: background worker "logical replication launcher" (PID 35018) exited with exit code 1
43+
2026-03-11 12:06:38.748 CST [35013] LOG: shutting down
44+
2026-03-11 12:06:38.757 CST [35013] LOG: checkpoint starting: shutdown immediate
45+
2026-03-11 12:06:38.798 CST [35013] LOG: checkpoint complete: wrote 0 buffers (0.0%), wrote 0 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.001 s, total=0.051 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=5222 kB; lsn=0/29F4DE8, redo lsn=0/29F4DE8
46+
2026-03-11 12:06:38.856 CST [35009] LOG: database system is shut down

orafce

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
Subproject commit e126058d785f93d1b5c39fc7465540737f884bd5

src/backend/catalog/oracle_compat_views.sql

Lines changed: 0 additions & 56 deletions
This file was deleted.

src/bin/initdb/postgres

11.1 MB
Binary file not shown.

0 commit comments

Comments
 (0)