Re: Relation "tablename" does not exist

Johan van der Merwe wrote:
> I have posted this before without receiving replies

Can't see it in the archives. Were you subscribed?

> My code is as follows:
>
> Public dbRemote As New Connection
> Public rsData As New Recordset
>
> dbRemote.Properties("Data Source").Value = "DSM"
> dbRemote.Properties("Initial Catalog").Value = "BCM_DSM"
> dbRemote.Properties("User ID").Value = "johan"
> dbRemote.Properties("Password").Value = "johan"
> dbRemote.Open
>
> rsData.Open "tblSuburb", dbRemote, , , adCmdTable
>
>
> I receive the error "Relation "tblSuburb" does not exist"

Either you created the table quoted (thus preserving its case) and you
are accessing it unquoted (so it's folded to lower-case) or the other
way around. It's how PostgreSQL provides case-insensitive table-names.

So:
CREATE "TaBlE1" ...
SELECT * FROM "TaBlE1" (works)
SELECT * FROM table1 (fails)
CREATE TaBlE2 ...
SELECT * FROM "TaBlE2" (works)
SELECT * FROM table2 (works)
SELECT * FROM TABLE2 (works)

HTH
--
Richard Huxton
Archonet Ltd