hi there is it possible to use a postgres view in AR? this code is being executed by AR to find a relation SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'iptrack'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum but it does not find my view "iptrack". i realise i may not be able to update my view without postgres rewrite rules, but I think i should be able to do searches on a view thanks for any help BD
on 2006-01-11 12:38
on 2006-01-11 12:50
sorry for the prior post, my mistake! doh!