Re: [BUGS] BUG #2458: Postgresql crash

2006-05-26 Thread Tom Lane
"Cstdenis" <[EMAIL PROTECTED]> writes: > [ SIGSEGV in plpgsql_xact_cb ] I think this is probably an instance of the bug patched here: http://archives.postgresql.org/pgsql-committers/2006-03/msg00022.php If you're certain that your applications never redefine a plpgsql function that might be in ac

[BUGS] BUG #2458: Postgresql crash

2006-05-26 Thread Cstdenis
The following bug has been logged online: Bug reference: 2458 Logged by: Cstdenis Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: FreeBSD 6.1-RELEASE Description:Postgresql crash Details: I am running a very busy postgresql based databas

Re: [BUGS] BUG #2424: initdb Did Not Escape the Password

2006-05-26 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- im

Re: [BUGS] "blah" is not a domain error

2006-05-26 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > Shouldn't it be an error to create a domain that conflicts with an existing > type? It is, if you create it in the same schema. "money", along with all the other built-in types, is in pg_catalog not public. regards, tom lane -

Re: [BUGS] "blah" is not a domain error

2006-05-26 Thread Jim C. Nasby
On Wed, May 24, 2006 at 05:29:34PM -0400, Tom Lane wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > I know domain support is pretty broken, so maybe this is a known issue... > > What are you concerned about exactly? It looks perfectly reasonable > to me. "money" is a base type not a domai

Re: [BUGS] BUG #2455: psql failing to restore a table because of a constaint violation.

2006-05-26 Thread Tom Lane
"Jeff Ross" <[EMAIL PROTECTED]> writes: > After the upgrade to 8.1.4, this script I use to sync a development database > with our live database began failing. > Here's the failure: > psql:/home/_postgresql/wykids20060524.sql:84507: ERROR: new row for > relation "Clearinghouse" violates check > c

Re: [BUGS] BUG #2457: Make fails at copydir.c / copydir.o

2006-05-26 Thread William Gray
Tom Lane wrote: > William Gray <[EMAIL PROTECTED]> writes: > >> I'm not sure how I'd go about determining that. I don't recall messing >> with any of my system's .h files. Do you know where I might look? >> > > grep through all the files under /usr/include looking for "bool" ... > >

Re: [BUGS] BUG #2424: initdb Did Not Escape the Password

2006-05-26 Thread imacat
Has anyone notice this? I found that this is not fixed in the 8.1.4 release. I have made a new patch for 8.1.4. It is attached below. Please tell me if there is any problem. Thank you. -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 diff -u -r postgresql-8.1.4.orig/src/bin/initdb/initd

Re: [BUGS] BUG #2457: Make fails at copydir.c / copydir.o

2006-05-26 Thread Tom Lane
William Gray <[EMAIL PROTECTED]> writes: > I'm not sure how I'd go about determining that. I don't recall messing > with any of my system's .h files. Do you know where I might look? grep through all the files under /usr/include looking for "bool" ... regards, tom lane -

Re: [BUGS] BUG #2457: Make fails at copydir.c / copydir.o

2006-05-26 Thread William Gray
Tom, I'm not sure how I'd go about determining that. I don't recall messing with any of my system's .h files. Do you know where I might look? Thanks! Billy Tom Lane wrote: > "William Gray" <[EMAIL PROTECTED]> writes: > >> When I run the make for 8.1.4, a number of parse errors are thrown, c

Re: [BUGS] BUG #2457: Make fails at copydir.c / copydir.o

2006-05-26 Thread Tom Lane
"William Gray" <[EMAIL PROTECTED]> writes: > When I run the make for 8.1.4, a number of parse errors are thrown, causing > the build to fail. The errors suggest some problem with "bool". Do you have any conflicting #define's for bool in your system headers? FWIW, 8.1.4 builds fine for me on 10

[BUGS] BUG #2455: psql failing to restore a table because of a constaint violation.

2006-05-26 Thread Jeff Ross
The following bug has been logged online: Bug reference: 2455 Logged by: Jeff Ross Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: OpenBSD 3.9 -current Description:psql failing to restore a table because of a constaint violation. Details:

[BUGS] BUG #2457: Make fails at copydir.c / copydir.o

2006-05-26 Thread William Gray
The following bug has been logged online: Bug reference: 2457 Logged by: William Gray Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Mac OS X Tiger 10.4.6 (PowerPC) Description:Make fails at copydir.c / copydir.o Details: When I run the

[BUGS] BUG #2456: How to write user defined functions in Postgress sql

2006-05-26 Thread Vivekananda
The following bug has been logged online: Bug reference: 2456 Logged by: Vivekananda Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows-2000 Description:How to write user defined functions in Postgress sql Details: Hai, I have good kn