Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-announcepgsql-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
> [...]
> 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 Pitt                        |
Ubuntu Developer (  | Debian Developer  (

In response to

pgsql-announce by date

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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group