On 2005-09-23, Tom Lane <[EMAIL PROTECTED]> wrote:
> Mark Stosberg <[EMAIL PROTECTED]> writes:
>> Why not make the translation on the fly, since using 'now' and
>> timestamp() are not recommended practices anyway ?
>
> Because we can't retroactively fix 7.1.
That fact hadn't escaped me.
I was thinking that in *8*.1, the parsing of "CREATE TABLE" could be
altered to recognize the old syntax and improve it on the fly.
Since the meaning is identical, it seems like a reasonable improvement
to me.
This kind of rewriting is apparently already happening, because when I declare
a column as "serial", it's immediately translated into a different
representation.
test=# create table t (c1 serial);
test=# \d t
Table "public.t"
Column | Type | Modifiers
--------+---------+---------------------------------------------------
c1 | integer | not null default nextval('public.t_c1_seq'::text)
Mark
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
