Inheritance: problems with primary key

Поиск
Список
Период
Сортировка
От camilarrocha@hotmail.com (Camila Rocha)
Тема Inheritance: problems with primary key
Дата
Msg-id 50da3813.0210030431.543d50b2@posting.google.com
обсуждение исходный текст
Ответы Re: Inheritance: problems with primary key
Список pgsql-general
hi,

I'm having troubles with inheritance too. I've created a table,
"person", and it has a field "code" as its primary key.
After, I've created a table, "student", that inherits person. I wanted
too use the column person.code as the primary key in the students
table too, but I've noticed that, when I insert a student, the
uniqueness of the primary key is no granted. for example, I can insert
two students.code = "1"

How can I inherit the primary key too??

thankx,
Camila

PS: Sorry about the bad english, i'm brazilian

В списке pgsql-general по дате отправления:

Предыдущее
От: j_v_dsilva@www.com (joseph v d'silva)
Дата:
Сообщение: Trouble compiling postgresql in hp-unix
Следующее
От: "Tommy"
Дата:
Сообщение: .NET ODBC Driver