BUG #1722: table with a serial field don't works
The following bug has been logged online:
Bug reference: 1722
Logged by: Massimo Mollo
Email address: maxy0440yxam@yahoo.it
PostgreSQL version: 8.03
Operating system: win2000pro, winXphome
Description: table with a serial field don't works
Details:
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".
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.
i searched on forums, but none knows that problems.
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