X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 448B6D1DB8D for ; Mon, 15 Mar 2004 15:13:41 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 53975-02 for ; Mon, 15 Mar 2004 11:13:43 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 452FAD1D82D for ; Mon, 15 Mar 2004 11:13:39 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id AC1E235634; Mon, 15 Mar 2004 07:13:42 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id AAA6D35631; Mon, 15 Mar 2004 07:13:42 -0800 (PST) Date: Mon, 15 Mar 2004 07:13:42 -0800 (PST) From: Stephan Szabo To: Yasir Malik Cc: PostgreSQL Subject: Re: Object-relational features In-Reply-To: Message-ID: <20040315071137.K65254@megazone.bigpanda.com> References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/159 X-Sequence-Number: 17258 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.