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

Using types in an inappropriate way causes crash of backend

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Using types in an inappropriate way causes crash of backend
Date: 2001-03-15 16:49:49
Message-ID: 200103151649.f2FGnnR51705@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Boris Boehlen (boris(at)i3(dot)informatik(dot)rwth-aachen(dot)de) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Using types in an inappropriate way causes crash of backend

Long Description
I tried to create a type to achieve the same as the "CREATE DOMAIN"
command of SQL2. After declaring a type `f' which should be the same
as `int4' I created table using this type. When tried to insert a value
into the table I got the following error:

  ERROR:  Attribute 'a' is of type 'f' but expression is of type 'int4'
	You will need to rewrite or cast the expression

Then I tried the next insert statement and the backend crashed. 

BTW: How can I achieve the same as using "CREATE DOMAIN" without 
extending PSQL?


Sample Code
create type f (input = int4in, output=int4out, internallength=4);
create table z (a f);
insert into z values(1);
insert into z values('1');

No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-03-15 17:07:32
Subject: Re: Using types in an inappropriate way causes crash of backend
Previous:From: Tom LaneDate: 2001-03-15 16:04:38
Subject: Re: Swedish characters

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