Can someone help me run Collect on a postgreSQL DB?

Answered

DSP User

• February 28, 2018 13:15

I am attempting to run Collect on a postgreSQL DB and have run into 2 issues.

1. When I run the Collect>TargetSource test connection, I get a network settings error that doesn't occur for any other source.
2. When I try to manually build an assemble package with code that runs in PostgreSQL, I get this error: Error [42601] ERROR: syntax error at or near "[". No query has been executed with that handle...

There are no brackets in my query so they are being put on in the back-end somewhere, but I don't see how to configure that.

1

• Best answer

  

  DSP User

  • February 28, 2018 14:32

  Support helped me with locate where the brackets are configured: Admin > Configuration > Setup > Database Types > {vertical} page

  0
• 

  DSP Expert

  • February 28, 2018 14:03

  EWeldon: Hi Josh, it is most likely coming from the table Design. In Collect,

  1. Navigate to the table.
  2. Click on Vertical View.
  3. Click the General Information tab.
  4. Click View Design.
  5. Click the "SQL" icon. You should see the SQL queries being used to create the table and select against it and any indexes that are defined. That is most likely where the square brackets are coming from.

  0
• 

  DSP Expert

  • February 28, 2018 14:06

  EWeldon: One additional note on this: the Create syntax should stay in T-SQL because it's executed in the DSP environment. The SELECT portion should be written in PostgreSQL syntax.

  0

Please sign in to leave a comment.