Download phpPgAdmin 4.1.2

Another new version of phpPgAdmin, the PostgreSQL counterpart of phpMyAdmin, has been released with 4.1.2 as the version number. This program consists of a collection of PHP scripts that allow to maintain and manage a PostgreSQL database via a web interface. For example, it is possible to create, modify and delete databases and tables. The list of changes since the previous entry in the junk tracker looks like this:

Version 4.1.2:

• Fix inability to assign a field type/domain of a different schema
• Fix PHP5 Strict mode complaints
• Fix IN/NOT IN to accept text input lists ‘a’,’b’.
• Fix bytea doesn’t display as NULL when NULL
• Fix bug in view creation wizard
• Fix XSS vulnerability: Escape HTML special characters before using $_SERVER[‘PHP_SELF’]

Version 4.1.1:

• Fix problem where failed update would report as duplicate update error and fail to return edit screen
• Fix error when using $conf[owned_only] on 8.1 & 8.2
• Fix error displaying schema names for parents of inherited tables
• Clean up non-standard escape warnings for PostgreSQL 8.2
• Fix improper text quoting for dropping roles and aggregates
• Fix bug when dumping mixed case table names in PostgreSQL 8.2

Version 4.1:

• New icons by Niko, from the graphics repository on pgFoundry.
• Added icons to bread crumb trail and tabs.
• Send encrypted passwords over the wire wherever possible.
• Alter sequence, nextval and setval (Guillaume)
• Auto-select ‘WITHOUT OIDS’ if ‘default_with_oids’ setting is false (Guillaume)
• Autovacuum configuration support (Robert Treat)
• Basic ROLE support (Chris Kings-Lynne, Javier Carlos)
• Add support for SSL connections (Eric Kinolik)
• Display content or pg_locks view (Javier Carlos)
• Add labels for checkboxes/radio buttons for improved usability (Guillaume)
• Display Prepared Transactions (Javier Carlos)
• Re-enable table browsing from tree icons (ioguix)
• Add Support For IN/OUT Parameters (John Jawed)
• Add column level information into the tree browser (ioguix)
• Promote column level interaction into its own page (ioguix)
• Add automatic lookup of foreign key values ​​in insert/update fields (John Jawed)
• Add ability to create/drop/alter custom aggregates (Javier Carlos)
• Add enable/disable trigger (John Jawed)
• Add global comments for databases and tablespaces
• Catalan translation from Bernat