The verbose output shows the table being vacuumed last. Maybe it
changed after 8.0
Greg Stark wrote:
Jim Nasby <[EMAIL PROTECTED]> writes:
My RFE: When vacuuming a table, pg should try to vacuum the primary key
first. If that results in 0 recovered entries, then assume the table has no
up
Mark Gibson <[EMAIL PROTECTED]> writes:
> I have unexpected results when trying to cast a string to a timestamp:
> test=# select TIMESTAMP WITH TIME ZONE '2006/06/25 06:00:00 GMT-5'
> test-# ;
>timestamptz
>
> 2006-06-24 20:00:00-05
IIRC, the semantics of the 'G
Mark Gibson wrote:
I have unexpected results when trying to cast a string to a timestamp:
test=# select TIMESTAMP WITH TIME ZONE '2006/06/25 06:00:00 GMT-5'
test-# ;
timestamptz
2006-06-24 20:00:00-05
Seems that what I get is about 10 hours earlier than I expec
I have unexpected results when trying to cast a string to a timestamp:
test=# select TIMESTAMP WITH TIME ZONE '2006/06/25 06:00:00 GMT-5'
test-# ;
timestamptz
2006-06-24 20:00:00-05
Seems that what I get is about 10 hours earlier than I expect...
Any ideas why
Michael Glaesemann wrote:
On Jun 25, 2006, at 14:23 , Mark Gibson wrote:
SELECT play_length - INTERVAL 'play_seconds seconds' ...
The column isn't interpolated into the string. Try
SELECT play_length - play_seconds * INTERVAL '1 second'
That worked great! Thanks!
Mark
-
I have a table which required some modifications, but making these
changes meant that i had to adjust some functions and types, as well. As
the DB is not "live" yet, i simply dumped everything, and copied the
bits that needed changes to a new file, made the changes, and ran that.
Unfortunately,
Tom Lane wrote:
> Um. Extract from the 8.0.5 CVS logs:
>
> 2005-12-08 14:19 tgl
>
> * src/backend/: postmaster/bgwriter.c, utils/resowner/resowner.c
> (REL8_0_STABLE): Fix bgwriter's failure to release buffer pins and
> open files after an error. This probably explains bug #20
Yet another way, this time being more explicit.
SELECT play_length - play_seconds * '1 second'::interval
Cheers.
On Saturday 24 June 2006 22:23, Mark Gibson wrote:
> If play_length is a timestamp, I can do this:
>
> SELECT play_length - INTERVAL '13 seconds' ...
>
> But what if play_seconds is
