Re: Updating OID column

On Mon, Apr 10, 2006 at 04:40:50PM +0800, Qingqing Zhou wrote:
>
> "Peter Eisentraut" <peter_e(at)gmx(dot)net> wrote
> > Is there a reason for why you can't update the OID column other than that
> no
> > one has bothered to code up the support for it?
> >
>
> AFAIK if two rows are with the same OID, we will think these two rows are
> different versions of the same tuple. So if we allow users to change OID
> columns, we may encounter some inconsistency.

Hardly, OIDs are optional anyway these days. We only guarentee that
OIDs will be unique if you have a unique index on them, so I imagine
the only reason it hasn't happened yet is because nobody's coded it.

How about when you select from a table with OIDs that it shows the OID
column? That would be the final step, wouldn't it?

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.