Re: Object-relational features

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.