[Mono-list] Npgsql problem "create local temporary"
Mon, 14 Jun 2004 22:21:06 -0700 (PDT)
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
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.