Try this command at the psql command line:
CREATE SEQUENCE atable_id_seq;
ALTER TABLE atable ALTER COLUMN id SET DEFAULT
nextval('"atable_id_seq"'::text);
Jeff
-Original Message-
How can I make the insert
command automatically update the 'id' to the next highest number?
---
I have a table with 5,000 rows in it. I also have a query that returns
about 950 rows, but I only want items 50-60 from that match.
What I want to show the user is
- the total # of matches (950)
- the 10 rows that I want
The following works, but can it be reduced to a
Remembering past discussions: Yes OID's wrap around. When this happens,
they will not nesecarily be unique anymore. Apparently this should not
be a problem unless one has queries that specifically use OID's. INT8
OID's have been talked about and will probably be implemented some day.
Jeff
>
