Postgres Pro
Downloads
Home   >   mailing lists

bug in pg_dump ALTER DATABASE - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject bug in pg_dump ALTER DATABASE
Date
Msg-id 40E0E8DE.7010906@familyhealth.com.au
Whole thread Raw
Responses Re: bug in pg_dump ALTER DATABASE  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: bug in pg_dump ALTER DATABASE  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tree view 
As part of my testing, I noticed this bug.  My database has a 
search_path set in the database vars.  It dumps lik ethis:

DROP DATABASE usa;
CREATE DATABASE usa WITH TEMPLATE = template0 OWNER = usadmin ENCODING = 
'LATIN1';
ALTER DATABASE usa SET search_path TO 'public, contrib';

Notice the single quotes around the TO bit?  That's completely broken. 
Those '' must not be there.

Is a fix for this required for only search_path, or is it a more general 
problem?

Chris

pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: client_min_messages in dumps?
Next
From: Tom Lane
Date:
Subject: Re: bug in pg_dump ALTER DATABASE