Thread: Postgres Question

Postgres Question

From

"Jeff Tucker"

Date:

26 October 2000, 00:12:53

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

From

Philip Warner

Date:

26 October 2000, 09:27:37

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   |/