[pgadmin-support] Syntax error on Change of Materialized View definition

2016-03-24 Thread Matthew Syphus
Has anyone else noticed this or might it be something particular to my installation? I haven't done much in the way of changing settings or options. Still an issue in pgAdminIII 1.22.1 with Postgres 9.5.1. Both this and 1.22.0 were installed with the EnterpriseDB stack builder. Thanks.

[pgadmin-support] Cannot backspace column data type

2016-03-24 Thread Matthew Syphus
When entering a new column ( [right-click table] > New Object > New Column) or changing an existing column, the data type cannot be backspaced if the auto-suggest kicks in. Nothing happens. It does not allow changing or undoing. I can highlight with the mouse and then press delete or backspac

[pgadmin-support] Cursor jumps to middle of comment field for column

2016-03-24 Thread Matthew Syphus
When tabbing into or clicking on the comment field of column properties (whether adding new or editing) the cursor is shown 5.5 lines down and an inch to the right. Typing goes in as expected, but the cursor always goes back to that odd position. pgAdminIII 1.22.1 Postgres 9.5.1 Windows 7 64-b

[pgadmin-support] Syntax error on Change of Materialized View definition

2016-02-29 Thread Matthew Syphus
I noticed that when changing the query definition of a Materialized View (using the view Properties > Definition tab), it always generates an error: An error has occurred: ERROR: syntax error at or near ")" LINE 3: ) This appears to be due to the addition of the following to the SQL statement: W

[pgadmin-support] No smallserial data type in version 1.16.1

2013-03-13 Thread Matthew Syphus
I have searched and not seen any reference to this issue. I apologize if it has been brought up already. In pgAdmin III version 1.16.1 the smallserial data type is not listed when creating a new column. It works fine when later editing the SQL manually. This was added in Postgres 9.2 http