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

[donaldi sp]

Hi Frans,

yes, when I add "Polling=false" in connection string,
it's look fine, but can you give an explaination
between using pooling and not using it, what's the
benefit and the cost of that thing, at least you can
give me a link about that.

but I got error like "Npgsql.NpgsqlException: cache
lookup failed for relation 21036" when I browse again
the page that have error before.

thank very much,

>>aldi<<

--- "Francisco Figueiredo Jr."
<fxjrlists@yahoo.com.br> wrote:
> --- 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
> _______________________________________________
> Mono-list maillist  -  Mono-list@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
> 



		
__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail