[Squirrel-sql-users] Possible bug in 'drop' function

[Denis G. <dgr...@we...>]

Hi,

I think I've stumbled on a bug in squirrel 1.1-Final
when accessing a Postgres 7.3.2 database.
To reproduce:

1. Create a view in a database

2. Refresh the Objects tree.
   (The new view appears under 'View')

3. Right click on the view name and select 'Drop'

4. A confirmation popup opens with "Are you sure?"

5. Execute the drop

6. The following error message appears:  
   java.sql.SQLException: ERROR:  "<Your-View-Name>" is not a table. 
   Use DROP VIEW to remove a view

7. The view is not removed.

cheers,
Denis


Denis Grannell, Kapuzinerstr. 45, D-80469 Muenchen
Tel: +49 89 201 3672          Fax: +49 89 202 2875
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/