Re: Serial data type not starting at 1
От | Andrew G. Hammond |
---|---|
Тема | Re: Serial data type not starting at 1 |
Дата | |
Msg-id | E164SFm-000345-00@xyzzy.lan.internal обсуждение исходный текст |
Ответ на | Serial data type not starting at 1 (Tielman J de Villiers <tjdevil@bondnet.co.za>) |
Список | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Which version of postgres are you running? Some stuff such as setval(sequence) and START only appears to have been implemented in more recent versions of postgres. This might be your problem. On 2001 November 15 08:50 am, Tielman J de Villiers wrote: > Hi, > > I hope someone can help me. > > I want to create a new table using the "automatic" sequence function of > Postgres by creating the first column as type "serial". But I want to start > at say "5000". Can it be done, and how? > > Thank you > > Tielman J de Villiers > BondNet Pty Ltd > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly - -- Andrew G. Hammond mailto:drew@xyzzy.dhs.org http://xyzzy.dhs.org/~drew/ 56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481 5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1 "To blow recursion you must first blow recur" -- me -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iEYEARECAAYFAjv0GF8ACgkQCT73CrRXhLFsFQCfVRkAgEQxcqZv+BQxdzoMLjj0 OCUAn0sPYTMrdTLxH9yoXQhklf4UzRvj =qpko -----END PGP SIGNATURE-----
В списке pgsql-general по дате отправления: