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

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 7.3.3 ANALYZE problem (is it too bad?)
Date: 2003-07-02 18:53:26
Message-ID: Pine.LNX.4.44.0307021651310.15529-100000@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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,

# ANALYZE/pg_dump seems to work with other tables.

Are there any thoughts on that?

On Wed, 2 Jul 2003, Achilleus Mantzios wrote:

>
> 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
> dynacom=# VACUUM ;
> VACUUM
> dynacom=# ANALYZE ;
> ERROR: Unable to format timestamp with time zone; internal coding error
>
>
> Anyone knows whats going on??
>

--
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-210-8981112
fax: +30-210-8981877
email: achill at matrix dot gatewaynet dot com
mantzios at softlab dot ece dot ntua dot gr

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Achilleus Mantzios 2003-07-03 12:23:43 Re: Was: Re: 7.3.3 ANALYZE problem
Previous Message Achilleus Mantzios 2003-07-02 18:45:35 7.3.3 ANALYZE problem (is it too bad?)