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