Bug #841: SET search_path in createdb -T ... and pgdump

Started by PostgreSQL Bugs Listover 23 years ago2 messagesbugs
Jump to latest
#1PostgreSQL Bugs List
pgsql-bugs@postgresql.org

Przemyslaw Sztoch (jnavy@o2.pl) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
SET search_path in createdb -T ... and pgdump

Long Description
Database variable is not dumped in pg_dump.
Database variable is not copied by cratedb with -T parameter.

Sample Code
Do it:
1.
CREATE DATABASE dbase;
CREATE SCHEMA grfinn AUTHORIZATION dba;
ALTER DATABASE dbase SET search_path = grfinn;

2.
createdb dbase2
pg_dump dbase|psql dbase2
createdb

3.
createdb -T dbase dbase3

In both database (dbase2 and dbase3) search_path is not set.

No file was uploaded with this report

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PostgreSQL Bugs List (#1)
Re: Bug #841: SET search_path in createdb -T ... and pgdump

pgsql-bugs@postgresql.org writes:

Database variable is not dumped in pg_dump.

It's not supposed to be. See pg_dumpall.

regards, tom lane