Horton

Re: BUG #1324: create domain strange behaviour

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Tzvetan Tzankov" <tzankov@noxis.net>
Cc: pgsql-bugs@postgresql.org
Date: 2004-11-17T15:44:35Z
Lists: pgsql-bugs 
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> Description:        create domain strange behaviour

IIRC, plpgsql is not yet domain-aware and won't check constraints
associated with domain values.  I'd suggest declaring
generate_session_id() to return plain text, so that the domain coercion
and constraint test happen after the function returns.

Yes, this is a bug in plpgsql, but it's not going to get fixed right
away.

			regards, tom lane