Author: codertutor_3o6d0o

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...

Numeric field overflow Create table CREATE TABLE test( id numeric(4,2) NOT NULL, description character varying(250), reg_date timestamp without time zone ); Wrong action insert into test (id, description, reg_date) values (123, 'test_dsp', now()); ERROR: numeric field overflow DETAIL: A field with...

The cause of error: There is no table created with the specified name. Check the table name or use IF EXISTS. Wrong alter ALTER TABLE test.clients RENAME TO customers; Messages ERROR: relation “test.clients” does not exist Correct alter ALTER TABLE IF...