From: | Patrick Robin <Patrick(dot)Robin(at)disney(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | backend dies when a user defined type returns null |
Date: | 2000-11-22 00:37:34 |
Message-ID: | 3A1B154E.F3D1EF75@fa.disney.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I created myself a user defined type following the example in the
Postgres programmer's guide.
In the example in chapter 5 it shows that the input function for the
user defined type returns null when the input type doesn't match the
correct format.
I do that for input strings that don't match my strict n.n.n format ( ex
3.2.1) but it causes the backend to die.
For example, this query causes it to die:
select * from collections where version='3.2'
But this one works because it is in the correct format:
select * from collections where version='3.2.1'
Am I doing something wrong?
Thanks
Patrick
--
________________________________________
Patrick Robin
patrickr(at)fa(dot)disney(dot)com
Walt Disney Feature Animation
500 South Buena Vista Street
Burbank,California 91521-4817
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-11-22 04:58:55 | Re: Transaction, Rollback and Database Corruption question, |
Previous Message | Tom Lane | 2000-11-22 00:16:59 | Re: Core dumps, i.e. how to track down a problem |