Re: [BUGS] make unsuccessful on mac os x 10.2

2002-09-09 Thread Bruce Momjian
Oh, that's a strange error. I thought our beta1 worked on OSX 10.2. You are on 10.2, right? Do have have any environment variables starting with LC_*? --- Michael Fortin wrote: > Bruce, > Thanks for the reply. It install

Re: [BUGS] make unsuccessful on mac os x 10.2

2002-09-09 Thread Bruce Momjian
Get 7.3beta1 for OSX 10.2. --- Michael Fortin wrote: > My guess is that the new compiler in 10.2 is not compatible with > postgres. Here is the output from configure and make: > > [mikef-ti:/database/postgresql-7.2.2] mi

Re: [BUGS] Unable to compile 7.3beta1 on cygwin

2002-09-09 Thread Bruce Momjian
Please grab a more current snapshot. We fixed this after beta1 was released. --- Ronald Kuczek wrote: > > Your name : Ronald Kuczek > Your email address : [EMAIL PROTECTED] > > > System Configuration > ---

Re: [BUGS] Bug #762: copy table from '/home/postgres/import' using

2002-09-09 Thread Stephan Szabo
On Mon, 9 Sep 2002 [EMAIL PROTECTED] wrote: > Long Description > When I attempt to populate an empty table using copy from (specificaly > while using a comma as the delimiter) I recieve an atoi error on the > first row and the copy fails. If I add a comma to the end of the first > row, I get a w

Re: [BUGS] _bt_check_unique checks every row in table when doing update??

2002-09-09 Thread Tom Lane
Mats Lofkvist <[EMAIL PROTECTED]> writes: > But when doing ~1000 updates (i.e. setting val0 and val1 with > a where on an existing key0/key1/key2 triplet), I get this which > seems very strange to me: I suppose you repeatedly updated the same row 1000 times? That creates an O(N^2) behavior becau

[BUGS] Bug #762: copy table from '/home/postgres/import' using delimiters ',' errors on first line.

2002-09-09 Thread pgsql-bugs
Jeff Post ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description copy table from '/home/postgres/import' using delimiters ',' errors on first line. Long Description When I attempt to populate an empty table using copy from (specifical

Re: [BUGS] ecpg hackery to get ecpg to compile from FreeBSD ports...

2002-09-09 Thread Sean Chittenden
> > > Different bogon that I ran across: > > > > > > 2:35pm sean@mat:ecpg/lib > gmake > > > cc -O -pipe -g -O -I/usr/local/include -Wall -Wmissing-prototypes >-Wmissing-declarations -fpic -DPIC -I../../../../src/interfaces/ecpg/include >-I../../../../src/interfaces/libpq -I../../../../src/inclu

Re: [BUGS] ecpg hackery to get ecpg to compile from FreeBSD ports...

2002-09-09 Thread Sean Chittenden
> > Different bogon that I ran across: > > > > 2:35pm sean@mat:ecpg/lib > gmake > > cc -O -pipe -g -O -I/usr/local/include -Wall -Wmissing-prototypes >-Wmissing-declarations -fpic -DPIC -I../../../../src/interfaces/ecpg/include >-I../../../../src/interfaces/libpq -I../../../../src/include -I/us

Re: [BUGS] Bug #761: Date format ambiguity while insertion!!!!

2002-09-09 Thread Peter Eisentraut
> My datestyle settings have been set as "ISO US(non european)" This would > mean that my date values should get inserted in the mm-dd- format. No. First, "ISO" is only the output format. Input is still accepted in most "reasonable" forms. Second, the "US" setting only defines how to resol

Re: [BUGS] pg_config Makefile bogon...

2002-09-09 Thread Peter Eisentraut
Sean Chittenden writes: > Attached is a quick patch that fixes making pg_config. When making > the port on FreeBSD, it uses commas in the LDFLAGS section of the > configure args and sed doesn't grok that so well. Patch just changes > the delimiters. -sc Fixed. -- Peter Eisentraut [EMAIL P

Re: [BUGS] ecpg hackery to get ecpg to compile from FreeBSD ports...

2002-09-09 Thread Peter Eisentraut
Sean Chittenden writes: > Different bogon that I ran across: > > 2:35pm sean@mat:ecpg/lib > gmake > cc -O -pipe -g -O -I/usr/local/include -Wall -Wmissing-prototypes >-Wmissing-declarations -fpic -DPIC -I../../../../src/interfaces/ecpg/include >-I../../../../src/interfaces/libpq -I../../../../

[BUGS] _bt_check_unique checks every row in table when doing update??

2002-09-09 Thread Mats Lofkvist
Hi, I'm running 7.2.1 on a sparc/solaris box. I get performance problems when doing updates in one of my tables (inserts are faster), so I tried to run it with profiling enabled. With reservations for my non-existent knowledge of the code, the results do look like the bad performance is because

Re: [BUGS] pg-config --includedir-server

2002-09-09 Thread elein
Yup, that was it. And of course it is properly mentioned in the INSTALL file. Thank you, elein At 09:43 AM 9/5/02, Tom Lane wrote: >elein <[EMAIL PROTECTED]> writes: > > Per docs 12.5.6 Writing Code I ran pg_config --includedir-server to verify > > the location on the C include files. It said

[BUGS] make unsuccessful on mac os x 10.2

2002-09-09 Thread Michael Fortin
My guess is that the new compiler in 10.2 is not compatible with postgres. Here is the output from configure and make: [mikef-ti:/database/postgresql-7.2.2] mikef% ./configure --with-java loading cache ./config.cache checking host system type... powerpc-apple-darwin6.0 checking which template t

[BUGS] update 7.0 -> 7.2.2 problem with shared libraries?!

2002-09-09 Thread Dmitry Gertsog
Dear, Sirs. I use Linux Suse 7.0 with Postgres 7.0 After updating Postgres to version 7.2.2 I found that some programs, which work successful with v7.0 of Postgres, now don't work correctly (all such programs was recompiled for new libraries). After analyses of situation I found problem in cryp

Re: [BUGS] Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM

2002-09-09 Thread Tim Knowles
Hi Guys, I haven't got access to my test machine which is at home so I can't try it but will the previous practice of creating a temp table (minus the column you want to delete), dropping the orignal and renaming the temp table work in 7.3 or will the dependency check catch this when you try and

[BUGS] problem with pl/python in 7.2.2

2002-09-09 Thread junk
Hello! I am having a problem with PostgreSQL 7.2.2 which does not happen with 7.2. Basically, I have Python 2.2.1 and PG 7.2.2installed on a RedHat 7.3 box where importing the re module into a python procedure doesn't work. When I try the same thing on a RedHat 7.1 with PG 7.2 iwht Python 2.2.1

[BUGS] Unable to compile 7.3beta1 on cygwin

2002-09-09 Thread Ronald Kuczek
Your name : Ronald Kuczek Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : i386 Operating System (example: Linux 2.0.26 ELF) : Windows NT 4.0 (cygwin) PostgreSQL version (example: PostgreSQL-7.3): PostgreSQL-

[BUGS] Bug #761: Date format ambiguity while insertion!!!!

2002-09-09 Thread pgsql-bugs
Shubhankar Dasgupta ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Date format ambiguity while insertion Long Description I am using Postgres 7.2.2 on Redhat Linux 7.2 My datestyle settings have been set as "ISO US(non eu