Menu

#1371 SQuirreL cannot handle deleted column with PostgreSQL driver

SQuirreL
open
nobody
None
5
2018-11-28
2018-11-28
Ken Huffman
No

I have SQuirreL 3.90 pointing to a PostgreSQL database where I have run an "alter table drop column". This unfortunately upsets SQuirrel when it attempts to read the meta-data and I get a pop-up "Error occurred during task execution: null"

(FWIW, PostgreSQL keeps info on deleted columns in its pg_attribute table where atttypid = 0. I'm surprised the getColumns() of postgresql's driver wouldn't handle it. Perhaps in the way it is called?)

Caused by: java.lang.NullPointerException
at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getColumns(AbstractJdbc2DatabaseMetaData.java:2520)
at org.postgresql.jdbc3.AbstractJdbc3DatabaseMetaData.getColumns(AbstractJdbc3DatabaseMetaData.java:373)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumns(SQLDatabaseMetaData.java:1760)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumns(SQLDatabaseMetaData.java:1774)
at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.ColumnsTab.createDataSet(ColumnsTab.java:69)
at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:131)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:748)

Discussion


Log in to post a comment.