postgres database

[Martin Sedlmayr <Ma...@faw.uni-ulm.de>]

I use tdk 1.1a11 and a postgres-7.0.3 database.

Following a snipplet from turbin-schema.sql:

drop sequence TURBINE_PERMISSION_SEQ;
drop table TURBINE_PERMISSION;

CREATE TABLE TURBINE_PERMISSION
(
    PERMISSION_ID serial,
    PERMISSION_NAME varchar (99) NOT NULL,
    OBJECTDATA oid,
    PRIMARY KEY(PERMISSION_ID),
    UNIQUE (PERMISSION_NAME)
);


Two points here:

- a sequence <columnname>_seq is expected, but postgres creates
  "implicetly" a <tablename>_<columnname>_seq

- long names will be truncated. In this example postgres created a
  "turbine_permi_permission_id_seq" instead of
"turbine_permission_seq"


Has onyone made the same experience ? Does anyone know a workaround ?
Or what am I missing here.

Thanks in advance,
Martin


---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org