Table X its full, what can i do now?

Поиск
Список
Период
Сортировка
От x asasaxax
Тема Table X its full, what can i do now?
Дата
Msg-id 91495cb0807090800w57ec7b78jcb506a58195acfb7@mail.gmail.com
обсуждение исходный текст
Ответы Re: Table X its full, what can i do now?  (Dan Myers <heron@xnapid.com>)
Re: Table X its full, what can i do now?  (Rodrigo Gonzalez <rjgonzale@gmail.com>)
Re: Table X its full, what can i do now?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-general
Hi everyone,


   I have the following sql script:

CREATE SEQUENCE "public"."teste_seq"
   INCREMENT 1  MINVALUE 1
   MAXVALUE 32767  START 1
   CACHE 1  CYCLE;

CREATE TABLE "public"."teste" (
 "id" SMALLINT DEFAULT nextval('teste_seq'::regclass) NOT NULL,
 CONSTRAINT "id_pk" PRIMARY KEY("id")
) WITHOUT OIDS;

 for($i=1;$i<32767;$i++)
 {
        $sql = "insert into teste values(DEFAULT)";
        echo pg_query($sql);
 }
$sql = "delete from teste where id=5";
pg_query($sql);
$sql = "delete from teste where id=10";
pg_query($sql);
$sql = "delete from teste where id=51";
pg_query($sql);
$sql = "delete from teste where id=35";
pg_query($sql);
$sql = "delete from teste where id=125";
pg_query($sql);
$sql = "delete from teste where id=425";
pg_query($sql);
The table teste its full but it has some holes, i can´t insert no
more, it give´s me the error: duplicate key violates unique constraint
"id_pk".
 What can i do to be able to continue inserting rows on this table?

Thanks a lot.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: rollback
Следующее
От: Madison Kelly
Дата:
Сообщение: Re: rollback