Re: [BUGS] could not find /usr/local/timezone

2004-10-29 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > LOG: could not open directory "/usr/share/timezone": No such file or > directory > What's it mean? Am I missing a package? Hmmm ... where is that coming from exactly? PG itself should not be referring to /usr/share/timezone --- we have our own TZ data

[BUGS] could not find /usr/local/timezone

2004-10-29 Thread Josh Berkus
Folks, This is a new one on me, but possibly because it's my first time working on Gentoo: Version: 8.0b4 Platform: Gentoo Linux 2.6.8 Severity: Unknown Message: LOG: could not open directory "/usr/share/timezone": No such file or directory What's it mean? Am I missing a package? -- --Jos

Re: [BUGS] BUG #1301: pg_restore failed on AMD 64bit machine

2004-10-29 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > When I try restore a backup (made by pg_dump with -Fc option), when it > reaches some specific table/at some specific positions in the backup file, > it will fail. This only happened on 64bit machines with version 7.4.0-7.4.6 How big is the b

[BUGS] BUG #1299: ordinal 2821 no en contrado en LIBEAY32.DLL

2004-10-29 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1299 Logged by: ALEX EDUARDO QUITIAQUEZ ESQUIVEL Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: Win Xp SP2 Description:ordinal 2821 no en contrado en LIBEAY32.DLL Details:

[BUGS] BUG #1301: pg_restore failed on AMD 64bit machine

2004-10-29 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1301 Logged by: hongyi Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.5 Operating system: SuSe 9.1 Description:pg_restore failed on AMD 64bit machine Details: pg_restore has flow on AMD64 machi

[BUGS] BUG #1298: 22021: invalid byte sequence for encoding \"UNICODE\": 0xe16d61"

2004-10-29 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1298 Logged by: Lucas Sultanum Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: Windows 2000 server Description:22021: invalid byte sequence for encoding \"UNICODE\": 0xe16d61

Re: [BUGS] PostgreSQL 8.0 Beta 4 - Qualified ORDER BY column name not working on UNION query

2004-10-29 Thread Tom Lane
Scott Eade <[EMAIL PROTECTED]> writes: > SELECT TURBINE_USER.USER_ID FROM TURBINE_USER WHERE TURBINE_USER.USER_ID = 1 > UNION > SELECT TURBINE_USER.USER_ID FROM TURBINE_USER WHERE TURBINE_USER.USER_ID = 2 > -- The following works. > --ORDER BY 1 ASC > -- The following does not work when I would per

Re: [BUGS] copy command PANIC in --encoding='utf8' createdb option

2004-10-29 Thread Tom Lane
Sil Lee <[EMAIL PROTECTED]> writes: > test1=> \copy t1 (col1) from '/opt/lgsec/dmp/test.dmp' > \. > PANIC: ERRORDATA_STACK_SIZE exceeded > test1=> > ^^; postmaster log > WARNING: ignoring unconvertible UHC character 0xb85f > CONTEXT: COPY t1, line 1: "/system/workbin/등락종??.TXT.20040319" > WARN

Re: [BUGS] Insertion Deferrable

2004-10-29 Thread Stephan Szabo
On Fri, 29 Oct 2004, [UTF-8] æ^]¨é^B^U wrote: > You told me restricted foreign key cannot deferable in PostgreSQL 8.0.0 Beta 4. > > 2004-10-21 22:33 tgl > > * doc/src/sgml/ddl.sgml, doc/src/sgml/ref/create_table.sgml, > src/backend/commands/tablecmds.c, src/backend/commands/trigger.

Re: [BUGS] 22021: invalid byte sequence for encoding \"UNICODE\":

2004-10-29 Thread Andreas Pflug
Lucas Sultanum wrote: I am not sure if this is a bug or I am doing something wrong. When I execute the following command (*insert into a_cadclias values ('6542','65465','amaro','ámaro')*) on pgAdmin III Query it works pretty well, but when I try to do the same through a C# App connecting to the

Re: [BUGS] Dropdb, Win32 Problem

2004-10-29 Thread Bruce Momjian
Thomas Wegner wrote: > Hello, > > on dropdb i get often this since first Beta of 8.0 (actualy i use 8.0.0 Beta > 4 > from PostgreSQL Installer Project): > > WARNING: could not remove database directory This has been fixed and will be in the next beta. -- Bruce Momjian

Re: [BUGS] BUG #1294: Random errors (failed connection)

2004-10-29 Thread Stefanos Harhalakis
On Tuesday 26 October 2004 05:08, Tom Lane wrote: > "PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > > Please consider changing the default for IRIX systems to select() instead > > of poll(). > > Can you suggest a test for configure to determine that poll() is broken? > I'm not particularly exc

Re: [BUGS] [Slony1-general] Thread-safety detection on HP-UX

2004-10-29 Thread Jan Wieck
On 10/26/2004 6:13 PM, Bruce Momjian wrote: I believe Slony always needs threading, it just can be used even if the OS doesn't fully support all thread-safe functions, so on 8.0 you use --thread_safety_force. Jan, is that correct? Yes. Slony allways uses pthreads and therefore it requires that on

[BUGS] copy command PANIC in --encoding='utf8' createdb option

2004-10-29 Thread Sil Lee
I installed PostgreSQL-8.0beta4 on Linux Fedora Core2. and first I made database test1. and create table t1, copy data from file 'test.dmp' $ createdb test1 CREATE DATABASE $psql test1 test1=> create table t1 (col1 varchar(100)); CREATE TABLE test1=> show client_encoding; client_encoding --

[BUGS] Sequence creation bug: 8.0.0beta4 win32

