Re: Accessing schema data in information schema - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Accessing schema data in information schema
Date
Msg-id 11052.1143136055@sss.pgh.pa.us
Whole thread Raw
In response to Re: Accessing schema data in information schema  ("Zeugswetter Andreas DCP SD" <ZeugswetterA@spardat.at>)
Responses Re: Accessing schema data in information schema  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
"Zeugswetter Andreas DCP SD" <ZeugswetterA@spardat.at> writes:
> Of course if we still need one row in pg_class for the ACL's, that row
> might as well be a view.

Yeah, view or view-like thingie.  Given the thought that we need both
transactional and nontransactional state for a sequence, I'm kind of
inclined to leave the transactional data in pg_class.  We could still
imagine putting the nontransactional state into a new pg_sequence
catalog indexed by, say, the pg_class OID of the sequences.  OTOH I'm
not sure how much that buys for Peter's problem --- it might be better
for him just to invent some functions that can grab the required data
given the sequence OID.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas DCP SD"
Date:
Subject: Re: Accessing schema data in information schema
Next
From: Andrew Dunstan
Date:
Subject: Re: Accessing schema data in information schema