Hi all,
BIGINT: if it makes you feel safer and you think it's not an issue, fine.
SERIAL vs verbose query:
*provided* *that* as of the feature >= PGSQL 8.2, the use of "old style" vs
"new style" is basically the same:
- 1 there's no point in breaking things by insinsting on the use of SERIAL
when with the use of "old style" + ALTER TABLE .. OWNED BY you achieve the
same results without breaking existing dbs if you use this form:
> CREATE SEQUENCE tablename_colname_seq;
> CREATE TABLE tablename (
> colname integer NOT NULL DEFAULT nextval('tablename_colname_seq')
> );
> ALTER SEQUENCE tablename_colname_seq OWNED BY tablename.colname;
- 2 since PGSQL < 8.2 are EOL, you could update existing db by adding the
following to system/schema/pgsql/upgrades/post/*.sql
> ALTER SEQUENCE tablename_colname_seq OWNED BY tablename.colname;
IMHO there's no point in not doing that , unless you want to support EOL
products.
+1 anyone?
Last but not least:
Please excuse my previous errors , I made it perfectly clear I'm not expert
but just willing to help.
--
knowledge has no owner, only means to reveal itself
--
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at http://groups.google.com/group/habari-dev
