[Mono-list] Npgsql problem "create local temporary"

donaldi sp don_aldi@yahoo.com
Mon, 14 Jun 2004 22:21:06 -0700 (PDT)

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

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.