-----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-----