Обсуждение: Bug #841: SET search_path in createdb -T ... and pgdump

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

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