Postgres Pro
Downloads
Home   >   mailing lists

Re: Schema-qualified statements in pg_dump output - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: Schema-qualified statements in pg_dump output
Date
Msg-id D1C06067E6169A6E1AC3B499@imhotep.credativ.de
Whole thread Raw
In response to Re: Schema-qualified statements in pg_dump output  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Schema-qualified statements in pg_dump output  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Schema-qualified statements in pg_dump output  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Tree view 
--On Montag, Juli 07, 2008 10:33:35 -0400 Tom Lane <tgl@sss.pgh.pa.us> 
wrote:

> It seems like quite a useless change, since in general there will be
> other qualified references in the dump that can't safely be removed.
> IOW what you intend to do doesn't work anyway.

Hmm, If i want to restore just a bunch of tables into a different schema, 
all i need to do is to change the dump's search_path then and i don't have 
to bother with DDL statements having hardwired schema qualifications. So 
this seems a straight forward simplification to me.

--  Thanks
                   Bernd

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] WIP: executor_hook for pg_stat_statements
Next
From: Andrew Dunstan
Date:
Subject: Re: PATCH: CITEXT 2.0 v2