Re: [GENERAL] FW: inheritance of functions - Mailing list pgsql-general

From Aaron J. Seigo
Subject Re: [GENERAL] FW: inheritance of functions
Date
Msg-id 99102709413700.03504@stilborne
Whole thread Raw
In response to FW: inheritance of functions  (Andrzej Mazurkiewicz <andrzej.mazurkiewicz@polkomtel.com.pl>)
List pgsql-general
hi...

> >  Postgres automatically allows the created table to inherit functions on
> > tables above it in the inheritance hierarchy.
> > create table A (
> > .
> > .
> > );
> >
> > create function F ...
> >
> > create table B (
> > ..
> > ) inherits (A);
> >
> > Now I assume that I can somehow use function F on table B

you would be able to use function F on table B even if it didn't inherit A.

however, if you construct rules, triggers, etc... on table A, these should be
inherited by table B.

the manual is, as far as my experience has led me to believe, referring to
functions "bound" (for lack of a better word) to the parent table....

--
Aaron J. Seigo
Sys Admin

pgsql-general by date:

Previous
From: Alain TESIO
Date:
Subject: Re: [GENERAL] how to insert from sequence
Next
From: bayard kohlhepp
Date:
Subject: [GENERAL] how do you specify null date field thru ecpg?