Обсуждение: Postgres Question

Поиск
Список
Период
Сортировка

Postgres Question

От
"Jeff Tucker"
Дата:
HELP!
 
I used to be able to manually set a sequence id by typing:
 
SELECT setval('products_seq_id',100); but for some reason it is no longer working.  It would previously return 100 and now it returns nothing and the counter is not increased to 100.  Any suggestions on where to look?
 
Thanks much
Jeff

Re: Postgres Question

От
Philip Warner
Дата:
At 11:22 25/10/00 -0400, Jeff Tucker wrote: 

>>>>

<excerpt>  

<fontfamily><param>Arial</param><smaller>SELECT
setval('products_seq_id',100); but for some reason it is no longer
working.  It would previously return 100 and now it returns nothing and
the counter is not increased to 100.  Any suggestions on where to look?

</smaller></fontfamily>

</excerpt><<<<<<<<


Which version are you using?




----------------------------------------------------------------

Philip Warner                    |     __---_____

Albatross Consulting Pty. Ltd.   |----/       -  \

(A.B.N. 75 008 659 498)          |          /(@)   ______---_

Tel: (+61) 0500 83 82 81         |                 _________  \

Fax: (+61) 0500 83 82 82         |                 ___________ |

Http://www.rhyme.com.au          |                /           \|
                                |    --________--

PGP key available upon request,  |  /

and from pgp5.ai.mit.edu:11371   |/