Re: Catalogs design question - Mailing list pgsql-hackers

From Steve Howe
Subject Re: Catalogs design question
Date
Msg-id 001d01c1593e$318c5790$8430b0c8@angla
Whole thread Raw
In response to Re: Catalogs design question  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Catalogs design question
Re: Catalogs design question
List pgsql-hackers
Hello Bruce!

> Yes, we inherited these arrays from Berkeley and haven't had any need to
> remove them.  Are you trying to do things that the other interfaces like
> ODBC and JDBC don't handle?
About the groups: I just want to write a function that will return the users
names belonged by a given group. I understand I can load the arrays in
memory, then sequentially compare the members from pg_shadow, but doing it
goes against the database priciple after all.
About the procs: the Borland's dbExpress specification demands a
input/output list of parameters for stored procedures, and I'm going to use
functions as stored procedures. But I need to make a types list to be able
list what are those params.

> The group array is a hack but the pg_proc array would be hard to replace
> becauseit acts as part of the unique key used for cache lookups.
This design itself bothers me.
We have no other option left  ? Like arrays being referenced in relations ?
That's far from perfect, but at least would solve those issues and others
which might appear in other catalogs...

Best Regards,
Steve Howe



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Catalogs design question
Next
From: "Steve Howe"
Date:
Subject: Re: Catalogs design question