Greenplum ERROR : relation sequence_tablename does not exist

Question

Executing a Query from C# code to PostgreSQL

INSERT INTO SCHEMA_NAME.Table_name(c1) values (nextval(\'sequence_name\'));

Working If I manually add any int value in the place of nextval() & also query working if I run on DB directly

Answer 1

Like your error says, you do not have a sequence created for this table.

Something in this direction would probably work...

CREATE SEQUENCE sequence_tablename INCREMENT 1 START 1;

Answer 2

I needed to add schema name before nextval() like nextval(schema_name."sequence_name")