[rt-devel] Postgres, bytea and my ruined evening.
Jesse Vincent
jesse at bestpractical.com
Thu Mar 20 15:25:10 EST 2003
Can folks who've been having Postgres issues give this snapshot a shot?
http://fsck.com/aegis/aegis.cgi/rt.3.0.C28.tar.gz?file@aetar+project@rt.3.0+change@28
Also, for the upgrade instructions, what's the recommended postgres
procedure for "dump all data, _but not the schema_ from this database to a file on disk and then reload it"?
On Thu, Mar 20, 2003 at 03:03:45PM -0500, Jesse Vincent wrote:
>
>
>
> > > At 03:13 PM 20/03/2003 +1100, Philip Warner wrote:
> > > > LastUpdated TIMESTAMP not null default current_timestamp
> > >
> > > ...that should really be 'TIMESTAMP WITHOUT TIME ZONE' to be consistent.
> > >
> > Thanks. Applied.
>
> Except my postgres 7.3.2 doesn't like the syntax and my reading of the
> docs seems to claim that 'WITHOUT TIME ZONE' is the default.
> Anway, this table isn't going to be touched using the RT API, only using
> a reaper to clear out old sessions. I'm going to back out this change.
>
> -j
>
> --
> http://www.bestpractical.com/rt -- Trouble Ticketing. Free.
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
--
http://www.bestpractical.com/rt -- Trouble Ticketing. Free.
More information about the Rt-devel
mailing list