Re: [BUGS] Repeatedly breaking indexes - SOLVED

2003-12-01 Thread Tom Lane
Martin Edlman <[EMAIL PROTECTED]> writes: > finally the problem is solved. The problem was with locales. > I installed and initialised the database under cs_CZ, so Pg > recorded cs_CZ in all its configurations and startup scripts. > After that I changed /etc/sysconfig/i18n to us

Re: [BUGS] unix_socket_directory vs pg_ctl?

2003-12-01 Thread SZUCS Gábor
Dear Bruce, Thanks for the confirmation. I'll stop searching the problem elsewhere then :) Yours, G. --- cut here --- - Original Message - From: "Bruce Momjian" <[EMAIL PROTECTED]> Sent: Sunday, November 30, 2003 6:29 AM > Yep, bu

[BUGS] PostgreSQL 7.4 & initdb in HP-UX 11i ---> creating conversions... ERROR: could not access file "$libdir/ascii_and_mic": No such file or directory

2003-12-01 Thread He Li
Using PostgreSQL version 7.4 in HP-UX 11i. Compiled using gcc version 3.3.1.   I tried to init db in HP-UX 11i, but the process failed, see below: (Last week, when I used PostgreSQL version 7.3.4 all went ok.)   -   bash$  bin/initdb -D /testing/HP-UX.11/postgresql -L /testi

[BUGS] pg_get_viewdef() and full joins of tables with identical column names

2003-12-01 Thread Toomas Rosin
I am running PostgreSQL 7.3.4. The problem I am having can be demonstrated on the following minimal case based on the full join example from the PostgreSQL User's Guide (Section 4.2.1.1): create database foo; \connect foo create table t1 (num integer, name char (1)); create table t2 (

Re: [BUGS] COPY alloc problem in 7.4

2003-12-01 Thread Margus Väli
I'm sending another file we have the alloc problem with. mv Neil Conway kirjutas R, 28.11.2003 kell 23:41: > unicode_test=# copy marksona from '/home/nconway/copy_input.asc' with delimiter '|' > null as ''; > ERROR: Unicode characters greater than or equal to 0x1 are not supported > CONTEXT:

Re: [BUGS] PATCH: Uninitialized variable usage in contrib/pg_autovacuum

2003-12-01 Thread Bruce Momjian
Patch applied. Thanks. --- Craig Boston wrote: > Sorry about the cross-post -- I'm not 100% sure which list this should be sent > to. > > I noticed in the 7.4 release that in contrib/pg_autovacuum, args->logfile is > no

Re: [BUGS] PATCH: Uninitialized variable usage in contrib/pg_autovacuum

2003-12-01 Thread Bruce Momjian
Patch applied to 7.4.X too. --- Craig Boston wrote: > Sorry about the cross-post -- I'm not 100% sure which list this should be sent > to. > > I noticed in the 7.4 release that in contrib/pg_autovacuum, args->logfile is >