Inherited tables
Posted in 1999
Hello,
I'm trying to inherit primary key constraint from a table.
I'm using DS/UDO 9.14.UC4.
The SQL code is something like this:
CREATE TABLE Tables OF TYPE Tables_t
(PRIMARY KEY (name));
CREATE TABLE CatTable OF TYPE CatTable_t UNDER Tables;
where:
1. Tables_t is a row type having a field named "name"
2. CatTable_t is a sub-type of Tables_t
Reading the documentation I supposed to have a primary key on the name
field in the CatTable table too, but that doesn't happen!!
I'm wrong or something in the server is wrong?
Thanks in advance
Best regards
Lucio
--
(
Lucio Benfante
http://www.dei.unipd.it/~benfante
)
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.