consulta en query

From: Ernesto Quiñones <ernesto(at)eqsoft(dot)net>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: consulta en query
Date: 2006-09-10 05:58:59
Message-ID: 200609100059.00447.ernesto@eqsoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Hola amigos tengo una situación algo extraña

el siguiente query corriendo desde el psql funciona sin problemas

SELECT c.relname AS Name
FROM pg_class c, pg_user u
WHERE c.relowner = u.usesysid AND c.relkind = 'r' AND
NOT EXISTS (SELECT 1 FROM pg_views WHERE viewname = c.relname)
AND c.relname !~ '^(pg_|sql_)'
UNION
SELECT c.relname AS Name
FROM pg_class c
WHERE c.relkind = 'r' AND NOT EXISTS
(SELECT 1 FROM pg_views WHERE viewname = c.relname)
AND NOT EXISTS (SELECT 1 FROM pg_user WHERE usesysid =
c.relowner)
AND c.relname !~ '^pg_'

ahora si lo corro desde php (4.3.4) en el log del postgresql recibo este
mensaje

LOG: statement: SELECT c.relname AS Name
FROM pg_class c, pg_user u WHERE c.relowner =
u.usesysid
AND c.relkind = 'r' AND NOT EXISTS
(SELECT 1 FROM pg_views WHERE viewname =
c.relname)
AND c.relname !~ '^(pg_|sql_)' UNION
SELECT c.relname AS Name FROM pg_class c
WHERE c.relkind = 'r' AND NOT EXISTS
(SELECT 1 FROM pg_views WHERE viewname =
c.relname)
AND NOT EXISTS (SELECT 1 FROM pg_user WHERE
usesysid = c.relowner)
AND c.relname !~ '^pg_'
ERROR: syntax error at or near "(" at character 286

si lo revisan bien son identicos, es mas copio el del log y lo corro en el
psql sin cambio alguno y corre sin problemas

e probado el query en psql con postgresql 8.1 y 7.4 y recibo el mismo problema
cuando lo invoco desde php, que puede estar pasando?

saludos

--
HTTP://WWW.EQSOFT.NET
Desarrollo de Software
Consultorías y Capacitación
Redes y Seguridad
Auditoría Informática

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Juan Martínez 2006-09-10 16:35:18 Re: ampliar fisicamente
Previous Message Juan Pablo Romero Bernal 2006-09-10 04:22:45 Re: