Bug #841: SET search_path in createdb -T ... and pgdump - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #841: SET search_path in createdb -T ... and pgdump
Date
Msg-id 20021209133948.42B36475B84@postgresql.org
Whole thread Raw
Responses Re: Bug #841: SET search_path in createdb -T ... and pgdump  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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 by date:

Previous
From: Neil Conway
Date:
Subject: Re: datatypes: text vs varchar
Next
From: Tom Lane
Date:
Subject: Re: Bug #841: SET search_path in createdb -T ... and pgdump