Re: Re: [HACKERS] contrib

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joe Conway" <joe(at)conway-family(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Re: [HACKERS] contrib
Date: 2001-05-15 04:42:51
Message-ID: 29576.989901771@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

"Joe Conway" <joe(at)conway-family(dot)com> writes:
> While thinking about how to implement TABLE_PRIVILEGES view per SQL92, I
> realized that a function is needed to dynamically return the current
> database name, and current database owner.

Just out of curiosity, why are these needed for TABLE_PRIVILEGES?

> current_dbname() - returns name of current database
> current_dboid() - retuns oid of current database
> current_dbownername() - returns owner name of current database (based on
> datdba)
> current_dbownerid() - returns owner usesysid (well, more accurately datdba)

One thing to bear in mind is that the existing notion of databases
may need to be rethought when we implement SQL-style schemas (which
I hope will happen for 7.2). It might be best to refrain from inventing
more functions until we see how the schema work settles out.

I haven't yet heard any serious discussion about how to integrate
the SQL-defined schema concepts with Postgres' traditional concept of
independent databases within an installation. It's about time to have
that discussion though ...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-05-15 04:45:08 Re: Re: bug in pgcrypto 0.3
Previous Message Bruce Momjian 2001-05-15 04:40:54 SCHEMA idea

Browse pgsql-patches by date

  From Date Subject
Next Message Joe Conway 2001-05-15 06:19:01 Re: Re: [HACKERS] contrib
Previous Message Bruce Momjian 2001-05-15 04:27:43 Re: Remove columns pg_index.haskeytype and pg_index.indisclustered