[PATCHES] Link to pgport earlier

2005-03-23 Thread Bruce Momjian
I would like to apply this to CVS HEAD and 8.0.X so PG client applications link to the libpgport non-shared library before linking to libpq so it doesn't pull libpgport symbols from libpq. This should make PG client apps more immune to libpq/pgport changes in each version. -- Bruce Momjian

Re: [PATCHES] PL/Python patch for Universal Newline Support

2005-03-23 Thread Michael Fuhr
Here's a PL/Python patch that includes a few tests for Universal Newline Support. "gmake installcheck" in src/pl/plpython is successful in HEAD on my Solaris 9 box running Python 2.4.1c2. I ran the tests against an unpatched 8.0.1 server and they failed as expected. -- Michael Fuhr http://www.f

Re: [PATCHES] [pgsql-hackers-win32] [HACKERS] win32 performance - fsync question

2005-03-23 Thread Bruce Momjian
I have applied the following patch to CVS HEAD and 8.0.X that changes the Win32 O_SYNC flag to O_DATASYNC, because this the actual behavior of the flag. This is now the default wal fsync method on Win32 because we perfer O_DATASYNC to fsync(). And second, it changes Win32 fsync to a new wal sync

[PATCHES] SPI_getnspname

2005-03-23 Thread Neil Conway
I noticed there is an SPI API function to get the name of a specified Relation, but no similar function to get the Relation's namespace. Attached is a patch that implements SPI_getnspname(). I wasn't sure if I should refer to the relation's "schema" or its "namespace"; my feeling was that SPI i

Re: [PATCHES] Faster install-sh in C

2005-03-23 Thread Neil Conway
Alvaro Herrera wrote: Also, keep in my that this C install program has the extra feature of being able to install multiple files on one invocation, per suggestion from Tom Lane. This allows us to save the nested for-loop in src/include/Makefile. GNU install (available on my system) also has this

Re: [PATCHES] contrib dbf2sql.pl

2005-03-23 Thread Bruce Momjian
Manuel Baena García wrote: > ok, It's more difficult to fix the existing version. I don't want to do > a new library. I just use the perl module DBD-XBase rather than rewrite > a library (contrib/dbase/dbf.c). Also, dbf2sql is a perl program... you > can to adapt it to your needs easily. Are you s

Re: [PATCHES] Faster install-sh in C

2005-03-23 Thread Tom Lane
Bruce Momjian writes: > OK, what is 'install' doing for us that 'cp' and 'chmod' would not > already do? Quite a lot of things, such as coping with busy target files --- not too important for headers, but very important for executables and shlibs. We might be able to get away with this for just

Re: [PATCHES] Faster install-sh in C

2005-03-23 Thread Bruce Momjian
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Also, keep in my that this C install program has the extra feature of > > being able to install multiple files on one invocation, per suggestion > > from Tom Lane. This allows us to save the nested for-loop in > > src/include/Makefil

Re: [PATCHES] Faster install-sh in C

2005-03-23 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Also, keep in my that this C install program has the extra feature of > being able to install multiple files on one invocation, per suggestion > from Tom Lane. This allows us to save the nested for-loop in > src/include/Makefile. GNU install (available

Re: [PATCHES] Faster install-sh in C

2005-03-23 Thread Alvaro Herrera
On Mon, Mar 07, 2005 at 07:50:23PM +0100, Peter Eisentraut wrote: > Alvaro Herrera wrote: > > Well, apparently everyone says the system install is not portable and > > the discussion stops there. > > Well, who actually says that? I know that I was the one who actually > coded up the current avoi

Re: [PATCHES] contrib dbf2sql.pl

2005-03-23 Thread Bruce Momjian
Manuel Baena García wrote: > - It solve problems with numeric columns. > http://archives.postgresql.org/pgsql-novice/2005-01/msg00246.php > http://archives.postgresql.org/pgsql-general/2005-01/msg01382.php > - The output is in SQL. Uh, can't you just fix the existing version rather than make a ne