Re: [BUGS] BUG #1473: Backend bus error, possibly due to ANALYZE

2005-02-10 Thread John Hansen
> It seems what's happening here is that dspam is submitting a > query with many thousands of elements in the IN clause. In > the parser, we transform "foo IN (a, b, c)" into "foo = a OR > foo = b OR foo = c", and then recurse for each element of the > OR expression and eventually run out of st

Re: [BUGS] 8.0 ecpg crashes with "create table as" statement.

2005-02-10 Thread Michael Meskes
On Thu, Feb 10, 2005 at 01:05:18PM +0900, TANIDA Yutaka wrote: > Probably, "create sequence" and "create domain" have same problems. Here's > a patch for preproc.y . Or at least very similar ones. :-) Thanks a lot for the report. Patch committed to CVS HEAD and 8.0 branch. Michael -- Michael M

Re: [BUGS] pg_dump table ordering bug [8.0.1]

2005-02-10 Thread Gerard Krupa
Andreas Lange wrote : > Hi! > > Our upgrade from 7.4.6 to 8.0.1 only had one small glitch. Two tables got dumped in the wrong order > (before their dependecies) and had to get their contents added manually after the restore. I've atleast > isolated the part where things go wrong. I've experienced

[BUGS] BUG #1474: pg_dump outputs tables in wrong order

2005-02-10 Thread Gerard Krupa
The following bug has been logged online: Bug reference: 1474 Logged by: Gerard Krupa Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: HP-UX B.11.11 U 9000/800 650319392 unlimited-user license PA-RISC 2.0 (64-bit) Description:pg_dump output

Re: [BUGS] BUG #1472: Win-Installation failed due to missing access-rights

2005-02-10 Thread Magnus Hagander
> The following bug has been logged online: > > Bug reference: 1472 > Logged by: Joachim Schuette > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.1 > Operating system: Win2k > Description:Win-Installation failed due to missing > access-rights > Details:

Re: [BUGS] BUG #1473: Backend bus error, possibly due to ANALYZE

2005-02-10 Thread Tom Lane
"Brian B." <[EMAIL PROTECTED]> writes: > I am loading some spam/ham data/tokens, to be used for the dspam anti-spam > software, into PostgreSQL. After a few hours of inserting and updating the > existing data, the backend crashes with a signal 10 (bus error). Judging by the trace, this doesn't dep

Re: [BUGS] BUG #1473: Backend bus error, possibly due to ANALYZE

2005-02-10 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > It seems what's happening here is that dspam is submitting a query with > many thousands of elements in the IN clause. In the parser, we transform > "foo IN (a, b, c)" into "foo = a OR foo = b OR foo = c", and then > recurse for each element of the OR expre

Re: [BUGS] pg_dump table ordering bug [8.0.1]

2005-02-10 Thread Tom Lane
"Gerard Krupa" <[EMAIL PROTECTED]> writes: > I've experienced a similar problem with a data-only dump using 8.0.1's > pg_dump. It seems that the COPYs (or INSERTs) are generated in > alphabetical order of table name, ignoring foreign key contraints and > requiring the output to be post-processed.

Re: [BUGS] BUG #1473: Backend bus error, possibly due to ANALYZE

2005-02-10 Thread Brian B.
Hello, On Thu, Feb 10, 2005 at 10:08:14AM -0500, Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > It seems what's happening here is that dspam is submitting a query with > > many thousands of elements in the IN clause. In the parser, we transform > > "foo IN (a, b, c)" into "foo = a O

Re: [BUGS] BUG #1473: Backend bus error, possibly due to ANALYZE

2005-02-10 Thread Tom Lane
"Brian B." <[EMAIL PROTECTED]> writes: > On Thu, Feb 10, 2005 at 10:08:14AM -0500, Tom Lane wrote: >> There is a check_stack_depth call in there, so this could only be the >> explanation if max_stack_depth is set too high for the actual >> stack depth limit. What's the platform, and what ulimit va

[BUGS] BUG #1475: error to install language pltcl

2005-02-10 Thread Luciano Almeida
The following bug has been logged online: Bug reference: 1475 Logged by: Luciano Almeida Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows XP Description:error to install language pltcl Details: Hello I'm from brazil... I'm tryi

[BUGS] BUG #1476: on Xeon 2.8 can't instaling source

2005-02-10 Thread Sinisa Zivanovic
The following bug has been logged online: Bug reference: 1476 Logged by: Sinisa Zivanovic Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.2 Operating system: SuSE 8.2 Description:on Xeon 2.8 can't instaling source Details: on Xeon 2.8 ./configure is ok gmak

[BUGS] No connection to Server

2005-02-10 Thread Dennis Hübner
  Name:   Dennis Huebner Email:  [EMAIL PROTECTED] PostgreSQL version: 8.0 Operation system:   Windows XP Professional Short description:    No connection to Server     Hi there,   I have trouble with newer versions of postgresql.  

Re: [BUGS] BUG #1476: on Xeon 2.8 can't instaling source

2005-02-10 Thread Bruce Momjian
Sinisa Zivanovic wrote: > > The following bug has been logged online: > > Bug reference: 1476 > Logged by: Sinisa Zivanovic > Email address: [EMAIL PROTECTED] > PostgreSQL version: 7.3.2 > Operating system: SuSE 8.2 > Description:on Xeon 2.8 can't instaling source > D

Re: [BUGS] BUG #1476: on Xeon 2.8 can't instaling source

2005-02-10 Thread Tom Lane
Bruce Momjian writes: > Sinisa Zivanovic wrote: >> gmake don know what to do - compaling all day ! > Buggy compiler? It should compile in 1-3 minutes on that machine. System clock set way in the past? regards, tom lane ---(end of broadcast)-