Hi, Please find the attached patch to fix RM # 3135 - [Web based] Syntax error displayed when user try to insert data on table where primray key is in captial letters and table contains OIDS
Thanks, Khushboo
diff --git a/web/pgadmin/tools/sqleditor/templates/sqleditor/sql/default/insert.sql b/web/pgadmin/tools/sqleditor/templates/sqleditor/sql/default/insert.sql index a4ed872..7e3f8a0 100644 --- a/web/pgadmin/tools/sqleditor/templates/sqleditor/sql/default/insert.sql +++ b/web/pgadmin/tools/sqleditor/templates/sqleditor/sql/default/insert.sql @@ -6,5 +6,5 @@ INSERT INTO {{ conn|qtIdent(nsp_name, object_name) }} ( {% for col in data_to_be_saved %} {% if not loop.first %}, {% endif %}%({{ col }})s::{{ data_type[col] }}{% endfor %} ) -{% if pk_names %} returning {{pk_names}}{% endif %} +{% if pk_names and not has_oids %} returning {{pk_names}}{% endif %} {% if has_oids %} returning oid{% endif %};