Internal catalogs error in log file

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Internal catalogs error in log file
Date: 2005-08-04 01:51:42
Message-ID: 20050804015142.5427.qmail@web52907.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I saw this in my log file:

ERROR: invalid regular expression: quantifier operand
invalid
STATEMENT: SELECT n.nspname as "Schema",
p.proname as "Name",
CASE WHEN p.proretset THEN 'setof ' ELSE ''
END ||
pg_catalog.format_type(p.prorettype, NULL)
as "Result data type",
pg_catalog.oidvectortypes(p.proargtypes) as
"Argument data types"
FROM pg_catalog.pg_proc p
LEFT JOIN pg_catalog.pg_namespace n ON
n.oid = p.pronamespace
WHERE p.prorettype <>
'pg_catalog.cstring'::pg_catalog.regtype
AND p.proargtypes[0] <>
'pg_catalog.cstring'::pg_catalog.regtype
AND NOT p.proisagg
AND
pg_catalog.pg_function_is_visible(p.oid)
AND p.proname ~ '^+$'
ORDER BY 1, 2, 3, 4;

It's greek to me ;). Any idea what caused this error,
and if there's some sort of problem?

Thanks,
CSN
PG 8.0.2

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-08-04 02:04:01 Re: feeding big script to psql
Previous Message SCassidy 2005-08-03 22:41:12 Re: Instalation batch file