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
pgsqlDataAdapter configuration
Error configuring the pssqldataadapter
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
What else can I do????
I really need it!
Thanks!
Rosa Ríos
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.
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.