Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#1081 Postgres UUID fields not working

All
open
nobody
None
5
2013-07-28
2013-04-23
No

Results that contain native UUIDs in postgres are not displayed correctly. Specifically the string <Other> is displayed and the ids themselves are not accessible.

Feature request #365 (from 2009) mentions this, but inability to display data properly should be a bug, not a feature request. The proliferation of UUIDs is rendering SquirrelSQL entirely unusable on many databases.

Discussion

  • Hello,
    have similiar issue.

    StackTrace :

    java.lang.IllegalStateException: Dialect (PostgreSQL) doesn't provide a java type for native type = uuid
    at net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect.getJavaTypeForNativeType(CommonHibernateDialect.java:595)
    at net.sourceforge.squirrel_sql.fw.dialects.PostgreSQLDialectExt.getJavaTypeForNativeType(PostgreSQLDialectExt.java:1282)
    at net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect.getTypeName(CommonHibernateDialect.java:581)
    at net.sourceforge.squirrel_sql.fw.dialects.DialectUtils.getCreateTableSQL(DialectUtils.java:1823)
    at net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect.getCreateTableSQL(CommonHibernateDialect.java:299)
    at net.sourceforge.squirrel_sql.plugins.dbdiff.gui.AbstractSideBySideDiffPresentation.execute(AbstractSideBySideDiffPresentation.java:102)
    at net.sourceforge.squirrel_sql.plugins.dbdiff.commands.CompareCommand.execute(CompareCommand.java:62)
    at net.sourceforge.squirrel_sql.plugins.dbdiff.actions.CompareAction.actionPerformed(CompareAction.java:121)
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    at javax.swing.AbstractButton.doClick(Unknown Source)
    at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
    at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
    at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    at java.awt.EventQueue.access$400(Unknown Source)
    at java.awt.EventQueue$2.run(Unknown Source)
    at java.awt.EventQueue$2.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    at java.awt.EventQueue$3.run(Unknown Source)
    at java.awt.EventQueue$3.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)