Re: [HACKERS] pgaccess - where to store the own data

2002-09-04 Thread Iavor Raytchev
Ross wrote: > I'm a bit late on this discussion, but I, for one, have liked > having > some of the pgaccess info stored with the database. That way, > no matter > what machine I connect to the DB from, I get the same set of > functions, > queries, and schema-documents. Very much true. A wiki p

Re: [HACKERS] pgaccess - where to store the own data

2002-09-04 Thread Ross J. Reedstrom
On Fri, Aug 30, 2002 at 02:43:38PM -0400, Matthew T. OConnor wrote: > > 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* > > chan

Re: [HACKERS] pgaccess - where to store the own data

2002-08-30 Thread Dave Page
> -Original Message- > From: Matthew T. OConnor [mailto:[EMAIL PROTECTED]] > Sent: 30 August 2002 18:59 > To: Dave Page > Cc: Iavor Raytchev; pgsql-hackers; pgsql-interfaces > Subject: Re: [HACKERS] pgaccess - where to store the own data > > > > > Wh

Re: [HACKERS] pgaccess - where to store the own data

2002-08-30 Thread Matthew T. OConnor
> 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

Re: [HACKERS] pgaccess - where to store the own data

2002-08-30 Thread Joe Conway
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

Re: [HACKERS] pgaccess - where to store the own data

2002-08-30 Thread Matthew T. OConnor
> > What do people think about this. Is it so bad that the own > > data is stored in the database pgaccess works with? > > pgAdmin II no longer uses such tables, but to get over the problem as > best I could, I added a cleanup option to pgAdmin I that removed all > server side objects in one go.

Re: [HACKERS] pgaccess - where to store the own data

2002-08-30 Thread Dave Page
> -Original Message- > From: Iavor Raytchev [mailto:[EMAIL PROTECTED]] > Sent: 30 August 2002 16:44 > To: pgsql-hackers; pgsql-interfaces > Subject: [HACKERS] pgaccess - where to store the own data > > > Hello everybody, > > There is an open que

[HACKERS] pgaccess - where to store the own data

2002-08-30 Thread Iavor Raytchev
Hello everybody, There is an open question we need broad opinion on. Currently pgaccess stores its own data in the database it works with. Some people do not like that. To store it elsewhere invokes a number of issues such as: - where is this somewhere - converting form all versions to the new