From: Yasir Malik <ymalik@cs.stevens-tech.edu>
To: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Object-relational features
Date: Sat, 13 Mar 2004 12:30:02 -0500 (EST)
Message-ID: <Pine.NEB.4.58.0403131226530.13162@dab.cs.stevens-tech.edu> (raw)
Hello,
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.
Thanks,
Yasir
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: ymalik@cs.stevens-tech.edu
Subject: Re: Object-relational features
In-Reply-To: <Pine.NEB.4.58.0403131226530.13162@dab.cs.stevens-tech.edu>
* 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