pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joe Conway <mail@joeconway.com>
To: Matthew T. OConnor <matthew@zeut.net>
Cc: Dave Page <dpage@vale-housing.co.uk>
Cc: Iavor Raytchev <iavor.raytchev@verysmall.org>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [HACKERS] pgaccess - where to store the own data
Date: Fri, 30 Aug 2002 11:12:28 -0700
Message-ID: <3D6FB58C.4010501@joeconway.com> (raw)
References: <03AF4E498C591348A42FC93DEA9661B8677C@mail.vale-housing.co.uk>
	<1030730363.13569.5.camel@zeutnull>

Matthew T. OConnor wrote:
> One thought is to use a completely separate database, but also allow it
> to be stored in the current database if the user wants it too.  This
> also solves the case of a user that can't create a new database for his
> admin tool (permissions etc...).  Also, it might be cleaner now that we
> have schemea support to create one pgadmin, or pgaccess schemea in the
> database, that handled all the others.
> 

As someone else mentioned (I think), even using a separate schema is not 
always an acceptable option. If you are using a "packaged" application 
(whether commercial or open source), you usually don't want *any* 
changes to the vendor provided database. Particularly with commercial 
software, that can mean loss of, or problems with, technical support, or 
problems when upgrading.

Joe




view thread (17+ messages)  latest in thread

Message-ID: <3D6FB58C.4010501@joeconway.com>
Permalink:  ../3D6FB58C.4010501@joeconway.com/
Also on:    postgresql.org/message-id/3D6FB58C.4010501@joeconway.com

 · 

reply

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-interfaces@postgresql.org
  Cc: mail@joeconway.com, matthew@zeut.net, dpage@vale-housing.co.uk, iavor.raytchev@verysmall.org, pgsql-hackers@postgresql.org
  Subject: Re: [HACKERS] pgaccess - where to store the own data
  In-Reply-To: <3D6FB58C.4010501@joeconway.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