

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


Mon, 8 Oct 2001 15:27:36 +0100 
Dave Page <dpage@vale-housing.co.uk>
Re: [pgadmin-hackers] What about CREATE OR REPLACE FUNC
Dave Page <dpage@vale-housing.co.uk> writes:
> ... I can't find an up-to-date snapshot

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

I just downloaded
ftp://ftp.us.postgresql.org/dev/postgresql-snapshot.tar.gz
which has a date of yesterday in the FTP archives, but actually
contains a snapshot from around 15 September as near as I can tell.
Looks like something is hosed in the snapshot preparation process;
Marc, could you take a look at it?

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

> I always assumed that something is done when the tarballs are built as the
> work just fine on the same machine.

No, the tarballs should be the same as what you get from a CVS pull
of the same date (other than not having a lot of /CVS subdirectories).
In fact, they're made basically by tar'ing up a CVS checkout.  Please
try diffing configure from a tarball against one from CVS to see if you
can figure out what's getting munged during your CVS pull.

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

LF vs CR/LF newlines leap to mind as a likely source of trouble...
though I'm not sure why that would manifest in just this way...

			regards, tom lane

Mon, 08 Oct 2001 11:42:52 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Daily snapshots hosed (was Re: [pgadmin-hackers] What about CREATE OR
	REPLACE FUNCTION?)

okay, daily snapshots are now being generated on the new server ... right
now, all the mirror sites are stale while Vince does some finishing
touches on the mirroring scripts/cgi's ... once he gerts that done, then,
from my perspective, we'll be ready for beta ...


On Mon, 8 Oct 2001, Tom Lane wrote:

> Dave Page <dpage@vale-housing.co.uk> writes:
> > ... I can't find an up-to-date snapshot
>
> > 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.
>
> I just downloaded
> ftp://ftp.us.postgresql.org/dev/postgresql-snapshot.tar.gz
> which has a date of yesterday in the FTP archives, but actually
> contains a snapshot from around 15 September as near as I can tell.
> Looks like something is hosed in the snapshot preparation process;
> Marc, could you take a look at it?
>
> >> 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.
>
> > I always assumed that something is done when the tarballs are built as the
> > work just fine on the same machine.
>
> No, the tarballs should be the same as what you get from a CVS pull
> of the same date (other than not having a lot of /CVS subdirectories).
> In fact, they're made basically by tar'ing up a CVS checkout.  Please
> try diffing configure from a tarball against one from CVS to see if you
> can figure out what's getting munged during your CVS pull.
>
> > 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.
>
> LF vs CR/LF newlines leap to mind as a likely source of trouble...
> though I'm not sure why that would manifest in just this way...
>
> 			regards, tom lane
>


Wed, 10 Oct 2001 09:05:24 -0400 (EDT)
"Marc G. Fournier" <scrappy@hub.org>
Re: Daily snapshots hosed (was Re: [pgadmin-hackers] What