Re: reproducible database crash with simple sql command

From: Martin Pitt <martin(at)piware(dot)de>
To: Christian(dot)Strobl(at)dlr(dot)de
Cc: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: reproducible database crash with simple sql command
Date: 2008-05-09 17:10:10
Message-ID: 20080509171010.GB6538@piware.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce pgsql-bugs

Hi Christian,

redirecting to the -bugs mailing list. This is totally inappropriate
for -announce.

Christian(dot)Strobl(at)dlr(dot)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)

In response to

Browse pgsql-announce by date

  From Date Subject
Next Message David Fetter 2008-05-12 06:26:43 == PostgreSQL Weekly News - May 11 2008 ==
Previous Message Christian.Strobl 2008-05-08 09:22:21 reproducible database crash with simple sql command

Browse pgsql-bugs by date

  From Date Subject
Next Message alex 2008-05-09 18:34:55 BUG #4151: Can't connect/start database after restart
Previous Message Christian Lippuner 2008-05-09 17:02:49 BUG #4150: ecpg: update/insert of array data does not work anymore since Version 8.2