Re: Re: Updating views - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Re: Updating views
Date
Msg-id Pine.LNX.4.30.0106051858500.900-100000@peter.localdomain
Whole thread Raw
In response to Re: Re: Updating views  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane writes:

> For example, if your view has
>     select ... where a>5;
> what do you think ought to happen if someone tries to insert a row
> with a<5?

It's an error if you specified WITH CHECK OPTION in the view definition,
it succeeds otherwise.  There's a standard semantic for it.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: turning off stderr message for postmaster
Next
From: "Len Morgan"
Date:
Subject: Re: Calling external programs