Am Samstag, den 16.07.2005, 09:19 +0200 schrieb Jiří Němec: > Hello, > > There's a problem with PostgreSQL 8.0.3 SELECT. All tables exist, all > columns exist, I have no idea where's the problem :/ PostgreSQL > reports this error: ERROR: relation "fieldx" does not exist... > > SELECT fieldx.field_id, COUNT(optionx.option_id) AS field_options > FROM c_custom_fields AS fieldx, j_product_groups_fields AS join_table > LEFT JOIN c_custom_fields_options AS optionx ON optionx.field_id = fieldx.field_id > WHERE fieldx.field_id = join_table.field_id AND join_table.group_id = 10 > GROUP BY fieldx.field_id > ORDER BY fieldx.field_id > > Any clues? May we see \dt please? I'm pretty sure fieldx does not exist. Maybe you have "FieldX" or something instead? ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
