| Age | Commit message (Collapse) | Author | Files | Lines |
|---|
|
Fix PR pkg/48777
|
|
|
|
|
|
From the release announcement:
This is a bug fix release which includes the following fixes:
* Allow the dump of pg schemas [Guillaume Lelarge]]
* Prevent a crash on Windows when dropping a column or a constraint on
a table [Dhiraj Chawla]
* Ensure DDLScript will work with Slony 2.2+ which has a new SQL level
API [Neel Patel]
* Fix ordering of object types in the display options and add Event
Triggers which were missing [Dhiraj Chawla].
* Ensure the debugger can cope with functions that have an OUT
parameter as the first. [Ashesh Vashi]
* Fix the quoting of user mapping objects [Dinesh Kumar]
* Ensure that materialised views are available as targets for synonyms
[Neel Patel]
* Fix the query used to find tables in a Slony replication set [Neel Patel]
* Prevent a crash if a user starts an external process such as a
backup, and then immediately hits cancel [Neel Patel].
* Fix a memory leak in the Event Trigger code [Dinesh Kumar].
For more information or to download, please visit the website at
http://www.pgadmin.org/.
|
|
|
|
pgAdmin III Changelog
=====================
Notes
-----
This is the pgAdmin III changelog. Items are marked with the initials of the
developer responsible for them, and the version of pgAdmin that the change
will first appear in. For convenience, changes during Beta and RC phases may
include an RCx or Bx suffix on the version number, but for simplicity these
will not normally be retained.
A name in square braces [Joe Bloggs] indicates that the change was written by
Joe. The initialed developer was responsible for reviewing the changes in these
cases.
Names shown as "per Joe Bloggs", indicate that Joe reported the problem and may
have provided help debugging it, but did not actually provide the change.
Key to developers
-----------------
- DP Dave Page
- AP Andreas Pflug
- JMP Jean-Michel Poure
- HS Hiroshi Saito
- AHP Adam H. Pendleton
- MP Marc Persuy
- DAP Darko Prenosil
- FGP Florian G. Pflug
- MH Magnus Hagander
- GL Guillaume Lelarge
- AV Ashesh Vashi
Changes
-------
Date Dev Ver Change details
---------- --- ------ --------------
2013-09-06 DP 1.18.1 Fix a memory leak in the Event Trigger code [Dinesh
Kumar].
2013-08-20 AV 1.18.0 Fix a layout bug in the graphical explain renderer that
could render nodes on top of each other.
2013-08-06 DP 1.18.0 Fix Slony's DDL Script support [Akshay Joshi].
2013-07-26 DP 1.18.0 Add support for Event Triggers in 9.3+ [Dinesh Kumar].
2013-07-22 DP 1.18.0 Avoid using a Help cache file that needs to be world
writeable, and ensure sed is happy when post-processing
helpfiles.
2013-07-22 DP 1.18.0 Fix the help path on the import dialogue and improve the
error handling [Akshay Joshi].
2013-07-22 DP 1.18.0 Fix path the the Search Objects help doc [Dhiraj Chawla].
2013-07-18 GL 1.18.0 Fix UTF-8 display for guru hints [Marek Cernocky].
2013-07-08 DP 1.18.0 Prevent a crash when creating a stored procedure in
PPAS [Dinesh Kumar].
2013-06-19 GL 1.18.0 Disable the Favourites menu items if there is no
favourites file path (per a comment from Michael Shapiro).
2013-06-18 GL 1.18.0 Make No the default button on the Truncate confirmation
dialog (per request from Humberto Cereser Ibanez).
2013-06-18 DP 1.18.0 Support Materialized Views [Neel Patel].
2013-06-07 DP 1.18.0 Avoid a possible crash on Linux when using the
"Script" options of the Query Tool [aditsu].
2013-05-26 DP 1.18.0 Fix comments on constraints [Thom Brown].
2013-05-26 DP 1.18.0 Fix schema prefixes in cast definitions in the browser.
2013-05-26 DP 1.18.0 Treat sequences as first class objects in the Grant
Wizard. Support USAGE and remove obsolete RULE
permissions [Dhiraj Chawla].
2013-05-26 DP 1.18.0 Set the default backup type to "Custom".
2013-05-21 DP 1.18.0 Improve the copy handling on the Edit Grid so that
it works more consistently and predictably.
2013-05-20 DP 1.18.0 Fix comments on columns.
2013-05-20 DP 1.18.0 Remove the "Apply" buttons from the function, view
package and external table dialogues. Their use is
discouraged, and the code is fragile, complex and
very buggy.
2013-05-20 DP 1.18.0 Fix a crash that could occur if the browser fails to
detect that an object has been changed by another
session.
2013-05-17 DP 1.18.0 Change the default SQL box font to a slightly smaller
size on GTK based platforms.
2013-05-17 DP 1.18.0 Don't prompt the user for a password if they're using
a client certificate.
2013-05-17 DP 1.18.0 Ensure global backups use the mintenance database to
avoid access issue with postgres or template1.
2013-05-17 DP 1.18.0 Fix SSL certificate authentication.
2013-05-08 DP 1.18.0 Fix renaming and schema changes for stored procedures
in PPAS [Dinesh Kumar].
2013-05-02 DP 1.18.0 Add SSH tunnelling support to allow connections to be
made to hosts via an SSH server [Akshay Joshi].
2013-05-02 DP 1.18.0 Display the index validity in the properties list for
indexes and index-based constraints [Gabrielle Roth].
2013-04-29 DP 1.18.0 Add an option to include column headers when copying
from the query tool results [Jasmin Dizdarevic].
2013-04-29 DP 1.18.0 Allow the decimal mark displayed by the query tool to be
configured as the thousands separator can [Jasmin
Dizdarevic].
2013-04-25 DP 1.18.0 Ensure the Query Tool's maximum column length setting
is honoured.
2013-04-22 DP 1.18.0 Handle default privileges to PUBLIC correctly. [Dhiraj
Chawla].
2013-03-24 GL 1.18.0 Add tab option in the Import dialog. Per a request from
Jeff Janes.
2013-03-17 GL 1.18.0 Add smallserial handling. Per a request from Matthew
Syphus.
2013-03-01 DP 1.18.0 Fix the editing of pg_hba.conf files [Dhiraj Chawla].
2013-02-25 DP 1.18.0 Fix the display of extension owner names.
2013-02-23 GL 1.18.0 Add a title to the backup and restore windows. Per
request from Bastiaan Olij.
2013-02-22 DP 1.18.0 Fix a bug that could cause a NOTICE to be displayed
when rendering FTS Configurations in the tree.
2013-02-07 DP 1.18.0 Don't try to display dependents or dependencies for
pgAgent jobs, schedules or steps.
2013-02-06 DP 1.18.0 Fix the handling of expiry times when modifying roles.
2013-02-04 DP 1.18.0 Prevent foreign keys being recreated unnecessarily when
modifying tables [Michael Banck]
2013-01-24 DP 1.18.0 Prevent Cmd+S adding characters to the Query Tool when
the Save button is disabled.
2013-01-18 DP 1.18.0 Fix handling of Greenplum partitions [Lubomir Petrov]
2013-01-06 GL 1.18.0 Add -V/--version CLI option.
2013-01-06 GL 1.18.0 Add actions menu to the serverstatus tool.
2013-01-06 GL 1.18.0 Fix the database SQL when reseting a configuration
parameter. Per a report from Bartosz Dmytrak.
2013-01-04 GL 1.18.0 Refresh the toolbar buttons when a list has been
updated. Per a report from Evan Martin.
2013-01-04 GL 1.18.0 Fix the "NO INHERIT" query. Report from Thomas Joseph.
2012-12-24 GL 1.18.0 Display default privs. Report from Nathan Alden.
2012-12-24 GL 1.18.0 Sort references by schema name and relation name in
dlgForeignKey. Report from Michal Kozusznik.
2012-12-24 GL 1.18.0 Fix the change of the superuser attribute. Report from
Michal Kozusznik.
2012-12-18 DP 1.18.0 Prevent a crash when using Cmd-A on a file loaded into
the Query Tool when opened with Cmd-E on Mac.
2012-12-07 DP 1.18.0 Fix the queries used to get object comments to allow
for duplicate OIDs that may be present following use
of pg_upgrade.
2012-12-03 DP 1.16.1 Prevent a crash that could happen if further changes
were made on a dialogue after using the Apply button.
[Akshay Joshi]
2012-11-29 GL 1.16.1 Save new comments on already existing columns when
editing a table. Per a report from Jeff Janes.
2012-11-29 GL 1.16.1 Fix the query editor behaviour when executing COPY TO
stdout and COPY FROM stdin [Heikki Linnakangas]
2012-11-28 AV 1.16.1 Date picker controls returns a full timestamp by
default, which can cause inadvertent date changes
on jobs and role validty dates. Ignore the time part.
2012-11-26 MH 1.16.1 Fix query for database descriptions
2012-11-15 DP 1.16.1 Avoid querying the catalogs for toast table settings
for every table in the database. This gives a huge
performance gain with large schemas.
2012-11-08 DP 1.16.1 Prevent a crash when refreshing a node which has a
child with an open dialogue [Dhiraj Chawla]
2012-11-08 DP 1.16.1 Fix dropping/renaming of indexes [Akshay Joshi]
2012-11-08 DP 1.16.1 Avoid updating the GQB model on every key press in
the query tool [Dhiraj Chawla]
2012-11-02 DP 1.16.1 Fix a crash that can occur when renaming objects.
[Ashesh Vashi/Sachin Srivastava]
2012-11-01 DP 1.16.1 Fix dropping of constraints [Akshay Joshi]
2012-10-31 DP 1.16.1 Fix the "blocked by" column in the server status
dialogue on 9.2 servers [Sachin Srivastava]
2012-10-11 DP 1.16.1 Prevent a crash if the query tool is closed whilst a
file is loading [Akshay Joshi]
2012-10-09 AV 1.16.1 Fix setting of comments on PPAS procedures.
2012-10-08 DP 1.16.1 Don't autosize the search results columns if no
results are found [Akshay Joshi]
2012-10-08 AV 1.16.1 Prevent a crash if opening a second config file in
the editor.
2012-10-08 DP 1.16.1 Prevent the SSL options combo box displaying
duplicate options if the server dialogue is
reopened [Akshay Joshi]
2012-09-14 GL 1.16.1 Fix trigger query when connected to PostgreSQL 8.2 or
lower, per a report from Jon Roberts.
2012-09-12 GL 1.16.1 Fix message when executing an empty query, per Marc
Mamin.
2012-09-06 DP 1.18.0 Detect serial/bigserial columns from pg_depend, rather
than guessing [Quan Zongliang].
2012-09-05 DP 1.18.0 Display the next expected value for a sequence in the
property list [Quan Zongliang].
2012-07-11 MH 1.18.0 Add optional thousands separator to the query tool
results grid.
2012-07-11 MH 1.18.0 Right-justify numeric values in the query tool results
|
|
|
|
|
|
version.
The list of bug fixes is available in the CHANGELOG.
The following are the recent Changes
------------------------------------
Date Dev Ver Change details
---------- --- ------ --------------
2012-12-03 DP 1.16.1 Prevent a crash that could happen if further changes
were made on a dialogue after using the Apply button.
[Akshay Joshi]
2012-11-29 GL 1.16.1 Save new comments on already existing columns when
editing a table. Per a report from Jeff Janes.
2012-11-29 GL 1.16.1 Fix the query editor behaviour when executing COPY TO
stdout and COPY FROM stdin [Heikki Linnakangas]
2012-11-28 AV 1.16.1 Date picker controls returns a full timestamp by
default, which can cause inadvertent date changes
on jobs and role validty dates. Ignore the time part.
2012-11-26 MH 1.16.1 Fix query for database descriptions
2012-11-15 DP 1.16.1 Avoid querying the catalogs for toast table settings
for every table in the database. This gives a huge
performance gain with large schemas.
2012-11-08 DP 1.16.1 Prevent a crash when refreshing a node which has a
child with an open dialogue [Dhiraj Chawla]
2012-11-08 DP 1.16.1 Fix dropping/renaming of indexes [Akshay Joshi]
2012-11-08 DP 1.16.1 Avoid updating the GQB model on every key press in
the query tool [Dhiraj Chawla]
2012-11-02 DP 1.16.1 Fix a crash that can occur when renaming objects.
[Ashesh Vashi/Sachin Srivastava]
2012-11-01 DP 1.16.1 Fix dropping of constraints [Akshay Joshi]
2012-10-31 DP 1.16.1 Fix the "blocked by" column in the server status
dialogue on 9.2 servers [Sachin Srivastava]
2012-10-11 DP 1.16.1 Prevent a crash if the query tool is closed whilst a
file is loading [Akshay Joshi]
2012-10-09 AV 1.16.1 Fix setting of comments on PPAS procedures.
2012-10-08 DP 1.16.1 Don't autosize the search results columns if no
results are found [Akshay Joshi]
2012-10-08 AV 1.16.1 Prevent a crash if opening a second config file in
the editor.
2012-10-08 DP 1.16.1 Prevent the SSL options combo box displaying
duplicate options if the server dialogue is
reopened [Akshay Joshi]
2012-09-14 GL 1.16.1 Fix trigger query when connected to PostgreSQL 8.2 or
lower, per a report from Jon Roberts.
2012-09-12 GL 1.16.1 Fix message when executing an empty query, per Marc
Mamin.
|
|
NetBSD 6, requested by tron.
|
|
Recursively bump package revisions again after the "freetype2" and
"fontconfig" handling was fixed.
|
|
to address issues with NetBSD-6(and earlier)'s fontconfig not being
new enough for pango.
While doing that, also bump freetype2 dependency to current pkgsrc
version.
Suggested by tron in PR 47882
|
|
|
|
|
|
|
|
|
|
|
|
requested by Thomas Klausner.
|
|
(additionaly, reset PKGREVISION of qt4-* sub packages from base qt4 update)
|
|
|
|
|
|
|
|
outdated list of mirrors.
|
|
|
|
a) tiff update to 4.0 (shlib major change)
b) glib2 update 2.30.2 (adds libffi dependency to buildlink3.mk)
Enjoy.
|
|
|
|
|
|
|
|
|
|
* Fix the debugger invocation code to ensure it handles different combinations
of server version and libpq builds as cleanly as possible.
* Fix the double line number in the function properties dialog.
* Fix for log_statement in 7.4.
* Lots of fixes on my "sort column" patch.
* Avoid an error when viewing index statistics in languages other than English.
* Fix connection color on the query tool
* Fix the reverse-engineered query for triggers
* Fix the server's property dialog for unpriviledged users
* Fix a crash if pressing escape in the edit grid filter and sorting dialogue.
Add a tooltip and make RO the queries combobox
* Fix the perspective string parameter
|
|
* Fix a possible crash on Solaris when closing the server status windows.
* Fix a possible crash on Solaris when cancelling a debugging operation.
* Fix a drawing glitch in the GQB, if the canvas exceeds the hard-coded minimum
size.
* Get rid of the schema name and double quotes of the result of the format_type
stored procedure
* Add a title to the frmStatus window when launched in standalone mode.
* Fix an issue with tab keypress on the frmQuery with Windows.
* Disable the "output pad" menu when the user is on the GQB tab.
* Disable the "scratch pad" menu when the user is on the GQB tab.
* Fix another issue with the connection check code.
* Fix an issue where the application_name is used as the database name during
a connection.
* Fix the connection check code.
* Don't send the Greenplum query for each user, but import it in the big roles
query.
* Ensure the highlight colour in the SQL textboxes will work with the system
colours.
* Make sure menubar's and toolbar's items are enabled/disabled as appropriate
when selecting a server's group, per a report from Steffen Kuhn.
* Ensure the Drop option is shown for rules when appropriate.
* Fix a crash that occured when pressing a key on a text cell in the Edit Grid,
when not in Edit mode.
|
|
version, and bump all depends.
Per discussion on pkgsrc-changes.
|
|
Also add some patches to remove use of deprecated symbols and fix other
problems when looking for or compiling against libpng-1.4.x.
|
|
* Fix the "quiet log" query in the status server.
* Call Stored Procedures in EnterpriseDB in an anonymous
block to prevent errors with out/inout parameters.
* Fix an error when working with packages on EnterpriseDB in 'postgres' mode.
* Prevent a crash if the user cancels a restore operation.
* Fix the refresh of a dropped function.
* Fix a crash bug seen when closing the debugger parameter dialog on OSX.
* Fix to only show Storage value if the value is different from the type's
default value.
* Fix uncalled attempt to "change" array data types in dlgColumn.
* Fix a crash that could occur if viewing a table with no rows in the Edit Grid.
* Fix a crash occuring when a function with a parameter with a default is
selected.
* Don't offer debugging options to non-superusers on Postgres Plus Advanced
Server < 8.4 which doesn't have support for user debugging.
* Fix the saving and reverse engineering of parameters for database, table,
and function.
* Specify the schema of the table/function to restore if pg_restore's release
is 8.2 or later.
* Fix the reverse engineering of a rule.
* Fix the status server window on Mac OS X.
* Fix the recent files, by notifying each frmQuery to update their recent files.
Same support for macros and favourites.
* Fix the canvas resizing with really big table.
* Add the missing RULEs for VIEWs in SQL pane.
* More...
|
|
* Correctly save the position of a pgFrame, per a report from Andreas Laggner
and Dan Halbert.
* Fix the reverse engineering of a function, per a report from Kieran McCusker.
* Fix the xmlTextWriterEndDocument check when saving a favorite.
* Fix an SQL error when changing a parameter for a database, role/user and
a function.
* Fix the display of a type with a specific typmod.
* Select the server choosen with the /s command-line argument.
* Fix the call to the Slony-I storenode function.
* Fix display of the date/time chooser.
|
|
|
|
* Replace Alt-F4 with Ctrl-Q and Ctrl-W.
* Prevent a crash if the edit grid is closed whilst it is loading data.
* Don't attempt to remove rows in the edit grid if the user presses the delete
key when the delete button is disabled.
* Only offer valid server encodings for new databases.
* Fix font dialogue on Snow Leopard.
* Fix an issue with the ordering of the mappings in a text search configuration.
* Fix a potential crash bug in the object browser.
* Reverse engineer empty (not NULL) ACLs correctly.
* Fix Greenplum support for column oriented partitions.
* Ensure function variables get reset if the function is modified.
* Fix cluster creation for Slony 2.0.
* Reverse engineer function defaults values correctly.
* Fix a potential crash in the edit grid.
* Fix domain creation/modification for domains in non-default schemas.
* Reverse engineer language privileges correctly.
* Get rid of "No SQL query was generated." message dialog when no tables are
selected in the GQB.
* Hints files should be encoded in UTF-8.
* Include comments on procedures in the reverse engineered SQL.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
reasons.
|
|
packages which have it active by default.
|
|
since they always need a C compiler, even when the source code is
completely in C++.
For some other packages, stated in the comment that a C compiler is
really not needed.
|
|
|
|
development platform for PostgreSQL, the most advanced Open Source database in
the world. The application may be used on BSD, Linux, Solaris, Mac OSX and
Windows platforms to manage PostgreSQL 7.3 and above running on any platform,
as well as commercial versions of PostgreSQL such as Pervasive Postgres,
EnterpriseDB, Mammoth PostgreSQL and SRA PowerGres.
pgAdmin III is designed to answer the needs of all users, from writing simple
SQL queries to developing complex databases. The graphical interface supports
all PostgreSQL features and makes administration easy. The application also
includes a syntax highlighting SQL editor, a server-side code editor, an
SQL/batch/shell job scheduling agent, support for the Slony-I replication
engine and much more. Server connection may be made using TCP/IP or Unix Domain
Sockets (on *nix platforms), and may be SSL encrypted for security. No
additional drivers are required to communicate with the database server.
|
