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
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
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