From: | Juan Jose Comellas <juanjo(at)comellas(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Problem with time in export |
Date: | 2002-05-02 17:39:14 |
Message-ID: | 200205021439.14563.juanjo@comellas.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've found a strange problem when dumping a database with a view that has a
comparison between relative times.
I have a database with a view that was created with the following statement:
CREATE VIEW connected_merchant AS
SELECT merchant_client.merchant_id, merchant_client.version,
merchant_client.last_access_time,
merchant_client.broker_ip_address, merchant_client.broker_port,
merchant_client.merchant_ip_address,
merchant_client.merchant_port, merchant_client.connection_type,
merchant_client.polling_frequency
FROM merchant_client
WHERE merchant_client.connection_type = 'Push'
OR
( merchant_client.connection_type = 'Pull'
AND
CURRENT_TIMESTAMP - merchant_client.last_access_time < 60 );
When I dump the database with pg_dumpall, the dump file rewrites the script to
create the view as the following statement:
CREATE VIEW "connected_merchant" as
SELECT merchant_client.merchant_id, merchant_client."version",
merchant_client.last_access_time, merchant_client.broker_ip_address,
merchant_client.broker_port, merchant_client.merchant_ip_address,
merchant_client.merchant_port, merchant_client.connection_type,
merchant_client.polling_frequency
FROM merchant_client
WHERE ((merchant_client.connection_type = 'Push'::"varchar")
OR
((merchant_client.connection_type = 'Pull'::"varchar")
AND
(reltime(("timestamp"('now'::text) -
merchant_client.last_access_time)) < (60)::reltime)));
The problem is that if I try to restore the database from the dump file I get
the following error:
psql:/tmp/db_2002-05-02.dump:1692: ERROR: Bad reltime external representation
'60'
Anybody knows if this a Postgres bug or if I'm doing something wrong?
Thanks.
--
Juan Jose Comellas
(juanjo(at)comellas(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Davis | 2002-05-02 17:43:08 | Re: hexadecimal values |
Previous Message | Shaun Thomas | 2002-05-02 17:08:34 | Re: What popular, large commercial websites run |