Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

There was an error while restoring the backup #483

Closed
Outsider0413 opened this issue Sep 5, 2023 · 2 comments
Closed

There was an error while restoring the backup #483

Outsider0413 opened this issue Sep 5, 2023 · 2 comments
Assignees
Labels
3.0 bug Something isn't working Community Community Supported Feature CR code check

Comments

@Outsider0413
Copy link
Contributor

Bug Report

After creating a table with the column attribute pg_catalog.varchar in Oracle mode, the type after restoring through pg_dump backup is inconsistent.

IvorySQL Version

master

OS Version (uname -a)

CentOS 7

Configuration options ( config.status --config )

./configure --prefix=$PWD/inst --enable-cassert --enable-debug --enable-tap-tests --enable-rpath --with-tcl --with-python --with-gssapi --with-pam --with-ldap --with-openssl --with-libedit-preferred --with-uuid=e2fs --with-ossp-uuid --with-libxml --with-libxslt --with-perl --with-icu CFLAGS='-DGCC_HASCLASSVISIBILITY -O0 -Wall -W -g3 -gdwarf-2'

Current Behavior

image
./pg_dump -dpostgres -p1521 > 1.sql
image
./createdb test
./psql -dtest -p1521 < 1.sql
image

Expected behavior/code

The data type after restoration should be the same as before

Step to reproduce

./configure --prefix=$PWD/inst --enable-cassert --enable-debug --enable-tap-tests --enable-rpath --with-tcl --with-python --with-gssapi --with-pam --with-ldap --with-openssl --with-libedit-preferred --with-uuid=e2fs --with-ossp-uuid --with-libxml --with-libxslt --with-perl --with-icu CFLAGS='-DGCC_HASCLASSVISIBILITY -O0 -Wall -W -g3 -gdwarf-2'
make
make install
./initdb -D ../data
./pg_ctl -D ../data -l ../logfile start
./createdb test
./psql -dpostgre -p1521
create table test(a pg_catalog.varchar);
./pg_dump -dpostgre -p1521 > 1.sql
./psql -dtest -p1521 < 1.sql

Additional context that can be helpful for identifying the problem

@Outsider0413
Copy link
Contributor Author

Outsider0413 commented Sep 7, 2023

#494

@DutMsn
Copy link
Contributor

DutMsn commented Sep 11, 2023

This issue has been resolved in PR #494 . So we need to close it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
3.0 bug Something isn't working Community Community Supported Feature CR code check
Projects
No open projects
Development

No branches or pull requests

3 participants