| From: | Archana K N <archanakknn(at)gmail(dot)com> |
|---|---|
| To: | pgsql-php(at)postgresql(dot)org |
| Subject: | 'SERIAL' in pgsql |
| Date: | 2012-07-16 09:23:55 |
| Message-ID: | CACa6=i01-C93NyY_rvhwsi9qaU6EFSTPgnvJZ1Tq7cE3ZQaEvA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
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
--------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thom Brown | 2012-07-16 09:56:30 | Re: 'SERIAL' in pgsql |
| Previous Message | Archana K N | 2012-06-05 10:17:52 | Re: Problem in importing database |