Inheritance and Update/Delete
От | Roger Mathis |
---|---|
Тема | Inheritance and Update/Delete |
Дата | |
Msg-id | 3d3bd4f5$0$12806$7402020d@newsfeed.sunrise.ch обсуждение исходный текст |
Ответы |
Re: Inheritance and Update/Delete
|
Список | pgsql-general |
Hi I made the following observation: On the ToDo-List is this entry: "Allow UPDATE/DELETE on inherited table ". But in my database (7.2.1) it is possible to update/delete rows on inherited tables, and I even can delete rows from the parent-table. I'm connected with postgres. I'm confused... This is the script of my database: DROP TABLE Lieferant; DROP TABLE Kunde; DROP TABLE Mitarbeiter; DROP TABLE Person; DROP TABLE Ort; DROP SEQUENCE ort_plznr_seq; DROP SEQUENCE mitarbeiter_mnr_seq; DROP SEQUENCE kunde_knr_seq; DROP SEQUENCE lieferant_lnr_seq; CREATE TABLE Ort ( PLZNr SERIAL NOT NULL, PLZ VARCHAR(8) NOT NULL, Ort VARCHAR(32) NOT NULL, CONSTRAINT ort_pk PRIMARY KEY (PLZNr)); CREATE TABLE Person ( PName VARCHAR(64) NOT NULL, PVorname VARCHAR(64) NOT NULL, PAdresse VARCHAR(64), Ort_PLZNr INTEGER NOT NULL, PTelefon INTEGER, PE_Mail VARCHAR(64), CONSTRAINT ort_plznr_fk FOREIGN KEY (Ort_PLZNr) REFERENCES Ort(PLZNr)); CREATE TABLE Mitarbeiter ( MNr SERIAL NOT NULL, MEintritt DATE NOT NULL, MAustritt DATE, CONSTRAINT ma_pk PRIMARY KEY (MNr)) INHERITS (Person); CREATE TABLE Kunde ( KNr SERIAL NOT NULL, KZahlungskondition INTEGER NOT NULL, CONSTRAINT kunde_pk PRIMARY KEY (KNr)) INHERITS (Person); CREATE TABLE Lieferant ( LNr SERIAL NOT NULL, LLieferzeit INTEGER, CONSTRAINT lieferant_pk PRIMARY KEY (LNr)) INHERITS (Person); INSERT INTO Ort VALUES (1,'6374','Buochs'); INSERT INTO Ort VALUES (2,'6005','Luzern'); INSERT INTO Ort VALUES (3,'8008','Z�rich'); INSERT INTO Ort VALUES (4,'3003','Bern'); INSERT INTO Person VALUES ('Mathis','Roger','Elfenaustrasse 25',2,0413600566,'roger.mathis@gmx.ch'); INSERT INTO Mitarbeiter (PName, PVorname, Ort_PLZNr, MEintritt) VALUES ('Gisler','Roland',2,'2002-07-02'); INSERT INTO Kunde (PName, PVorname, Ort_PLZNr, KZahlungskondition) VALUES ('Fischer','Peter',3,30); INSERT INTO Lieferant (PName, PVorname, Ort_PLZNr, LLieferzeit) VALUES ('Treyer','Oskar',4,10); CU Roger
В списке pgsql-general по дате отправления: