Re: [pgadmin-hackers] What about CREATE OR REPLACE FUNC - Mailing list pgsql-hackers

From Dave Page
Subject Re: [pgadmin-hackers] What about CREATE OR REPLACE FUNC
Date
Msg-id AA30E7BCCA5C1D4E88A231900F8325C00B82@dogbert.vale-housing.co.uk
Whole thread Raw
List pgsql-hackers

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
> Sent: 08 October 2001 15:13
> To: Dave Page
> Cc: 'Jean-Michel POURE'; pgsql-hackers@postgresql.org; Bruce 
> Momjian; pgadmin-hackers@postgresql.org
> Subject: Re: [pgadmin-hackers] [HACKERS] What about CREATE OR 
> REPLACE FUNC TION? 
> 
> 
> 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.

I tried postgresql.rmplc.co.uk and got one (apparently) dated 7 Oct, however
CREATE OR REPLACE FUNCTION didn't seem to be there (it certainly doesn't
work anyway - syntax error at OR). I then looked in the primary copy on
mail.postgresql.org and found the copy there was dated 30 Sept from which I
assumed that the 07/10/2001 date on rm's copy was actually a US date - that
site has been seriously out of date before.

> 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?

I've tried it a few times and I always get something like:

root@tux1:/usr/local/src/pgsql# ./configure
su: ./configure: bad interpreter: No such file or directory
root@tux1:/usr/local/src/pgsql# sh ./configure
: command not found
: command not found
: command not found
: command not found
: command not found
'/configure: line 127: syntax error near unexpected token `do
'/configure: line 127: `do
root@tux1:/usr/local/src/pgsql#

I always assumed that something is done when the tarballs are built as the
work just fine on the same machine. The only odd thing I can think of is
that my copy of the source is maintained on my PC using WinCVS and was
zipped/ftp'd onto a test box.

Regards, Dave.



pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: [pgadmin-hackers] What about CREATE OR REPLACE FUNC
Next
From: Patrice Hédé
Date:
Subject: Mule internal code ?