Обсуждение: 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