| From: | Eric B(dot)Ridge <ebr(at)tcdi(dot)com> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Fwd: REWRITE_INVOKE_MAX and "query may contain cycles" |
| Date: | 2003-02-21 02:36:32 |
| Message-ID: | 499EF643-4545-11D7-9F63-0003937E3354@tcdi.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday, February 20, 2003, at 09:25 PM, Martijn van Oosterhout
wrote:
> On Thu, Feb 20, 2003 at 08:56:13PM -0500, Eric B. Ridge wrote:
>> Is there no keyword for getting the DEFAULT value of a column when
>> doing an INSERT? I know, just don't specify the columns, but with
>> RULEs (and how we're using 'em), we could really use something like
>> this. How hard would this be to implement? And where would one do
>> it?
>
> It's there, I beleive added in 7.3 (or was it 7.2?). Very cool, no?
<short pause while RTFM>... yep, it's there in 7.3. That is cool!
But my suggestion of NEW inheriting the DEFAULT value when not
specified in ON INSERT RULEs still stands (I just checked the docs, it
ain't there).
eric
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-02-21 03:20:14 | Re: Fwd: REWRITE_INVOKE_MAX and "query may contain cycles" |
| Previous Message | Martijn van Oosterhout | 2003-02-21 02:25:50 | Re: Fwd: REWRITE_INVOKE_MAX and "query may contain cycles" |