> [EMAIL PROTECTED] writes: > > If a byte string that is not valid unicode is inserted into a bytea > > column, analyze will fail unless the data was tagged as bytea in the > > insert. > > Your example produces no failure for me. You'd better be more specific > about which PG version you're running, on what platform, with what > configure options and what database encoding, etc.
Ah, sorry about that. It's 7.2.1, in the Debian package incarnation 7.2.1-2. The database and the client encoding are both unicode. These are the setting from postmaster.conf (nothing strange): debug_level = 0 log_connections = on log_pid = on log_timestamp = on syslog = 2 silent_mode = off syslog_facility = LOCAL0 trace_notify = off max_connections = 64 shared_buffers = 128 tcpip_socket = 1 stats_start_collector = on stats_reset_on_server_start = off stats_command_string = on stats_block_level = on stats_row_level = on /Anders ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])