From: <no...@so...> - 2002-04-16 17:39:14
|
Bugs item #544781, was opened at 2002-04-16 10:35 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=418980&aid=544781&group_id=37132 Category: None Group: 2.4.1 Status: Open Resolution: None Priority: 5 Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: Error in All Databases Right Frame Initial Comment: PostgreSQL said: ERROR: No such function 'pg_encoding_to_char' with the specified attributes Your query: SELECT datname, usename AS owner, pg_encoding_to_char (encoding) AS enc FROM pg_database d, pg_user u WHERE d.datdba = u.usesysid AND datname NOT LIKE 'template_' AND pg_get_userbyid(datdba) = CURRENT_USER UNION SELECT datname, NULL AS owner, pg_encoding_to_char (encoding) AS enc FROM pg_database WHERE datdba NOT IN (SELECT usesysid FROM pg_user) AND datname NOT LIKE 'template_' AND pg_get_userbyid (datdba) = CURRENT_USER ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2002-04-16 10:39 Message: Logged In: NO I'm running PostgreSQL 6.5.3 ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=418980&aid=544781&group_id=37132 |