BUG #1722: table with a serial field don't works

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #1722: table with a serial field don't works

Massimo Mollo

The following bug has been logged online:

Bug reference:      1722
Logged by:          Massimo Mollo
Email address:      [hidden email]
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.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [hidden email])
Reply | Threaded
Open this post in threaded view
|

Re: BUG #1722: table with a serial field don't works

Richard Huxton
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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [hidden email])