Hi All, Actually I'am in progress to porting aspnet forums from .NET to mono, I use Postgresql and Npgsql for database backend subtitute MS SQL, some of store proc has been converted into plpgsql function. But I have a problem with store procedure which contain "create local table tabel1(column1 int identity not null,..)" statement.
if I try to convert it, it will be like: "create local table table1(column1 serial not null,..)" it will create sequence "table1_column1_seq" implicitly. table1 should be dropped if we close the connection and also attribute in it (the sequence also dropped), isn't it ? so we can create again in the other session. but it's not. So when execute this statement again it cause an error, it says that "table1_column1_seq" already exists, but if I try refresh several time again it's work well. which configuration should I change? any idea about this ? thank in advance, >> aldi << __________________________________ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ _______________________________________________ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list