Thread: Does ASSERTION constraint work ?
<div><p>Hi,<p>I try to use SQL statement 'CREATE ASSERTIION', but it does not work, how to use it? Does PostgreSQL support ASSERTIONconstraint ? Please help me out.<p>Thanks.<p>Yanchun <br /> </div><br clear="all" /><hr />Get your FREEdownload of MSN Explorer at <a href="http://explorer.msn.com">http://explorer.msn.com</a><br />
(I think) you'd better check the --enable-cassert option in http://www.postgresql.org/idocs/index.php?install-procedure.html cheers, t. On Wed, 30 May 2001, rui zhong wrote: > > Hi, > > I try to use SQL statement 'CREATE ASSERTIION', but it does not work, how to use it? Does > PostgreSQL support ASSERTION constraint ? Please help me out. > > Thanks. > > Yanchun > > > > _________________________________________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > >
On Wed, 30 May 2001, rui zhong wrote: > I try to use SQL statement 'CREATE ASSERTIION', but it does not work, > how to use it? Does PostgreSQL support ASSERTION constraint ? Please > help me out. AFAIK, Assertions are not yet implemented in PostgreSQL. You may be able to use triggers to get the appropriate effect, but it's alot more work.
"Thalis A. Kalfigopoulos" wrote: > > (I think) you'd better check the --enable-cassert option in http://www.postgresql.org/idocs/index.php?install-procedure.html > That enables C assertions at compile time. Not the same thing. -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com