[ADMIN] iso-8859-1 and utf-8

2008-09-25 Thread Claus Guttesen
Hi. I found out by accident that my db-dump, at least in ver. 8.3.3, automagically converts from iso-8859-1 to utf-8. Our db has been around since January 2000 and iso-8859-1 was chosen back then as encoding. When I occasionally imported the nightly dump to a test-db it would complain very early d

[ADMIN] change max_value in sequence

2008-09-05 Thread Claus Guttesen
Hi. I have a table with a serial field defined with an older version of postgresql (ver. 7). Back then max_value was 2147483647: select max_value from my_bid_seq ; max_value 2147483647 How can I increase it? By updating the max_value-field? This is an older thread and may have chang

Re: [ADMIN] [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92

2007-03-20 Thread Claus Guttesen
I am using postgres 8.2.3. I have recently converted my database from sql-ascii to UTF8. I have a portal which calls a perl program to insert the data into the database. While inserting, I am getting an error message DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding