Daniel Struck <struck(dot)d(at)retrovirology(dot)lu> writes:
> This makes it also impossible to change the type of a value by a trigger?
Correct. It is annoying in some cases, but if the input to the trigger
isn't of the column datatype, then what type is it? It's hard to see
how that could work in general.
If you want, say, a varchar length constraint to be checked only after
the trigger runs, I'd counsel declaring the column as plain text and
writing the length test as a CHECK constraint.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: PostgreSQL Bugs List||Date: 2004-02-10 22:54:33|
|Subject: BUG #1077: install-strip does not work for MacOS X 10.2.8|
|Previous:||From: Tom Lane||Date: 2004-02-10 16:12:39|
|Subject: Re: [BUGS] Probably a security bug in PostgreSQL rule system |