[Pgsql-ayuda] Herencia entre tablas.

[Cuevas Luis]

Amigos/as miren este ejemplo de herencia entre tablas.
Fuera fantastico que funcionara, no creen?

* CREATE TABLE tabla1 (
  id int2 NOT NULL, 
  Nombre varchar(10), 
  CONSTRAINT tabla1_pkey PRIMARY KEY (id)
) WITH OIDS;

INSERT INTO tabla1 VALUES (1, ‘l’);

* CREATE TABLE tabla2 (
Salario float4
) INHERITS(tabla1) WITH OIDS;

INSERT INTO tabla2 VALUES (2, ‘a’, 34);


* CREATE TABLE tabla3 (
 Titulo varchar(10)
) INHERITS(tabla1) WITH OIDS;

INSERT INTO tabla3 VALUES (3, ‘s’, ‘T’);


* CREATE TABLE General (
  Tipo int2, 
  Comentario varchar(10), 
  CONSTRAINT mref1 FOREIGN KEY (Tipo) REFERENCES
tabla1 (id)) WITH OIDS;


INSERT INTO General VALUES (3, ‘per’);
ERROR:  mref1 referential integrity violation - key
referenced from general not found in tabla1

INSERT INTO General VALUES (2, ‘per’);
ERROR:  mref1 referential integrity violation - key
referenced from general not found in tabla1

INSERT INTO General VALUES (1, ‘per’);
OK

Comentarios...
Saludos
Luis

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/