Using inheritance in PostgreSQL

Posted by Anton Prokofiev on Stack Overflow See other posts from Stack Overflow or by Anton Prokofiev
Published on 2010-05-13T20:45:05Z Indexed on 2010/05/15 17:34 UTC
Read the original article Hit count: 279

Filed under:

postgresql

|

inheritance

Hello, All! Is somebody have an experience using inheritance in PostgreSQL?

Is it worth to use it, or better to keep hands of :)? In which situation you would use it?

To be true I'm a little bit in doubt about mixing relational and OO models...

© Stack Overflow or respective owner

Related posts about postgresql

Postgresql fails to start on Ubuntu 10.04.4 LTS

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I installed postgresql 9.2 from add-apt-repository ppa:pitti/postgresql using apt-get install postgresql-9.2 At the end of the install and every time I try to launch postgresql by using the following command /etc/init.d/postgresql start or service postgresql start I get this error: Error:… >>> More
can't install psycopg2 in my env on mac os x lion

as seen on Server Fault - Search for 'Server Fault'
I tried install psycopg2 via pip in my virtual env, but got this error: ld: library not found for -lpq (full log here: http://pastebin.com/XdmGyJ4u ) I tried install postgres 9.1 from .dmg and via port, (gksks)iMac-Alexander:~ lorddaedra$ locate libpq /Developer/SDKs/MacOSX10.7.sdk/usr/include/libpq /Developer/SDKs/MacOSX10… >>> More
Postgresql has broken apt-get on Ubuntu

as seen on Super User - Search for 'Super User'
On ubuntu 12.04, whenever I try to install a package using apt-get I'm greeted by: The following packages have unmet dependencies: postgresql-9.1 : Depends: postgresql-client-9.1 but it is not going to be instal led E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a so lution)… >>> More
Installing PostgreSQL on FreeBSD (with ports)

as seen on Server Fault - Search for 'Server Fault'
Hey everyone, I am trying to install (using ports) PostgreSQL on a virtual server, running FreeBSD. My one question is this: Which of the following should I install? postgresql-contrib postgresql-docs postgresql-jdbc postgresql-libpgeasy postgresql-libpq++ postgresql-libpqxx postgresql-odbc … >>> More
Strange permission errors in new PostgreSQL installation

as seen on Server Fault - Search for 'Server Fault'
A freshly installed PostgreSQL (with configuration overwritten) won't start: $ sudo service postgresql start * Starting PostgreSQL 9.1 database server * Error: could not read /etc/postgresql/9.1/main/postgresql.conf: Permission denied Looks like it should be able to read it though: $ ls -l postgresql… >>> More

Related posts about inheritance

Single Table Inheritance (Database Inheritance design options) pros and cons and in which case it us

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I study about today about 2 database design inheritance approaches: 1. Single Table Inheritance 2. Class Table Inheritance In my student opinion Single Table Inheritance make database more smaller vs other approaches because she use only 1 table. But i read that the more favorite approach… >>> More
How to use Private Inheritence aka C++ in C# and Why not it is present in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I know that private inheritance is supported in C++ and only public inheritance is supported in C#. I also came across an article which says that private inheritance usually defines a HAS-A relationship and kind of an aggregation relationship between the classes. EDIT: C++ code for private inheritance: The… >>> More
[PHP] Singleton class and using inheritance

as seen on Stack Overflow - Search for 'Stack Overflow'
I have am working on a web application that makes use of helper classes. These classes hold functions to various operation such as form handling. Sometimes I need these classes at more than one spot in my application, The way I do it now is to make a new Object. I can't pass the variable, this will… >>> More
Difference between Inheritance and Composition

as seen on Stack Overflow - Search for 'Stack Overflow'
Are Composition and Inheritance are the same? If I want to implement the composition pattern, how can I do that in Java? >>> More
C# Interface Inheritance (Basics)

as seen on Stack Overflow - Search for 'Stack Overflow'
Why does the following produce a compiler error: public interface OwnSession : ISession { } [...] OwnSession s = SessionFactory.OpenSession(); // compiler error (in german unfortunately) [...] "SessionFactory" returns a "ISession" on "OpenSession()" (NHibernate) >>> More