pgsqlDataAdapter configuration

[sam]

Hi, i am new to postgresql database and i am using the latest trial version of the postgresqldirect.net prvider to connect it to .Net(1.1 - visual studio 2003).
I have been able to successfully establish a connection to the postgresql database, and i am now trying to configure a data adapter.

i have two tables in the database named User and Utility. When configuring the Dataadapter and on selecting tableDirect type, the tables appear in the table object name combobox as 'public.User' and 'public.Utility'. when i select any of these names and try and generate the insert ,update and delete commands, i get the error,

relation 'public.User' does not exist

Could you tell me if i am doing something wrong or there is some configuration i have left out.
any help whatsoever will be appreciated

[Oleg]

This a known problem. We will fix it in the future releases.
Try correcting name 'public.User' to 'User' in table name text box manually.

[Rosa Ríos]

I have the same problem that Sam, I did what you tell and It didn't work.

What else can I do????

I really need it!


Thanks!

Rosa Ríos

[szinkopa]

Perhaps the root of the problem is that the name of the table (and anything else) is not lowercase. You know there is an issue with PostgreSQL that it is lowering names if it is not quoted. You have to quote the name: "User". But I don't think this works in the IDE.

So the best way is using lowercase letters only, with underlines, such as: 'user_category' or something like this.

Perhaps Pg Direct should quote all names before passing it to Pg server.

[Yuri]

Thank you for information.
We reproduced your problem and fixed it. This fix will be included in the next PostgreSqlDirect .NET build.
It will be available in a week.