Re: [BUGS] Minor bug with syslog facility

2003-07-02 Thread Tom Lane
"Donald Fraser" <[EMAIL PROTECTED]> writes: > Changing the syslog facility (syslog_facility) in the configuration file ha= > s no effect after sending a SIGHUP to the postmaster. > The only way to get the change is to restart the postmaster. Probably so --- I think the syslog library will only exa

Re: [BUGS] Make install error

2003-07-02 Thread Bernd von den Brincken
Hello, Segree, Gareth wrote: Whenever I do a make install I get the following error: /usr/lib/postgresql/ascii_msc.so does not exist. Obvious, you have to install the ascii library before you can use postgres on your Nokia mobile phone. Regards // Bernd vdB ---(end of br

Re: [BUGS] Problem with "z_" in Unicode-DB

2003-07-02 Thread Markus Bertheau
В Срд, 02.07.2003, в 23:17, Ian Barwick пишет: > On Wednesday 02 July 2003 00:37, Markus Bertheau wrote: > > В Срд, 02.07.2003, в 00:27, Ian Barwick пишет: > > > On Tuesday 01 July 2003 11:01, Wehrle, Daniel wrote: > > > > Statement: > > > > SELECT ID FROM tblAssets WHERE uri like > > > > '/files/A

Re: [BUGS] Problem with "z_" in Unicode-DB

2003-07-02 Thread Ian Barwick
On Wednesday 02 July 2003 00:37, Markus Bertheau wrote: > В Срд, 02.07.2003, в 00:27, Ian Barwick пишет: > > On Tuesday 01 July 2003 11:01, Wehrle, Daniel wrote: > > > Statement: > > > SELECT ID FROM tblAssets WHERE uri like > > > '/files/AssetStore/postgreSqlTest/ratz_ruebe.jpg' ; > > > > > > ERRO

[BUGS] Make install error

2003-07-02 Thread Segree, Gareth
Title: Make install error Whenever I do a make install I get the following error: /usr/lib/postgresql/ascii_msc.so does not exist. Why?

[BUGS] Minor bug with syslog facility

2003-07-02 Thread Donald Fraser
PostgreSQL: 7.3.3 OS: Redhat 7.2   Changing the syslog facility (syslog_facility) in the configuration file has no effect after sending a SIGHUP to the postmaster. The only way to get the change is to restart the postmaster. Not sure whether this is a bug or it is suppose to behave this way

Re: Was: Re: [BUGS] 7.3.3 ANALYZE problem

2003-07-02 Thread Tom Lane
Achilleus Mantzios <[EMAIL PROTECTED]> writes: > Finally i found the bad row in the bad table. Were you able to determine what value was actually stored? (You might try using EXTRACT to get different parts of it.) regards, tom lane ---(end of broa

Re: [BUGS] 7.3.3 ANALYZE problem (is it too bad?)

2003-07-02 Thread Achilleus Mantzios
On Wed, 2 Jul 2003, Tom Lane wrote: > Achilleus Mantzios <[EMAIL PROTECTED]> writes: > > dynacom=# VACUUM ANALYZE ; > > ERROR: Unable to format timestamp with time zone; internal coding error > > Is it possible you have any really wacko timestamp values in your data? Thats right. The problem is

Re: [BUGS] 7.3.3 ANALYZE problem (is it too bad?)

2003-07-02 Thread Tom Lane
Achilleus Mantzios <[EMAIL PROTECTED]> writes: > dynacom=# VACUUM ANALYZE ; > ERROR: Unable to format timestamp with time zone; internal coding error Is it possible you have any really wacko timestamp values in your data? This looks like this recent report: http://fts.postgresql.org/db/msg.html?m

[BUGS] 7.3.2: indexes on bigint field is not used for queries without quotas

2003-07-02 Thread Maxime Zakharov
Hi, POSTGRESQL BUG REPORT System Configuration - Architecture (example: Intel Pentium)

Was: Re: [BUGS] 7.3.3 ANALYZE problem

2003-07-02 Thread Achilleus Mantzios
Finally i found the bad row in the bad table. My wondering is that a) java.sql.Timestamp.valueOf(String) accepts -MM-dd hh:mm:ss.fff b) when i try UPDATE noonmsg SET eta = '4714-01-01 BC'; i get ERROR: TIMESTAMP WITH TIME ZONE out of range '4714-01-01 BC' c) the girl who does data entry

Re: [BUGS] 7.3.3 ANALYZE problem (is it too bad?)

2003-07-02 Thread Achilleus Mantzios
Also, % pg_dump -t noonmsg dynacom > noonmsg_dump.sql pg_dump: ERROR: Unable to format timestamp with time zone; internal coding error pg_dump: lost synchronization with server, resetting connection pg_dump: SQL command to dump the contents of table "noonmsg" failed: PQendcopy() failed. Also,

[BUGS] 7.3.3 ANALYZE problem (is it too bad?)

2003-07-02 Thread Achilleus Mantzios
dynacom=# SELECT version(); version - PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC 2.96 (1 row) dynacom=# VACUUM ANALYZE ; ERROR: Unable to format timestamp with time zone; internal coding error dy

[BUGS] 7.3.3 configure should check for curses before readline

2003-07-02 Thread Ian Grant
The canned readline check assumes that curses is already installed. If it isn't then the readline check fails and configure reports that readline is not available. The real problem though is that curses is not available. -- Ian Grant, Computer Lab., William Gates Building, JJ Thomson Ave., Cambr

Re: [BUGS] Invalid EUC_JP char seq bug?

2003-07-02 Thread Tatsuo Ishii
> >>search_words=%B7%F6%BA%7E > >>select id from products where name like '??~' > >>Query failed: ERROR: Invalid EUC_JP character sequence found (0xba7e) > > > > > > This is definitly a bad EUC_JP. > > According to a PHP developer in my bug report > (http://bugs.php.net/bug.php?id=24309&edit=2