Thanks, created table but can't figure out how to apply. Guess I need to crawl back to the newbie table. Any suggestions? I can see the the data when I do a select * from log. This would be good if I could use this to track certain access to web pages data. Is this what the product is good for? Eric Dunn Jeff Peterson <jpeterso@rangebroadband.com> on 08/16/2002 05:06:05 PM Please respond to jpeterso@rangebroadband.com To: Dan Hix/USA/BAC@BankofAmerica, Eric N. Dunn/USA/BAC@BankofAmerica cc: Randall.G.Steiner@BankofAmerica.com, Seth Baltuch/USA/BAC@BankofAmerica Subject: RE: [Zope] (no subject) Some small changes: CREATE TABLE log( log_id SERIAL, 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 DEFAULT TIMEOFDAY() ); I was a little unsure of what it was you were trying to accomplish with the timestamp, and as I am *not* an Oracle guru I made some guesses. The above function TIMEOFDAY() returns the high precision time with timezone, but you should probably investigate NOW() and TIMESTAMP and maybe some of the other Postgres time functions as well, just to be sure you are getting what you want. SERIAL variable handles all the sequence creation, etc. VARCHAR is also ok in place of "character varying".
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of eric.n.dunn@bankofamerica.com Sent: Friday, August 16, 2002 11:00 AM To: Dan.Hix@bankofamerica.com Cc: Randall.G.Steiner@bankofamerica.com; zope@zope.org; seth.baltuch@bankofamerica.com Subject: [Zope] (no subject)
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 )
I just converted the sql you gave me. If I were you I'd investigate closer whether my guess at the timestamp stuff is correct. I have no knowledge of the product. Jeff.
-----Original Message----- From: eric.n.dunn@bankofamerica.com [mailto:eric.n.dunn@bankofamerica.com] Sent: Friday, August 16, 2002 4:19 PM To: jpeterso@rangebroadband.com Cc: zope@zope.org Subject: RE: [Zope] (no subject)
Thanks, created table but can't figure out how to apply. Guess I need to crawl back to the newbie table. Any suggestions? I can see the the data when I do a select * from log.
This would be good if I could use this to track certain access to web pages data. Is this what the product is good for? Eric Dunn
Jeff Peterson <jpeterso@rangebroadband.com> on 08/16/2002 05:06:05 PM
Please respond to jpeterso@rangebroadband.com
To: Dan Hix/USA/BAC@BankofAmerica, Eric N. Dunn/USA/BAC@BankofAmerica cc: Randall.G.Steiner@BankofAmerica.com, Seth Baltuch/USA/BAC@BankofAmerica Subject: RE: [Zope] (no subject)
Some small changes:
CREATE TABLE log( log_id SERIAL, 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 DEFAULT TIMEOFDAY() );
I was a little unsure of what it was you were trying to accomplish with the timestamp, and as I am *not* an Oracle guru I made some guesses. The above function TIMEOFDAY() returns the high precision time with timezone, but you should probably investigate NOW() and TIMESTAMP and maybe some of the other Postgres time functions as well, just to be sure you are getting what you want.
SERIAL variable handles all the sequence creation, etc. VARCHAR is also ok in place of "character varying".
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of eric.n.dunn@bankofamerica.com Sent: Friday, August 16, 2002 11:00 AM To: Dan.Hix@bankofamerica.com Cc: Randall.G.Steiner@bankofamerica.com; zope@zope.org; seth.baltuch@bankofamerica.com Subject: [Zope] (no subject)
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 )
participants (2)
-
eric.n.dunn＠bankofamerica.com -
Jeff Peterson