[Zope] (no subject)

[Jeff Peterson]

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 )
>
>
>
>
>
>
>