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 )