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

[Francisco Figueiredo Jr.]

--- donaldi sp <don_aldi@yahoo.com> escreveu: > 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,
> 

Hi Donaldi.

I think this has something about connection pooling. When you close the
connection, in fact it is returned to pool. Could you try a simple application
which creates the sequence and exits? This way the connection will be closed
and you can try it again.

Also, you can get the 0.6 release final for mono in
gborg.postgresql.org/project/npgsql where you can say pooling=no in connection
string and it will not do pooling.

Mono cvs will be updated soon after cvs freeze for beta 3.

Regards,

Francisco Figueiredo Jr.



______________________________________________________________________

Participe da pesquisa global sobre o Yahoo! Mail: 
http://br.surveys.yahoo.com/global_mail_survey_br