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>)
Список pgsql-general
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