ioguix [Sun, 18 Jul 2010 11:45:36 +0000 (13:45 +0200)]
Fix a bug with grouping servers feature
* opened connexions were appearing in every group
* after connexion/disconnection, stay in the group instead
of falling back in the 'all' group
Leonardo Sápiras [Sat, 12 Jun 2010 13:42:22 +0000 (15:42 +0200)]
Fix refresh lock page javascript for compatibility with IE
...which is stricter than others on this...
Leonardo Sápiras [Wed, 9 Jun 2010 20:36:25 +0000 (22:36 +0200)]
Oops, forgot to add the js/database.js file to the commit
6134a181d1910910021d
ioguix [Wed, 9 Jun 2010 19:42:02 +0000 (21:42 +0200)]
Merge branch 'master' of github.com:xzilla/phppgadmin
ioguix [Wed, 9 Jun 2010 19:41:50 +0000 (21:41 +0200)]
remove some testing values from the english recoded file :/
Leonardo Sápiras [Wed, 9 Jun 2010 19:40:20 +0000 (21:40 +0200)]
Add auto-refresh process and prepared xact using ajax
This patch rename the existing js/locks.js as js/database.js
and factorise the code to use it from both page.
Leonardo Sápiras [Sun, 6 Jun 2010 21:09:10 +0000 (23:09 +0200)]
Add bottom link to top of the page
Leonardo Sápiras [Tue, 1 Jun 2010 22:29:35 +0000 (00:29 +0200)]
Fix bad parameter name for database on ajax locks page refresh request
ioguix [Mon, 31 May 2010 23:06:42 +0000 (01:06 +0200)]
Better handling connection error and waiting in locks page behaviour on ajax request
* re-add error message on page
* add a loading icon when a query is running
* cancel ajax request when clicking on stop
* preload image (start icon don't show up on error without it)
Leonardo Sápiras [Sun, 30 May 2010 20:25:05 +0000 (22:25 +0200)]
Auto refresh the locks list using ajax. See ajax_refresh conf var.
Patch by Leonardo Sápiras during the gsoc2010, plus some external edits based on Alexey reviews and mine.
Pierre-dominique PERRIER [Sun, 30 May 2010 19:20:57 +0000 (21:20 +0200)]
Highlight table's lines when overing them.
Patch by Pierre-dominique PERRIER with some cleanup by me.
Robert Treat [Sat, 22 May 2010 13:43:29 +0000 (09:43 -0400)]
fix invalid xhtml tag, per Alexey Baturin
Guillaume (ioguix) de Rorthais [Sun, 16 May 2010 22:16:24 +0000 (00:16 +0200)]
Fix wizzard create view form where schemas, tables and fields were not cleaned
Guillaume (ioguix) de Rorthais [Sun, 16 May 2010 21:47:07 +0000 (23:47 +0200)]
Fix bug reported by Alexey Baturin on admin page + small ergonomy changes
In the "Autovacuum setup per table" section:
* removed useless schema and table column when on a table's admin page
* added links to related schema and table when on a database's admin page
Guillaume (ioguix) de Rorthais [Sun, 16 May 2010 21:41:22 +0000 (23:41 +0200)]
force display_errors to 'on'
Guillaume (ioguix) de Rorthais [Sat, 15 May 2010 17:50:13 +0000 (19:50 +0200)]
Remove Postgres.php:getVariable() function
1st it was unsecure, 2nd it was unused anyway
Guillaume (ioguix) de Rorthais [Sat, 15 May 2010 17:44:58 +0000 (19:44 +0200)]
Cleaning usage of ->clean() vs. ->fieldClean() in Postgres*.php classes
Guillaume (ioguix) de Rorthais [Sat, 15 May 2010 15:49:27 +0000 (17:49 +0200)]
Merge branch 'master' of github.com:xzilla/phppgadmin
Guillaume (ioguix) de Rorthais [Sat, 15 May 2010 15:36:03 +0000 (17:36 +0200)]
Fix magic_quotes_gpc related bug. Reported by Alex Baturin.
This parameter is not settable from script + it affects parse_str that brakes redirect.php
Guillaume (ioguix) de Rorthais [Sat, 15 May 2010 15:36:03 +0000 (17:36 +0200)]
Fix magic_quotes_gpc related bug.
This parameter is not settable from script + it affects parse_str that brakes redirect.php
Robert Treat [Thu, 13 May 2010 19:15:54 +0000 (15:15 -0400)]
make this TODO item better
Robert Treat [Sat, 24 Apr 2010 19:07:45 +0000 (15:07 -0400)]
fix trigger list and search for 9.0, push older functions to 8.4 class
Magnus Hagander [Wed, 14 Apr 2010 15:59:00 +0000 (23:59 +0800)]
Consistently call privileges the same thing
Magnus Hagander [Wed, 14 Apr 2010 15:58:47 +0000 (23:58 +0800)]
Properly call sequences "Sekvenser"
Guillaume (ioguix) de Rorthais [Sun, 11 Apr 2010 22:35:57 +0000 (00:35 +0200)]
remove last 8.5 references in Postgres.php
Guillaume (ioguix) de Rorthais [Sun, 11 Apr 2010 22:29:37 +0000 (00:29 +0200)]
Update the help files, removing old ones, updating PostgresDoc73.php accordingly and renaming 85 -> 90
Guillaume (ioguix) de Rorthais [Sun, 11 Apr 2010 21:56:58 +0000 (23:56 +0200)]
Fix cluster action on the admin page
Guillaume (ioguix) de Rorthais [Mon, 5 Apr 2010 20:56:34 +0000 (22:56 +0200)]
Refactor admin page, adding it in table level, fixes and support for autovacuum per table for pg 8.4+
Alexey Baturin [Tue, 30 Mar 2010 22:21:57 +0000 (00:21 +0200)]
fix a bug in tests archi where we tried to open tests/selenium/static/TestSuite.html *before* creating the static folder
Guillaume (ioguix) de Rorthais [Sun, 28 Mar 2010 21:28:35 +0000 (23:28 +0200)]
add .gitattribute file to exclude some files when creating an archive using the git archive command
Alexey Baturin [Mon, 15 Mar 2010 13:50:25 +0000 (14:50 +0100)]
Add UTF-8 Russian translation
Jehan-Guillaume (ioguix) de Rorthais [Sat, 13 Mar 2010 00:47:46 +0000 (01:47 +0100)]
add ability to logicaly group servers under custom top nodes in the browser tree
Jehan-Guillaume (ioguix) de Rorthais [Fri, 12 Mar 2010 23:46:57 +0000 (00:46 +0100)]
Update ADODB library with latest release. It fixes some more deprecation warning about function removed in PHP 6.0. Reported by Christian Tessarek.
Jehan-Guillaume (ioguix) de Rorthais [Fri, 12 Mar 2010 21:40:19 +0000 (22:40 +0100)]
update selenium lib to current 1.0.3
Jehan-Guillaume (ioguix) de Rorthais [Thu, 11 Mar 2010 23:28:49 +0000 (00:28 +0100)]
In fulltext.php, doDropMapping should not exit() on error but return so we can send the closing html tags. Reported by Alexey Baturin.
Jehan-Guillaume (ioguix) de Rorthais [Thu, 11 Mar 2010 23:27:10 +0000 (00:27 +0100)]
Fix #
2967918, display bug when creating a FTS conf with multi errors. Reported by Alexey Baturin.
Jehan-Guillaume (ioguix) de Rorthais [Sat, 6 Feb 2010 12:23:55 +0000 (13:23 +0100)]
housecleaning: remove all useless hasXXX() functions since we drop support for pg < 7.3
Robert Treat [Sat, 9 Jan 2010 22:15:31 +0000 (17:15 -0500)]
fix for bug #
1963050, we emit 'No Access' now in cases where we dont have permissions to see database sizes
Robert Treat [Sat, 9 Jan 2010 21:19:16 +0000 (16:19 -0500)]
out error messages in monospaced fonts, so that pg's error pointer to align properly with the error. per gripe from Philippe Cloutier
Robert Treat [Sat, 2 Jan 2010 04:51:28 +0000 (23:51 -0500)]
fix typo
Robert Treat [Sat, 2 Jan 2010 04:25:57 +0000 (23:25 -0500)]
basic support for Postgres 8.5
Robert Treat [Sat, 2 Jan 2010 03:56:31 +0000 (22:56 -0500)]
fix typo
Robert Treat [Fri, 1 Jan 2010 15:45:11 +0000 (10:45 -0500)]
Fix for BUG #
2857758, don't clean() comments before submitting them to setComment. This is somewhat counter-intuitive, but since we clean the comment in setComment itself, cleaning before hand means we end up with doubly escaped data. We don't really have a good way to prevent this (like a subclassed type or something), so we'll go with this for now. The alternative would have been to not clean() the comments in setComment itself, however that would mean that forgetting to clean() it in the passing function would result in a security exploit (and note we already did not apply this uniformly). I think there is a saying to keep the escaping as close to the db interaction as possible, and this seems to mesh with that idea.
Robert Treat [Fri, 1 Jan 2010 15:44:17 +0000 (10:44 -0500)]
update credit
Robert Treat [Fri, 1 Jan 2010 14:14:49 +0000 (09:14 -0500)]
overhaul the cant connect question, plus other fixes
Jehan-Guillaume (ioguix) de Rorthais [Fri, 27 Nov 2009 08:40:14 +0000 (09:40 +0100)]
Replace some deprecated fonctions in php 5.3. Patch by Jason Jackson
Robert Treat [Fri, 20 Nov 2009 20:33:16 +0000 (15:33 -0500)]
use pg_get_expr to generate correct attribute default rather than adsrc, which according to tgl is never reliable. fixes insert bug reported by Casey Shobe.
Guillaume (ioguix) de Rorthais [Thu, 5 Nov 2009 23:29:59 +0000 (00:29 +0100)]
quick update of TODO with reminders for 5.0
Guillaume (ioguix) de Rorthais [Tue, 3 Nov 2009 00:00:35 +0000 (01:00 +0100)]
quick update of TODO with reminders for 5.0
Guillaume (ioguix) de Rorthais [Sat, 31 Oct 2009 15:59:03 +0000 (16:59 +0100)]
Remove a trailing '}' in the schema part of found indexes on the find page
Guillaume (ioguix) de Rorthais [Fri, 30 Oct 2009 21:04:27 +0000 (22:04 +0100)]
Fix Undefined index formConcur when creating an index without CONCURRENTLY
Guillaume (ioguix) de Rorthais [Fri, 30 Oct 2009 19:00:06 +0000 (20:00 +0100)]
add forgotten adodb new translation files
Guillaume (ioguix) de Rorthais [Fri, 30 Oct 2009 15:16:34 +0000 (16:16 +0100)]
Update adodb with the latest 5.09a which support php5 only and include deprecated bug fixes for php 5.3
Guillaume (ioguix) de Rorthais [Fri, 30 Oct 2009 13:06:06 +0000 (14:06 +0100)]
When creating table with WITHOUT OIDS not checked, behaviour was left to the db default setting. Force WITH OIDS if WITHOUT OIDS is unchecked. Remove useless hasWithoutOIDs() as well as 7.3 -> 8.4
support it.
Guillaume (ioguix) de Rorthais [Thu, 29 Oct 2009 17:30:13 +0000 (18:30 +0100)]
pg_dump[all] 8.4 doesn't support -d option anymore. Use --inserts instead. Reported by Simon LECAILLE
Guillaume (ioguix) de Rorthais [Thu, 29 Oct 2009 16:46:43 +0000 (17:46 +0100)]
allow empty comment on database to remove it if needed.
Guillaume (ioguix) de Rorthais [Thu, 29 Oct 2009 14:52:37 +0000 (15:52 +0100)]
Remove one deprecated usage in 5.3 of "... =& new ...". Please, report any other deprecated usage as I don't have php 5.3 yet.
Objects are manipulaed throught alias (not refs) anyway which, are not a copy of the object itself in php5. See:
- php.net/manual/en/language.oop5.references.php
- php.net/manual/en/migration53.deprecated.php
Guillaume (ioguix) de Rorthais [Mon, 26 Oct 2009 05:48:48 +0000 (06:48 +0100)]
pg > 8.1 does not support privilege RULE on table or view
Guillaume (ioguix) de Rorthais [Mon, 26 Oct 2009 01:22:46 +0000 (02:22 +0100)]
Fix bug in privilege when setting ALL on a column
Guillaume (ioguix) de Rorthais [Fri, 2 Oct 2009 02:05:21 +0000 (04:05 +0200)]
Fix bug where many requests fail when a schema has a ' or a " in the Postgres* class files.
Guillaume (ioguix) de Rorthais [Thu, 1 Oct 2009 23:26:01 +0000 (01:26 +0200)]
Refactor and improve the auto-complete foreign-key support in the insert form
- clean the code
- add support for multi-colmn foreign key
- show all the table column in the choice list
- add pagination in the list to browse prev/next 11 values
- use of jquery lib
Guillaume (ioguix) de Rorthais [Thu, 1 Oct 2009 23:25:27 +0000 (01:25 +0200)]
add jquery js lib
Guillaume (ioguix) de Rorthais [Sun, 13 Sep 2009 15:38:09 +0000 (11:38 -0400)]
remove duplicated escaped comment on create db
Guillaume (ioguix) de Rorthais [Sun, 13 Sep 2009 14:00:08 +0000 (10:00 -0400)]
small warning fix about db lvl collation vars when creating DB on pg < 84
Guillaume (ioguix) de Rorthais [Fri, 14 Aug 2009 02:29:19 +0000 (22:29 -0400)]
add support for database level collation
Guillaume (ioguix) de Rorthais [Tue, 14 Jul 2009 05:27:39 +0000 (01:27 -0400)]
Miscellaneous fix while trying to fix the selenium tests
+ fix selenium test when creating a DB under 8.4 with incompatible encoding with template1 (use template0 everytime)
+ removed hasForeignKeysInfo
+ removed hasConstraintsInfo
+ fixed one assertion in the column selenium tests
+ fixed alterColumn where old name was used to alter the type while the col was renamed in the same transaction
+ some indentation fixes
- SEQUENCE selenium test need to be fixed
Robert Treat [Sun, 12 Jul 2009 12:03:19 +0000 (08:03 -0400)]
Fix bug #
2718862, error when commenting on database
Robert Treat [Sun, 12 Jul 2009 00:52:40 +0000 (20:52 -0400)]
doh, missing changes from concurrent index feature
Guillaume (ioguix) de Rorthais [Wed, 8 Jul 2009 18:03:50 +0000 (20:03 +0200)]
update TODO file
Robert Treat [Mon, 6 Jul 2009 01:07:38 +0000 (21:07 -0400)]
add support for concurrent index builds
Robert Treat [Mon, 6 Jul 2009 00:46:44 +0000 (20:46 -0400)]
first crack at 5.0 release notes
Robert Treat [Mon, 6 Jul 2009 00:13:42 +0000 (20:13 -0400)]
add ability to terminate backend processes for 8.4+
Robert Treat [Fri, 3 Jul 2009 23:51:52 +0000 (19:51 -0400)]
remove known completed items, I think there are still some items done but not marked
Robert Treat [Fri, 3 Jul 2009 23:43:30 +0000 (19:43 -0400)]
adding some TODO items from the forums
Robert Treat [Fri, 3 Jul 2009 23:14:28 +0000 (19:14 -0400)]
add option for specifying the template database during database creation. prompted by changes in 8.4 wrt encoding rules changes, but this should work on all versions. Verified against 8.3 and 8.4
Robert Treat [Sat, 27 Jun 2009 18:30:48 +0000 (14:30 -0400)]
woops, let's not re-introduce this bug
Robert Treat [Sat, 27 Jun 2009 18:15:05 +0000 (14:15 -0400)]
Updated Czech translation file, thanks to Marek Černocký <marek@manet.cz>
Robert Treat [Sat, 27 Jun 2009 18:03:03 +0000 (14:03 -0400)]
Adding Greek translation, thanks to Adamantios Diamantidis <adamand@cc.duth.gr>
Robert Treat [Sat, 27 Jun 2009 17:25:32 +0000 (13:25 -0400)]
Merge branch 'master' of git@github.com:xzilla/phppgadmin
Robert Treat [Sat, 27 Jun 2009 17:24:03 +0000 (13:24 -0400)]
Add updated translation for Brazillian Portuguese, per Fernando Wendt <fernandowendt@msn.com>
Guillaume (ioguix) de Rorthais [Wed, 20 May 2009 18:47:26 +0000 (14:47 -0400)]
Add CLP support
Guillaume (ioguix) de Rorthais [Wed, 20 May 2009 16:22:52 +0000 (12:22 -0400)]
privmap and privlist class variables update for 8.4
Guillaume (ioguix) de Rorthais [Mon, 11 May 2009 01:21:08 +0000 (21:21 -0400)]
Fixes about using html chars in object names. Fix bug #
1607047. More work could be needed in other places though.
- fix insert on a table with name or fields containing html chars
- fix altering a field containing html chars in its name
- fix altering a table containint html chars in its name
Robert Treat [Tue, 21 Apr 2009 03:23:06 +0000 (23:23 -0400)]
Merge branch 'master' of git@github.com:xzilla/phppgadmin
Robert Treat [Tue, 21 Apr 2009 03:22:29 +0000 (23:22 -0400)]
fix for bug #
2742616, autocomplete on tables in different schemas
Guillaume (ioguix) de Rorthais [Mon, 20 Apr 2009 23:29:28 +0000 (19:29 -0400)]
Upgrade minimal PostgreSQL version to 7.3
Guillaume (ioguix) de Rorthais [Mon, 20 Apr 2009 23:27:42 +0000 (19:27 -0400)]
Merge branch 'master' into devInfo
Guillaume (ioguix) de Rorthais [Wed, 1 Apr 2009 03:10:46 +0000 (23:10 -0400)]
oops, actually commit the hasObjectID fix
Guillaume (ioguix) de Rorthais [Wed, 1 Apr 2009 02:57:51 +0000 (22:57 -0400)]
Fix a bug where cleaning a table name containing quotes makes hasObjectID works on a false table name and fail.
Fix hasObjectID to return null on error instead of -99 that is considered as true in php.
Robert Treat [Fri, 27 Mar 2009 19:15:20 +0000 (15:15 -0400)]
more TODO updates
Robert Treat [Sun, 15 Mar 2009 01:21:55 +0000 (21:21 -0400)]
fix for bug #
2672374, invalid utf8 declaration. thanks to David Navara
Robert Treat [Fri, 27 Mar 2009 18:40:53 +0000 (14:40 -0400)]
Merge branch 'master' of git@github.com:xzilla/phppgadmin
Robert Treat [Fri, 27 Mar 2009 18:40:23 +0000 (14:40 -0400)]
TODO updates
Guillaume (ioguix) de Rorthais [Thu, 26 Mar 2009 01:29:09 +0000 (21:29 -0400)]
upgrade version info to 5.0-dev
Guillaume (ioguix) de Rorthais [Tue, 17 Mar 2009 21:31:53 +0000 (22:31 +0100)]
Fix mistakenly escaped quotes in function getStatsTableTuples (called from the info page)
Guillaume (ioguix) de Rorthais [Wed, 11 Mar 2009 02:01:37 +0000 (22:01 -0400)]
fix bug #
2605601 Doesn't check if pg_dump_path is valid
Guillaume (ioguix) de Rorthais [Tue, 10 Mar 2009 02:00:41 +0000 (22:00 -0400)]
Fix bug #
2654193 "space as first character in column bytea"
Robert Treat [Thu, 19 Feb 2009 16:29:48 +0000 (11:29 -0500)]
postgres 8.4 replaces pg_autovacuum system table with reloptions on the tables themselves, so we need to avoid trying to show this in future versions. I think this might be the first feature we have both coming and going
Robert Treat [Sun, 8 Feb 2009 19:41:51 +0000 (14:41 -0500)]
more optimized graphics, from limo driver. refs #
2562645
Guillaume (ioguix) de Rorthais [Sun, 8 Feb 2009 17:20:15 +0000 (12:20 -0500)]
Fix bug #
2555949 Where inserting in a table with no champs is allowed and shows warning. Thanks to Limo Driver (l-s) for reporting.