Category: PostgreSQL

PostgreSQL INSERT has more target columns than expressions INSERT has more target columns than expressions in PL/pgSQL INSERT has more target columns The cause of error: INSERT has more target columns than expressions in PL/pgSQL. The solution is to check the...

PostgreSQL invalid input syntax for type boolean The cause of error: Invalid input syntax for type boolean is when values other than true or false are assigned to an boolean variable. Wrong function CREATE OR REPLACE FUNCTION update_test2 (p_old_name varchar, p_new_name...

Multiple primary keys for table are not allowed The cause of error: There is already a primary key created. Check the primary key or drop the existing primary key. Create table and primary key CREATE TABLE test.products( product_id numeric, product_name varchar(500),...

PostgreSQL negative substring length not allowed Wrong select select substring('abc', 1,-1); ERROR: negative substring length not allowed Correct select select substring('abc', 1, 1); Data Output: a select substring('abc', 1, 2); Data Output: ab...

Null value in column violates not-null constraint in PL/pgSQL Not-null constraint The cause of error: Null value in column violates not-null constraint in PL/pgSQL. Create Students table CREATE TABLE test.students ( id numeric NOT NULL, first_name character varying(50) NOT NULL, last_name...