Andreas Kretschmer wrote:
Andreas Kretschmer <[EMAIL PROTECTED]> schrieb:
Adam <[EMAIL PROTECTED]> schrieb:
I just emptied my table and I want all my new inserts to start with a
'location_id' of '1'. The table is named "locations" with a SERIAL column
"location_id"
If you want to start at 1
Andreas Kretschmer <[EMAIL PROTECTED]> schrieb:
> Adam <[EMAIL PROTECTED]> schrieb:
>
> >
> > I just emptied my table and I want all my new inserts to start with a
> > 'location_id' of '1'. The table is named "locations" with a SERIAL column
> > "location_id"
> >
> > I tried the below SQL to r
Adam <[EMAIL PROTECTED]> schrieb:
>
> I just emptied my table and I want all my new inserts to start with a
> 'location_id' of '1'. The table is named "locations" with a SERIAL column
> "location_id"
>
> I tried the below SQL to rest the sequence ID but it's not working. What am I
> doing wron