Re: [GENERAL] PostgreSQL 6.5.3 on SuSE 6.1

1999-12-04 Thread Peter Eisentraut
I don't have SuSE but I'll give it a shot. First of all, libreadline is only needed by the psql frontend, the postmaster should still start up. If you don't have libreadline installed at all then the compilation should have omitted it, so that seems unlikely. Chances are that running /sbin/ldconf

Re: [GENERAL] Buggered Sequence

1999-12-04 Thread Ross J. Reedstrom
Jason - Jesse's sugestion should work, but there's a setval() function for this exact use: SELECT setval('people_id_seq',44); I usually use it like this: SELECT setval('"Experiments_ExptID_seq"',max("ExptID")) from "Experiments"; That automatically sets the sequence value to the current max i

Re: [GENERAL] Buggered Sequence

1999-12-04 Thread Jesse Kipp
Can you do: drop sequence people_id_seq create sequence people_id_seq start 44 ? jesse kipp "Jason C. Wells" wrote: > > sequence_name|last_value|increment_by| >max_value|min_value|cache_value|is_cycled|is_called > >-+--++--+-+---+---

[GENERAL] Buggered Sequence

1999-12-04 Thread Jason C. Wells
sequence_name|last_value|increment_by| max_value|min_value|cache_value|is_cycled|is_called -+--++--+-+---+-+- people_id_seq| 4| 1|2147483647|1| 1|f|t (1 row) After I screw