Hey guys,

Is it true to say that it's impossible for me to allow comments on 
casts, as there is no OID on the pg_cast table?

Chris



Tue, 14 Oct 2003 13:48:01 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
comments on casts
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> Is it true to say that it's impossible for me to allow comments on 
> casts, as there is no OID on the pg_cast table?

Eh?

regression=# select oid from pg_cast;
  oid
-------
 16420
 16421
 16422
 16423
 16424
 ... etc ...

It would be a very serious design error if pg_cast didn't have OIDs,
because then pg_cast entries couldn't have dependency entries in
pg_depend.

			regards, tom lane

Tue, 14 Oct 2003 02:30:57 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: comments on casts 
> regression=# select oid from pg_cast;
>   oid
> -------
>  16420
>  16421
>  16422
>  16423
>  16424
>  ... etc ...
> 
> It would be a very serious design error if pg_cast didn't have OIDs,
> because then pg_cast entries couldn't have dependency entries in
> pg_depend.

OK.  Weird.  I could have _sworn_ I tried that and I didn't get an OID 
column.  Oh well - makes things a lot easier.

Also, with the pg_largeobject table, there seems to be no 'owner' 
concept on lobs at all.  So is there no problem with any random gumby 
commenting on anyone else's large object?

Chris



Tue, 14 Oct 2003 14:48:54 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: comments on casts
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> Also, with the pg_largeobject table, there seems to be no 'owner' 
> concept on lobs at all.  So is there no problem with any random gumby 
> commenting on anyone else's large object?

We don't have a lot of choice.  I suppose ideally LOs should have
owners, but I don't really want to put that much effort (and breakage of
existing apps, no doubt) into them.

			regards, tom lane

Tue, 14 Oct 2003 09:43:07 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: comments on casts 
Christopher Kings-Lynne writes:

> Also, with the pg_largeobject table, there seems to be no 'owner'
> concept on lobs at all.  So is there no problem with any random gumby
> commenting on anyone else's large object?

Not any worse that any random gumby reading or writing anyone else's large
object.

-- 
Peter Eisentraut   peter_e@gmx.net


Tue, 14 Oct 2003 17:30:43 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: comments on casts