Skip site navigation (1) Skip section navigation (2)

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

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #841: SET search_path in createdb -T ... and pgdump
Date: 2002-12-09 13:39:48
Message-ID: 20021209133948.42B36475B84@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Przemyslaw Sztoch (jnavy(at)o2(dot)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


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-12-09 15:32:59
Subject: Re: Bug #841: SET search_path in createdb -T ... and pgdump
Previous:From: Rafael FernandezDate: 2002-12-08 23:09:10
Subject: Can't start postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group