From: daniel alvarez <d-alvarez@gmx.de>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: neilc@samurai.com
Cc: tgl@sss.pgh.pa.us
Cc: chriskl@familyhealth.com.au
Cc: dev@archonet.com
Cc: pgsql-performance@postgresql.org
Subject: Re: OIDs as keys
Date: Sat, 8 Mar 2003 21:01:32 +0100 (MET)
Message-ID: <26462.1047153692@www68.gmx.net> (raw)
References: <200303070150.h271oaW02436@candle.pha.pa.us>
> Neil Conway wrote:
> > On Thu, 2003-03-06 at 16:13, Bruce Momjian wrote:
> > > It would be good to somehow SET the use_oids GUC value on restore
> start,
> > > and just use SET when the table is different than the default, but
> then
> > > there is no mechanism to do that when you restore a single table.
> >
> > What if the default value changes?
> >
> > IMHO, running a SET per CREATE TABLE isn't too ugly...
>
> 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? Having a session setting for the
common case and a CREATE-TABLE clause for the specifics sounds natural.
When a single table needs to be restored all one needs to to is changing the
session setting before running the CREATE command. The alternative clause
in CREATE-TABLE statements would be used as a cleaner way of expressing
the same thing without affecting the session, when the statement's text can
be entered manually (as opposed to loading it from an existing dumpfile).
The default for the session setting could be set in the configuration file
then.
regards, Daniel Alvarez Arribas <d-alvarez@gmx.de>
--
+++ GMX - Mail, Messaging & more http://www.gmx.net +++
Bitte lächeln! Fotogalerie online mit GMX ohne eigene Homepage!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: d-alvarez@gmx.de, pgman@candle.pha.pa.us, neilc@samurai.com, tgl@sss.pgh.pa.us, chriskl@familyhealth.com.au, dev@archonet.com
Subject: Re: OIDs as keys
In-Reply-To: <26462.1047153692@www68.gmx.net>
References: <200303070150.h271oaW02436@candle.pha.pa.us> <26462.1047153692@www68.gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox