Skip site navigation (1) Skip section navigation (2)

secuencia automatica

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 (view raw or flat)
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

Responses

pgsql-es-ayuda by date

Next:From: Gilberto Castillo MartínezDate: 2012-05-16 16:29:36
Subject: Re: secuencia automatica
Previous:From: Agustin Ignacio GenovesDate: 2012-05-16 15:26:43
Subject: Re: Schema vs BD

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group