core dump in psql (Is it a bug?)

Поиск
Список
Период
Сортировка
Искать

core dump in psql (Is it a bug?)

От:
Ludwig Lim <lud_nowhere_man@yahoo.com>
Дата:
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

Re: core dump in psql (Is it a bug?)

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Ludwig Lim  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
FAQ