Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] contrib

From: "Joe Conway" <joe(at)conway-family(dot)com>
To: <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] contrib
Date: 2001-05-15 03:54:46
Message-ID: 00df01c0dcf2$c8e21530$0705a8c0@jecw2k1 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
> > Is there a formal way of submiting something to the
> > contrib section of the distribution?
>
> Not really.  Just throw it over to patches, and we will check it out.
>
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us

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. I also remembered that I have
needed the first function before and could not find anything. Attached is a
group of 4 functions, suitable (I think) for contrib, as follows:

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)

Installation:
copy to contrib
tar -xzvf current_db.tgz
cd current_db
./install.sh (or alternatively make; make install; psql -U postgres
your_db_name < current_db.sql)

I'd like to have this considered for inclusion in contrib if deemed useful
to others. Is there anything specific I need to do to in addition to the
attached?

Thanks,

-- Joe



Attachment: current_db.tgz
Description: application/x-compressed (2.4 KB)

In response to

  • Re: contrib at 2001-02-05 03:42:10 from Bruce Momjian

Responses

pgsql-hackers by date

Next:From: Justin CliftDate: 2001-05-15 03:58:39
Subject: Re: Re: [HACKERS] contrib
Previous:From: Tom LaneDate: 2001-05-15 03:34:33
Subject: Re: Updating system catalogs after a tuple deletion

pgsql-patches by date

Next:From: Justin CliftDate: 2001-05-15 03:58:39
Subject: Re: Re: [HACKERS] contrib
Previous:From: Bruce MomjianDate: 2001-05-15 03:47:50
Subject: Re: Remove columns pg_index.haskeytype and pg_index.indisclustered

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group