Why Are There Errors When Inserting Data into PostgreSQL?
Description
This document addresses special considerations when GenRocket SQLInsertReceivers are used to insert data into a PostgreSQL database table.
The Errors
The following error(s) may be received when attempting to insert test data into PostgreSQL:
column "columnName" of relation "relation name" does not existcolumn "columnName" does not existReason for Errors
PostgreSQL follows SQL standards, and identifiers such as table names/column names are forced to lowercase unless surrounded by double quotes.
Example 1 (Without Quotes)
APP_USER becomes app_user
Example 2 (With Quotes)
"APP_USER" becomes APP_USER
The Solution
To resolve this issue, users can try with double quotes or change all column names within the Receiver's Attribute Property Keys to lowercase.
Article Feedback: Was this helpful?
Give feedback