On Jun 15, 2006, at 15:52 , Johan van der Merwe wrote:
My code is as follows:
Could you explain a bit more what this code is? Is it Java? Python? What does it do? I know it's not SQL, and I'm guessing it's some kind of ORM, but without more information I really don't know how to help (and perhaps others are having the same trouble).
I receive the error "Relation "tblSuburb" does not exist"
What is the name of the table in the database itself? Can you provide an example of SQL that *does* do what you want? Or perhaps some psql output showing the table definition for "tblSuburb"? There's a chance that it's a quoting problem: your code is calling "tablSuburb" (with double-quotes, which tells the server to look for a case-sensitive match) and your table is actually named "tblsuburb". PostgreSQL downcases all unquoted identifiers.
Hope this helps a bit. Michael Glaesemann grzm seespotcode net
