Revize 6daefa8c

import of old project

html/PostgresssAdmin/CREDITS

@@ +1 @@
+CREDITS
+-------
+
+Project Administration & Major Projects
+
+- Dan Wilson
+- Robert Treat
+- Christopher Kings-Lynne
+
+Translators
+
+- Angelo Rigo (Brazilan Portuguese)
+- Chan Min Wai (Chinese)
+- He Wei Ping (Chinese)
+- Chih-Hsin Lee (Trad. Chinese)
+- Hugo Jonker (Dutch)
+- Pascal Peyre (French)
+- H. Etzel, Markus Bertheau (German)
+- Kalef (Italian)
+- Tadashi Jokagi (Japanese)
+- Rafal Slubowski (Polish)
+- Alexander Khodorisky (Russian)
+- Martin Marqu?s (Spanish)
+- Andrej Misovic (Slovak)
+- Devrim Gunduz (Turkish)
+- Libor Vanek (Czech)
+- Stefan Malmqvist (Swedish)
+- Nicola Soranzo (Italian)
+- Petri Jooste (Afrikaans)
+- Sulyok P?ter (Hungarian)
+- Zaki Almuallim (Arabic)
+- Erdenemandal Bat-Erdene (Mongolian)
+- Alex Rootoff (Ukrainian)
+- Jonatan (Hebrew)
+- Alin Vaida (Romanian)
+- Arne Eckmann (Danish)
+- Francisco Cabrita (Portuguese)
+
+Look & Feel
+
+- Davey (CSS)
+
+Contributors
+
+- Felix Meinhold
+- Jean-Michel Poure
+- Rafal Slubowski
+- Brett Toolin
+- Mark Gibson (Pop-up SQL window)
+- Nicola Soranzo
+- Oliver Meyer & Sven Kiera (Table icons link to browse table)
+- Bryan Encina (SQL window improvements, bug fixes, admin)
+- Dan Boren (Object comments)
+- Adrian Nida (Fix time outs)
+- Russell Smith
+
+Third Party Libraries
+
+- Highlight.php (Jacob D. Cohen of rafb.net)
+- XLoadTree2 (Erik Arvidsson & Emil A Eklund of webfx.eae.net)
+
+Corporate Sponsors
+
+- SpikeSource (www.spikesource.com) - Slony support

html/PostgresssAdmin/DEVELOPERS

@@ +1 @@
+DEVELOPER INFO
+--------------
+
+ phpPgAdmin is Open Source, so you're invited to contribute to it.
+ Many great features have been written by other people and you too
+ can help to make phpPgAdmin a useful tool.
+ 
+ phpPgAdmin 3 has its roots in the phpPgAdmin 2.4 software.  A complete 
+ rewrite was necessary to support PostgreSQL 7.3 and to address problems
+ in the phpPgAdmin 2.4 codebase.
+ 
+ If you're planning to contribute source code, please read the following 
+ information:
+ 
+ The following method is preferred for new developers:
+  - fetch the current CVS tree over anonymous CVS:
+  
+    cvs -d :pserver:[e-mail]:/cvsroot/phppgadmin login
+    [Password: ]  simply press the Enter key!
+    
+    cvs -z3 -d :pserver:[e-mail]:/cvsroot/phppgadmin co -d phpPgAdmin webdb
+    [This will create a new sub-directory named phpPgAdmin] 
+    
+  - Add your stuff
+  - Send us the file(s) you've modified or send us a patch (preferred).  To generate a patch, do this
+    in your 'phpPgAdmin' directory:
+
+    	cvs diff -c > file.txt
+
+    Then, just send us the file.txt
+
+	Please note submitting code is considered a transfer of copyright to the phpPgAdmin project.
+
+  Only project developers can access the CVS tree via ssh and SSH1 must 
+  be installed on your client machine. 
+  
+  	export CVS_RSH=ssh
+  	
+  	login once with ssh to [e-mail] to create required
+  	user directories on the server.
+  	
+  	cvs -z3 -d [e-mail]:/cvsroot/phppgadmin co -d phpPgAdmin webdb
+  	
+  Write access to the CVS tree is granted only to developers who have already
+  contributed something useful to phpPgAdmin.  If you're interested in that, 
+  please contact us.                                  
+                                 
+TIPS FOR DEVELOPERS
+-------------------
+
+When you submit code to phpPgAdmin, we do expect it to adhere to the existing
+coding standards in the source.  So, instead of using your personal favourite
+code layout style, please format it to look like surrounding code.
+
+Test your code properly!  Say you are developing a feature to create domains.
+Try naming your domain all of the following:
+
+	* "
+	* '
+	* \
+	* words with spaces
+	* <br><br><br>
+
+If you are adding a new class function, be sure to use the "clean",
+"fieldClean", "arrayClean" and "fieldArrayClean" functions to properly escape
+odd characters in user input.  Examine existing functions that do similar
+things to yours to get yours right.
+
+When writing data to the display, you should always urlencode() variables in
+HREFs and htmlspecialchars() variables in forms.
+
+COMMON VARIABLES
+----------------
+
+$data - A data connection to the current or default database.
+$misc - Contains miscellaneous functions.  eg. printing headers and footers, etc.
+$lang - Global array containing translated strings.  The strings in this array have already
+        been converted to HTML, so you should not htmlspecialchars() them.
+$conf - Global array of configuration options.
+
+WORKING WITH RECORDSETS
+-----------------------
+
+phpPgAdmin uses the ADODB database library for all its database access.  We have
+also written our own wrapper around the ADODB library to make it more object
+oriented (ADODB_base.pclass).
+
+This is the general form for looping over a recordset:
+
+$rs = $class->getResults();
+if (is_object($rs) && $rs->recordCount() > 0) {
+	while (!$rs->EOF) {
+		echo $rs->f['field'];
+		$rs->moveNext();
+	}
+}
+else echo "No results.";
+

html/PostgresssAdmin/FAQ

@@ +1 @@
+phpPgAdmin Frequently Asked Questions
+-------------------------------------
+
+Installation errors
+-------------------
+
+Q: I've installed phpPgAdmin but when I try to use it I get an error message
+   telling me that I have not compiled proper database support into my
+   PHP installation. 
+
+A: This means that you have not properly compiled PostgreSQL support into
+   your PHP. The correct configure flag to use is '--with-pgsql'.  Read the
+   PHP manual and website for more help with this.
+
+   PostgreSQL support can be also compiled into PHP as a dynamic extension, 
+   so if you have precompiled version (Linux RPM, or Windows binary), there 
+   are still chances, that only thing you should do is to enable loading it
+   automagically.
+
+   It can be done by editing your php.ini file (under Windows, usually in 
+   C:\WINDOWS or C:\WINNT, under Linux /etc/php.ini) and uncommenting this 
+   line:
+
+        ;extension=php_pgsql.dll	;under Windows
+	;extension=pgsql.so		;under Linux
+
+   so it would look like that:
+   	
+        extension=php_pgsql.dll		;under Windows
+	extension=pgsql.so		;under Linux
+
+   In Linux distributions based on Red Hat or Fedora, PHP extensions are
+   automatically configured in /etc/php.d/pgsql.ini, simply install the
+   php-pgsql package.
+
+
+Q: I get a warning like this when using phpPgAdmin on Windows: 
+
+    "Warning: session_start() [function.session-start]:
+     open(/tmp\sess_5a401ef1e67fb7a176a95236116fe348, O_RDWR) failed"
+
+A: You need to edit your PHP.INI file (usually in c:\windows) and change this
+   line:
+
+    session.save_path = "/tmp"
+
+   to:
+   
+    session.save_path = "c:\windows\temp"
+
+   And make sure that the folder c:\windows\temp actually exists.
+
+
+Login errors
+------------
+
+Q: I always get "Login failed" even though I'm _sure_ I'm using the right
+   username and password.
+
+A: Check the PostgreSQL log on your server, it will give the exact reason
+   why the login is failing.  Edit the pg_hba.conf file in your PostgreSQL
+   data dir and make sure you have enabled access to the server properly.
+
+   If you've installed phpPgAdmin on a computer different from the PostgreSQL
+   server, another likely reason may be that you have not started the
+   PostgreSQL server with TCP/IP sockets enabled. To enable this, edit your
+   postgresql.conf file and change this line:
+
+   	#tcpip_socket = false
+
+   to:
+
+   	tcpip_socket = true
+
+   and then restart PostgreSQL.
+
+Q: For some users I get a "Login disallowed for security" message.
+
+A: Logins via phpPgAdmin with no password or certain usernames (pgsql,
+   postgres, root, administrator) are denied by default. Before changing this
+   behaviour (setting $conf['extra_login_security'] to false in the
+   config.inc.php file) please read the PostgreSQL documentation about client
+   authentication and understand how to change PostgreSQL's pg_hba.conf to
+   enable passworded local connections.
+
+Q: I can use any password to log in!
+
+A: PostgreSQL, by default, runs in trust mode.  That means that it doesn't
+   ask for passwords for local connections.  We highly recommend that you
+   edit your pg_hba.conf file, and change the login type to 'md5'.  Note
+   that if you change the 'local' login type to 'md5', then you might need
+   to enter a password to start PostgreSQL.  Get around this by using a
+   .pgpass file - explained in the PostgreSQL documentation.
+
+
+Other errors
+------------
+
+Q: When I enter non-ASCII data into the database via a form, it's inserted
+   as hexadecimal or Ӓ format!
+
+A: You have not created your database in the correct encoding.  This problem
+   will occur when you try to enter an umlaut into an SQL_ASCII database, or
+   SJIS Japanese into an EUC-JP database, etc.
+
+Q: When I drop and re-create a table with the same name, it fails.
+
+A: You need to drop the sequence attached to the SERIAL column of the table
+   as well.  PostgreSQL 7.3 and above do this automatically.  If you have
+   upgraded to PostgreSQL 7.3 from an earlier version, you need to run the
+   contrib/adddepend script to record all dependencies.
+
+Q: When browsing a table, the 'edit' and 'delete' links do not appear.
+
+A: In order, phpPgAdmin will prefer the following as unique row identifiers:
+
+	1. Primary keys
+	2. Unique keys (cannot be parital or expressional indexes)
+	3. OID column (will require a sequential scan to update, unless you 
+	   index the OID column)
+
+   Furthermore, any NULL values in the unique index will mean that that row
+   will be uneditable.  Also, since OIDs can become duplicated in a table,
+   phpPgAdmin will alter the row, and then check to ensure that exactly one
+   row has been modified - otherwise rollback will occur.
+
+
+Questions on dumps
+------------------
+
+Q: What happened to the database dump feature?
+
+A: You need to configure phpPgAdmin (in the config.inc.php file) to point
+   to the location of the pg_dump and pg_dumpall utilities on your server.
+   Once you have done that, the database export feature will appear.
+
+Q: I would like to use the pg_dump integration for database and table
+dumps on Windows. How do I get pg_dump.exe on Windows?
+
+A: To get the pg_dump utilities on Windows, you need to install PostgreSQL 8.0
+   for Windows. It is available for download at
+   http://www.postgresql.org/ftp/win32/ .
+   Once you have installed that, set the pg_dump and pg_dumpall locations
+   in the config.inc.php file to
+   'C:\\Program Files\\PostgreSQL\\8.0\\bin\\pg_dump.exe' and
+   'C:\\Program Files\\PostgreSQL\\8.0\\bin\\pg_dumpall.exe', or wherever you
+   installed them.
+
+Q: Why can't I reload the SQL script I dumped in the SQL window?
+
+A: The following limitations currently exist in SQL script execution:
+
+	* Only uploaded SQL scripts can contain COPY commands and for
+	  this to work, you must have PHP 4.2 or higher.
+
+	* 'psql' commands such as '\connect' will not work at all.
+
+	* Multiline SQL statements will not work, eg:
+
+		CREATE TABLE example (
+			a INTEGER
+		);
+
+	* You cannot change the current database or current user during
+	  the execution of the script.
+
+   We do intend to work on some of these limitations in the future, but
+   some of them are PostgreSQL restrictions and we recommend using the
+   'psql' utility to restore your full SQL dumps.
+
+
+Other questions
+---------------
+
+Q: When inserting a row, what is does the 'Value' or 'Expression' box mean?
+
+A: Choosing 'Expression' means that you can use functions, operators, other 
+   field names, etc. in your value - you need to properly quote any literal 
+   values yourself.  'Value' on the other hand, means that no matter what you
+   enter as the value, it will be inserted as-is into the database.
+
+Q: Why is there never any information on the 'Info' page of a table?
+
+A: The Info page will show you what other tables have foreign keys to the
+   current table and some data from the PostgreSQL statistics collector.
+   The stats collector is not enabled by default in PostgreSQL.  To enable
+   it, look in your postgresql.conf file for the stats_* options.  Just
+   make them all 'true' and restart PostgreSQL.
+
+Q: Why can't I download data from queries executed in the SQL window?
+
+A: You need to check the 'Paginate results' option to allow downloads.
+
+Q: I would like to help out with the development of phpPgAdmin. How should I
+   proceed?
+   
+A: We really would like your help! Please read the DEVELOPERS and TRANSLATORS
+   files.
+

html/PostgresssAdmin/HISTORY

@@ +1 @@
+phpPgAdmin History
+------------------
+
+Version 4.0.1
+-------------
+
+Bugs
+* Fix major bug in non-english translations where HTML unicode entities
+  caused failure in the object browser tree.  Fixed by instead encoding
+  all entities as numeric (ŗ) instead of named (é).
+* Fix issue with includes where '.' is not in the include_path
+* Don't prompt to share credentials when only one server is present
+* Fix logout link
+* Preserve expanded/collapsed across result pages
+* Use pg_clientencoding() if pg_client_encoding() does not exist.  If
+  pg_clientencoding() itself doesn't exist, then force setting the encoding
+
+Version 4.0
+-----------
+
+Features
+* Slony replication support (Thanks to sponsorship from SpikeSource)
+* Allow current database to be at the top
+* Allow base URL of PostgreSQL documentation to be configured
+* Allow variable size textarea when editing values (Juergen Weigert)
+* Allow SQL script upload to parse arbitrary SQL, including multiline
+  SQL statements.  Improve output to show every command as its executed
+  and SELECT results.
+* Add rudimentary support for PostgreSQL 8.1 and 8.2
+* primary key and unique key at table creation (Andreas Huber)
+* Add row|statement level options to create trigger for >= 7.4 (Robert Treat)
+* Allow altering name (for >= 7.4) and owner (for >= 8.0) of a database (Bryan Encina)
+* Allow login to several servers simultaneously
+* Rearrange frame layout to suit multi-server support
+* New browser tree with dynamically loading branches
+  (Using XLoadTree2 from http://webfx.eae.net/)
+* Allow language change from the intro page at any time
+* Avoid getting and setting encoding queries if possible
+* Avoid version query in PHP 5 / PostgreSQL 7.4+
+* Avoid query for superuser status in PHP 5 / PostgreSQL 7.4+
+* Put PostgreSQL 7.4+ in read only mode for pagination of results
+  to avoid executing selects that have write side effects.
+* Allow re-using username and password for all servers - saves re-entering
+  username and password for every server in a pool.
+* Make default language 'auto' indicating auto detect.  If a language is
+  deliberately specifed, then that will always be used and no detection will
+  occur.
+* ADOdb library updated to version 4.65
+  
+Bugs
+* Tree Icons are displayed middle instead of top
+* Ensure login frame is always at top level (Russell Smith)
+* Fix non-ASCII characters inserted in Unicode databases as HTML entities with
+ non-UTF8 web servers (Markus Bertheau)
+* Fix export to work with release candidates and beta releases as well as finals
+ (Russell Smith)
+* Fix port selection for local connections
+* Fix timeouts on long running operations (Adrian Nida)
+* Allow Multiline character and character varying editing and inserting
+* Add automatic browser language selection for all languages
+* Stop duplicate insert on re-POST of data
+* Fix bug with exporting schema for servers < 7.3
+* Fix opclasses on 7.2 and below
+* Fix listing of opaque functions in 7.2
+* Actually fix PHP 4.4.0's new strict references
+
+Translations
+* Japanese from Tadashi Jokagi
+* Danish from Arne Eckmann
+* Arabic from Zaki
+* Romanian from Alin
+* Afrikaans from Petri
+* Polish from Rafal (utf-8 encoding)
+* Slovak from Andrej
+* German from Markus
+* Spanish From Martin
+* Hungarian from Sulyok
+* Turkish from Devrim
+
+Version 3.5.6
+-------------
+
+Bugs
+* Actually fix PHP 4.4.0's new strict references
+
+Version 3.5.5
+-------------
+
+Bugs
+* Fix for PHP 4.4.0's new strict references
+* Small improvement to Opera browser detection in the tree
+* Fix listing of opaque functions in 7.2
+* Fix listing of opclasses and functions pre 7.3
+
+Version 3.5.4
+-------------
+
+Bugs
+* Fix security hole in include() of language file:
+   http://secunia.com/advisories/15941/
+  Check now requires that the language filename be in the list
+  of known allowed filenames.
+* Fix that functions returning cstring were not being listed
+* Make parsing of PostgreSQL 1-dimensional arrays correct.  Makes
+  named function parameter use more reliable.
+* Fix downloading of the results of multiline queries.
+
+Version 3.5.3
+-------------
+
+Bugs
+* Fix using schema enabled dump on non-schema enabled backend
+* Don't try setting no timeout when in safe mode
+* Reload browser after executing arbitrary SQL
+* Fix browser in RTL languages
+* Fix inability to drop database using the drop link
+* Fix last internal oid value for PostgreSQL 8.0
+* Fix (again) dumping on v8 for windows, exclude dumping some objects.
+
+Translations
+* Portuguese from Francisco
+
+Version 3.5.2
+-------------
+
+Bugs
+* Fix export to work with release candidates and beta releases as well as finals
+ (Russell Smith)
+* Fix port selection for local connections (Russell Smith)
+* Fix timeouts on long running operations (Adrian Nida)
+* Allow Multiline character and character varying editing and inserting
+* Do browser language detection for all languages
+
+Translations
+* Japanese from Tadashi
+* Danish from Arne
+
+Version 3.5.1
+-------------
+
+Bugs
+* Support 8.0beta5 schema tablespace changes
+* Help link fixes
+* Estimated row count in 7.0 and 7.1 fixes
+* Priviliges nav fix
+* Function privileges fix
+* Search path fix
+* pg_dump on win32 8.0 native fix
+
+Translations
+* Romanian from Alin
+* Italian updates from Nicola
+
+Version 3.5
+-----------
+
+Features
+* Context-sensitive online help system
+* Use language preferencies from browser (Markus Bertheau, Nicola Soranzo)
+* Tablespace support for 8.0
+* Support cancelling backend processes in 8.0
+* Allow setting privileges on databases
+* Allow setting schema search path in SQL window
+* Allow filtering find results by object type
+* Show function arguments in find results
+* Support 8.0's named function arguments
+* "Sticky" navigation.  phpPgAdmin will now remember while tab you are
+  looking at (eg. 'Indexes') when you change which table you are viewing.
+* New fast navigation bar.  A breadcrumb style navigation bar for fast
+  jumping between areas.
+* Much improved grant/revoke feature
+* Allow creating and viewing composite types
+* pg_dumpall integration.  Now you can download the entire cluster via
+  phpPgAdmin.
+* Show line numbers when viewing functions
+* Syntax highlighting for PL/SQL, PL/PgSQL, PL/PHP, PL/Ruby, PL/Java, 
+  PL/J, PL/Python and PL/Perl functions, thanks to Jacob D. Cohen's
+  BSD-licensed highlighting code on rafb.net
+* Add page navigation links at the bottom as well as the top of the page
+  when browsing results.
+* Support for 8.0's alter column type
+* Support for 8.0's add columns with defaults and not null
+
+Translations
+* Romanian from Alin
+* Arabic from Zaki
+* Japanese from Tadashi
+* Spanish from Robert & Martin
+* Mongolian from Erdenemandal
+* Ukrainian from Alex Rootoff
+* Hebrew from jonatan
+* Hungarian from Sulyok
+* French from Pascal
+* Afrikaans from Petri
+* Turkish from Devrim
+* Slovak from Andrej
+* German from Markus
+* Italian from Nicola
+* Polish from Rafal
+
+Bugs
+* Fix that non-Auto mode import didn't work (Adrian Nida)
+* Fix inability to drop constraints when using a non-english translation
+* Work around MSIE's failure to handle downloads in SSL mode
+* Allow insert, update, delete, references and trigger to be granted
+  and revoked on views.
+
+Version 3.4.1
+-------------
+
+Bugs
+* Fix export of mixed case tables pre 7.4
+* Fix table export problems pre 7.3
+* Fix join clause created by view wizard for pre 7.3
+* Fix reindex of mixed case indexes
+* Show domains in type lists in appropriate places
+* Fix for multiline CDATA parsing in XML import
+* Fix missing _schema notice in reports
+
+Version 3.4
+-----------
+
+Features
+* Add CACHE and CYCLE parameters in sequence creation
+* View, add, edit and delete comments on tables, views, schemas, 
+  aggregates, conversions, operators, functions, types,
+  opclasses, sequences and columns (Dan Boren & ChrisKL)
+* Add config file option for turning off the display of comments
+* Allow creating array columns in tables
+* Allow adding array columns to tables
+* Allow creating domains with type length and arrays
+* Show domain base type and comment in domains list
+* Allow import of CSV, Tabbed and XML data.  "Auto" mode chooses
+  import mode based on the file extension.
+* Allow upload and execution of _basic_ SQL scripts
+* More admin features available: vacuum, analyze, cluster all and reindex
+  (with all options) (Bryan Encina)
+* Fix SQL popup window to reload when the database is changed so
+  that the correct page encoding is used.
+* Create view wizard (Bryan Encina)
+* Allow specification of MATCH, DEFERRABLE and INITIALLY DEFERRED on
+  foreign keys.
+* Automatically uncheck the NULL checkbox when data is typed in the value
+  field while editing data.
+* Show query runtime when executing arbitrary SQL
+* Allow renaming functions when backend supports it
+* Views are now more like tables.  They are listed in the browser,
+  you can view the virtual columns of the view and its column defaults.
+  Columns in view can also be renamed and have defaults set.
+* Allow viewing, dropping and creation of rules on views.
+* Support for 8.0-dev ALTER COLUMN TYPE, adding of SERIAL and BIGSERIAL
+  columns, adding NOT NULL columns and adding columns with defaults.
+
+Bugs
+* Fix pg_dump output for PostgreSQL 7.0.x and 7.1.x
+* In 7.4 pg_dump, specify schema when dumping tables
+* Fix bug in displaying array types in 7.0.x
+* Fix bug where views appeared as tables in 7.0.x search results
+* Fix bug where find object SQL on < 7.2 was broken
+* Fix Find for domain constraints
+* Fix popup SQL window so that two different phpPgAdmin instances should
+  not want to use the same pop-up.
+* Fix create table if you don't supply as many fields as you originally
+  specified.
+* Fix schema support for views
+
+Translations
+* Trad. Chinese from Chih-Hsin Lee
+* Italian from Nicola
+* Spanish from Martin
+* Slovak from Andrej
+* German from Markus
+* Turkish from Devrim
+* Hungarian from Sulyok
+* French from Pascal
+* Polish from Rafal
+* Russian from Alex
+
+Version 3.3.1
+-------------
+
+Bugs
+* Fix table stats for <= 7.2
+
+Translations
+* Spanish from Martin
+
+Version 3.3
+-----------
+
+Features
+* Database dump feature, which uses pg_dump
+* Large speed improvements by reducing number of database
+  connections and using external style sheet.
+* SQL pop-up window now defaults to the current database
+* Display aggregates and operator classes
+* Integration with the PostgreSQL statistics collector.  See
+  table and index performance and usage information.
+* Display user session defaults for PostgreSQL >= 7.3
+* Rename user feature for PostgreSQL >= 7.4
+* Create functions returning arrays and table types
+* Allow editing Select results by oid
+* Allow pagination of queries entered in the SQL box
+* Allow EXPLAIN ANALYZE of SQL queries (in both SQL boxes)
+* Default cursor conveniently in SQL box and Find
+
+Bugs
+* Object browser fixed for databases with no schemas
+* Properly detect that reports database is missing
+* Fix for alter column on PostgreSQL 7.1
+* phpPgAdmin now works without '.' in the include_path
+* Can now remove expire dates on user accounts
+* Properties of mixed case named views work in 7.4
+
+Translations
+* Spanish from Martin Marques
+* Japanese from Tadashi Jokagi
+* Swedish from Stefan Malmqvist
+* Slovak from Andrej Misovik
+* Hungarian from Sulyok Peter
+* Trad. Chinese from Chih-Hsin Lee
+* Italian from Nicola Soranzo
+* Afrikaans from Petri Jooste
+* Turkish from Devrim Gunduz
+* German from Markus Bertheau
+* Czech from Libor Vanek
+* Russian from Alex Khodorivsky
+
+Version 3.2.1
+-------------
+
+Bugs
+* Trailing newline problem in chinese-sim translation fixed
+
+Translations
+* French from Pascal
+* Russian from Step
+
+Version 3.2
+-----------
+
+Features
+* PostgreSQL 8.0 CVS support
+* Option to dump table structure, data or structure and data
+* Set datestyle and extra_float_digits when dumping data
+* Results of table browse, table select, view browsing and report browsing
+  can now ALL be sorted by column
+* Result rows of table selects can now be edited and deleted
+* Extra login security to prevent logging into servers as postgres and
+  no password - a VERY common newbie error.
+* Cluster indexes and indexed constraints (with analyze)
+* Display clustered status of indexes and indexed constraints
+* Table info - shows tables that reference the table, parent tables,
+  and child tables.
+* Choice of operator when performing a Select
+* 'Select All' feature of table selects now available on view
+  selects.
+* Removed any trace of MySQL support
+* Show casts
+* Show conversions
+* Show languages
+* Make table icon link to browse table
+* New show_advanced option that allows the hiding or display of
+  "advanced" objects such as conversions, types, operators, casts and
+  languages.
+* Find Object feature can now find conversions, languages, domains,
+  constraints, indexes, rules and triggers.
+* Better language Makefile for translators
+* The SQL box now remembers your query when you click 'Back'.
+
+Bugs
+* Added legal DOCTYPE
+* Allow creating foreign keys to tables not in current schema
+* Always add brackets around CHECK () constraints
+* Never display an index in both Indexes and Constraints
+* BIGSERIAL missing from PostgreSQL 7.2
+* Types lengths (eg. varchar(255)) weren't being displayed properly
+  in PostgreSQL 7.0.x
+* Resetting sequence on 7.1+ now restarts at 1, not 2
+* Remove deprecated column default 'now' from SQL script
+* Properly escape pg_ in internal queries
+
+Translations
+* Afrikaans from Petri Jooste
+* Hungarian from Sulyok P?ter
+* German update from Markus Bertheau
+* Trad. Chinese from Chih-Hsin Lee
+* Hungarian from Peti 
+* Spanish update from Martin Marques
+* Slovak update from Andrej Misovic
+* Turkish update from Devrim
+* Swedish update from Stefan
+* Italian update from Nicola
+
+Version 3.1
+-----------
+
+Bug Fixes:
+* Table browsing for 7.4 fixed
+* Synch script for translators disabled due to bugginess.  If you want
+  to use it, just comment out the warning lines from the script itself.
+* Change HTML download to XHTML and make it a 100% conforming document, with DTD
+* Alter XML format to allow future features
+
+Translations:
+* Trad. Chinese
+* Dutch
+* Spanish
+* Swedish
+* Turkish
+* French
+* Japanese
+
+Version 3.1-rc-1
+----------------
+
+Bug Fixes
+* Table browsing for != 7.3
+* SQL window improvements
+* Translation improvements
+
+Version 3.1-beta-1
+------------------
+
+Features:
+* Add first & last links to nav.  Double number of pages shown.
+* Allow granting privileges WITH GRANT OPTION for 7.4
+* Allow revoking GRANT OPTION with CASCADE option for 7.4
+* Display new PostgreSQL 7.4 grant options and grantor in privileges
+* Find object feature
+* Support for domains in 7.3 and domain constraints and alter domain in 7.4
+* Add/drop users to/from groups
+* Alter (rename) triggers
+* Pop-up SQL window from Mark Gibson
+* Superusers can always see all databases
+* Default database encoding for languages
+* Convert our images to PNG format
+* Allow creating tables WITHOUT OIDS
+* Show boolean values as TRUE or FALSE when viewing data
+* Allow renaming table and changing table owner
+* Refresh feature on table browse
+* Support better formatted view dumps in 7.4
+* When browsing data, numeric types are aligned right
+* Ability to create unique and partial indexes
+* View and edit table comments
+* Changed XML format significantly.  Now doesn't use field names as
+  tag names, outputs column type information, and is in correct XML format!
+* Save result sets as views and reports in most cases 
+* Download the results of selects and reports
+* Tick all box on Select feature
+* Export in HTML format
+* Allow listing of operators
+* Add a robots.txt file to prevent search engine indexation
+* Can now safely edit row based on OID.  Guards are in place against duplicate OIDs.
+* Works properly if you have cookies disabled
+
+Bug Fixes:
+* Lots of NULL value in table dump fixes (XML format changed slightly)
+* Boolean default values and general boolean field handling fixes
+* Support zero column tables
+* Correctly display the contents of bytea fields
+* Consider information_schema to be a system object
+* Remember fields if index creation fails
+* Fix saving and loading function volatility
+* Don't list domains under types
+* Lots of reports fixes (titles, page reloads, etc.)
+* Selecting for NULL values in Select feature
+
+Translations:
+* Italian translation update from Nicola Soranzo
+* German update from Markus Bertheau
+* Spanish update from Martin Marques
+* Trad. Chinese update from Chih-Hsin Lee
+* Russian update from Step
+* Slovak update from Andrej
+* Polish update from Rafal
+* Swedish translation from Stefan Malqvist
+* Turkish update from Devrim Gunduz
+* German update from Markus Bertheau
+* Traditional Chinese update from Chih-Hsin Lee
+* Spanish update from Martin
+
+Version 3.0.1
+-------------
+
+Bug Fixes
+* Lots of NULL value in table dump fixes (XML format changed slightly)
+* Support zero column tables
+* Correctly display the contents of bytea fields
+* Error in ADODB_base.php
+* Fix saving and loading function volatility
+* Don't list domains under types
+
+Version 3.0
+-----------
+
+* German update from Markus Bertheau
+* Russian update from Alexander Khodorivsky
+
+Version 3.0-rc-2
+----------------
+
+* Slovak update from Andrej Misovic
+* Japanese update from Tadashi Jokagi
+* Added 'defaultdb' per-connection variable
+  for installations where connection to template1
+  is disabled.
+* Removed uses of call time pass by reference,
+  since it is a deprecated feature of PHP. 
+
+Version 3.0-rc-1
+----------------
+
+* Fix drop database reload browser bug
+* Look & Feel upgrade from Davey
+* Value & expression on edit row
+* Chinese update from Chih-Hsin Lee 
+* Fixed support for functions and sequences
+  containing bizarre characters
+
+Version 3.0-beta-1
+-------------------
+
+* Cascade drop on columns and constraints
+* Czech translation
+* Preserve spaces when displaying data
+* Greatly improved PostgreSQL 7.2, 7.1 and 7.0 support
+* Italian translation
+* Show database version in top bar 
+* Many features useful for PostgreSQL hosting:
+	- Hide reports
+	- Filter for owned reports
+	- Hide admin for non-super users
+	- Easy for a user to change their own password
+	- Enforceable minimum password length
+* Switched to PEAR's HTML_TreeMenu to avoid license issue
+* Function editor can handle setof functions, and all
+  function properties for volatility, etc.
+* Manage permissions on functions
+* Massive table browsing improvements:
+	- Sort ascending and descending by clicking
+	  on field name
+	- Trim long strings.  Use 'expand' and 'collapse' to
+	  see full strings or trimmed strings.
+* Revoke on objects.  Grant or revoke to multiple groups
+  and users at once.
+* Brazilian Portuguese translation from Angelo Rigo
+
+Version 3.0.0-dev-4
+-------------------
+
+* Sort on a column when browsing a table
+* Slovak translation
+* Turkish translation
+* German translation
+* Reload browser after create/drop of database, schemas and tables
+* Select on views
+* Add foreign key constraint, with actions
+* Cascade drop on all objects
+
+Version 3.0.0-dev-3
+-------------------
+
+* French translation
+* Russian translations
+* Japanese translations
+* Trigger definitions
+* ADODB upgrade
+* Allow editing of non-null unique
+
+Version 3.0.0-dev-2
+-------------------
+
+* Language files now use an array of strings
+* Almost complete Chinese translation
+* Create sequence
+* Create trigger
+* Create index
+* Add check constraint
+* Lots of small fixes
+* Add column
+
+Version 3.0.0-dev-1
+-------------------
+
+* Renamed to phpPgAdmin from WebDB
+* Heaps of other stuff
+
+Version 0.6 - 24-Dec-2002
+-------------------------
+
+* Support short_tags off
+* Fix browsing tables, pagination, etc.
+* Fix all error handling
+* Fix problems with apostrophes in database, usernames or passwords
+
+Version 0.5 - 20-Dec-2002
+-------------------------
+
+* Initial public release
+* Still many problems making it unsuitable for production.
+
+Version 0.1 - Early 2002
+------------------------
+
+* Initial development version
+

html/PostgresssAdmin/INSTALL

@@ +1 @@
+phpPgAdmin Installation Guide
+-----------------------------
+
+1. Unpack your download
+
+   If you've downloaded a tar.gz package, execute from a terminal:
+
+   gunzip phpPgAdmin-*.tar.gz
+   tar -xvf phpPgAdmin-*.tar
+
+   Else, if you've downloaded a tar.bz2 package, execute from a terminal: 
+
+   bunzip2 phpPgAdmin-*.tar.bz2
+   tar -xvf phpPgAdmin-*.tar
+
+   Else, if you've downloaded a zip package, execute from a terminal:
+
+   unzip phpPgAdmin-*.zip
+
+2. Configure phpPgAdmin
+
+   edit phpPgAdmin/conf/config.inc.php
+
+   If you mess up the configuration file, you can recover it from the
+   config.inc.php-dist file.
+
+3. Set up the reports database.
+
+   If you want to enable reports (which are a useful feature) then go to
+   the 'sql' subdirectory and view the SQL script for your database.  It
+   will contain instructions on how to set up the reports database.
+
+4. If you run your PHP installation in safe mode, in order that the database
+   dump feature can work correctly, you need to set the 'safe_mode_allowed_env_vars'
+   php.ini variable to include the PGPASSWORD and PGUSER environmental variables
+   and the safe_mode_exec_dir to include /usr/bin (or wherever the pg_dump
+   binaries are found).
+   
+   	eg. safe_mode_allowed_env_vars = PHP_,PG
+   	    safe_mode_exec_dir = /usr/bin
+   
+   Given that you usually don't want to allow everything in /usr/bin to
+   be executed, you might want to copy the pg_dump and pg_dumpall utilities
+   to a directory by themselves.
+   
+   Also, you will need to ensure that your 'pg_dump' and 'pg_dumpall' utilities
+   are executable by the PHP process, if you want dump support in phpPgAdmin.
+
+   Lastly, if you run phpPgAdmin in safe mode, very long running imports,
+   exports and transactions may time out and be aborted.
+
+5. Enable the statistics collector in PostgreSQL.  phpPgAdmin will display
+   table and index performance and usage statistics if you have enabled the
+   PostgreSQL statistics collector.  To enable the collector, uncomment the
+   following lines in your postgresql.conf and enable them:
+
+   	stats_start_collector = true
+	stats_command_string = true
+	stats_block_level = true
+	stats_row_level = true
+
+6. Browse to the phpPgAdmin installation using a web browser.  You might
+   need cookies enabled for phpPgAdmin to work.
+
+7. IMPORTANT - SECURITY
+
+   PostgreSQL by default does not require you to use a password to log in.
+   We STRONGLY recomment that you enable md5 passwords for local connections
+   in your pg_hba.conf, and set a password for the default superuser account.
+
+   Due to the large number of phpPgAdmin installations that have not set
+   passwords on local connections, there is now a configuration file
+   option called 'extra_login_security', which is TRUE by default.  While
+   this option is enabled, you will be unable to log in to phpPgAdmin as
+   the 'root', 'administrator', 'pgsql' or 'postgres' users and empty passwords
+   will not work.
+   
+   Once you are certain you have properly secured your database server, you
+   can then disable 'extra_login_security' so that you can log in as your
+   database administrator using the administrator password.

html/PostgresssAdmin/LICENSE

@@ +1 @@
+Copyright (c) 2002, 2003 The phpPgAdmin Project
+
+This program is free software; you can redistribute it and/or modify
+it under the terms of the GNU General Public License as published by
+the Free Software Foundation; either version 2 of the License, or
+(at your option) any later version.
+This program is distributed in the hope that it will be useful,
+but WITHOUT ANY WARRANTY; without even the implied warranty of
+MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+GNU General Public License <http://www.opensource.org/gpl-license.html>
+for more details.
+

html/PostgresssAdmin/TODO

@@ +1 @@
+PHPPGADMIN TODO LIST FOR DEVELOPERS
+-----------------------------------
+
+phpPgAdmin is an open source project which means that if you see something on 
+this list that you would like to implement, just send us a patch.  You can find
+our project page here:
+
+	http://sourceforge.net/projects/phppgadmin/
+
+An item is marked 'claimed' when a username in brackets is put after the TODO
+item.
+
+An item is marked with a '-' if it has been completed.
+
+Export
+------
+
+* Switch to SPARQL format:
+  http://www.w3.org/TR/2005/WD-rdf-sparql-XMLres-20050801/
+
+  Actually...SQL/XML is maybe better.
+
+Misc
+----
+
+* Support 8.1 standard compliant strings (E'')
+
+Users
+-----
+
+* 7.3 user variables (eg. ALTER USER SET .. TO ...)
+
+Groups
+------
+
+Roles
+-----
+
+* Support for 8.1 roles (removing users and groups)
+
+Permissions
+-----------
+
+* Grant ... on all tables, views, ... to user, group, public
+
+Databases
+---------
+
+* Add alter database variables for 7.3+
+* Comments on Create and Alter database
+
+Schemas (7.3)
+-------------
+
+* Rename
+* Alter owner
+* Alter ... SET SCHEMA support
+
+Large Objects
+-------------
+
+* Add support for large objects
+
+Tables
+------
+
+* Allow PK and UNIQUE and FKs during create table
+* Vacuum & analyze individual tables
+* When adding a column or creating a table, prevent size on non-size types (eg. integer(2)).  You can find these by looking at format_type in the postgresql source code.
+* When browsing a table, clicking on a FK value should jump to the
+  PK row.
+* When editing a table, turn FK columns into drop-downs based on estimated
+  rows in the foreign table?
+* Auto-select 'WITHOUT OIDS' if 'default_with_oids' setting is false
+
+Views
+-----
+
+* Allow INSERT and import on views with the appropriate rules.
+
+Sequences
+---------
+
+* Alter sequence
+* setval & nextval
+
+Functions
+---------
+
+* Support 8.1 IN, OUT and INOUT parameters.
+* Display owner
+* Alter owner
+
+Indexes 
+-------
+
+* Expressional indexes
+
+Types
+-----
+
+Operators
+---------
+
+* Create
+
+Operator Classes
+----------------
+
+* Create
+
+Triggers
+--------
+
+* Allow functions from other schemas.
+* Support ENABLE/DISABLE trigger in 8.1
+
+Aggregates
+----------
+
+* Properties
+* Drop
+* Create
+
+Languages
+---------
+
+* Drop
+* Create
+
+Domains (7.3)
+-------------
+
+Conversions (7.3)
+-----------------
+
+* Properties
+* Drop
+* Create
+
+Casts (7.3)
+-----------
+
+* Properties
+* Drop
+* Create
+
+Miscellaneous
+-------------
+
+* Allow management of built-in autovacuum in 8.1
+* Put a 'What's blocking this query' on Processes view
+* Show locks on database view
+* Show NOTICES on queries in SQL window/file
+* Add sslmode to connection variables
+* Printable view of things
+* Show comments for all objects (Dan Boren)
+* Allow setting/dropping comments for all objects (Dan Boren)
+* Show owner for all objects
+* Allow changing owner for objects that have this feature (7.4+ generally)
+* Translated FAQ
+* Icons for all objects, for use in navigation widgets
+
+Exotic
+------
+
+* Support contrib/tsearch2 for easy full text indexes
+* Pivot reports (ADODB has a feature for this)
+* Parameterized reports (use prepared queries)
+* Full web accessability conformance
+
+Principles
+----------
+
+* register_globals off support
+* maximum error_reporting support - enforces code quality, reduces bugs and 
+  improves security
+* PHP 4.2 features used
+* No HTML font, colour, layout tags.  Use CSS for everything
+* One day we should make it all XHTML
+* everything properly escaped - prevent sql injection and cross-site scripting 
+  probs
+* Support Postgres 7.0 and upwards
+* psql -E is a cool way of seeing how to do schema queries
+* Checking out older versions of describe.c in src/bin/psql in the postgres 
+  distro is a good way of seeing how to query older versions of postgres for 
+  schema information
+* Put functions in the highest class possible.  For instance, simple selects 
+  should be in Postgres, whereas something that works for 7.1+ should be in the 
+  7.1 class.  This will minimise bugs and duplicated code.
+* Adhere to current coding standards
+* Avoid using global variables if possible
+

html/PostgresssAdmin/TRANSLATORS

@@ +1 @@
+Translator Info
+---------------
+
+If you like phpPgAdmin, then why not translate it into your native language?
+
+Translation is slightly complicated in phpPgAdmin compared to other PHP
+software, since we support viewing database encodings that are different to
+your language encoding.
+
+Also, there are quite a large number of strings to be translated.  Partial
+translations are better than no translations at all, and a rough guide is that
+the strings are in the order from most important to least important in the
+language file.  You can ask the developers list if you don't know what a
+certain string means.
+
+To translate messages, you will need to install GNU Recode on your computer.
+
+GNU Recode: http://www.gnu.org/software/recode/recode.html
+
+Your favourite OS should have a GNU Recode package available. (See bottom for
+details.)
+
+Once you have Recode installed, these are the steps to creating a new
+translation:
+
+1. Go to the lang/ subdirectory
+
+2. Copy english.php to yourlanguage.php
+
+3. Update the comment at the top of the file.  Put yourself as the language 
+   maintainer. Edit the 'applang' variable and put your language's name in it,
+   in your language.
+  
+   Edit the 'appcharset' variable and put in the name of the encoding for your
+   language.
+
+4. Go through as much of the rest of the file as you wish, replacing the
+   English strings with strings in your native language.
+
+At this point, you can send the yourlanguage.php file to us and we will take
+care of testing and recoding the translation.  Please only do that if you 
+find the rest of these steps too difficult.
+
+5. Edit the Makefile in the lang/ directory and add an entry for your new
+   language.  Note that the parameter for Recode is "yourcharset..HTML".
+
+6. Run the Makefile by typing 'make yourlanguage'.  A recoded language file
+   will appear in the lang/recoded/ directory.  If the recoding fails, then
+   fix the error in your language file and try again.
+
+7. The HTML encoded language file is what phpPgAdmin actually uses to display
+   localised strings.  Have a look at the recoded file to see how the HTML
+   encoding works.  By encoding your language like this, we can display your
+   language's characters as well as the characters of the language in your
+   database.
+
+8. To add your language to phpPgAdmin, edit the lang/translations.php file
+   and add your language to the $appLangFiles array.
+   You must include the HTML encoded version of your language's name.  You can
+   get this from the recoded version of your translated strings file.
+   Also, add your language to the $availableLanguages array for
+   browser auto detection.
+
+9. Send your contribution to us.  We need the lib.inc.php entry as well as the
+   yourlanguage.php file in lang/.  We don't need the recoded file as we can
+   recode it ourselves before committing it.  Email to the developers list:
+   [e-mail]
+
+10. Thank you for your contribution!  You have just made phpPgAdmin accessible
+    to thousands more users!
+
+11. There exists a tool named 'langcheck' in the lang/ directory.  To run it,
+    just type 'php langcheck <language>'.  It will give you a report about
+    which strings are missing from your language file and which need to be
+    deleted.
+
+Appendix A: Ways to Get Recode
+------------------------------
+
+* FreeBSD: cd /usr/ports/converters/recode; make install clean
+* BSD: ftp.gnu.org/gnu/recode/
+* Red Hat: rpm -Uvh recode-3.6-6.i386.rpm
+* Debian: Available via apt-get
+* Win32: http://unxutils.sourceforge.net

html/PostgresssAdmin/aggregates.php

@@ +1 @@
+<?php
+
+	/**
+	 * Manage aggregates in a database
+	 *
+	 * $Id: aggregates.php,v 1.12 2005/10/18 03:45:15 chriskl Exp $
+	 */
+
+	// Include application functions
+	include_once('./libraries/lib.inc.php');
+	
+	$action = (isset($_REQUEST['action'])) ? $_REQUEST['action'] : '';
+	if (!isset($msg)) $msg = '';
+
+	/**
+	 * Show default list of aggregates in the database
+	 */
+	function doDefault($msg = '') {
+		global $data, $conf, $misc;
+		global $lang;
+
+		$misc->printTrail('schema');
+		$misc->printTabs('schema', 'aggregates');
+		$misc->printMsg($msg);
+		
+		$aggregates = $data->getAggregates();
+
+		$columns = array(
+			'aggregate' => array(
+				'title' => $lang['strname'],
+				'field' => 'proname',
+			),
+			'type' => array(
+				'title' => $lang['strtype'],
+				'field' => 'proargtypes',
+				'params'=> array('null' => $lang['stralltypes']),
+			),
+			'comment' => array(
+				'title' => $lang['strcomment'],
+				'field' => 'aggcomment',
+			),
+		);
+		
+		$actions = array();
+		
+		$misc->printTable($aggregates, $columns, $actions, $lang['strnoaggregates']);
+	}
+
+	/**
+	 * Generate XML for the browser tree.
+	 */
+	function doTree() {
+		global $misc, $data;
+		
+		$aggregates = $data->getAggregates();
+		
+		$proto = concat(field('proname'), ' (', field('proargtypes'), ')');
+		
+		$attrs = array(
+			'text'   => $proto,
+			'icon'   => 'functions',
+			'toolTip'=> field('aggcomment'),
+		);
+		
+		$misc->printTreeXML($aggregates, $attrs);
+		exit;
+	}
+	
+	if ($action == 'tree') doTree();
+	
+	$misc->printHeader($lang['straggregates']);
+	$misc->printBody();
+
+	switch ($action) {
+		default:
+			doDefault();
+			break;
+	}	
+
+	$misc->printFooter();
+
+?>

html/PostgresssAdmin/all_db.php

@@ +1 @@
+<?php
+
+	/**
+	 * Manage databases within a server
+	 *
+	 * $Id: all_db.php,v 1.41 2005/10/18 03:45:15 chriskl Exp $
+	 */
+
+	// Include application functions
+	include_once('./libraries/lib.inc.php');
+	
+	$action = (isset($_REQUEST['action'])) ? $_REQUEST['action'] : '';
+	if (!isset($msg)) $msg = '';
+	$PHP_SELF = $_SERVER['PHP_SELF'];
+