Re: Remote administration functionality

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Magnus Hagander" <mha(at)sollentuna(dot)net>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Remote administration functionality
Date: 2005-08-01 15:02:33
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4AC96AD@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> -----Original Message-----
> From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> Sent: 01 August 2005 15:36
> To: Magnus Hagander
> Cc: Dave Page; Tom Lane; PostgreSQL-development
> Subject: Re: [HACKERS] Remote administration functionality
>
> Uh, not sure why it would be harder. What system would be easier?
> Sure, file I/O works, but you can't even try to do that from psql.

In pgAdmin we would need to track all the changes the user makes to the
file, and generate all the appropriate insert, update and delete queries
to make the server match what the user wants. With file IO, we just let
the user edit, then send the resulting file in one select statement.

WRT to doing it in psql, the average psql user is probably the same
person that would prefer to use vi or emacs to do the job anyway.

/D

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2005-08-01 15:52:47 Re: Remote administration functionality
Previous Message Stephen Frost 2005-08-01 14:56:27 Re: Remote administration functionality