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:31:17 EST

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

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

> Ok, that makes sense. Like I said I created this db to mimic our
> previous db, but I think the best solution here would be to continue
> my trend of using all lowercase column names so that I'm not faced
> with this problem.
>
> Thank you for your reply, and you too Joshua. Sorry for such an easy
> question :-)

No sweat :)... I trust you will have more. Bring them on.

Joshua D. Drake

> > Sam
> >
> > ---------------------------(end of
> > broadcast)--------------------------- TIP 6: explain analyze is
> > your friend
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 1: if posting/reading
> through Usenet, please send an appropriate subscribe-nomail command
> to majordomo@postgresql.org so that your message can get through to
> the mailing list cleanly
>

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

iD8DBQFHPf4WATb/zqfZUUQRAntLAJ4s6L7sLvYkeMkwGPfaKu/GuK+gGgCfXXd5 0/qLZJQUZd3TMEk6/vptgls=
=uYbF
-----END PGP SIGNATURE-----

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

Received on Fri Nov 16 15:32:55 2007

Do you need help?

This message: [ Message body ]
Next message: Sean Davis: "Re: [GENERAL] XML schema"
Previous message: Tom Hart: "Re: [GENERAL] "field doesn't exist" even though I'm sure it does"
In reply to: Tom Hart: "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:04:05 EDT