"field doesn't exist" even though I'm sure it does

From: Tom Hart <tomhart(at)coopfed(dot)org>
To: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: "field doesn't exist" even though I'm sure it does
Date: 2007-11-16 20:13:48
Message-ID: 473DF9FC.8010906@coopfed.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)coopfed(dot)org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-11-16 20:20:37 Re: "field doesn't exist" even though I'm sure it does
Previous Message Joshua D. Drake 2007-11-16 20:06:46 Re: Primary Key