Hi,
I have a problem with the SEQUENCE generation. I have a column in a table which auto increments by 1 every time there is a entry and I am strictly prohibited to use only PostgreSQL 7.2 version. Now the problem is with the COPY command, I will have to copy entire columns present in the table from a file with this version of PostgreSQL. I just cant copy those fields I want to update. For this what I did was I got the current value of the auto generated sequence from ie the column "last_value" from the sequence table and updated the auto generating column also along with the other columns. Now the problem is that even after I have inserted some data in the tables I see no change in the column last_value of the sequence table since last copy or insert of data. Why is it? And is there any alternate way to copy only those columns I need to using this version of PostgreSQL?
Note: I referred man pages of create_sequence to get the information.
Regards,
Sid
Do you Yahoo!?
Yahoo! Search presents -
Jib Jab's 'Second Term'