Expand my Community achievements bar.

Adobe Campaign User Groups are live now. Join our Adobe Campaign User Groups and connect with your local leaders!

Cursor sql error on postgres FDA table

Avatar

Level 2

I'm connecting to a postgres database on AWS via FDA but getting errors on the primary key.

The table is called transactions and has an attribute called betId as a unique primary key field.

When I access the data in the table (via schema data view) I either get an error that primary key needs to be defined or when I define betId as primary key a sql error for cursor:
ERROR: column a0.betid does not exist.

'SELECT A0.betId FROM adobe.transactions A0 LIMIT 200' could not be executed.

 

Schema definition:
<key internal="true" name="pid" noDbIndex="true">
  <keyfield xpath="@id"/>
</key>
<attribute advanced="false" label="betId" name="id" length="16" sqlname="betId" type="string"/>

1 Reply

Avatar

Level 3

Hi @PLundmark 

Adobe Campaign is case sensitive, so it seems "A0.betId" is not same for Adobe as "a0.betId".

Maybe you can check your database configuration to solve it.