Menu
▾
▴
phppgadmin-help — For broadcasting of forum and big reports to developers
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
(19) |
May
(131) |
Jun
(48) |
Jul
(81) |
Aug
(23) |
Sep
(78) |
Oct
(37) |
Nov
(50) |
Dec
(21) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(39) |
Feb
(56) |
Mar
(56) |
Apr
(40) |
May
(59) |
Jun
(56) |
Jul
(103) |
Aug
(77) |
Sep
(60) |
Oct
(40) |
Nov
(37) |
Dec
(58) |
| 2004 |
Jan
(76) |
Feb
(56) |
Mar
(23) |
Apr
(34) |
May
(25) |
Jun
(49) |
Jul
(30) |
Aug
(53) |
Sep
(28) |
Oct
(22) |
Nov
(46) |
Dec
(26) |
| 2005 |
Jan
(48) |
Feb
(93) |
Mar
(41) |
Apr
(57) |
May
(38) |
Jun
(42) |
Jul
(22) |
Aug
(65) |
Sep
(20) |
Oct
(19) |
Nov
(67) |
Dec
(34) |
| 2006 |
Jan
(35) |
Feb
(11) |
Mar
(24) |
Apr
(30) |
May
(12) |
Jun
(11) |
Jul
(15) |
Aug
(14) |
Sep
(16) |
Oct
(21) |
Nov
(14) |
Dec
(11) |
| 2007 |
Jan
(29) |
Feb
(22) |
Mar
(27) |
Apr
(127) |
May
(12) |
Jun
(44) |
Jul
(44) |
Aug
(8) |
Sep
(6) |
Oct
(52) |
Nov
(17) |
Dec
(16) |
| 2008 |
Jan
(25) |
Feb
(14) |
Mar
(21) |
Apr
(15) |
May
(5) |
Jun
(13) |
Jul
(42) |
Aug
(31) |
Sep
(21) |
Oct
(6) |
Nov
(9) |
Dec
(24) |
| 2009 |
Jan
(8) |
Feb
(16) |
Mar
(183) |
Apr
(586) |
May
(8) |
Jun
(4) |
Jul
(12) |
Aug
(7) |
Sep
(7) |
Oct
(12) |
Nov
(8) |
Dec
(3) |
| 2010 |
Jan
(42) |
Feb
(1) |
Mar
(10) |
Apr
(1) |
May
(10) |
Jun
(12) |
Jul
(7) |
Aug
(25) |
Sep
(47) |
Oct
(45) |
Nov
(11) |
Dec
(19) |
| 2011 |
Jan
(4) |
Feb
(4) |
Mar
(6) |
Apr
(5) |
May
(11) |
Jun
(8) |
Jul
(14) |
Aug
(4) |
Sep
(8) |
Oct
(17) |
Nov
(42) |
Dec
(13) |
| 2012 |
Jan
(21) |
Feb
(20) |
Mar
(5) |
Apr
(10) |
May
(5) |
Jun
(4) |
Jul
(14) |
Aug
(3) |
Sep
(6) |
Oct
(11) |
Nov
(29) |
Dec
(6) |
| 2013 |
Jan
(9) |
Feb
(3) |
Mar
(8) |
Apr
(5) |
May
(6) |
Jun
(4) |
Jul
|
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2014 |
Jan
|
Feb
|
Mar
(1) |
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: SourceForge.net <no...@so...> - 2012-11-04 13:26:55
|
Bugs item #3570272, was opened at 2012-09-20 16:38 Message generated for change (Comment added) made by ioguix You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: 5.0.3 Status: Closed Resolution: Fixed Priority: 5 Private: No Submitted By: Dante Lopez (dqlopez) Assigned to: J.Guillaume (ioguix) de Rorthais (ioguix) Summary: pg_tablespace.spclocation column removed in 9.2 Initial Comment: phpPgAdmin 5.0.3 (PHP 5.4.6-2~precise+1) Can't create database/table/schema on the current build if used with Postgres 9.2. Refer to this mailing list issues: http://archives.postgresql.org/pgsql-bugs/2012-06/msg00203.php http://archives.postgresql.org/pgsql-bugs/2012-06/msg00202.php http://archives.postgresql.org/pgsql-bugs/2012-06/msg00201.php http://archives.postgresql.org/pgadmin-hackers/2012-04/msg00045.php SQL error: ERROR: column "spclocation" does not exist LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio... ^ In statement: SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation, (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname ---------------------------------------------------------------------- >Comment By: J.Guillaume (ioguix) de Rorthais (ioguix) Date: 2012-11-04 05:26 Message: Guys, You should use the latest snpashot of PPA instead of patching it. ---------------------------------------------------------------------- Comment By: https://www.google.com/accounts () Date: 2012-10-25 05:57 Message: peterireds, You missed one thing. Change in Postgres92.php FROM: class Postgres84 extends Postgres { var $major_version = 8.4; TO: class Postgres92 extends Postgres { var $major_version = 9.2; It completes the fix. Cesar ---------------------------------------------------------------------- Comment By: J.Guillaume (ioguix) de Rorthais (ioguix) Date: 2012-10-08 05:55 Message: ...Or just download the snapshot of the current dev branch: https://github.com/phppgadmin/phppgadmin/zipball/master ---------------------------------------------------------------------- Comment By: Peter Hfer (peterireds) Date: 2012-10-06 14:11 Message: Quick Fix: (worked with my Version (5.0.3) / pg 9.2.1 ) 1) change to /classes/database 2) copy "Postgres84.php" to "Postgres92.php" 3) open Connection.php 4) add a line case '9.2': return 'Postgres92'; break; at // Detect version and choose appropriate database driver - switch 5) open "Postgres.php" & copy functions "getTablespaces" + "getTablespace" 6) open "Postgres92.php" paste functions into the class 7) replace ", spclocation," with ", pg_tablespace_location(oid) as spclocation," in both functions regards Peter ---------------------------------------------------------------------- Comment By: J.Guillaume (ioguix) de Rorthais (ioguix) Date: 2012-09-21 10:18 Message: Hello, phpPgAdmin 5.0 is officialy not compatible with pg 9.2. This regression has been fixed in our current development branch of phpPgAdmin. The next release of phpPgAdmin should be released soon. Thank you for your bug report. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&group_id=37132 |
|
From: SourceForge.net <no...@so...> - 2012-10-30 14:06:31
|
The following forum message was posted by hapeter at http://sourceforge.net/projects/phppgadmin/forums/forum/115883/topic/6091422: Same in dataexport.php line 88: --- header('Content-Type: text/plain; charset="'.$data->codemap[$dbEncoding].'"'); --- Peter |
|
From: SourceForge.net <no...@so...> - 2012-10-30 14:05:30
|
The following forum message was posted by hapeter at http://sourceforge.net/projects/phppgadmin/forums/forum/115883/topic/6091422: Hi, dump does not use database incoding in dbexport.php. Possible solution: line 43: --- header('Content-Type: text/plain; charset="'.$data->codemap[$dbEncoding].'"'); --- line 136: --- $cmd .= ' -E '.$dbEncoding; --- Bests, Peter |
|
From: SourceForge.net <no...@so...> - 2012-10-25 12:57:17
|
Bugs item #3570272, was opened at 2012-09-20 16:38 Message generated for change (Comment added) made by You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: 5.0.3 Status: Closed Resolution: Fixed Priority: 5 Private: No Submitted By: Dante Lopez (dqlopez) Assigned to: J.Guillaume (ioguix) de Rorthais (ioguix) Summary: pg_tablespace.spclocation column removed in 9.2 Initial Comment: phpPgAdmin 5.0.3 (PHP 5.4.6-2~precise+1) Can't create database/table/schema on the current build if used with Postgres 9.2. Refer to this mailing list issues: http://archives.postgresql.org/pgsql-bugs/2012-06/msg00203.php http://archives.postgresql.org/pgsql-bugs/2012-06/msg00202.php http://archives.postgresql.org/pgsql-bugs/2012-06/msg00201.php http://archives.postgresql.org/pgadmin-hackers/2012-04/msg00045.php SQL error: ERROR: column "spclocation" does not exist LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio... ^ In statement: SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation, (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname ---------------------------------------------------------------------- Comment By: https://www.google.com/accounts () Date: 2012-10-25 05:57 Message: peterireds, You missed one thing. Change in Postgres92.php FROM: class Postgres84 extends Postgres { var $major_version = 8.4; TO: class Postgres92 extends Postgres { var $major_version = 9.2; It completes the fix. Cesar ---------------------------------------------------------------------- Comment By: J.Guillaume (ioguix) de Rorthais (ioguix) Date: 2012-10-08 05:55 Message: ...Or just download the snapshot of the current dev branch: https://github.com/phppgadmin/phppgadmin/zipball/master ---------------------------------------------------------------------- Comment By: Peter Hfer (peterireds) Date: 2012-10-06 14:11 Message: Quick Fix: (worked with my Version (5.0.3) / pg 9.2.1 ) 1) change to /classes/database 2) copy "Postgres84.php" to "Postgres92.php" 3) open Connection.php 4) add a line case '9.2': return 'Postgres92'; break; at // Detect version and choose appropriate database driver - switch 5) open "Postgres.php" & copy functions "getTablespaces" + "getTablespace" 6) open "Postgres92.php" paste functions into the class 7) replace ", spclocation," with ", pg_tablespace_location(oid) as spclocation," in both functions regards Peter ---------------------------------------------------------------------- Comment By: J.Guillaume (ioguix) de Rorthais (ioguix) Date: 2012-09-21 10:18 Message: Hello, phpPgAdmin 5.0 is officialy not compatible with pg 9.2. This regression has been fixed in our current development branch of phpPgAdmin. The next release of phpPgAdmin should be released soon. Thank you for your bug report. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&group_id=37132 |
|
From: SourceForge.net <no...@so...> - 2012-10-24 01:37:34
|
Bugs item #3579602, was opened at 2012-10-23 18:32 Message generated for change (Comment added) made by skrapion You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3579602&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Tables Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Rick Yorgason (skrapion) Assigned to: Nobody/Anonymous (nobody) Summary: escapeBytea returns "x" for blank strings Initial Comment: When selecting from a table with a bytea field, the field is automatically filled with a single "x" character, meaning you have to clear it before an actual selection will work. The problem is a result of the call to pg_escape_bytea in Postgres::escapeBytea (classes/database/Postgres.php). For some reason, when pg_escape_bytea("") is called in this function, it returns "\\x". The confusing part is that if I write a script that does nothing but print the output of pg_escape_bytea(""), it returns an empty string as expected. I haven't figured out what phpPgAdmin does to alter the behaviour of this function. I'm currently using phpPgAdmin 5.0.3-1, PostgreSQL 9.1+129ubuntu1, Apache 2.2.22-1ubuntu1, and php 5.3.10-1ubuntu3.4 under Ubuntu 12.04.1 LTS. ---------------------------------------------------------------------- >Comment By: Rick Yorgason (skrapion) Date: 2012-10-23 18:37 Message: I just realized my first sentence might be confusing since I'm using the term 'field' in two different ways. What I meant to say is, if you have a table with a bytea field and try to use the 'Select' action on it (ie tables.php?action=confselectrows), it fills the textarea next to the bytea column with an 'x' character. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3579602&group_id=37132 |
|
From: SourceForge.net <no...@so...> - 2012-10-24 01:32:59
|
Bugs item #3579602, was opened at 2012-10-23 18:32 Message generated for change (Tracker Item Submitted) made by skrapion You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3579602&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Tables Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Rick Yorgason (skrapion) Assigned to: Nobody/Anonymous (nobody) Summary: escapeBytea returns "x" for blank strings Initial Comment: When selecting from a table with a bytea field, the field is automatically filled with a single "x" character, meaning you have to clear it before an actual selection will work. The problem is a result of the call to pg_escape_bytea in Postgres::escapeBytea (classes/database/Postgres.php). For some reason, when pg_escape_bytea("") is called in this function, it returns "\\x". The confusing part is that if I write a script that does nothing but print the output of pg_escape_bytea(""), it returns an empty string as expected. I haven't figured out what phpPgAdmin does to alter the behaviour of this function. I'm currently using phpPgAdmin 5.0.3-1, PostgreSQL 9.1+129ubuntu1, Apache 2.2.22-1ubuntu1, and php 5.3.10-1ubuntu3.4 under Ubuntu 12.04.1 LTS. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3579602&group_id=37132 |
|
From: <hir...@gm...> - 2012-10-20 06:16:27
|
The following data was submitted on 2012/10/20 06:16. ====== E-mail ====== Name Hiron PostgreSQL ver. 9.1.3-1 phpPgAdmin ver. 5.0.4 Comments Sir, I am unable to export the struture of a table via export tab. It shows the foloowing error "Export error: Failed to execute pg_dump (given path in your conf/config.inc.php : D:\wamp\www\phpPgAdmin-5.0.4\pg_dump). Please, fix this path in your configuration and relog." |
|
From: SourceForge.net <no...@so...> - 2012-10-12 12:29:45
|
The following forum message was posted by m4dm4rtig4n at http://sourceforge.net/projects/phppgadmin/forums/forum/115883/topic/6013775: Hi, I currently install version 5.1 phpPgAdmin because my postgres server is version 9.2 and I want to know if the new stable version is expected soon? Thanx, Sincerely. |
|
From: SourceForge.net <no...@so...> - 2012-10-08 12:55:27
|
Bugs item #3570272, was opened at 2012-09-20 16:38 Message generated for change (Comment added) made by ioguix You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: 5.0.3 Status: Closed Resolution: Fixed Priority: 5 Private: No Submitted By: Dante Lopez (dqlopez) Assigned to: J.Guillaume (ioguix) de Rorthais (ioguix) Summary: pg_tablespace.spclocation column removed in 9.2 Initial Comment: phpPgAdmin 5.0.3 (PHP 5.4.6-2~precise+1) Can't create database/table/schema on the current build if used with Postgres 9.2. Refer to this mailing list issues: http://archives.postgresql.org/pgsql-bugs/2012-06/msg00203.php http://archives.postgresql.org/pgsql-bugs/2012-06/msg00202.php http://archives.postgresql.org/pgsql-bugs/2012-06/msg00201.php http://archives.postgresql.org/pgadmin-hackers/2012-04/msg00045.php SQL error: ERROR: column "spclocation" does not exist LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio... ^ In statement: SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation, (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname ---------------------------------------------------------------------- Comment By: J.Guillaume (ioguix) de Rorthais (ioguix) Date: 2012-10-08 05:55 Message: ...Or just download the snapshot of the current dev branch: https://github.com/phppgadmin/phppgadmin/zipball/master ---------------------------------------------------------------------- Comment By: Peter Hfer (peterireds) Date: 2012-10-06 14:11 Message: Quick Fix: (worked with my Version (5.0.3) / pg 9.2.1 ) 1) change to /classes/database 2) copy "Postgres84.php" to "Postgres92.php" 3) open Connection.php 4) add a line case '9.2': return 'Postgres92'; break; at // Detect version and choose appropriate database driver - switch 5) open "Postgres.php" & copy functions "getTablespaces" + "getTablespace" 6) open "Postgres92.php" paste functions into the class 7) replace ", spclocation," with ", pg_tablespace_location(oid) as spclocation," in both functions regards Peter ---------------------------------------------------------------------- Comment By: J.Guillaume (ioguix) de Rorthais (ioguix) Date: 2012-09-21 10:18 Message: Hello, phpPgAdmin 5.0 is officialy not compatible with pg 9.2. This regression has been fixed in our current development branch of phpPgAdmin. The next release of phpPgAdmin should be released soon. Thank you for your bug report. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&group_id=37132 |
|
From: SourceForge.net <no...@so...> - 2012-10-06 21:11:44
|
Bugs item #3570272, was opened at 2012-09-20 16:38 Message generated for change (Comment added) made by You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: 5.0.3 Status: Closed Resolution: Fixed Priority: 5 Private: No Submitted By: Dante Lopez (dqlopez) Assigned to: J.Guillaume (ioguix) de Rorthais (ioguix) Summary: pg_tablespace.spclocation column removed in 9.2 Initial Comment: phpPgAdmin 5.0.3 (PHP 5.4.6-2~precise+1) Can't create database/table/schema on the current build if used with Postgres 9.2. Refer to this mailing list issues: http://archives.postgresql.org/pgsql-bugs/2012-06/msg00203.php http://archives.postgresql.org/pgsql-bugs/2012-06/msg00202.php http://archives.postgresql.org/pgsql-bugs/2012-06/msg00201.php http://archives.postgresql.org/pgadmin-hackers/2012-04/msg00045.php SQL error: ERROR: column "spclocation" does not exist LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio... ^ In statement: SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation, (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname ---------------------------------------------------------------------- Comment By: https://www.google.com/accounts () Date: 2012-10-06 14:11 Message: Quick Fix: (worked with my Version (5.0.3) / pg 9.2.1 ) 1) change to /classes/database 2) copy "Postgres84.php" to "Postgres92.php" 3) open Connection.php 4) add a line case '9.2': return 'Postgres92'; break; at // Detect version and choose appropriate database driver - switch 5) open "Postgres.php" & copy functions "getTablespaces" + "getTablespace" 6) open "Postgres92.php" paste functions into the class 7) replace ", spclocation," with ", pg_tablespace_location(oid) as spclocation," in both functions regards Peter ---------------------------------------------------------------------- Comment By: J.Guillaume (ioguix) de Rorthais (ioguix) Date: 2012-09-21 10:18 Message: Hello, phpPgAdmin 5.0 is officialy not compatible with pg 9.2. This regression has been fixed in our current development branch of phpPgAdmin. The next release of phpPgAdmin should be released soon. Thank you for your bug report. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&group_id=37132 |
|
From: SourceForge.net <no...@so...> - 2012-10-05 09:03:42
|
The following forum message was posted by xantis at http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/5401353: PHP 5.4 have the PHP.INI strict standards ... By default, PHP 4.4.9 ... 5.3.x have only E_ALL & ~E_NOTICE Adding the ~E_STRICT & ~E_DEPRECATED after the E_ALL & ~E_NOTICE tells PHP to suppress warning if the PHP code does not use STRICT STANDARDS ... Code runs anyway, without strict standards ;-) add the following line of code (in the top, next line after the <?php to: conf/config.inc.php error_reporting(E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED); |
|
From: SourceForge.net <no...@so...> - 2012-10-01 01:00:21
|
Bugs item #3573308, was opened at 2012-09-30 18:00 Message generated for change (Tracker Item Submitted) made by kpinc You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3573308&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: Yes Submitted By: Karl O. Pinc (kpinc) Assigned to: Nobody/Anonymous (nobody) Summary: Password change process is insecure Initial Comment: An attacker who is physically present can change a user's Postgres password. To thwart this attack phpPgAdmin should require re-authentication from the user before accepting a new password. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3573308&group_id=37132 |
|
From: SourceForge.net <no...@so...> - 2012-09-21 17:19:12
|
Bugs item #3570272, was opened at 2012-09-20 16:38 Message generated for change (Settings changed) made by ioguix You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: 5.0.3 Status: Closed Resolution: Fixed Priority: 5 Private: No Submitted By: Dante Lopez (dqlopez) Assigned to: J.Guillaume (ioguix) de Rorthais (ioguix) Summary: pg_tablespace.spclocation column removed in 9.2 Initial Comment: phpPgAdmin 5.0.3 (PHP 5.4.6-2~precise+1) Can't create database/table/schema on the current build if used with Postgres 9.2. Refer to this mailing list issues: http://archives.postgresql.org/pgsql-bugs/2012-06/msg00203.php http://archives.postgresql.org/pgsql-bugs/2012-06/msg00202.php http://archives.postgresql.org/pgsql-bugs/2012-06/msg00201.php http://archives.postgresql.org/pgadmin-hackers/2012-04/msg00045.php SQL error: ERROR: column "spclocation" does not exist LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio... ^ In statement: SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation, (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname ---------------------------------------------------------------------- Comment By: J.Guillaume (ioguix) de Rorthais (ioguix) Date: 2012-09-21 10:18 Message: Hello, phpPgAdmin 5.0 is officialy not compatible with pg 9.2. This regression has been fixed in our current development branch of phpPgAdmin. The next release of phpPgAdmin should be released soon. Thank you for your bug report. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&group_id=37132 |
|
From: SourceForge.net <no...@so...> - 2012-09-21 17:18:24
|
Bugs item #3570272, was opened at 2012-09-20 16:38 Message generated for change (Comment added) made by ioguix You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: 5.0.3 >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Dante Lopez (dqlopez) >Assigned to: J.Guillaume (ioguix) de Rorthais (ioguix) Summary: pg_tablespace.spclocation column removed in 9.2 Initial Comment: phpPgAdmin 5.0.3 (PHP 5.4.6-2~precise+1) Can't create database/table/schema on the current build if used with Postgres 9.2. Refer to this mailing list issues: http://archives.postgresql.org/pgsql-bugs/2012-06/msg00203.php http://archives.postgresql.org/pgsql-bugs/2012-06/msg00202.php http://archives.postgresql.org/pgsql-bugs/2012-06/msg00201.php http://archives.postgresql.org/pgadmin-hackers/2012-04/msg00045.php SQL error: ERROR: column "spclocation" does not exist LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio... ^ In statement: SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation, (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname ---------------------------------------------------------------------- >Comment By: J.Guillaume (ioguix) de Rorthais (ioguix) Date: 2012-09-21 10:18 Message: Hello, phpPgAdmin 5.0 is officialy not compatible with pg 9.2. This regression has been fixed in our current development branch of phpPgAdmin. The next release of phpPgAdmin should be released soon. Thank you for your bug report. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&group_id=37132 |
|
From: SourceForge.net <no...@so...> - 2012-09-20 23:38:20
|
Bugs item #3570272, was opened at 2012-09-20 16:38 Message generated for change (Tracker Item Submitted) made by dqlopez You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: 5.0.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Dante Lopez (dqlopez) Assigned to: Nobody/Anonymous (nobody) Summary: pg_tablespace.spclocation column removed in 9.2 Initial Comment: phpPgAdmin 5.0.3 (PHP 5.4.6-2~precise+1) Can't create database/table/schema on the current build if used with Postgres 9.2. Refer to this mailing list issues: http://archives.postgresql.org/pgsql-bugs/2012-06/msg00203.php http://archives.postgresql.org/pgsql-bugs/2012-06/msg00202.php http://archives.postgresql.org/pgsql-bugs/2012-06/msg00201.php http://archives.postgresql.org/pgadmin-hackers/2012-04/msg00045.php SQL error: ERROR: column "spclocation" does not exist LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio... ^ In statement: SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation, (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&group_id=37132 |
|
From: Jehan-Guillaume (i. de R. <io...@fr...> - 2012-09-17 08:11:05
|
On 17/09/2012 09:55, eye...@gm... wrote: > The following data was submitted on 2012/09/17 07:55. > > ====== E-mail ====== > > Name > Panos Katertziadis > PostgreSQL ver. > 8.4.13 > phpPgAdmin ver. > 5.0.4 > Comments > Hello. I wish that phpPGadmin would "spit out" the sql it uses for perfoming tasks like creation of a table (or anything else). I just migrated from mySQL and phpMYadmin (which has the feature) and i think that such "spitting" can certainly aid to better understanding of the PostgreSQL idiosyncracies. If the feature is already available, please point me to it. Kind Regards, Panos. Hello, this feature is not available and would require a lot of work in PPA. However, it's been a while I am thinking about refactoring some parts of PPA that would maker this easier to accomplish. Anyway, if you want to learn more about PostgreSQL SQL syntaxe, it's simple: it follows the official SQL specs. You can also use "\h SQL COMMAND" (ie. \h ALTER TABLE) in psql, or just check the PostgreSQL doc which is really good. Cheers, |
|
From: <eye...@gm...> - 2012-09-17 07:55:22
|
The following data was submitted on 2012/09/17 07:55. ====== E-mail ====== Name Panos Katertziadis PostgreSQL ver. 8.4.13 phpPgAdmin ver. 5.0.4 Comments Hello. I wish that phpPGadmin would "spit out" the sql it uses for perfoming tasks like creation of a table (or anything else). I just migrated from mySQL and phpMYadmin (which has the feature) and i think that such "spitting" can certainly aid to better understanding of the PostgreSQL idiosyncracies. If the feature is already available, please point me to it. Kind Regards, Panos. |
|
From: <sh...@ip...> - 2012-09-10 14:52:30
|
The following data was submitted on 2012/09/10 14:52.
====== E-mail ======
Name
Sebastian Hahn
PostgreSQL ver.
PostgreSQL 8.3.18
phpPgAdmin ver.
phpPgAdmin 5.0.4 (PHP 5.3.8)
Comments
Dear Developers,
I always get an error message using the command:
SQL error:
ERROR: syntax error at or near "\"
LINE 1: COPY warp_grid (id,cell,ind_ld,ind_l,geog) FROM \'/srv/www/h...
^
In statement:
COPY warp_grid (id,cell,ind_ld,ind_l,geog) FROM \'/srv/www/htdocs/radar/warp_grid_insert.txt\' WITH DELIMITER AS \',\';
The original query looks like:
COPY warp_grid (id,cell,ind_ld,ind_l,geog) FROM '/srv/www/htdocs/radar/warp_grid_insert.txt' WITH DELIMITER AS ',';
Why does phpPgAdmin add \ ? Why do I get the error msg? What needs to be changed? Thanks in advance!
Best regards,
Sebastian
|
|
From: <csn...@cs...> - 2012-08-22 18:58:49
|
The following data was submitted on 2012/08/22 18:58. ====== E-mail ====== Name csnupusx PostgreSQL ver. csnupusx phpPgAdmin ver. csnupusx Comments help request register |
|
From: Jehan-Guillaume (i. de R. <io...@fr...> - 2012-08-06 13:12:48
|
Hello, phpPgAdmin is not compatible with PostgreSQL 9.2 yet, so some features might not work...like creating database. Cheers, On 06/08/2012 12:08, egi...@sp... wrote: > The following data was submitted on 2012/08/06 10:08. > > > > ====== E-mail ====== > > Name > Egidijus > PostgreSQL ver. > PostgreSQL 9.2beta2 > phpPgAdmin ver. > phpPgAdmin 5.0.4 > Comments > Hello, > > I create PostgreSQL user with privileges: Superuser, Create DB, Can create role and etc. > When I try create database or table I'm getting these messages: > > --------------------------------------------------------------------- > SQL error: > > ERROR: column "spclocation" does not exist > LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio... > ^ > In statement: > > SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation, > (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment > FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname > > --------------------------------------------------------------------- > > Fatal error: > > Call to a member function recordCount() on a non-object in /phpPgAdmin/all_db.php on line 233 > > --------------------------------------------------------------------- > > What can you suggest for me? Can it be a bug of phpPgAdmin ? > Thanks in advance for your answer. > > Best regards, > Egidijus > |
|
From: <egi...@sp...> - 2012-08-06 10:08:35
|
The following data was submitted on 2012/08/06 10:08.
====== E-mail ======
Name
Egidijus
PostgreSQL ver.
PostgreSQL 9.2beta2
phpPgAdmin ver.
phpPgAdmin 5.0.4
Comments
Hello,
I create PostgreSQL user with privileges: Superuser, Create DB, Can create role and etc.
When I try create database or table I'm getting these messages:
---------------------------------------------------------------------
SQL error:
ERROR: column "spclocation" does not exist
LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio...
^
In statement:
SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation,
(SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment
FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname
---------------------------------------------------------------------
Fatal error:
Call to a member function recordCount() on a non-object in /phpPgAdmin/all_db.php on line 233
---------------------------------------------------------------------
What can you suggest for me? Can it be a bug of phpPgAdmin ?
Thanks in advance for your answer.
Best regards,
Egidijus
|
|
From: SourceForge.net <no...@so...> - 2012-07-28 07:19:05
|
Bugs item #3550565, was opened at 2012-07-28 00:19 Message generated for change (Tracker Item Submitted) made by df7cb You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3550565&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: General Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Christoph Berg (df7cb) Assigned to: Nobody/Anonymous (nobody) Summary: Some text badly truncated or not shown at all Initial Comment: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=682954 I've received a report from a Debian user where text in some table (see the screenshot) got truncated, apparently in the middle of some utf8 character. Some other cell is reported as being empty where it should have some content. -------------- Date: Fri, 27 Jul 2012 11:35:25 +0200 From: Csanyi Pal <csa...@gm...> Subject: Bug#682954: [phppgadmin] The phpPgAdmin displays table data poorly Package: phppgadmin Version: 5.0.4-1 Severity: important Hi, in the Table Browse view some of the datas are poorly displayed. What I'm mean here is visible if one download the image of this display problem from here (one must click on the download icon): http://cspl.me/joomla/index.php/itt-helyben/kepek I can try to explain the problem here in words. (English isn't my first language.) On the image one can see 9 rows in the Table. All rows are displayed properly but but the second, third and sixth. In the column named 'unnep_neve' phpPgAdmin display the column too strait so one can see the text in the second row as 'A II. világháború szerb áldozatainak emlékna…' in place of the proper text: 'A II. világháború szerb áldozatainak emléknapja'. In the second row in the 'megjegyzes' column one can see empty field, but there should to be the text: 'November 11. a napja, de az vasárnapra esik, ezért hétfőn ünnepeljük meg.' In the sixth row the problem is the same as in the second row, but with different text. So it seems to me that that phpPgAdmin displays Table data poorly because if a text in a column exceeds some length then it can't be seen properly or at all. Certainly in the psql prompt these rows can be seen properly when I run the SELECT statement on this table. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3550565&group_id=37132 |
|
From: SourceForge.net <no...@so...> - 2012-07-16 16:04:13
|
Bugs item #3544661, was opened at 2012-07-16 09:04 Message generated for change (Tracker Item Submitted) made by You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3544661&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: General Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: https://www.google.com/accounts () Assigned to: Nobody/Anonymous (nobody) Summary: phpMyAdmin Chrome Non resizable left column Initial Comment: The left column is not resizeable under Chrome version 20.0. The fix consists in edit the frameborder in the index.php file. See http://www.edmondscommerce.co.uk/php/phpmyadmin-chrome-resizable-left-column-solution/ ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3544661&group_id=37132 |
|
From: SourceForge.net <no...@so...> - 2012-07-14 05:22:46
|
The following forum message was posted by at http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/5415566: The problem went away when I set extra_login_security to false in config.inc.php and restarted PostgreSQL. Hopefully, that has ended the problem. |
|
From: SourceForge.net <no...@so...> - 2012-07-14 05:21:04
|
The following forum message was posted by at http://sourceforge.net/projects/phppgadmin/forums/forum/115884/topic/5406562: The problem went away when I set extra_login_security to false in config.inc.php and restarted PostgreSQL. Hopefully, that has ended the problem. |
667 messages has been excluded from this view by a project administrator.
