From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Yasir Malik <ymalik@cs.stevens-tech.edu>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: Object-relational features
Date: Mon, 15 Mar 2004 07:13:42 -0800 (PST)
Message-ID: <20040315071137.K65254@megazone.bigpanda.com> (raw)
In-Reply-To: <Pine.NEB.4.58.0403131226530.13162@dab.cs.stevens-tech.edu>
References: <Pine.NEB.4.58.0403131226530.13162@dab.cs.stevens-tech.edu>
On Sat, 13 Mar 2004, Yasir Malik wrote:
> For my object-relational database class I decided to use PostgreSQL
> because it is my favorite database and it calls it self a ORDBMS. Little
> did I know that it supports supports very little OR features. For
> example, using "create type as" is totally worthless because you can't use
> it as a field type in a table; you can't compose in another "create type
> as"; and you can't inherit another composite type. The only way to create
> a true type is to use "create type" and write C code as a shared object,
> so I'm basically doing everything C, which is not something I want to do.
> I've searched the mailing lists and have found little said about the OR
> features. Am I missing something here? Does PostgreSQL support OR
> features similar to Oracle 9i (which is what I'm forced to use). I really
> do not want to use Oracle because I have to switch over to my Windows
> partition, and Oracle takes about 100 MB of virtual memory on my 256 MB
> machine.
Generally speaking many of the OR portions of PostgreSQL have fallen by
the side for lack of alot of developer support. It generally needs
someone championing it who's willing to do some of the work and probably
take some lumps on -hackers trying to get stuff accepted.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone.bigpanda.com, ymalik@cs.stevens-tech.edu
Subject: Re: Object-relational features
In-Reply-To: <20040315071137.K65254@megazone.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox