| 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: | Whole Thread | Raw Message | 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: |