Re: [BUGS] 8.0: Absolute path required for INITDB?

2004-08-15 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > What was the resolution of this? Can we make relative -L work or do we > > add error checks for relative -L paths? > > We fixed the problem that was requiring Josh to use -L. I think -L is a > wizard's switch and need not be user-fr

Re: [BUGS] 8.0: Absolute path required for INITDB?

2004-08-15 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > What was the resolution of this? Can we make relative -L work or do we > add error checks for relative -L paths? We fixed the problem that was requiring Josh to use -L. I think -L is a wizard's switch and need not be user-friendly, so I feel no need to

Re: [BUGS] 8.0: Absolute path required for INITDB?

2004-08-15 Thread Bruce Momjian
What was the resolution of this? Can we make relative -L work or do we add error checks for relative -L paths? --- Josh Berkus wrote: > 8.0 beta CVS of 8/8/2004: > > If a relative path is used for the -L option in initdb,

Re: [BUGS] BUG #1218: COPY usage in script with CR/LF invoking from

2004-08-15 Thread Bruce Momjian
Yea, we just found this failure and the fix will be in beta2 and is in CVS now. To work around it, convert it to unix newlines. --- PostgreSQL Bugs List wrote: > > The following bug has been logged online: > > Bug referen

Re: [BUGS] postgresql 8 (pgAdminIII) crashes when login form X is

2004-08-15 Thread Andreas Pflug
Peter Eisentraut wrote: 10006226 wrote: I installed version 8 software using msi pack and created postgres user and one other. On opening pgAdmin login form - couldn't overtype User-name postgres and clicked form close icon (Red X). MsgBox said "An error has occurred. Couldn't create a connection d

[BUGS] BUG #1218: COPY usage in script with CR/LF invoking from psql break after '\.'

2004-08-15 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1218 Logged by: OU Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: Windows XP Description:COPY usage in script with CR/LF invoking from psql break after '\.' Details: My

Re: [BUGS] postgresql 8 (pgAdminIII) crashes when login form X is clicked

2004-08-15 Thread Peter Eisentraut
10006226 wrote: > I installed version 8 software using msi pack and created postgres > user and one other. > On opening pgAdmin login form - couldn't overtype User-name postgres > and clicked form close icon (Red X). > MsgBox said "An error has occurred. Couldn't create a connection > dialogue!" T

[BUGS] postgresql 8 (pgAdminIII) crashes when login form X is clicked

2004-08-15 Thread 10006226
I installed version 8 software using msi pack and created postgres user and one other. On opening pgAdmin login form – couldn’t overtype User-name postgres and clicked form close icon (Red X). MsgBox said “An error has occurred. Couldn’t create a connection dialogue!” Clicked OK and Wind

Re: [BUGS] Configure error Beta 8.0.0

2004-08-15 Thread Tom Lane
"Jim J." <[EMAIL PROTECTED]> writes: > Can not configure Beta 8.0.0beta1 on SuSE 9.1 kernel 2.6.5-7.104. Looks to me like you're missing most or all of the standard headers (/usr/include/ contents). A few packages shy of a full install maybe? regards, tom lane --

[BUGS] Configure error Beta 8.0.0

2004-08-15 Thread Jim J.
Can not configure Beta 8.0.0beta1 on SuSE 9.1 kernel 2.6.5-7.104. Was able to install beta 8 on SuSE 9.0 on a 2.4 xxx kernel. Do I need to revert back? Configure output on SuSE 9.1 is: checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu checking which

Re: [BUGS] Primary key duplicates

2004-08-15 Thread Zeki Mokhtarzada
It appears that I can select the rows, but not delete or update them. # select ctid from files where ctid = '(53101,30)'; ctid (53101,30) (1 row) # delete from files where ctid = '(53101,30)'; DELETE 0 # update files set fileid = 1000 where ctid = '(53101,30)'; UPDATE 0 # -Ze

Re: [BUGS] Primary key duplicates

2004-08-15 Thread Zeki Mokhtarzada
On Fri, 13 Aug 2004, Tom Lane wrote: > It would be interesting to see the ctid, xmin, cmin, and xmax fields > as well. ctid |xmin|cmin|xmax| oid| fileid | userid --++++--+-+- (53101,

Re: [BUGS] [8.0beta] failure on NetBSD/alpha

2004-08-15 Thread Tom Lane
Stefan Schumacher <[EMAIL PROTECTED]> writes: > gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes > -Wmissing-declarations -I../../../src/include -c -o execQual.o > execQual.c > execQual.c: In function `ExecInitExpr': > execQual.c:2896: internal compiler error: Segmentation fault > Please s

[BUGS] [8.0beta] failure on NetBSD/alpha

2004-08-15 Thread Stefan Schumacher
I made two further builds on my NetBSD machines. One successfull on my NetBSD/i386 SMP machine with 2 Pentium III/500 CPUs: [...] gmake[1]: Leaving directory `/mnt/export/postgresql-8.0.0beta1/config' PostgreSQL installation complete. # uname -mrs NetBSD 2.0E i386 # dmesg |grep -i pentium c

Re: [BUGS] BUG #1214: ecpg regression in 8.0.0beta1

2004-08-15 Thread Michael Meskes
On Wed, Aug 11, 2004 at 06:51:59PM -0400, Tom Lane wrote: > Looks like a slip-up in copying a change from the main grammar. I've > applied the attached patch to fix it. Thanks for the report! Thanks Tom. Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De ICQ: 179140304, AIM/Yahoo: m