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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 16 Nov 2007 15:13:48 -0500
Tom Hart <tomhart@coopfed.org> wrote:

>  Addr2           | text         |
>  Addr3           | text         |
>  City            | text         |
>  State           | text         |
>  Zip             | text         |
>  Zip5            | text         |
>  xxPrimaryName   | text         |
>  xxJointName     | text         |
>  xxHouseholdHash | text         |
> 
> current=#
> 
> TIA
> 

It is because when you created the relation you double quoted isactive,
so it isn't isactive it is "isActive". E.g; case is relevant.

Joshua D. Drake


> Thomas R. Hart II
> tomhart@coopfed.org
> 
> ---------------------------(end of
> broadcast)--------------------------- TIP 9: In versions below 8.0,
> the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
> 


- -- 

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
            UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHPfuVATb/zqfZUUQRAv0YAJ9C2YwfiJILDj3DQYmZoCVFBjQ9QwCfZeGE
22+aBWTnM0FYpuBjJJGBSuc=
=5CnL
-----END PGP SIGNATURE-----