| From: | Harold Alexander Onore Harold <onoreharold(at)gmail(dot)com> |
|---|---|
| To: | Lista PostgreSQL en Español <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | secuencia automatica |
| Date: | 2012-05-16 16:24:23 |
| Message-ID: | CAFeQaKudsXZFh5k3utEf=CCG94sLYP=31jauK5yeUk9XeXuAVw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gilberto Castillo Martínez | 2012-05-16 16:29:36 | Re: secuencia automatica |
| Previous Message | Agustin Ignacio Genoves | 2012-05-16 15:26:43 | Re: Schema vs BD |