Massimo Mollo wrote:
>
> I've installed postgres on 2 pcs, a win2000 and a winxp home.
> when i create a table with a SERIAL field, the pgadmin can see and use it,
> but with psql or a .net program using odbc, ole or lpgsql, the error is
> "RELATION *tablename* NOT FOUND".
Please supply the real query and real error message.
What is the real tablename?
Is it in your search_path?
Does it contain spaces or mixed case, and if so is it quoted?
If you don't know why you would want to quote it, check the manuals
(chapter "Identifiers and Keywords") and list archives.
> i tryed to use psql and the .net program on the same pc, or a lan-connected
> pc.
> If i change the type of the field originally SERIAL, the error vanish.
Is the problem with the table not being found or the type of the column?
--
Richard Huxton
Archonet Ltd