Re: Hi ...Inheritance in postgres 7.3.4 reg.

From: Klaus Naumann <kn(at)mgnet(dot)de>
To: K-Sudhakaran <sudhakar(at)ncb(dot)ernet(dot)in>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Hi ...Inheritance in postgres 7.3.4 reg.
Date: 2004-07-29 16:59:39
Message-ID: Pine.LNX.4.58.0407291858220.2739@spock.intra.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 22 Jul 2004, K-Sudhakaran wrote:

Hi Sudhakaran,

I'm not sure if I missunderstand you, but I think the feature you're
describing is foreign keys ...
If it's not, please try to describe it in more detail.

Greeetings, Klaus

>
> Hi/Hello Postgres Team!
>
> Me Sudhakaran, working for a software R&D institution located in Bangalore
> city of India.
>
> I feel that, if a table (entity) inherits another parent table(entity),
> the primary key should be unique accross all the inherited tables. That is
> the real inheritance otherwise I feel it is a mere containment of
> structure what we have in postgres 7.3.4.
>
> Because, say for example, as in my application domain, if a staff member
> inherits citizen, it means that, when a staff instance is added to staff
> entity, then it takes role in citizen (its parent) entity by default as
> after all every staff is a citizen.
>
> I am interested in contributing for this effort's special feature.
> Can I know which source code files I may have 2 explore to
> understand the Inheritance implementation in postgres 7.3.4 which I am
> using right now in my application development.
>
> Hope you would encourage me going ahead in this open source way of getting
> wanted things, by your postive response out of your bussy schedules.
>
> Thanx a lot.
>
> Kind regards
> K.Sudhakaran
>
> ____________________________________________________________________________
> K.Sudhakaran
> Staff Scientist
> #68 National Centre for Software Technology
> Electronic City,Hosur Road
> Bangalore. 561 229
> Phone. 8523300 Extn 2404
>
> Love all Serve All
> Help Ever , Hurt Never
> ____________________________________________________________________________
>
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>

--
Full Name : Klaus Naumann | (http://www.mgnet.de/) (Germany)
Phone / FAX : ++49/177/7862964 | E-Mail: (kn(at)mgnet(dot)de)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-07-29 17:00:50 Re: more signals (was: Function to kill backend)
Previous Message Gaetano Mendola 2004-07-29 16:16:27 Re: extra info on autovaccum log