Re: [HACKERS] What about CREATE OR REPLACE

2001-10-04 Thread Jean-Michel POURE
>I've been following this thread on pgsql-patches - obviously my brain has >lost too many brain cells following the 3 pints of beer I've had this week >'cos the usefulness of this just didn't register!! Let's have another pint of beer, Fiesta, C'est la fĂȘte !!! Cheers /JMP

Re: [HACKERS] What about CREATE OR REPLACE FUNC

2001-10-04 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 04 October 2001 14:40 > To: [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] [HACKERS] What about CREATE OR > REPLACE FUNCTION? > > > Hi, > > Think this might be interesting. > If CREATE OR REPLACE F

Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?

2001-10-04 Thread Tom Lane
Jean-Michel POURE <[EMAIL PROTECTED]> writes: > Does CREATE OR REPLACE FUNCTION preserve function OID? Yes. That's the whole point ... > What it the difference with CREATE OR ALTER FUNCTION? The former exists (now), the latter doesn't exist. regards, tom lane

Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?

2001-10-04 Thread Gavin Sherry
On Thu, 4 Oct 2001, Jean-Michel POURE wrote: > Hello, > > Does CREATE OR REPLACE FUNCTION preserve function OID? > What it the difference with CREATE OR ALTER FUNCTION? > > We would like to implement pseudo-editing of functions in pgAdmin II. > Is there any solution which preserves function OID

Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?

2001-10-04 Thread Jean-Michel POURE
> > Did we come to any conclusion about whether to accept Gavin Sherry's > > CREATE OR REPLACE FUNCTION patch? > > http://fts.postgresql.org/db/mw/msg.html?mid=1035792 > > AFAIR, the score was that I liked it, Bruce didn't, and no one else > > had expressed an opinion. > >I withdraw my objection.

Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?

2001-10-04 Thread Jean-Michel POURE
Hi, Think this might be interesting. If CREATE OR REPLACE FUNCTION comes up, views and triggers will not break anymore. Cheers, Jean-Michel POURE > Did we come to any conclu

Re: pgAdmin

2001-10-04 Thread Jean-Michel POURE
>Hello! >I'm a Linux writer, and have included pgAdmin in my second Linux book, about >to come out. Can you tell me if the last version of 'pgAdmin I' --for want >of a better term-- is still available? >Thanks! >John Lathrop >[EMAIL PROTECTED] Hello John, Thank you for your interest in pgAdmin