Thread: FW: Patch for current_schemas to optionally include implicit schemas
I posted this a few days ago - I think it must have got lost somewhere :-( > -----Original Message----- > From: Dave Page > Sent: 03 June 2002 20:09 > To: pgsql-patches@postgresql.org > Cc: 'Tom Lane' > Subject: Patch for current_schemas to optionally include > implicit schemas > > > Following my discussion with Tom on -hackers a while ago > about finding the full schema search path, I decided to give > it a go myself and hopefully both learn something, and give > Tom one less thing to do! > > Attached is the result which seems to work OK here. The > existing current_schemas() works as previously, & I have > added current_schemas(bool) which will return the full > implicit/explicit path if passed true or the explicit path is > pass false. > > Thorough checking is advised in case I've done something > nasty or missed something I was unaware of (being my first > venture into the backend code) :-) > > Regards, Dave. > >
Attachment
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
Dave Page wrote:
> I posted this a few days ago - I think it must have got lost somewhere
> :-(
>
> > -----Original Message-----
> > From: Dave Page
> > Sent: 03 June 2002 20:09
> > To: pgsql-patches@postgresql.org
> > Cc: 'Tom Lane'
> > Subject: Patch for current_schemas to optionally include
> > implicit schemas
> >
> >
> > Following my discussion with Tom on -hackers a while ago
> > about finding the full schema search path, I decided to give
> > it a go myself and hopefully both learn something, and give
> > Tom one less thing to do!
> >
> > Attached is the result which seems to work OK here. The
> > existing current_schemas() works as previously, & I have
> > added current_schemas(bool) which will return the full
> > implicit/explicit path if passed true or the explicit path is
> > pass false.
> >
> > Thorough checking is advised in case I've done something
> > nasty or missed something I was unaware of (being my first
> > venture into the backend code) :-)
> >
> > Regards, Dave.
> >
> >
Content-Description: current_schemas.diff
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Bruce Momjian <pgman@candle.pha.pa.us> writes: > Your patch has been added to the PostgreSQL unapplied patches list at: > http://candle.pha.pa.us/cgi-bin/pgpatches > I will try to apply it within the next 48 hours. I believe I objected to that one... we need something like it but Dave's first cut wasn't right. regards, tom lane
This patch is returned for further work/review. --------------------------------------------------------------------------- Dave Page wrote: > I posted this a few days ago - I think it must have got lost somewhere > :-( > > > -----Original Message----- > > From: Dave Page > > Sent: 03 June 2002 20:09 > > To: pgsql-patches@postgresql.org > > Cc: 'Tom Lane' > > Subject: Patch for current_schemas to optionally include > > implicit schemas > > > > > > Following my discussion with Tom on -hackers a while ago > > about finding the full schema search path, I decided to give > > it a go myself and hopefully both learn something, and give > > Tom one less thing to do! > > > > Attached is the result which seems to work OK here. The > > existing current_schemas() works as previously, & I have > > added current_schemas(bool) which will return the full > > implicit/explicit path if passed true or the explicit path is > > pass false. > > > > Thorough checking is advised in case I've done something > > nasty or missed something I was unaware of (being my first > > venture into the backend code) :-) > > > > Regards, Dave. > > > > Content-Description: current_schemas.diff [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026