Hola estoy intentando en mi linux crear una tabla postgres con un campo id
que sea autonumerico con esto y no me funciona.
Alguien me puede echar una mano?
gracias
CREATE SECUENCE "tracks_id_seq" start 1 increment 1 maxvalue 2147483647
minvalue 1 cache 1 ;
REVOKE ALL on "tracks_id_seq" from PUBLIC;
GRANT ALL on "tracks_id_seq" to "postgres";
GRANT ALL on "tracks_id_seq" to "jspuser";
CREATE TABLE "tracks" (
"id" integer DEFAULT nextval('"tracks_id_seq"'::text) NOT NULL,
"email" character varying(250),
"url" character varying(250),
"ip" character varying(25)
);
--
-- TOC Entry ID 14 (OID 19499)
--
-- Name: marchas Type: ACL Owner:
--
REVOKE ALL on "tracks" from PUBLIC;
GRANT ALL on "tracks" to "postgres";
GRANT INSERT,UPDATE,DELETE,SELECT on "tracks" to "jspuser";
GRANT INSERT,UPDATE,DELETE,SELECT on "tracks" to GROUP "webstandarusers";
--
�Desea desuscribirse? Escriba a [EMAIL PROTECTED] con el tema
'unsubscribe'. M�s informaci�n: http://www.linux.or.cr/listas
