Re: [HACKERS] Making rpath a bit more flexible

2004-10-11 Thread Peter Eisentraut
Am Montag, 11. Oktober 2004 22:31 schrieb Tom Lane: > The problem of course is that we have no rpath pointing to the place > where libperl.so lives. (Now that I look, the only reason this worked > before was that I had /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE > mentioned in /etc/ld.so.con

Re: [HACKERS] CVS fixed ...

2004-10-11 Thread Heikki Linnakangas
On Mon, 11 Oct 2004, Marc G. Fournier wrote: Also, the link to cvsweb interface at http://developer.postgresql.org/ broke. How so? I just wwent to the link and everything appears fine to me ... There's a link to "PostgreSQL Server CVS web interface" in the bottom of that page, which still points

Re: [HACKERS] minor code question: portal memory cxts

2004-10-11 Thread Neil Conway
On Tue, 2004-10-12 at 09:40, Tom Lane wrote: > Copy-and-paste oversight I'd say. Probably the latter ought to be > "PortalHoldContext" or some such. Thanks, that's what I suspected. I've applied the attached fix to HEAD. -Neil Index: src/backend/utils/mmgr/portalmem.c ==

Re: [HACKERS] CVS fixed ...

2004-10-11 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > On Mon, 11 Oct 2004, Heikki Linnakangas wrote: >> Also, the link to cvsweb interface at http://developer.postgresql.org/ >> broke. > How so? I just wwent to the link and everything appears fine to me Down at the bottom of http://developer.postgre

Re: [HACKERS] Unit testing

2004-10-11 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > On Tue, 2004-10-12 at 05:08, Greg Stark wrote: >> You wouldn't be able to find errors in the semantics of xids for example, or >> in the WAL logic that didn't cover some corner case. Or race conditions >> between backends... > Going into this, these were p

Re: [HACKERS] open item: tablespace handing in pg_dump/pg_restore

2004-10-11 Thread Bruce Momjian
Greg Stark wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > OK, I have applied the following patch that uses Cygwin native symlink() > > instead of the Win32 junctions. The reason for this is that Cygwin > > symlinks work on Win95/98/ME where junction points do not > > Is this really a

Re: [HACKERS] Unit testing

2004-10-11 Thread Gavin Sherry
On Tue, 12 Oct 2004, Neil Conway wrote: > On Tue, 2004-10-12 at 05:08, Greg Stark wrote: > > But it seems to me that most of the really hard bugs to find involve subtle > > interactions between functions and the state of the database. > > > > You wouldn't be able to find errors in the semantics of

Re: [HACKERS] open item: tablespace handing in pg_dump/pg_restore

2004-10-11 Thread Greg Stark
Bruce Momjian <[EMAIL PROTECTED]> writes: > OK, I have applied the following patch that uses Cygwin native symlink() > instead of the Win32 junctions. The reason for this is that Cygwin > symlinks work on Win95/98/ME where junction points do not Is this really a Win95/98/ME vs NT distinction or

Re: [HACKERS] Unit testing

2004-10-11 Thread Gavin Sherry
On Mon, 11 Oct 2004, Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > On Tue, 2004-10-12 at 00:43, Tom Lane wrote: > >> Most likely (and I for one will for sure resist any attempt to force > >> global uniqueness on static names). > > > You're right that the issue can be avoided easily

Re: [HACKERS] CVS fixed ...

2004-10-11 Thread Marc G. Fournier
On Mon, 11 Oct 2004, Heikki Linnakangas wrote: On Sun, 10 Oct 2004, Marc G. Fournier wrote: pgsql-server renamed to pgsql contrib/earthdistance moved back into pgsql/contrib/earthdistance modules file updated for changes checkout seems to work fine for me ... let me know if there are any problems

Re: [HACKERS] Unit testing

2004-10-11 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > On Tue, 2004-10-12 at 00:43, Tom Lane wrote: >> Most likely (and I for one will for sure resist any attempt to force >> global uniqueness on static names). > You're right that the issue can be avoided easily enough, but what need > is there _not_ to have g

Re: [HACKERS] Unit testing

2004-10-11 Thread Neil Conway
On Tue, 2004-10-12 at 05:08, Greg Stark wrote: > But it seems to me that most of the really hard bugs to find involve subtle > interactions between functions and the state of the database. > > You wouldn't be able to find errors in the semantics of xids for example, or > in the WAL logic that didn

Re: [HACKERS] Unit testing

2004-10-11 Thread Neil Conway
On Tue, 2004-10-12 at 00:43, Tom Lane wrote: > Most likely (and I for one will for sure resist any attempt to force > global uniqueness on static names). You're right that the issue can be avoided easily enough, but what need is there _not_ to have globally unique function names? -Neil ---

Re: [CYGWIN] [HACKERS] open item: tablespace handing in pg_dump/pg_restore

2004-10-11 Thread Reini Urban
Bruce Momjian schrieb: Tom Lane wrote: Bruce Momjian <[EMAIL PROTECTED]> writes: OK, I have applied the following patch that uses Cygwin native symlink() instead of the Win32 junctions. The reason for this is that Cygwin symlinks work on Win95/98/ME where junction points do not and we have no way

Re: [HACKERS] minor code question: portal memory cxts

2004-10-11 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > The memory context created at src/backend/utils/mmgr/portalmem.c:183 > shares the name of the memory context created at portalmem.c:279 (they > are both called "PortalHeapMemory"). Is there a reason for this? Copy-and-paste oversight I'd say. Probably the

Re: [HACKERS] Need for DLLINIT in Makefile.shlib

2004-10-11 Thread Reini Urban
Bruce Momjian schrieb: I am curious why Cygwin needs DLLINIT in Makefile.shlib, and Win32 doesn't: # Cygwin case $(shlib) lib$(NAME).a: $(OBJS) $(DLLINIT) $(DLLTOOL) --export-all $(DLLTOOL_DEFFLAGS) --output-def $(NAME).def $(OBJS) $(DLLWRAP) -o $(sh

[HACKERS] minor code question: portal memory cxts

2004-10-11 Thread Neil Conway
The memory context created at src/backend/utils/mmgr/portalmem.c:183 shares the name of the memory context created at portalmem.c:279 (they are both called "PortalHeapMemory"). Is there a reason for this? -Neil ---(end of broadcast)--- TIP 5: Have

Re: [HACKERS] open item: tablespace handing in pg_dump/pg_restore

2004-10-11 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > OK, I have applied the following patch that uses Cygwin native symlink() > > instead of the Win32 junctions. The reason for this is that Cygwin > > symlinks work on Win95/98/ME where junction points do not and we have no > > way to kn

Re: [HACKERS] open item: tablespace handing in pg_dump/pg_restore

2004-10-11 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > OK, I have applied the following patch that uses Cygwin native symlink() > instead of the Win32 junctions. The reason for this is that Cygwin > symlinks work on Win95/98/ME where junction points do not and we have no > way to know what system will be run

Re: [HACKERS] open item: tablespace handing in pg_dump/pg_restore

2004-10-11 Thread Bruce Momjian
OK, I have applied the following patch that uses Cygwin native symlink() instead of the Win32 junctions. The reason for this is that Cygwin symlinks work on Win95/98/ME where junction points do not and we have no way to know what system will be running the Cygwin binaries so the safest bet is to

[HACKERS] Need for DLLINIT in Makefile.shlib

2004-10-11 Thread Bruce Momjian
I am curious why Cygwin needs DLLINIT in Makefile.shlib, and Win32 doesn't: # Cygwin case $(shlib) lib$(NAME).a: $(OBJS) $(DLLINIT) $(DLLTOOL) --export-all $(DLLTOOL_DEFFLAGS) --output-def $(NAME).def $(OBJS) $(DLLWRAP) -o $(shlib) --dllname $(shlib

Re: [HACKERS] PL/PgSQL for counting all rows in all tables.

2004-10-11 Thread Robert Treat
On Tue, 2004-10-05 at 05:09, Dave Page wrote: > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Ian FREISLICH > > Sent: 05 October 2004 09:57 > > To: Greg Sabino Mullane > > Cc: [EMAIL PROTECTED] > > Subject: Re: [HACKERS] PL/PgSQL for cou

Re: [HACKERS] cvs tip broken build for plpython

2004-10-11 Thread Andrew Dunstan
Tom Lane wrote: "Andrew Dunstan" <[EMAIL PROTECTED]> writes: On my FC3 installation, there is a /usr/lib/libpython2.3.so.1.0 ... do you have anything comparable? No, except the non-standard one on the openoffice libs. Building as shared lib only became a part of standard python in rel

[HACKERS] Making rpath a bit more flexible

2004-10-11 Thread Tom Lane
I've just noticed that plperl is broken on my new Fedora installation: [EMAIL PROTECTED] plperl]$ make ... gcc -O2 -fno-strict-aliasing -g -fpic -shared -Wl,-soname,libplperl.so.0 plperl.o spi_internal.o SPI.o -L../../../src/port -L/usr/local/lib /usr/lib/perl5/5.8.5/i386-linux-thread-multi/auto

Re: [HACKERS] Status ofTrigger Firing Order and 'FOR EACH STATEMENT'?

2004-10-11 Thread Tom Lane
Dan Libby <[EMAIL PROTECTED]> writes: > I am still curious to hear an estimate of the difficulty of adding > rowset vars representing OLDSET and NEWSET to each trigger defined as > 'FOR EACH STATEMENT'. It's on the TODO list, but I don't think anyone has a clear fix on the implementation effort

Re: [HACKERS] cvs tip broken build for plpython

2004-10-11 Thread Tom Lane
"Andrew Dunstan" <[EMAIL PROTECTED]> writes: >> On my FC3 installation, there is a /usr/lib/libpython2.3.so.1.0 >> ... do you have anything comparable? > No, except the non-standard one on the openoffice libs. Building as shared > lib only became a part of standard python in release 2.3 - see > ht

Re: [HACKERS] Unit testing

2004-10-11 Thread Greg Stark
Neil Conway <[EMAIL PROTECTED]> writes: > Andrew Dunstan wrote: > > 2. Won't dissolving away "static" cause naming conflicts? > > It might, yes. Those can be resolved, I think. I don't see a good reason why > function names can't be unique across the source tree; at the very least, it > means les

Re: [HACKERS] CVS fixed ...

2004-10-11 Thread Heikki Linnakangas
On Sun, 10 Oct 2004, Marc G. Fournier wrote: pgsql-server renamed to pgsql contrib/earthdistance moved back into pgsql/contrib/earthdistance modules file updated for changes checkout seems to work fine for me ... let me know if there are any problems "cvs update" stopped working for me, I guess I'l

Re: [HACKERS] Unit testing

2004-10-11 Thread Andrew Dunstan
Neil Conway wrote: 3. Unit testing frameworks are best suited to component-based architectures, ISTM. I'm not sure that one would fit Postgres very well. Can you elaborate? With objects that are relatively standalone, you can instantiate them easily and plug them into a testing framework. The

Re: [HACKERS] pg_restore case sensitivity

2004-10-11 Thread Tom Lane
John Bercik <[EMAIL PROTECTED]> writes: > I'm in PG 8.0b3 and in it's psql i perform an -Fc pg_dump on a 7.4 db. > When I go to restore in PG 8.0b3 I get errors because of schemas that > have capital letters ("EMRImporting"). It creates schema "emrimporting" > and fails upon trying to restore

Re: [HACKERS] Unit testing

2004-10-11 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > 2. Won't dissolving away "static" cause naming conflicts? Most likely (and I for one will for sure resist any attempt to force global uniqueness on static names). It seems that that whole issue is easily avoided though ... just #include the source file

Re: [HACKERS] Unit testing

2004-10-11 Thread Neil Conway
Andrew Dunstan wrote: 2. Won't dissolving away "static" cause naming conflicts? It might, yes. Those can be resolved, I think. I don't see a good reason why function names can't be unique across the source tree; at the very least, it means less irritation for anyone using tags. 3. Unit testing f

Re: [HACKERS] OT moving from MS SQL to PostgreSQL

2004-10-11 Thread Reini Urban
Greg Stark schrieb: Christopher Browne <[EMAIL PROTECTED]> writes: - The alternative _I_ would most like would be to deploy web apps in Lisp, but I never have the "round tuits" to get into that very far... If you find any tuits sometime you might want to check out Per Bothner's Kawa. It's a schem

Re: [HACKERS] Unit testing

2004-10-11 Thread Andrew Dunstan
Neil Conway wrote: [ apologies if this mail is poorly formatted, posted via webmail ] Gavin Sherry said: For the latest few weeks Neil and I have been discussing unit testing as a means of testing Postgres more rigorously. I should note that we've also been looking at some other ideas, inc

Re: [HACKERS] Speeding up DELETEs on table with FKs ...

2004-10-11 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > On Mon, 11 Oct 2004, Tom Lane wrote: >> "numeric", hm? Is the referenced column also of type numeric? > Correct, and a join of the two tables appears to use both indices, altho > one is of numeric(9,0) and the other numeric(12,0) ... could that >

Re: [HACKERS] Unit testing

2004-10-11 Thread Neil Conway
[ apologies if this mail is poorly formatted, posted via webmail ] Gavin Sherry said: > For the latest few weeks Neil and I have been discussing unit testing as > a means of testing Postgres more rigorously. I should note that we've also been looking at some other ideas, including different appro

[HACKERS] pg_restore case sensitivity

2004-10-11 Thread John Bercik
I'm in PG 8.0b3 and in it's psql i perform an -Fc pg_dump on a 7.4 db. When I go to restore in PG 8.0b3 I get errors because of schemas that have capital letters ("EMRImporting"). It creates schema "emrimporting" and fails upon trying to restore data to "EMRImporting" schema because it doesn'

[HACKERS] Unit testing

2004-10-11 Thread Gavin Sherry
Hi guys, For the latest few weeks Neil and I have been discussing unit testing as a means of testing Postgres more rigorously. A brief overview of the ideas behind unit testing can be found here: http://www.extremeprogramming.org/rules/unittests.html. The basic idea is that you write small(ish) t

Re: [HACKERS] [PATCHES] HP-UX PA-RISC/Itanium 64-bit Patch and HP-UX

2004-10-11 Thread Shinji Teragaito
>> On Fri, 08 Oct 2004 00:26:06 -0400, Tom Lane <[EMAIL PROTECTED]> said: > Shinji Teragaito <[EMAIL PROTECTED]> writes: > 152c152 > < SHLIB_LINK += `$(CC) -print-libgcc-file-name` > --- >> SHLIB_LINK += `$(CC) $(LDFLAGS) -print-libgcc-file-name` > Okay. I'm slightly w