Index: openacs-4/packages/acs-lang/www/admin/message-list-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/Attic/message-list-postgresql.xql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/acs-lang/www/admin/message-list-postgresql.xql 9 Dec 2003 13:41:52 -0000 1.1.2.1 +++ openacs-4/packages/acs-lang/www/admin/message-list-postgresql.xql 9 Feb 2004 09:56:03 -0000 1.1.2.2 @@ -9,15 +9,15 @@ select lm1.message_key, lm1.message as default_message, lm2.message as translated_message, - lmk.description + lmk.description, + coalesce(lm2.deleted_p, 'f') as deleted_p from lang_messages lm1 left outer join lang_messages lm2 on (lm2.locale = :locale and lm2.message_key = lm1.message_key and lm2.package_key = lm1.package_key), lang_message_keys lmk where lm1.locale = :default_locale and lm1.package_key = :package_key and lm1.message_key = lmk.message_key and lm1.package_key = lmk.package_key - and (lm2.deleted_p = 'f' or lm2.deleted_p is null) and lm1.deleted_p = 'f' $where_clause order by upper(lm1.message_key), lm1.message_key