Re: OIDs as keys

daniel alvarez wrote:
> > daniel alvarez  writes:
> > >> Not ugly, but a little noisy.  However, my idea of having a single SET
> > >> at the top is never going to work, so I don't have a better idea.
> > 
> > > Why isn't this done on a per-session basis?
> > 
> > Because pg_dump can't know what the session default will be when the
> > dump is reloaded.  The scheme you are proposing will only succeed in
> > making pg_dump unreliable.
> 
> Ouch. Why is this? Doesn't it read the config because of portability
> reasons?

Remember the dump output is just an SQL script, so there is no 'logic'
in the script, and it can be loaded right into psql.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073