[Pgsql-ayuda] LOG: query

Sandrigo Lezcano alkafes@yahoo.com
Tue, 1 Jul 2003 18:50:15 -0500 (CDT)


mmm  creo que confirma mi teoria de squema y owner
----
bueno quito todo esto de las lineas
Jul  1 18:50:25 localhost postgres[3013]: 
----  ya envie pero fue moderado ---
completo desde la conexion hasta el chau..
y por eso el error de blank (creo ..mmm)



[15-1] LOG:  query: select relname, nspname, relkind
from pg_class, pg_namespace where relkind in ('r',
'v') and nspname like
[15-2]  'postgres' and relname like 'PBCATTBL' and
relname !~ '^pg_|^dd_' and pg_namespace.oid =
relnamespace order by nspname, relname
[16] LOG:  duration: 0.002744 sec
[17-1] LOG:  query: CREATE TABLE postgres.pbcattbl
(pbt_tnam char(65) NOT NULL,pbt_tid int4 ,pbt_ownr
char(65) NOT NULL,pbd_fhgt int2
[17-2]  ,pbd_fwgt int2 ,pbd_fitl char(1) ,pbd_funl
char(1) ,pbd_fchr int2 ,pbd_fptc int2 ,pbd_ffce
char(18) ,pbh_fhgt int2 ,pbh_fwgt
[17-3]  int2 ,pbh_fitl char(1) ,pbh_funl char(1)
,pbh_fchr int2 ,pbh_fptc int2 ,pbh_ffce char(18)
,pbl_fhgt int2 ,pbl_fwgt int2
[17-4]  ,pbl_fitl char(1) ,pbl_funl char(1) ,pbl_fchr
int2 ,pbl_fptc int2 ,pbl_ffce char(18) ,pbt_cmnt
varchar(254) )
[18] ERROR:  Namespace "postgres" does not exist
[19-1] LOG:  query: select relname, nspname, relkind
from pg_class, pg_namespace where relkind in ('r',
'v') and relname !~ '^pg_|^dd_'
[19-2]  and pg_namespace.oid = relnamespace order by
nspname, relname
[20] LOG:  duration: 0.004922 sec
[21-1] LOG:  query: select u.nspname, c.relname,
a.attname, a.atttypid, t.typname, a.attnum, a.attlen,
a.atttypmod, a.attnotnull,
[21-2]  c.relhasrules from pg_namespace u, pg_class c,
pg_attribute a, pg_type t where u.oid = c.relnamespace
and c.oid= a.attrelid and
[21-3]  a.atttypid = t.oid and (a.attnum > 0) and
c.relname like 'descuentos\\_diferidos\\_tipos' and
u.nspname like 'public' order by
[21-4]  u.nspname, c.relname, attnum
[22] LOG:  duration: 0.031145 sec


_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com