BUG #13993: Temp sequence does not seem to be properly deleted
От | mathias.zajaczkowski@ubik.ch |
---|---|
Тема | BUG #13993: Temp sequence does not seem to be properly deleted |
Дата | |
Msg-id | 20160228200812.10543.12731@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #13993: Temp sequence does not seem to be properly
deleted
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 13993 Logged by: Zajaczkowski Email address: mathias.zajaczkowski@ubik.ch PostgreSQL version: 9.4.4 Operating system: Windows 7 64 bits Description: I use pgAdmin V. 1.20.0 (Jul 13 2015, rev: REL-1_20_0) Within a script I created temporary sequence: CREATE TEMP SEQUENCE 'rateSeq' with S in uppercase to be used for rate table pk. Script run fine. Next time script gave an error "relation rateseq already exists". I modified the creation of the sequence to: CREATE TEMP SEQUENCE rateseq (all in lower case) Same error when running the script. I tried: DROP SEQUENCE rateseq Result: sequence <<rateseq>> does not exist. I completely changed the name of my sequence to "seq4rate" => same error. I hade a look in pg_class table where I found a record with relname = rateseq. I deleted this line. It was not a good idea, but I'm not in production and had this try. Since then trying to run the script I had a message "... with Oid can not be found ..." I restored the database. Problem persisted. I stoped and restarted the service "postgresql-x64-9.4 - PostgreSQL Server 9.4". That solved my problem. Kind regards
В списке pgsql-bugs по дате отправления: