Re: Serial data type not starting at 1

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