Re: Add new field with auto-icrement to existing table

Exactly what I needed.

Thanks,
Brice

2015-01-06 18:44 GMT+01:00 Andreas Kretschmer <akretschmer(at)spamfence(dot)net>:

> Brice André <brice(at)famille-andre(dot)be> wrote:
>
> > But now, I would want to develop a server-based application. And this
> > application would need a single column unique ID for referencing tables
> > entries. My current primary key does not fit my needs as it is based on
> two
> > columns. So, I would want to add a new field on all derived tables. And,
> as I
> > don't want to change the synchronisation stuff, the values of this new
> field
> > should be assigned automatically.
>
> Create a new Sequence. I think, that should fit your requirement.
>
> Andreas
> --
> Really, I'm not out to destroy Microsoft. That will just be a completely
> unintentional side effect. (Linus Torvalds)
> "If I was god, I would recompile penguin with --enable-fly." (unknown)
> Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>