Re: Extended SERIAL parsing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Zoltan Boszormenyi <zboszor(at)dunaweb(dot)hu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Extended SERIAL parsing
Date: 2006-06-11 23:54:10
Message-ID: 28444.1150070050@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Zoltan Boszormenyi <zboszor(at)dunaweb(dot)hu> writes:
> after some experimentation, I came up with the attached patch,
> which implements parsing the following SERIAL types:

As has been pointed out before, it would be a seriously bad idea to
implement the SQL syntax for identity columns without matching the
SQL semantics for them. That would leave us behind the eight-ball
when we wanted to implement the SQL semantics. Right now we have
a useful but non-standard semantics, and a useful but non-standard
syntax, and those two should stick together.

I'm not too happy with converting SERIAL4 and SERIAL8 into reserved
words, either, as I believe this patch does.

Some other things missing are documentation and pg_dump support.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-06-12 00:03:22 Re: Non-transactional pg_class, try 2
Previous Message Tom Lane 2006-06-11 23:47:56 Re: TODO: Add pg_get_acldef(), pg_get_typedefault(), pg_get_attrdef(),