Re: [HACKERS] regression script/makefile exit failure

2004-12-10 Thread Andrew Dunstan
Further investigation has shown that the exit/trap idiom used in pg_regress.sh is less than 100% portable. The following shell script has been seen to produce incorrect output on both Cygwin and FreeBSD: #!/bin/sh trap ' st=$? echo status = $st exit $st ' 0 (exit 9); exit I'm not sure how we

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-10 Thread Tom Lane
Matthias Schmidt <[EMAIL PROTECTED]> writes: > By the way: Do you have an idea about a small or > medium sized task from the TODO-List for a newbee, which gets me up to > speed?(!Win32) A lot of the tasks listed under DATA TYPES are fairly self-contained problems ... but what draws your interest?

Re: [HACKERS] 8.0.0beta5 FailedAssertion (Crash) when casting composite types

2004-12-10 Thread Tom Lane
I wrote: > The cause of this failure is that parse_coerce.c thinks that a child > table's rowtype is binary-compatible with its parent's rowtype: > ... > The Really Clean And Correct fix to this, IMHO, would be to invent a new > expression node type that represents coercing a rowtype expression to

[HACKERS] old-style handler error

2004-12-10 Thread Sibtay Abbas
i have added my own pocedural language in postgresql. by using the Create function command i ve also written a procedure in that language. now when invoke that function with SELECT (func_name) i receive the following error message ERROR: language 17254 has old-style handler.

[HACKERS] Test

2004-12-10 Thread Christopher Kings-Lynne
Sorry - please ignore. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] apparent problem on linux/s390

