From: | "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca> |
---|---|
To: | "Robert Treat" <rob(at)xzilla(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PGError: ERROR: missing FROM-clause entry for table |
Date: | 2010-11-26 03:13:40 |
Message-ID: | 60401.70.50.88.137.1290741220.squirrel@webmail.harte-lyne.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, November 25, 2010 21:58, Robert Treat wrote:
> On Thu, Nov 25, 2010 at 9:21 PM, James B. Byrne
> <byrnejb(at)harte-lyne(dot)ca>wrote:
>>
>
> Looks to me like the problem is you are trying to ORDER BY columns
> in
> "ca_customs_entry", but there is no such table for that (don't
> confuse it
> with "ca_customs_entries"). You need to either set a matching
> alias, or fix
> the table name qualifier in those order by columns.
That was exactly the problem. Thank you very much. I am afraid
that the mental gymnastics that Rails requires--table names are
plural, corresponding model classes are singular--often trips me up.
I would never have seen that error on my own.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne mailto:ByrneJB(at)Harte-Lyne(dot)ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
From | Date | Subject | |
---|---|---|---|
Next Message | Leif Jensen | 2010-11-26 05:04:13 | Help on explain analyze |
Previous Message | Robert Treat | 2010-11-26 02:58:18 | Re: PGError: ERROR: missing FROM-clause entry for table |