dotaz na postgresql

[Jan Serak]

Karel Zak wrote:
> 
> 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.

Ano i ne ;-) Dropnout ji nemuzete, deletnout samozrejme ano.

> 
> > > 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?

Me teda taky...

						Jan Serak