2004-12-10 Thread Steve Atkins
On Tue, Dec 07, 2004 at 10:37:36AM +0200, Nicolai Tufar wrote: > On Mon, 06 Dec 2004 19:15:23 -0500, Andrew Dunstan <[EMAIL PROTECTED]> wrote: > > > > problems apparently with NaNs, infinities and negative zeros. Sure smells more like an IEEE issue than a postgresql issue (built for IBM FP rather

[HACKERS] buildfarm build failure: icc7 + --enable-cassert

2004-12-10 Thread Darcy Buskermolen
It looks like --enable-cassert isn't handled properly under icc7 http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=herring&dt=2004-12-07%2016:30:44 -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com ---(end of broa

Re: [HACKERS] How can I recovery old Data from files and

2004-12-10 Thread Premsun Choltanwanich
I already reinstall old version of PostgreSQL. However I still cannot run PostgreSQL service after I reinstall on many time. I think that I cannot use pg_dump or all command without PostgreSQL service running. So What thing I can do now? >>> Andrew Dunstan <[EMAIL PROTECTED]> 7/12/2004 10:18:19 pm

[HACKERS] regression script/makefile exit failure

2004-12-10 Thread Andrew Dunstan
I have seen several cases where either pg_regress appears not to exit with the expected non-zero exit status or "make check" does not apparently exit with the expected non-zero status. In particular, I've seen it on cygwin, windows, and have at least a suspicion of it happening on FreeBSD. The

[HACKERS] first pgAdmin 1.3 snapshot

2004-12-10 Thread Andreas Pflug
At this very moment, the first snapshot of pgAdmin III 1.3 is uploading, which includes the pgsql configuration file editor. For pginstaller purposes, the command line pgadmin3 -c or pgadmin3 -ch \pg_hba.conf or pgadmin3 -cm \postgresql.conf handles the configuration files. If pginstaller shoul

Re: [HACKERS] Call for port reports

2004-12-10 Thread Patrick B Kelly
./configure \ --prefix=/usr/local/pgsql/8.0rc1 \ --enable-thread-safety \ --with-tcl \ --with-perl \ --with-python \ --with-krb5 \ --with-pam \ --with-openssl \ --with-includes=/sw/include/ \ --with-libraries=/sw/lib

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-10 Thread Matthias Schmidt
Am 07.12.2004 um 19:24 schrieb Tom Lane: Matthias Schmidt <[EMAIL PROTECTED]> writes: By the way: Do you have an idea about a small or medium sized task from the TODO-List for a newbee, which gets me up to speed?(!Win32) A lot of the tasks listed under DATA TYPES are fairly self-contained problems

Re: [Testperf-general] Re: [HACKERS] 8.0beta5 results w/ dbt2

2004-12-10 Thread Mark Wong
On Tue, Dec 07, 2004 at 09:12:18AM +, Simon Riggs wrote: > Not sure, as yet, what is causing effect 2. It's not related to the > kernel, but is related to user CPU and I/O waits and effects all tables > in proportion to their overall I/O usage. Some evidence that it becomes > more pronounced as

Re: [HACKERS] Call for port reports

2004-12-10 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > It's now time to fill the holes. Briefly, I'm looking for exit status 0 > on > ./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \ > --with-perl --with-python --with-krb5 --with-pam -with-openssl > make > make install > make check > w

Re: [HACKERS] V8 Beta 5 on AIX

2004-12-10 Thread Andrew Sullivan
On Mon, Dec 06, 2004 at 08:07:00PM -0500, Bruce Momjian wrote: > Yea, we needed this problem report during beta, not RC. For the record, there _was_ such a problem report, for b3: http://archives.postgresql.org/pgsql-hackers/2004-10/msg00046.php A -- Andrew Sullivan | [EMAIL PROTECTED] A cert

Re: [HACKERS] V8 Beta 5 on AIX

2004-12-10 Thread Zeugswetter Andreas DAZ SD
>> However, one thing we can do is to try this in Makefile.aix: >> # AIX needs threads for everything that uses libpq >> LIBS += $(PTHREAD_LIBS) >> That is going to enable thread libs for all linking including the >> backend, but it might work. > That is certainly wrong. The correct th

Re: [Testperf-general] Re: [HACKERS] 8.0beta5 results w/ dbt2

2004-12-10 Thread Mark Wong
On Mon, Dec 06, 2004 at 07:52:37PM +, Simon Riggs wrote: > Varying bgwriter_maxpages upwards should take performance higher. > I have 2 runs now. I for both tests, I have bgwriter_percent=100, checkpoint_segments=8192, checkpoint_timout=600, debug_shared_buffers=10, log_min_messages=debug1 a

Re: [HACKERS] apparent problem on linux/s390

2004-12-10 Thread Nicolai Tufar
On Tue, 07 Dec 2004 13:51:36 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > FWIW, I get clean regression test passes on a real z900 at Red Hat, > in both s390 and s390x (32- and 64-bit) modes. I'm not sure what that > means --- it could be that Red Hat Linux doesn't use the hardware > floating point

Re: [HACKERS] Status of server side Large Object support?

2004-12-10 Thread Hannu Krosing
On E, 2004-11-29 at 02:22, David Garamond wrote: > Joe Conway wrote: > > Not if the column is storage type EXTERNAL. See a past discussion here: > > http://archives.postgresql.org/pgsql-general/2003-07/msg01447.php > > what is the reasoning behind this syntax? > > ALTER TABLE [ ONLY ] table [ *

Re: [HACKERS] branch for 8.0?

2004-12-10 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > I'm in favor of waiting until the release. Well, if we can hold to the Dec 15 release date, it's only a week's difference ... so I don't care much either way. Are you concerned about having to double-patch the last-minute translation updates?

Re: [HACKERS] [SECURITY] Fedora Core 2 Update: mysql-3.23.58-9.1 (fwd)

2004-12-10 Thread Alvaro Herrera
On Thu, Dec 09, 2004 at 12:17:58AM +0200, Devrim GUNDUZ wrote: > Heh heh heh :-) > > - -- Forwarded message -- > Date: Wed, 08 Dec 2004 12:33:48 -0500 > From: Tom Lane <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] Well, working for Red Hat has the down

