[BUGS] Unpredictable signal 11 crashes on Mac OS X

2003-10-08 Thread Gareth Boden
Hi, We've been having a lot of problems with unpredicatable crashes with 7.3.4 on OS X Server (10.2.6 and 10.2.8 exhibit the same behaviour). Having run with verbose logging for some time, we have not noticed any real consistency in the types of queries which are causing the crash recently. A few

[BUGS] tgconstrrelid bug

2003-10-08 Thread Misha Gale
Can anyone tell me whether the bug where the tgconstrrelid column of the pg_triggers catalogue was ever fixed ("[BUG?] tgconstrrelid doesn't survive a dump/restore" - http://archives.postgresql.org/pgsql-hackers/2001-04/msg00720.php)? I am finding some effects of this in my database, but that could

Re: [BUGS] tgconstrrelid bug

2003-10-08 Thread Stephan Szabo
On Wed, 8 Oct 2003, Misha Gale wrote: > Can anyone tell me whether the bug where the tgconstrrelid column of the > pg_triggers catalogue was ever fixed ("[BUG?] tgconstrrelid doesn't > survive a dump/restore" - > http://archives.postgresql.org/pgsql-hackers/2001-04/msg00720.php)? I am > finding so

Re: [BUGS] Unpredictable signal 11 crashes on Mac OS X

2003-10-08 Thread Tom Lane
Gareth Boden <[EMAIL PROTECTED]> writes: > We've been having a lot of problems with unpredicatable crashes with > 7.3.4 on OS X Server (10.2.6 and 10.2.8 exhibit the same behaviour). Have you looked into the possibility of bad hardware? I routinely test PG on OS X (10.2.6 currently) and have ne

Re: [BUGS] Unpredictable signal 11 crashes on Mac OS X

2003-10-08 Thread Gareth Boden
On Wednesday, October 8, 2003, at 03:54 PM, Tom Lane wrote: Gareth Boden <[EMAIL PROTECTED]> writes: We've been having a lot of problems with unpredicatable crashes with 7.3.4 on OS X Server (10.2.6 and 10.2.8 exhibit the same behaviour). Have you looked into the possibility of bad hardware?

[BUGS] Canceling statement results in broken connection (JDBC)

2003-10-08 Thread Alexander Staubo
Using Statement.cancel() to cancel a running query, queries are sometimes successfully canceled, but more often result in a broken connection, after which all interactions result in an error such as this: Unknown Response Type c at org.postgresql.core.QueryExecutor.execute(QueryExecutor.

[BUGS] Bug Report

2003-10-08 Thread Branden R. Williams
POSTGRESQL BUG REPORT TEMPLATE Your name : Branden R. Williams Your email address : [EMAIL PROTECTED]

[BUGS] pg_resetxlog and pgscripts italian translation

2003-10-08 Thread [EMAIL PROTECTED]
Hi, These are the first translations of the pg_resetxlog.pot and pgscripts.pot files. The "it" option is missing in both the nls.mk files so it must be added. I will now start to work also on cleaning up and adjusting the psql.pot file i posted 2 days ago. Best Regards, Fabrizio Mazzoni Macro

[BUGS] Minor irritant with comment parsing in a function (SQL) body

2003-10-08 Thread Richard Huxton
Versions: 7.3, 7.4beta (not latest) Applies to SQL functions, but not apparently to plpgsql (because of the different parser, I presume). This is really a "doctor it hurts when I..." thing - the fact that I've never come across it before must mean it's pretty hard to trigger. The first version

Re: [BUGS] Minor irritant with comment parsing in a function (SQL)

2003-10-08 Thread Peter Eisentraut
Richard Huxton writes: > CREATE OR REPLACE FUNCTION zzz_test () RETURNS text AS ' > SELECT ''hello world'' > -- SELECT ''goodbye world'' > ::text; > ' LANGUAGE 'SQL'; > > ERROR: parser: unterminated quoted string at or near "'hello world' > -- SELECT 'goodbye world' > ::text; That's a good one

Re: [BUGS] Minor irritant with comment parsing in a function (SQL)

2003-10-08 Thread Richard Huxton
On Wednesday 08 October 2003 20:56, Peter Eisentraut wrote: > Richard Huxton writes: > > CREATE OR REPLACE FUNCTION zzz_test () RETURNS text AS ' > > SELECT ''hello world'' > > -- SELECT ''goodbye world'' > > > > ::text; > > > > ' LANGUAGE 'SQL'; > > > > ERROR: parser: unterminated quoted string

Re: [BUGS] pg_resetxlog and pgscripts italian translation

2003-10-08 Thread Peter Eisentraut
[EMAIL PROTECTED] writes: > These are the first translations of the pg_resetxlog.pot and > pgscripts.pot files. Installed. Please send them to pgsql-patches next time. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the

Re: [BUGS] Minor irritant with comment parsing in a function (SQL)

2003-10-08 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > The bug here is that the scanner doesn't know that a newline (or end of > input) is a required as part of a -- comment. I think the minimum-damage place to fix this is by requiring \n after {comment} in the horiz_whitespace rule. As is, it's possible

Re: [BUGS] Bug Report

2003-10-08 Thread Joe Conway
Branden R. Williams wrote: POSTGRESQL BUG REPORT TEMPLATE Your name : Branden R. Williams Your email addres

Re: [BUGS] Minor irritant with comment parsing in a function (SQL)

2003-10-08 Thread Peter Eisentraut
Tom Lane writes: > I think the minimum-damage place to fix this is by requiring \n after > {comment} in the horiz_whitespace rule. As is, it's possible for > xqcat to match to a second quote that is in the body of a -- comment. You mean like this? horiz_whitespace({horiz_space}|{comment

Re: [BUGS] Bug Report

2003-10-08 Thread Tom Lane
"Branden R. Williams" <[EMAIL PROTECTED]> writes: > When using the replace() function, it appears that some of the output is > filtered through a printf variant. This was fixed as of 7.3.3. regards, tom lane ---(end of broadcast)---

Re: [BUGS] [pgadmin-hackers] Degrade(character conversion problem) pga3?

2003-10-08 Thread Andreas Pflug
Hiroshi Saito wrote: Hi Andreas. I have a problem. It is a happening within this week. See below. http://cre-ent.skcapi.co.jp/~saito/pgadmin3/20030922_1.jpg http://cre-ent.skcapi.co.jp/~saito/pgadmin3/20031007_1.jpg Tonight, let me know it if you know something though it will be examined. Thank y

Re: [BUGS] [pgadmin-hackers] Degrade(character conversion problem) pga3?

2003-10-08 Thread Hiroshi Saito
Hi Andreas. Hmm.. It is thought still to be bug on this side. Or, wxWindows. When the code is analyzed, it seems to be the below. With the SJIS 9776 9166 8eaf 95ca 94d4 With the EUC_JP d7cd c7c1 b1bc ccca d6c8 With the UNICODE feff 8981 7d20 8b58 5225 756a When it is probably delivered, it fa

Re: [BUGS] Unpredictable signal 11 crashes on Mac OS X (SOLVED[?])

2003-10-08 Thread Gareth Boden
On Wednesday, October 8, 2003, at 03:54 PM, Tom Lane wrote: Gareth Boden <[EMAIL PROTECTED]> writes: We've been having a lot of problems with unpredicatable crashes with 7.3.4 on OS X Server (10.2.6 and 10.2.8 exhibit the same behaviour). Have you looked into the possibility of bad hardware? I ro