Re: Error with sequences, "sequence was re-created"

Поиск
Список
Период
Сортировка
Искать
От
Stephan Szabo
Тема
Re: Error with sequences, "sequence was re-created"
Дата
Msg-id
20021002123528.J10839-100000@megazone23.bigpanda.com
Ответ на
Список
Дерево обсуждения
Error with sequences, "sequence was re-created" "Charles H. Woloszynski" <chw@clearmetrix.com>
Re: Error with sequences, "sequence was re-created" Stephan Szabo <sszabo@megazone23.bigpanda.com>
On Wed, 2 Oct 2002, Charles H. Woloszynski wrote:

> I am porting an existing database to PostgreSQL and have encountered a
> strange error.
>
> When I am in psql and use \i to read the SQL script, I get messages
> about various sequences being re-created.    After the re-creation of
> the sequence, I am getting errors about currval() not being valid.  I've
> included a snippet of the output below.  [There were a series of ERROR
> messages that the script causes when it tries to drop tables that don't
> exist ... I've ignored those... perhaps to my detriment].

Can you send the appropriate section of the script?


В списке pgsql-general по дате отправления
От: scott.marlowe
Дата:
Сообщение: Re: Question about Cursors
От: Mihai Gheorghiu
Дата:
Сообщение: Use of GROUP BY
FAQ