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