Dear Scott...
i tried like this but it didn't succeeded.
kv=# alter table sales modify salesid serial;
ERROR: syntax error at or near "modify" at character
19
kv=# alter table sales alter column salesid serial;
ERROR: syntax error at or near "serial" at character
40
kv=# alter table sales alter column modify salesid
serial;
ERROR: syntax error at or near "salesid" at character
39
kv=#
Please keep telling.
Thank you very much in advance.
--- "Wenzel, Scott"
Not using postgres, but try
alter table sales modify salesid serial;
-----Original Message----- From: Prabu Subroto [mailto:prabu_subroto@yahoo.com] Sent: Tuesday, July 27, 2004 1:16 PM To: suse-programming-e@suse.com Subject: [suse-programming-e] altering a table to set serial function
Dear my friends...
I am using postgres 7.4 and SuSE 9.1.
I want to use auto_increment as on MySQL. I look up the documentation on www.postgres.com and I found "serial" .
But I don't know how to create auto_increment. here is my try: " kv=# alter table sales alter column salesid int4 serial; ERROR: syntax error at or near "int4" at character 40 "
Please tell me the correct command to that.
Thank you very much in advance.
__________________________________ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail
-- To unsubscribe, email: suse-programming-e-unsubscribe@suse.com For additional commands, email: suse-programming-e-help@suse.com Archives can be found at: http://lists.suse.com/archive/suse-programming-e
-- To unsubscribe, email: suse-programming-e-unsubscribe@suse.com For additional commands, email: suse-programming-e-help@suse.com Archives can be found at: http://lists.suse.com/archive/suse-programming-e
__________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail