Re: Fwd: REWRITE_INVOKE_MAX and "query may contain cycles" - Mailing list pgsql-general

On Thursday, February 20, 2003, at 10:20  PM, Tom Lane wrote:
> "Eric B. Ridge" <ebr@tcdi.com> writes:
>> INSERT INTO foo (id, title, type) VALUES (<default>, 'whatever',
>> <default>);
>
>> Is there no keyword for getting the DEFAULT value of a column when
>> doing an INSERT?
>
> Not sure how far back this goes, but in 7.3 you can say DEFAULT:
<snip>
>   alter table foo_view alter column id set default
> nextval('seq_foo_id');
>
> and away you go.

Thanks for this information.  Y'all rock.  These two things are enough
to convince me to upgrade to 7.3 immediately.

eric