Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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







Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group