reproducible database crash with simple sql command
hi all,
first i create a table
create table regions (id integer, name varchar);
then i want to set a default value for a column, e.g.
alter table regions alter column name set default 'bavaria';
at this point crashes the database with the message
PANIK: ERROR_STACK_SIZE exceeded
the rest of the message is unfortunately in german
then i have to restart the postgres-service manually
this error is very easy reproducible at my environment
is this a problem of my installation or can anybody reproduce this error
at his environment
thanks and greetings from munich
christian
p.s. os windows xp, sp2
postgres 8.3.1, visual c++, build 1400
Hi Christian,
redirecting to the -bugs mailing list. This is totally inappropriate
for -announce.
Christian.Strobl@dlr.de [2008-05-08 11:22 +0200]:
first i create a table
create table regions (id integer, name varchar);then i want to set a default value for a column, e.g.
alter table regions alter column name set default 'bavaria';at this point crashes the database with the message
PANIK: ERROR_STACK_SIZE exceeded
[...]
p.s. os windows xp, sp2
postgres 8.3.1, visual c++, build 1400
Hm, works fine with PostgreSQL 8.3.1 on Ubuntu 8.04, also under a German
installation/locale. After the ALTER I get
martin=> \d regions
Tabelle �public.regions�
Spalte | Typ | Attribute
--------+-------------------+--------------------------------------
id | integer |
name | character varying | default 'bavaria'::character varying
which looks alright to me. Might be a windows specific bug?
Martin
--
Martin Pitt | http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)