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
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: |