sid tow wrote:
I am using a 7.2 version of postgreSQL and here if I have to copy
data in a particular table then I cannot specify the columns I want
to update, but rather i will have to copy data into all the columns
present. Now the problem is that I have a auto generated sequence
starting from 1
I am using a 7.2 version of postgreSQL and here if I have to copy data in a particular table then I cannot specify the columns I want to update, but rather i will have to copy data into all the columns present. Now the problem is that I have a auto generated sequence starting from 1 in one of the c
sid tow wrote:
Hi All,
Is there a way to stop a auto generated sequence from incrementing
for some time and then activate it to do the increments.
You might be able to do something by revoking permissions to the
sequence, and wrapping nextval/currval with security=owner functions. If
you can desc
Hi All,
Is there a way to stop a auto generated sequence from incrementing for some time and then activate it to do the increments.
Regards
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'
