#171 Brak wyświetlania constraintów PG17

[Anonymous]

• System: Windows 10
• Java: Oracle Corporation, 11.0.2
• Baza danych: PostgreSQL 17.4

W widoku tabel w zakładce ograniczenia dla każdej tabeli brak wpisów, a wejście w zakładkę kończy się za każdym razem błędem:

org.postgresql.util.PSQLException: ERROR: CASE types "char" and text cannot be matched
Pozycja: 927
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2733)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2420)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:372)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:517)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:434)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:137)
at pl.mpak.usedb.core.Query.open(Query.java:393)
at pl.mpak.orbada.universal.gui.tabbed.UniversalPropTab.refresh(UniversalPropTab.java:197)
at pl.mpak.orbada.universal.gui.tabbed.UniversalPropTab.refresh(UniversalPropTab.java:220)
at pl.mpak.orbada.gui.OrbadaTabbedPane.refresh(OrbadaTabbedPane.java:80)
at pl.mpak.orbada.gui.OrbadaTabbedPane$2.run(OrbadaTabbedPane.java:95)
at java.desktop/java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:313)
at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:770)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:740)
at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

[Andrzej Kałuża]

Zmiany w orbadzie już nie będą kontynuowane ale akurat ten błąd jakiś czas temu poprawiłem. Podmień sobie załączoną wtyczkę w katalogu plugins

Pozdrawiam