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(at)coopfed(dot)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(at)coopfed(dot)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-----