Hosting Provided By

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

From: Joshua D. Drake <jd(at)commandprompt.com>
Date: Fri Nov 16 2007 - 15:20:37 EST

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

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

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

---------------------------(end of broadcast)---------------------------

TIP 5: don't forget to increase your free space map settings Received on Fri Nov 16 15:24:41 2007

Do you need help?

This message: [ Message body ]
Next message: Sam Mason: "Re: [GENERAL] "field doesn't exist" even though I'm sure it does"
Previous message: Sam Mason: "Re: [GENERAL] Primary Key"
In reply to: Tom Hart: "[GENERAL] "field doesn't exist" even though I'm sure it does"
Next in thread: Sam Mason: "Re: [GENERAL] "field doesn't exist" even though I'm sure it does"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Mon Jun 16 2008 - 20:03:54 EDT