2004-10-29 Thread Nick Farrell
Hi. I'm seeing a couple of strange things. default encoding: unicode locale: en_AU running psql from localhost, I appear able to create a sequence, but I get an error whenever I try to use it. This code runs fine on linux (though the linux DB is v7.5.X). In addition, the log snippet below shows m

[BUGS] Dropdb, Win32 Problem

2004-10-29 Thread Thomas Wegner
Hello, on dropdb i get often this since first Beta of 8.0 (actualy i use 8.0.0 Beta 4 from PostgreSQL Installer Project): WARNING: could not remove database directory - Thomas Wegner Cabrio Meter - The Weather Plugin for Trillian http://trillian.wegner

[BUGS] Bug

2004-10-29 Thread Lucas Sultanum
Hello,   I am not sure if this is a bug or I am doing something wrong. When I execute the following command (insert into a_cadclias values ('6542','65465','amaro','ámaro'))  on pgAdmin III Query it works pretty well, but when I try to do the same through a C# App connecting to the database

[BUGS] pg_autovacuum in 8beta-dev3 small bug

2004-10-29 Thread Leen Besselink
Hi folks, 8.0beta3 has pg_autovacuum included, when I want to run this as a Windows service, it says you can use the -I and -R options. When I do that and I specify a password with '-P' (uppercase) then in the registry it's saved as '-p' (lowercase) in the service-commandline (ImagePath). Also i

[BUGS] PostgreSQL vs NOD32 anti-virus

2004-10-29 Thread Rafael Franco
Hello,       PostgreSQL 8.0 beta 1 for windows, don’t work with NOD32 anti-virus system. It fails on connection task.     I uninstalled NOD32 and PostgreSQL works fine. Install NOD32 again and PostgreSQL don’t work.     I teste on Windows XP and Windows 2003 serv

[BUGS] Not a real bug, but an error

2004-10-29 Thread Andrea D.
Hi, I've just upgraded Roma 7.3.x to 7.4.5 on a Mandrake 10.1 community. I've used pg_dumpall (Roma version 7.4.5) to dump my previous databases to a file in plain text form and then trend to restore using 'psql -f'. But there was an error: a function needed in a constraint of a table was placed af

[BUGS] Insertion Deferrable

2004-10-29 Thread 杨邕
You told me restricted foreign key cannot deferable in PostgreSQL 8.0.0 Beta 4. 2004-10-21 22:33 tgl * doc/src/sgml/ddl.sgml, doc/src/sgml/ref/create_table.sgml, src/backend/commands/tablecmds.c, src/backend/commands/trigger.c: Disallow referential integrity actions f

[BUGS] 22021: invalid byte sequence for encoding \"UNICODE\": 0xe16d61"

2004-10-29 Thread Lucas Sultanum
Versions tested: "PostgreSQL 8.0.0beta2 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.2.3 (mingw special 20030504-1)"   AND   "PostgreSQL 8.0.0beta4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.3.1 (mingw special 20030804-1)"     Hello,   I am not sure if this is a bug or I a

[BUGS] 8 beta 4 installation failed

2004-10-29 Thread Igor Azarny
Hi ! 8 beta 4 for win32 installation failed. Installation process freez on "Activating procedural languages" Enviroment win Xp professional version 2002 service pack 2.   Happy bug hunting ! Igor Azarny Do you Yahoo!? Express yourself with Y! Messenger! Free. Download now.

[BUGS] PostgreSQL 8.0 Beta 4 - Qualified ORDER BY column name not working on UNION query

2004-10-29 Thread Scott Eade
I am running PostgreSQL 8.0 Beta 4 (Windows installer) on Windows XP Pro SP2. The query below has three ORDER BY clauses. When I execute it with the uncommented clause an error results. Some further commentary is included in the comments below. I would expect the uncommented clause to produ

[BUGS] SSL password problem in PG-WIN32

2004-10-29 Thread Anthony
When I startup using myself compiled PG.(use MINGW,OPENSSL,ZLIB) And I use pg_ctl start -o -i, it work fine. But when use pg_ctl start -o -il, it will prompt: Enter PEM pass phrase: when I input password, it fails. it say " NO THIS COMMAND" I think this problem exist in postmaster don't have one

[BUGS] PostgreSQL 8.0.0-beta4 pginstaller failure on Windows 2003

2004-10-29 Thread Bruce Patin
I downloaded http://pgfoundry.org/projects/pginstaller/ and used it to attempt installation of PostgreSQL 8.0.0-beta4 on a Microsoft Windows Server 2003 Standard Edition. Things I changed from defaults are the userid "postgresql", instead of "postgres", and checked box to "Accept connections on al

[BUGS] Strange behavior in psql

2004-10-29 Thread C. David Wilde
Hello, My apologies if this is not a bug or has already been resolved. I have searched fairly extensively for this particular problem and haven't found anything yet. I have been having problems with psql under linux lately and this problem has followed me from 7.4.4 - 7.4.6, but it started some

[BUGS] DBD::PgSPI crashes database server (SIGSEGV)?

2004-10-29 Thread Zhamak Dehghani
Hi, I have tried to use "plperlu" to write server functions to encapsulate some common functionality such as "copy an entity"(and all its associated records). I'm getting a database server crash calling the function from psql or a perl client. Where the crash happens is kind of random and happens

Re: [BUGS] [HACKERS] Question on the 8.0Beta Version

2004-10-29 Thread Adrian Maier
On Fri, 22 Oct 2004 08:59:56 +0200, Davide Negri <[EMAIL PROTECTED]> wrote: > Hello, > i have installed postgres 8.0 beta3 as a program on my pc on windows xp. I > have read on the installation note file that postgres server will not run > with administrative permissions. I have read on your forum