-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Well, you might consider using the "on-topic" zope-db list...zope-db@zope.org for help. The kind of question you've got should be okay there... Russell On Friday 16 August 2002 12:51 pm, eric.n.dunn@bankofamerica.com wrote:
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 )
_______________________________________________ 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 )
- -- Linux -- the OS for the Renaissance Man -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE9Xb3zAqKGrvVshJQRAq7+AJkBhRIJQv6NIRxF6wnavTFCwF5sJwCgmkcW PLt67Cx9oa9qX3c6gXdOo6w= =F5+g -----END PGP SIGNATURE-----