'SERIAL' in pgsql
Archana K N <[email protected]> Mon, 16 Jul 2012 14:53:55 +0530
| Newsgroups | gmane.comp.db.postgresql.php |
|---|---|
| Message-ID | <CACa6=i01-C93NyY_rvhwsi9qaU6EFSTPgnvJZ1Tq7cE3ZQaEvA@mail.gmail.com> |
--f46d04016b472651da04c4eefda7 Content-Type: text/plain; charset=ISO-8859-1 Hello, I have a database whose primary key is 'slno' and which is an auto increment field.I inserted some values to database say upto " slno - 5". Then I deleted the row with 'slno' 3 . Now I want the to shift all the rows upward ie 4th row should be third and its 'slno' should also be 3. I heard that this is not possible.Is there a way to do this other than to move all rows to another database except the slno. -- ------------------- regards archana -------------------- --f46d04016b472651da04c4eefda7 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable <br clear=3D"all">Hello,<br><br>=A0 I have a database whose primary key is = 'slno' and which is an auto increment field.I inserted some values = to database say upto <br>" slno - 5". Then I deleted the row with= 'slno' 3 . Now I want the to shift all the rows upward ie 4th row = should be third and its 'slno' should also be 3. I heard that this = is not possible.Is there a way to do this other than to move all rows to an= other database except the slno.<br> <br>-- <br>-------------------<br>regards<br>archana<br>-------------------= -<br> --f46d04016b472651da04c4eefda7--