Re: PGError: ERROR: missing FROM-clause entry for table
| От | Robert Treat |
|---|---|
| Тема | Re: PGError: ERROR: missing FROM-clause entry for table |
| Дата | |
| Msg-id | AANLkTi=FY=tOjgF=YPmCuFAsMkt=rbajo6z761bi+Dnv@mail.gmail.com обсуждение исходный текст |
| Ответ на | PGError: ERROR: missing FROM-clause entry for table ("James B. Byrne" <byrnejb@harte-lyne.ca>) |
| Ответы |
Re: PGError: ERROR: missing FROM-clause entry for table
|
| Список | pgsql-general |
On Thu, Nov 25, 2010 at 9:21 PM, James B. Byrne <byrnejb@harte-lyne.ca> wrote:
I am getting this error:
PGError: ERROR: missing FROM-clause entry for table "ca_customs_entry"
LINE 1: ..._entries"."is_cadex_transmitted" = 'f') ORDER BY
ca_customs...
The code is generated by a Ruby-on-Rails-3.0.1 ActiveRecord model:
SELECT "ca_customs_shipments".* FROM "ca_customs_shipments" INNER
JOIN "ca_customs_entries" ON
"ca_customs_entries"."ca_customs_shipment_id" =
"ca_customs_shipments"."id" WHERE
("ca_customs_entries"."is_cadex_transmitted" = 'f') ORDER BY
ca_customs_entry.is_across_transmitted,
ca_customs_entry.is_across_rejected,
ca_customs_entry.is_across_accepted,
ca_customs_entry.is_cadex_released LIMIT 5 OFFSET 0
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.
Robert Treat
play: xzilla.net
work: l42.org/lg
В списке pgsql-general по дате отправления: