>
> > >
> > > So how do you store something in data type serial?
> > > I've created the column but everytime I attempt to do an update I get
> > > back the error message that I can't store a duplicate key.
> > >
> > > table_col_seq.last_value = 1
> > > increment = 1
> > > maxvalue = 2billion s
If you have this table:
create table testing (
id serial,
datatext,
md int
);
You would use:
insert into testing (data, md) values ('my_data', 12);
insert into testing (data, md) values ('more data', 15);
The key part is that you don't specify the serial f
Michael wrote:
>
> > >
> > > So how do you store something in data type serial?
> > > I've created the column but everytime I attempt to do an update I get
> > > back the error message that I can't store a duplicate key.
> > >
> > > table_col_seq.last_value = 1
> > > increment = 1
> > > maxvalue
> >
> > So how do you store something in data type serial?
> > I've created the column but everytime I attempt to do an update I get
> > back the error message that I can't store a duplicate key.
> >
> > table_col_seq.last_value = 1
> > increment = 1
> > maxvalue = 2billion something
> >
> > I
>
> So how do you store something in data type serial?
> I've created the column but everytime I attempt to do an update I get
> back the error message that I can't store a duplicate key.
>
> table_col_seq.last_value = 1
> increment = 1
> maxvalue = 2billion something
>
> I've tried storing 1,