[Zope] (no subject)

eric.n.dunn@bankofamerica.com eric.n.dunn@bankofamerica.com
Fri, 16 Aug 2002 12:51:33 -0400


It has to do with setting up "SQL Log" that I saw announced on Zope.org this
morning(http://www.zope.org/Members/hdstich/SQLLog_announce).  I want to try
but we only have Oracle people here.  Can't find a Postgresql person local.
I have it in my Zope 2.5.1 instance but am not a PG expert.




Jens Vagelpohl <jens@zope.com> on 08/16/2002 12:31:19 PM

To:   Eric N. Dunn/USA/BAC@BankofAmerica
cc:   Seth Baltuch/USA/BAC@BankofAmerica,
      Randall.G.Steiner@BankofAmerica.com, zope@zope.org, Dan
      Hix/USA/BAC@BankofAmerica
Subject:  Re: [Zope] (no subject)



apart from the fact that this question is off-topic on this list, postgres
documentation is available online::

http://www.postgresql.org/idocs/index.php?user.html

jens


On Friday, August 16, 2002, at 12:00 , eric.n.dunn@bankofamerica.com wrote:

>
>
> Does anyone know the comparable SQL for Postgresql.
>
>
> CREATE TABLE log (
>       log_id integer DEFAULT nextval('log_id_seq'::text),
>       severity character varying(32) DEFAULT 'INFO' NOT NULL,
>       subsystem character varying(80) DEFAULT 'DTML' NOT NULL,
>       summary character varying(256) DEFAULT '' NOT NULL,
>       detail character varying(8192) DEFAULT '' NOT NULL,
>       log_time timestamp(2) without time zone DEFAULT
> ('now'::text)::timestamp(6) with time zone
>     );
>


_______________________________________________
Zope maillist  -  Zope@zope.org
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )