Обсуждение: core dump in psql (Is it a bug?)

Hi:

  The following commands generate a core dump in psql.

loyalty# BEGIN;
loyalty# UPDATE sc_add_points
loyalty# SET transtime = trunc(transtime/100);
loyalty# Function 'trunc(int4)' does not exist
         -- (followed by some other messages)--

         -- After this I accidentally typed the
         -- following instead of doing a "ROLLBACK"

loyalty# \df trunc
NOTICE : current transaction aborted.....
Floating point exception (core dumped)


Some other info
version :  PostgreSQL 7.2.2 on i686-pc-linux-gnu,
compiled by GCC 2.96
OS :       RedHat Linux 7.1

Thank you in advance,
ludwig lim

PS : I don't know where to post this question since
i'm not yet sure if it is a bug. On what appropriate
list should I post messages such as this one.

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com

Ludwig Lim <lud_nowhere_man@yahoo.com> writes:
>   The following commands generate a core dump in psql.

Yeah, this is a known bug (printTables fails to cope with zero-column
tables).  It's fixed in 7.3.

            regards, tom lane