Saludos lista estoy intentando crear una tabla y al intentar crear una
secuencia automatica me genera el siguiente error
NOTICE: CREATE TABLE will create implicit sequence
"ppa_reports_report_id_seq" for serial column "ppa_reports.report_id"
ERROR: permission denied to create "pg_catalog.ppa_reports_report_id_seq"
DETALLE: System catalog modifications are currently disallowed.
********** Error **********
ERROR: permission denied to create "pg_catalog.ppa_reports_report_id_seq"
SQL state: 42501
Detail: System catalog modifications are currently disallowed.
la sentencia a ejecutar es la siguiente
CREATE TABLE ppa_reports (
report_id SERIAL,
report_name varchar(255) NOT NULL,
db_name varchar(255) NOT NULL,
date_created date DEFAULT NOW() NOT NULL,
created_by varchar(255) NOT NULL,
descr text,
report_sql text NOT NULL,
paginate boolean NOT NULL,
PRIMARY KEY (report_id)
);
Atentamente,
Harold Onore