Re: [HACKERS] apparent problem on linux/s390

2004-12-10 Thread Horak Daniel
> > Maybe we should mark the buildfarm member as "s390 emulator" ? > > It could be. But we'd rather use the full specification, > "Hercules 2.37, ESAME S390 architecture, 31 bit mode, running Debian > Linux Woody" Full support for IEEE float number instructions was added into Hercules during last

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-10 Thread Matthias Schmidt
Am 06.12.2004 um 23:27 schrieb Tom Lane: schmidtm <[EMAIL PROTECTED]> writes: Do I get that right: the only reason to do max(sysid) or a user-supplied ID in CreateUser() (commands/user.c) is that we don't have the ability to get sequences over the *.BKI/initdb mechanism? No, that's not quite the di

Re: [HACKERS] Call for port reports

2004-12-10 Thread Andrew Dunstan
Peter Eisentraut wrote: Briefly, I'm looking for exit status 0 on ./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \ --with-perl --with-python --with-krb5 --with-pam -with-openssl (I would like the build farm members for Windows and Cygwin to use more feature-enabling options

[HACKERS] errmsg("... because ...")

2004-12-10 Thread Alvaro Herrera
Hackers, There are a bunch of error messages saying something like "cannot foo because bar" For example, errmsg("cannot assign to field \"%s\" of column \"%s\" because its type %s is not a composite type") What do you think of changing those to use errdetail in addition to errmsg? So this pa

Re: [HACKERS] apparent problem on linux/s390

2004-12-10 Thread Horak Daniel
> > Meanwhile, if anyone knows of real big iron that could join > the buildfarm > > that would also be good. > > I can't put it in the buildfarm ;-) but I have access to real s390 > hardware inside Red Hat. I'll try to run a test build and see whether > the regression tests pass. > > I would ex

[HACKERS] old-style handler problem

2004-12-10 Thread Sibtay Abbas
hi everyone i ve added my own pl language in postgresql. i ve followed the process mentioned in the documentation. for the handler function i ve followed the following template PG_FUNCTION_INFO_V1(myhandler); Datum plsample_call_handler(PG_FUNCTION_ARGS) { Datum rv; ...m

[HACKERS] Small fix for 7.2.6/contrib/seg

2004-12-10 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, While trying to build 7.2.6 FC1 RPMs due to a request from Pierlugi today, I saw an error in contrib/seg. This small patch fixed the typo and we can build the RPMs now. Could you please apply it to 7.2? ===

[HACKERS] [SECURITY] Fedora Core 2 Update: mysql-3.23.58-9.1 (fwd)

2004-12-10 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Heh heh heh :-) - -- Forwarded message -- Date: Wed, 08 Dec 2004 12:33:48 -0500 From: Tom Lane <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [SECURITY] Fedora Core 2 Update: mysql-3.23.58-9.1 - --

Re: [HACKERS] apparent problem on linux/s390

2004-12-10 Thread Tom Lane
Nicolai Tufar <[EMAIL PROTECTED]> writes: > Hercules is a tested and proved emulator but I have a vague doubt > that it's IEEE FPU emulation may be slightly different from the > real iron's one. FWIW, I get clean regression test passes on a real z900 at Red Hat, in both s390 and s390x (32- and 64

Re: [HACKERS] spi and other languages

2004-12-10 Thread Doug McNaught
Sibtay Abbas <[EMAIL PROTECTED]> writes: > We can call SQL statements like SPI_Execute("SELECT * > FROM sometable") from the spi interface. My question > is that can we enter other procedural languages as > well, like pgplsql statements. You can call a function written in another procedural langa

Re: [HACKERS] branch for 8.0?

2004-12-10 Thread Peter Eisentraut
Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > There was some talk of branching REL8_0_STABLE after 8.0.0rc1 was > > released. Is that still the plan? > > I'm up for it, personally --- is everybody else ready? Should we > wait another day or three? I'm in favor of waiting until the