On 10/04/2011 08:05 AM, Robert Buckley wrote:
> Thanks for the replies,
>
> I have one question regarding this comment...
>
> "You also need to add a DEFAULT expression and optionally
> make the sequence owned by the column:"
>
> What difference does it make if a table "owns" a sequence of not?.
Hi,
2011-10-04 14:05 keltezéssel, Robert Buckley írta:
> Thanks for the replies,
>
> I have one question regarding this comment...
>
> "You also need to add a DEFAULT expression and optionally
> make the sequence owned by the column:"
>
> What difference does it make if a table "owns" a sequence o
neral@postgresql.org
Gesendet: 13:43 Dienstag, 4.Oktober 2011
Betreff: Re: [GENERAL] auto-increment column
2011-10-04 13:30 keltezéssel, Robert Buckley írta:
Hi,
>
>
>I have a column in a table called hist_id with the datatype "integer". When I
>created the table I assigned
2011-10-04 13:30 keltezéssel, Robert Buckley írta:
> Hi,
>
> I have a column in a table called hist_id with the datatype "integer". When I
> created
> the table I assigned this column the primary key constraint but didn´t make
> it an
> auto-increment column.
>
> How could I do this to an the alr
On Tue, Oct 04, 2011 at 12:30:48PM +0100, Robert Buckley wrote:
> Hi,
>
> I have a column in a table called hist_id with the datatype "integer". When I
> created the table I assigned this column the primary key constraint but
> didn´t make it an auto-increment column.
>
> How could I do this to
Hi,
I have a column in a table called hist_id with the datatype "integer". When I
created the table I assigned this column the primary key constraint but didn´t
make it an auto-increment column.
How could I do this to an the already existing column?
I have created the sequence with the followi