Re: [BUGS] importing from 8.0.3 unicode problem

2005-10-30 Thread Tomas Zerolo
On Sun, Oct 30, 2005 at 12:23:00PM -0800, Theodore Petrosky wrote: > I don't know if this is a bug or my not understanding > something. [...] > I get an error: > ERROR: invalid UNICODE byte sequence detected near > byte 0x8e > CONTEXT: COPY ioinfo, line 177, column publication: > "Elle D?cor" > E

[BUGS] importing from 8.0.3 unicode problem

2005-10-30 Thread Theodore Petrosky
I don't know if this is a bug or my not understanding something. I installed 8.1beta4 on a machine (mac os x 10.4.2). I have my pg_dump file from my running 8.0.3 server in the office (os x 10.3.9). I created a cluster with: initdb --encoding-UNICODE /path/to/dir then createdb databasename psql

Re: [BUGS] Fwd: Bug#325114: Postgres Rolling back for no reason

2005-10-30 Thread Tom Lane
Martin Pitt <[EMAIL PROTECTED]> writes: > No one else is using the database. 161 was a value that was put into the row > a LONG time ago. As far as we can figure it seems like postgres is > continually rolling back a transaction which isn't taking place. How long ago is "a LONG time"? More than 2

[BUGS] Fwd: Bug#325114: Postgres Rolling back for no reason

2005-10-30 Thread Martin Pitt
Hi PostgreSQL developers! In Debian we recently received the bug report below, but since I don't know the guts of PostgreSQL so well, could someone please take a look at it? Thanks in advance! Martin - Forwarded message from Michael Blake <[EMAIL PROTECTED]> - Subject: Bug#325114: Post