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

Rename Schema in MonetDB #6609

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

Rename Schema in MonetDB #6609

monetdb-team opened this issue Nov 30, 2020 · 0 comments

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

Date: 2018-06-05 15:53:33 +0200
From: Harman DBA <>
To: SQL devs <>
Version: 11.29.7 (Mar2018-SP1)
CC: kravchenko.anton86, martin.van.dinther, @PedroTadim

Last updated: 2019-04-30 12:36:03 +0200

Comment 26476

Date: 2018-06-05 15:53:33 +0200
From: Harman DBA <>

User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36
Build Identifier:

We need to rename schema as we have challenges exporting database objects and importing it to a new database with a different schema name if the size of the database is huge(500GB +).

Reproducible: Always

Steps to Reproduce:

1.need to make a copy of the database with a different schema name
2.exporting database is taking longer time, to avoid, We plan to make a cold backup and rename schema
3.this can resolve if the schema can be renamed

Actual Results:

NA

Expected Results:

rename schema on a database

Ability to rename objects - need option to rename tables,rename schemas.

Comment 26485

Date: 2018-06-14 15:24:44 +0200
From: Martin van Dinther <<martin.van.dinther>>

Changed it to an enhancement request.

Suggested syntax: ALTER SCHEMA name RENAME TO new_name
See also: https://www.postgresql.org/docs/current/static/sql-alterschema.html

Renaming a table name is already recorded in:
https://www.monetdb.org/bugzilla/show_bug.cgi?id=3567

Renaming a column name is already recorded in:
https://www.monetdb.org/bugzilla/show_bug.cgi?id=2478

Comment 26671

Date: 2018-11-07 11:48:07 +0100
From: @PedroTadim

A new SQL statement will be available in the next feature release of MonetDB for renaming schemas:

ALTER SCHEMA [IF EXISTS] oldname RENAME TO newname;

Comment 26844

Date: 2019-01-23 13:25:29 +0100
From: @sjoerdmullender

Will be in next feature release.

Comment 26959

Date: 2019-04-16 22:04:19 +0200
From: @sjoerdmullender

*** Bug #6698 has been marked as a duplicate of this bug. ***

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant