Failed to populate indices of table table_name I need to design my PostgreSQL database and I use SQL Power Architect to do it. 

But after I import it to SQL Power Architect and drag the table to workspace, I got error  message : Failed to populate indices of table &lt;table_name&gt;, I explore the error, and got Caused by : org.postgresql.util.PSQLException: ERROR: column i.indproc does not exist. 

Actually I never use column i.indproc in my database, and this error appear when I drag each tables to workspace (for the first time, after I delete the table from workspace and drag it again, the error not appear)

Here the message


  java.lang.RuntimeException: ca.sqlpower.sqlobject.SQLObjectException:
  Failed to populate indices of table login     at
  ca.sqlpower.sqlobject.SQLObject$1.run(SQLObject.java:193)     at
  java.awt.event.InvocationEvent.dispatch(Unknown Source)   at
  java.awt.EventQueue.dispatchEventImpl(Unknown Source)     at
  java.awt.EventQueue.access$500(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.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown
  Source)   at java.awt.EventQueue.dispatchEvent(Unknown Source)    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) Caused by:
  ca.sqlpower.sqlobject.SQLObjectException: Failed to populate indices
  of table login    at
  ca.sqlpower.sqlobject.SQLTable.populateIndices(SQLTable.java:550)     at
  ca.sqlpower.sqlobject.SQLTable.populateColumns(SQLTable.java:369)     at
  ca.sqlpower.sqlobject.SQLTable.populateImpl(SQLTable.java:1335)   at
  ca.sqlpower.sqlobject.SQLObject.populate(SQLObject.java:186)  at
  ca.sqlpower.sqlobject.SQLTable.getChildren(SQLTable.java:1963)    at
  ca.sqlpower.sqlobject.SQLObject.getChildren(SQLObject.java:285)   at
  ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.ensurePopulated(PlayPen.java:1599)
    at
  ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.doStuff(PlayPen.java:1574)
    at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:104)    at
  java.lang.Thread.run(Unknown Source) Caused by:
  org.postgresql.util.PSQLException: ERROR: column i.indproc does not
  exist     at
  org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
    at
  org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
    at
  org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
    at
  org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    at
  org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
    at
  org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:236)     at
  org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getIndexInfo(AbstractJdbc2DatabaseMetaData.java:3735)
    at
  ca.sqlpower.sql.jdbcwrapper.DatabaseMetaDataDecorator.getIndexInfo(DatabaseMetaDataDecorator.java:426)
    at
  ca.sqlpower.sql.jdbcwrapper.PostgresDatabaseMetaDataDecorator.getIndexInfo(PostgresDatabaseMetaDataDecorator.java:173)
    at
  ca.sqlpower.sqlobject.SQLIndex.fetchIndicesForTableAndUpdatePK(SQLIndex.java:827)
    at ca.sqlpower.sqlobject.SQLTable.populateIndices(SQLTable.java:538)
    ... 9 more


Please help me to solve this problem
This very likely is caused by Postgres version support. If you are trying to connect to a Postgres 10 server SQL Power Architect does not support this version. My solution, which is far from perfect, is to run a small older Postgres in my development desktop for ERD purposes. From what I can gather, version 10 support is either unlikely and/or problematic at best.