On Friday, April 01, 2011 05:16:53 am enrico secco wrote:
> I start to think to export the data with a 'low level' system. I open a
> simple psycopg connection to insert the data. Could be is un-elegant but I
> resolve.
Should you decide to use direct inserts then you can still do so from dabo.
tempCur = self.PrimaryBizobj.getTempCursor()
tempCur.execute("insert into table (someval,moreval) values (%s, '%s')" %
(codeval,morecodeval))
I'm really not sure why you are unable to save using the standard way. I have
created similar programs several times having moved MsSQL data over to
Postgres more than once. One difference is I have always used serial data
types for my PK's. But I would think you would have seen a different error
message if the PK was the trouble.
Maybe if you provided some of the code or an example of the code we can see
what might be going wrong.
One more thought - are there any triggers, FK's, or indexes that could be
preventing the insert from completing? I have seen where older copies of
Postgres or Psycopg did not return the errors.
Johnf
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/201104010638.44122.jo...@jfcomputer.com
