Re: [BUGS] BUG #1678: pw_shadow BUS ERROR

2005-05-24 Thread John Hansen
I've seen this before, and that was due to unaligned memory access, which is not supported on some platforms. I thought we didn't do unaligned memory access?? ... John > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Haluk GUNCER > Sent: Wednesday

Re: [BUGS] BUG #1671: Long interval string representation rejected

2005-05-24 Thread Neil Conway
Tom Lane wrote: Considering that you're incrementing bufptr inside the macro, it hardly seems that double-evaluation is a problem: the argument pretty much has to be a variable. OTOH there is no reason for the input argument to be treated that way. I'd suggest just one macro [...] Ah, yeah, t

Re: [BUGS] BUG #1678: pw_shadow BUS ERROR

2005-05-24 Thread Neil Conway
Haluk GUNCER wrote: fixing permissions on existing directory /usr/local/pgsql/data ... ok creating directory /usr/local/pgsql/data/global ... ok creating directory /usr/local/pgsql/data/pg_xlog ... ok creating directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok creating directory /usr/l

Re: [BUGS] [SQL] could not devise a query plan

2005-05-24 Thread Tom Lane
=?ISO-8859-2?Q?Sz=FBcs_G=E1bor?= <[EMAIL PROTECTED]> writes: > ABSTRACT: The following query fails. > SELECT * FROM > (SELECT a,b FROM cdqp WHERE a=1 AND b=2) AS aa > NATURAL FULL JOIN > (SELECT a,b FROM cdqp WHERE a=1 and b=2) AS bb > WHERE a+b = 3; Thanks for

Re: [BUGS] Bulletin Board

2005-05-24 Thread Bruno Wolff III
On Mon, May 23, 2005 at 11:04:36 -0400, "Goar, Saul" <[EMAIL PROTECTED]> wrote: > Do you have a Bulletin Board, or web site for questions and answers. There are FAQs referenced off the Postgresql web site. If you want to ask specific questions than you should use the appropiate mailing lists. T

[BUGS] Ordinal 968 could not be located in the dynamic link library LIBEAY32.dll

2005-05-24 Thread Franklin Phan
I just installed 8.0.3 on Windows XP Pro and I got the following error everytime I boot: The ordinal 968 could not be located in the dynamic link library LIBEAY32.dll. What is going on? How do I fix this? Thanks. ---(end of broadcast)--- TIP 1

Re: [BUGS] BUG #1671: Long interval string representation rejected

2005-05-24 Thread Tom Lane
I wrote: > #define APPEND_CHAR(bufptr, end, newchar) \ > do \ > { \ > if (((bufptr) + 1) >= (end)) \ > return DTERR_BAD_FORMAT; \ > *(bufptr)++ = (newchar); \ > } while (0); Oh BTW, there definitely should not be a semicolon at th

[BUGS] BUG #1679: Error while compiling (linking), finite, Unsatisfied symbols

2005-05-24 Thread Haluk GUNCER
The following bug has been logged online: Bug reference: 1679 Logged by: Haluk GUNCER Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.10 to 8.0.3 Operating system: HP UX B.11.11 Description:Error while compiling (linking), finite, Unsatisfied symbols Details:

[BUGS] BUG #1678: pw_shadow BUS ERROR

2005-05-24 Thread Haluk GUNCER
The following bug has been logged online: Bug reference: 1678 Logged by: Haluk GUNCER Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 to 8.0.3 Operating system: HP-UX B.11.11 Description:pw_shadow BUS ERROR Details: the system is a high end system used in a

Re: [BUGS] BUG #1671: Long interval string representation rejected

2005-05-24 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > Attached is a patch that implements this. I'm not especially happy about > the implementation: defining _two_ local macros (that both > doubly-evaluate one of their arguments) is pretty ugly, but I didn't see > a cleaner alternative -- suggestions welcom

[BUGS] Bulletin Board

2005-05-24 Thread Goar, Saul
Title: Bulletin Board Do you have a Bulletin Board, or web site for questions and answers. Respectfully, Saul L. Goar SRA International, Inc. JDTC COMM 757-878-1942 DSN 826-1942 DSN FAX 826-6542 [EMAIL PROTECTED] Visit our website(s) at: NIPRNET Website

Re: [BUGS] [SQL] could not devise a query plan

2005-05-24 Thread Szűcs Gábor
Dear Gnanavel, (please reply to the lists...) Indeed it works! Still, I think it's a bug. As for this solution being a workaround, it's a bit of pain, since the subselect names (effectively, the included subselects) are not constant. As for my workaround, I used a condition to not include t

Re: [BUGS] could not devise a query plan

2005-05-24 Thread Szűcs Gábor
Dear Gurus, Sorry for upping a 13-month-old thread; please tell if I should've opened another one. Here I come again, with another silly join. Please forgive me, but our queries are built from blocks :) VERSION: 7.4.6, 7.4.8, 8.0.0rc4 (sorry, no newer installed right now) ABSTRACT: The fol

Re: [BUGS] BUG #1677: Bug in select with Union

2005-05-24 Thread Russell Smith
On Mon, 23 May 2005 11:54 pm, Tom Lane wrote: > "Julien Vallet" <[EMAIL PROTECTED]> writes: > > The result is "ERROR: UNION types text and bigint cannot be matched" > > This is the identical issue reported here: > http://archives.postgresql.org/pgsql-bugs/2005-02/msg8.php > See also this thre