Thread: Re: [HACKERS] What about CREATE OR REPLACE FUNC

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm.poure@freesurf.fr]
> Sent: 08 October 2001 14:43
> To: pgsql-hackers@postgresql.org
> Cc: Tom Lane; Bruce Momjian; pgadmin-hackers@postgresql.org
> Subject: Re: [pgadmin-hackers] [HACKERS] What about CREATE OR
> REPLACE FUNCTION?
>
>
> Dear all,
>
> 1) CREATE OR REPLACE FUNCTION
> In pgAdmin II, we plan to use the CREATE OR REPLACE FUNCTION
> if the patch
> is applied. Do you know if there is any chance it be applied
> for beta time?
> We would very much appreciate this feature...

It's already done in pgAdmin CVS (committed this morning) and I believe
Bruce committed the patch to PostgreSQL on 2nd October. I just haven't
tested it yet as I can't find an up-to-date snapshot and I don't know the
magic that has to be worked on the PostgreSQL CVS version of the configure
script in order to make it run without barfing.

> 2) PL/pgSQL default support
> It is sometimes tricky for Windows users to install a
> language remotely on
> a Linux box (no access to createlang and/or no knowledge of
> handlers). So
> why not enable PL/pgSQL by default?

2nd 'ed!

Regards, Dave.

Dave Page <dpage@vale-housing.co.uk> writes:
> ... I can't find an up-to-date snapshot

Where have you looked?  I checked a couple of FTP mirrors at random and
see up-to-date snapshots, eg at ftp://ftp.us.postgresql.org/dev/
ftp://postgresql.wavefire.com/pub/dev/
ftp://postgresql.rmplc.co.uk/pub/postgresql/dev/
all of which have snapshots dated Sun Oct  7 08:02:00 2001 as I write.

> and I don't know the
> magic that has to be worked on the PostgreSQL CVS version of the configure
> script in order to make it run without barfing.

News to me that it requires any magic at all; I use it almost daily
without problems.  Why doesn't it work for you?

            regards, tom lane