Re: bug with insert

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