I forgot, my postgresql is 8.2 beta1
I think I found a bug in pgAdmin3 beta 3 5475.
OS: Windows
I ve created a table and can not access that tables. pgAdmin shows the
tables and their columns(not always) but I can not make INSERT
statements!!!
CREATE TABLE funds_currency
(
"ID" integer NOT NULL DEFAULT
nextval('"funds_currency_ID_seq"'::regclass), "Abbrev" character
varying(10)
)
insert into funds_currency (abbrev) values ('BGN')
ERROR: column "abbrev" of relation "funds_currency" does not exist SQL
state: 42703
Character: 29
But the table is there with this column "abbrev" (I could not create it
agan)!!!
It is really frustrating!
When I make select statements it is OK.
p.s. I do not think for a submitting a bug you need to subscribe to a
mailing list.
Cheers
Anton Andreev
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
