Re: pg_restore --single-transaction and --clean

Kevin Grittner escribió:
> Robert Haas <robertmhaas@gmail.com> wrote:
> > Tom Lane <tgl@sss.pgh.pa.us> wrote:
>  
> >> We try to avoid using nonstandard SQL in dumps.
> > 
> > How often do we succeed?  It seems unlikely that our dumps would
> > be restorable into any other database.
>  
> When we were running in a mixed environment we had several occasions
> where it was useful to feed pg_dump --column-inserts output into
> Sybase databases.  It was very nice to have that.  I think we did
> sometimes have to filter it through sed to deal with BOOLEAN vs BIT
> issues.

Maybe we should have a --compatible-mode or some such that enables these
things, instead of staying away from useful PG-only features.

The problem would then be how to test it ...

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.