[Mono-list] aspsqlprovider problem select table users

[Daniel Nauck]

Hello,

can you please enable tracing so we can see what exception occurs?

http://dev.nauck-it.de/aspsqlprovider/wiki/Debugging

Daniel

Rodrigo Cuevas schrieb:
> 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
>>>     
>>
>>   
>