DBInputTable, Postgres and functions.

newscientist

• December 10, 2010 00:00

• Answered

Follow

I am using Community Edition and Postgresql 8.4.

In an earlier post it was established that a Postgresql query such as: 'select * from myFunc();' cannot be used in DBExecute component, only in a DBInputTable component.

However, when I enter the above query, I get: Node DB_INPUT_TABLE0 finished with status: ERROR caused by: org.postgresql.util.PSQLException: ERROR: transaction is read-only

I have not set transactions to read-only and cannot set the transaction to read-write in DBInputTable.

How do I get round this?


Regards
Chris

• 

  avackova

  • December 13, 2010 09:44

  0

  Comment actions Permalink

  Hello Chris,
  I can't reproduce the problem. select from function is properly executed, as well as executing the function, that returns a result set (see ExtExamples/graph/graphDBExecutePostgre.grf from our examples).
  Does the problem occur when trying to read data from the table also?
• 

  julrych

  • December 14, 2010 14:27

  0

  Comment actions Permalink

  Hi Chris,
  An issue may occur if myFunc() attempts to write/update a table because the select statement set the transaction as read-only. What does your myFunc() actually do?
• 

  starsailor

  • March 18, 2014 14:32

  0

  Comment actions Permalink

  Was this issue ever resolved?
  
  I'm asking now because I have the same problem now with DBInputTable when trying to select from certain OOB Vertica 6.1 functions like:
  
  select analyze_statistics('sometable');
  
  where DBInput table errors because the connnection is set to read-only mode and I can't get DBExecute to process it because the statement has a result set that causes DBExecute to error too.
• 

  admin

  • March 19, 2014 12:04

  0

  Comment actions Permalink

  Hi,
  
  This issue seems to be related to Vertica JDBC specific, please see viewtopic.php?f=4&t=6781#p10822 for details.

Please sign in to leave a comment.