Thread: bug with insert

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

Anton Andreev написа:
> 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

That's right - your column is named "Abbrev" and not "abbrev". Please
read the paragraph starting with "There is a second kind of
identifier:..." here -
http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS

> 
> 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.
>


-- 
Milen A. Radev