Sure, that's the problem. We wanted to rename the "viewid" column but renaming primary keys is tricky when using hibernate.
We must include a drop constraint on that foreign key, let me know if you remember the name of it. Lars On Thu, Aug 28, 2014 at 10:13 AM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > That does not work, but this does (CAREFUL WITH THIS ONE) > > alter table sqlview drop column viewid CASCADE; > > There is a foreign key reference to some other table, but cannot recall > which one it was. Something to do with users I think. > > Regards, > Jason > > > > On Thu, Aug 28, 2014 at 10:10 AM, Lars Helge Øverland <larshe...@gmail.com > > wrote: > >> Hi Jason, >> >> can you execute this on your db and see if the query fails, if so provide >> the log? >> >> alter table sqlview drop column viewid; >> >> regards, >> >> Lars >> >> >> >> On Thu, Aug 28, 2014 at 9:43 AM, Jason Pickering < >> jason.p.picker...@gmail.com> wrote: >> >>> Looks like there was an attempt to fix this in rev 14845, but still not >>> working for me. >>> >>> We are using >>> >>> Version:2.16 Build revision:16370 >>> Probably could be hacked rather easily, but not sure if things are still >>> not fixed properly in the startup routines? >>> Regards,Jason >>> Caused by: org.postgresql.util.PSQLException: ERROR: null value in >>> column "viewid" violates not-null constraint >>> Detail: Failing row contains (null, test sql view, , SELECT uid, name >>> from organisationunit LIMIT 10;, bMTwKD2Vpe0, null, 2014-08-28 >>> 07:41:46.921, 4511, 2014-08-28 07:41:46.921, 2361, rw------). >>> at >>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161) >>> at >>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890) >>> at >>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) >>> at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560) >>> at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) >>> at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) >>> at >>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) >>> at >>> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133) >>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-devs@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
