[ppa-help] [ phppgadmin-Bugs-3612602 ] fail to insert, update via sql box

[SourceForge.net <no...@so...>]

Bugs item #3612602, was opened at 2013-05-03 15:21
Message generated for change (Comment added) made by woodz_
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3612602&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: 5.1
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: woodz (woodz_)
Assigned to: Nobody/Anonymous (nobody)
Summary: fail to insert, update via sql box

Initial Comment:
when I put the command (while "Paginate results" is checked)
  update mytable set id = 6 -- just a simple table, 2 columns are enough, e.g. id as integer and name as varchar
into the SQL box, an error is generated saying:

SQL error:

ERROR:  syntax error at or near "set"
LINE 1: SELECT COUNT(*) AS total FROM (update mytable set dn_id = ...
                                                        ^

In statement:
SELECT COUNT(*) AS total FROM (update mytable set dn_id = 6) AS sub

I can put the command above into an external sql and open by Browse.., that will do.
If I do in SQL box while "Paginate results" is un-checked, it will do also.
Similar results for insert-command.

Thanks for review.
woodz


----------------------------------------------------------------------

>Comment By: woodz (woodz_)
Date: 2013-05-03 15:23

Message:
sorry did a mistake, you need to replace dn_id by id in sql error report

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3612602&group_id=37132