[Mono-list] aspsqlprovider problem select table users

[Rodrigo Cuevas]

The example AspSqlprovider 1.2.4 works with npgsql 2.0.1 and npgsql 2.0RTM
version npgsql 2.0.2 , 2.0.3, 2.0.4 get the error.
the problem is greater than npgsql versions 2.0.1 ?
Greetings

Rodrigo Cuevas escribió:
> Thanks Daniel
> I had version 1.2.1 with Npgsql 2.0 RTM now I'm trying the 1.2.4 
> version that comes with Npgsql 2.0.4.
> When you run the example from which I get the following error:
>
> //Operation aborted due to an exception (see Trace for details).//
>
> ProviderException: Operation aborted due to an exception (see Trace 
> for details).]
>
> NauckIT.PostgreSQLProvider.PgSessionStateStoreProvider.SetAndReleaseItemExclusive(HttpContext 
> context, String id, SessionStateStoreData item, Object lockId, Boolean 
> newItem) in C:\Users\Daniel Nauck\Documents\Visual Studio 
> 2008\Projects\PostgreSQLProvider\PgSessionStateStoreProvider.cs:506
>
> System.Web.SessionState.SessionStateModule.OnReleaseState(Object 
> source, EventArgs eventArgs) +476
>
> System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 
> +92
>
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& 
> completedSynchronously) +64
>
>
> Any suggestions.
>
> Daniel Nauck escribió:
>> Hello,
>>
>> PostgreSQL is case sensitive and the user table has a upper case U.
>> So try:
>>
>> SELECT * FROM "Users";
>>
>> Add double quotes around table and field names.
>>
>> hope that helps.
>>
>> Daniel
>>
>> Rodrigo Cuevas schrieb:
>>  
>>> hi,
>>> use PostgreSQL ASP.NET 2.0 Membership, Role, Profile and Session-State
>>> Store Provider Project
>>> source
>>> http://dev.nauck-it.de/aspsqlprovider/
>>> <http://dev.nauck-it.de/aspsqlprovider/#WelcometoPostgreSQLASP.NET2.0MembershipRoleProfileandSession-StateStoreProviderProject>After 
>>>
>>> creating the schema in the database execute the search:
>>> select * from users;
>>> and get the error
>>> /relation/ "users" /does not exist/
>>> help please
>>>
>>>
>>> _______________________________________________
>>> Mono-list maillist  -  Mono-list at lists.ximian.com
>>> http://lists.ximian.com/mailman/listinfo/mono-list
>>>     
>>
>>   
>
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>   

-------------- next part --------------
A non-text attachment was scrubbed...
Name: bellinux.vcf
Type: text/x-vcard
Size: 177 bytes
Desc: not available
Url : http://lists.ximian.com/pipermail/mono-list/attachments/20090314/726b905e/attachment.vcf