"field doesn't exist" even though I'm sure it does
От | Tom Hart |
---|---|
Тема | "field doesn't exist" even though I'm sure it does |
Дата | |
Msg-id | 473DF9FC.8010906@coopfed.org обсуждение исходный текст |
Ответы |
Re: "field doesn't exist" even though I'm sure it does
Re: "field doesn't exist" even though I'm sure it does |
Список | pgsql-general |
Hey everybody. I've got a strange one today. I'm trying to convert an extremely messy access sql query into something that can be used with our postgresql database (the pgsql db is being built to replace the access db). I had barely begun trying to convert it when I was confronted with this error message: column "isactive" of relation "membermailingaddress" does not exist However, a quick \d in psql let's me know that there is indeed a field "isactive" on that specific table. I can't begin to imagine why it would throw an error like this. Here's my psql output, with a simple test query to reproduce the issue, and a \d membermailingaddress afterwards. Anybody have any ideas? current=# insert into membermailingaddress( current(# mb_cn_num, current(# mb_acct_num, current(# IsActive, current(# IsMember current(# ) current-# VALUES current-# ( current(# 1, current(# 1500.0, current(# TRUE, current(# FALSE current(# ) current-# ; ERROR: column "isactive" of relation "membermailingaddress" does not exist LINE 4: IsActive, ^ current=# \d membermailingaddress Table "public.membermailingaddress" Column | Type | Modifiers -----------------+--------------+----------- mb_cn_num | integer | mb_acct_num | numeric(6,1) | IsActive | boolean | IsMember | boolean | IsMail | boolean | IsPromoMail | boolean | HouseholdID | numeric | HouseholdSize | integer | Name1 | text | Name2 | text | Addr1 | text | Addr2 | text | Addr3 | text | City | text | State | text | Zip | text | Zip5 | text | xxPrimaryName | text | xxJointName | text | xxHouseholdHash | text | current=# TIA Thomas R. Hart II tomhart@coopfed.org
В списке pgsql-general по дате отправления: