| From: | "Joe Conway" <joe(at)conway-family(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: Re: [HACKERS] contrib |
| Date: | 2001-05-15 06:19:01 |
| Message-ID: | 016a01c0dd06$efb89e90$0705a8c0@jecw2k1 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
>
> Just out of curiosity, why are these needed for TABLE_PRIVILEGES?
>
Only one is really needed for that purpose, current_dbname. TABLE_PRIVILEGES
defines the field TABLE_CATALOG which should be set to the current database
name. In MSSQL7 you can get the current database using a function called
DB_NAME(). In Oracle, you can get it by querying for NAME from V_$DATABASE.
-- Joe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vadim Mikheev | 2001-05-15 06:57:58 | Re: Postgres bug (working with iserverd) |
| Previous Message | Max Khon | 2001-05-15 05:50:57 | Re: 7.2 items |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2001-05-15 09:22:38 | Re: GIST question |
| Previous Message | Tom Lane | 2001-05-15 04:42:51 | Re: Re: [HACKERS] contrib |