Re: Revision Control in pgAdmin/PostgreSQL

[Dave Page]

> -----Original Message-----
> From: Douglas Bates [mailto:[EMAIL PROTECTED]] 
> Sent: 26 December 2001 19:33
> To: [EMAIL PROTECTED]
> Cc: Alan Zaslavsky; Saikat DebRoy; Deepayan Sarkar
> Subject: [pgadmin-support] Revision Control in pgAdmin/PostgreSQL
> 
> 
> I use pgadmin 1.1.72 to connect to a PostgreSQL 7.1.3 server 
> running on a Debian GNU/Linux 3.0 (testing) machine.
> 
> After connecting to the server and selecting a database, one 
> of the properties that is displayed is whether the database 
> has Revision Control.  On my server that is always "No".
> 
> The only place I have ever seen Revision Control for 
> PostgreSQL mentioned is in pgAdmin.  In 1.1.72 there are even 
> icons on the icon bar 1.1.72 that deal specifically with 
> revision control.  However, I have searched the documentation 
> for pgAdmin and for PostgreSQL and can find no mention of 
> Revision Control or how I would enable it.
> 
> Can anyone suggest where I could read about this?  I am very 
> interested in this capability.

Hi Douglas,

Currently there is no documentation for pgAdmin's revision control I'm
afraid. But...

The system is specific to pgAdmin, it is not part of PostgreSQL itself, of
pgAccess, phpPgAdmin or any other interface. It can be enabled in pgAdmin by
viewing the properties of a database, and checking the Revision Control
checkbox. When you then click OK, pgAdmin will create a revision control
table (pgadmin_rclog - normally hidden) in the database, and will scan all
the objects in the database and log the SQL that you normally see in the
definition pane in the main window.