[Pgsql-ayuda] LOG: query

From: Sandrigo Lezcano <alkafes(at)yahoo(dot)com>
To: Pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx
Subject: [Pgsql-ayuda] LOG: query
Date: 2003-07-01 23:50:15
Message-ID: 20030701235015.38149.qmail@web20006.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

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

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Alvaro Herrera 2003-07-02 00:44:37 Re: [Pgsql-ayuda] LOG: query
Previous Message Alvaro Herrera 2003-07-01 22:42:59 Re: Fw: [Pgsql-ayuda] log_statement - PowerBuilder/PostgreSQL