dotaz na postgresql

[Karel Zak]

On Mon, 4 Dec 2000, Michal Měšťan wrote:

> > Na http://www.postgresql.org/docs/user/sql-createtable.htm
> > se pise:
> >
> > UNDER inherited_table
> >
> >       The optional UNDER clause specifies a collection of table names from which
> > this table automatically inherits all fields. If any inherited field
> >       name appears more than once, Postgres reports an error. Postgres
> > automatically allows the created table to inherit functions on tables above it
> >       in the inheritance hierarchy.
> >
> > Dedi se tedy definice atributu (asi by bylo spravnejsi rici "kopiruji"). S daty
> > tabulky
> > se nedeje nic, jedna se o naprosto nezavisle tabulky. Unikatni klic udrzite jen
                              ^^^^^^^^^^^^^^^^^^^^^^^^^
 Ano i ne :-) Rodicovskou tabulku nesmazete pokud ma potomky.

> > v jedne
> > jedine tabulce. Pokud to potrebujete mit ve vice tabulkach, nezbyva Vam nic
> > jineho, nez
> > to vyprogramovat v databazovych triggerech.
> 

> nebo pouzit cizi klice... (coz vede tez na trigger, ale uz je 
> pripraveny v 7.0.x)

 Todle by mne zajimalo, jak to chcete udelat pomoci FOREIGN KEYs?

				Karel