Re: [Fwd: [HACKERS] Coerce to Domain]

Your patch has been added to the PostgreSQL unapplied patches list at:

http://momjian.postgresql.org/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------

Rod Taylor wrote:
-- Start of PGP signed section.
> Patch moves evaluation of the domain (seek for list of constraints) out
> of the parser and into the executor.
>
>
> Note that in the below test the domain isn't on the table -- but is in
> the view which shows rules are altered appropriately for the domain
> change.
>
>
>
>
> -- Confirm ALTER DOMAIN with RULES.
> create table domtab (col1 integer);
> create domain dom as integer;
> create view domview as select cast(col1 as dom) from domtab;
> insert into domtab (col1) values (null);
> insert into domtab (col1) values (5);
> select * from domview;
> col1
> ------
>
> 5
> (2 rows)
>
> alter domain dom set not null;
> select * from domview; -- fail
> ERROR: Domain dom does not allow NULL values
> alter domain dom drop not null;
> select * from domview;
> col1
> ------
>
> 5
> (2 rows)
>
> alter domain dom add constraint domchkgt6 check(value > 6);
> select * from domview; --fail
> ERROR: ExecEvalConstraintTest: Domain dom constraint domchkgt6 failed
> alter domain dom drop constraint domchkgt6 restrict;
> select * from domview;
> col1
> ------
>
> 5
> (2 rows)
>
>
> --
> Rod Taylor <rbt(at)rbt(dot)ca>
>
> PGP Key: http://www.rbt.ca/rbtpub.asc

[ Attachment, skipping... ]
-- End of PGP section, PGP failed!

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073