Re: [SQL] Maintence DB

2007-03-13 Thread Greg Toombs
(From the pgadmin documentation) "The maintenance DB field is used to specify the initial database that pgAdmin connects to, and that will be expected to have the pgAgent schema and adminpack objects installed (both optional). On PostgreSQL 8.1 and above, the maintenance DB is normally called '

Re: [SQL] A form of inheritance with PostgreSQL

2007-03-12 Thread Greg Toombs
warning. Anyway, thanks for the heads-up. Alvaro Herrera wrote: Greg Toombs wrote: What disaster do you foresee? Is that version unstable? Yes. There are known, unfixed bugs, and architectural problems that cannot be fixed.

Re: [SQL] A form of inheritance with PostgreSQL

2007-03-12 Thread Greg Toombs
What disaster do you foresee? Is that version unstable? Tom Lane wrote: Greg Toombs <[EMAIL PROTECTED]> writes: After reading a few more methods of doing things, I went with the simplest one, as 1. time is of the essence, and 2. I'm stuck with PostgreSQL 7.1 on the se

Re: [SQL] A form of inheritance with PostgreSQL

2007-03-12 Thread Greg Toombs
AM 3/9/2007, [EMAIL PROTECTED] wrote: Date: Thu, 08 Mar 2007 13:01:51 -0500 From: Greg Toombs <[EMAIL PROTECTED]> To: pgsql-sql@postgresql.org Subject: A form of inheritance with PostgreSQL Message-ID: <[EMAIL PROTECTED]>  Hello. I'm trying

[SQL] A form of inheritance with PostgreSQL

2007-03-08 Thread Greg Toombs
Hello. I'm trying to figure out how to nicely implement a C++ class-like system with PostgreSQL. Consider the following: Tables Fruit, Apple, Orange I want to design the foreign key scheme such that there are relations between fruit and apple, and fruit and orange, that imply that apple is a