Обсуждение: Re: [ADMIN] pg_dump backup problems with password authentication

-----BEGIN PGP SIGNED MESSAGE-----

Hi!

============
trurl=# select '["2000-11-01 10:00:00+02" "2000-11-30 10:00:00+02"]'::tinterval =
trurl=# '["2000-09-01 10:00:00+03" "2000-09-30 10:00:00+03"]'::tinterval;
 ?column?
- ----------
 t
(1 row)
============
I'm crazy?

P.S. PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.95.2



- --
      Trurl McByte, Capt. of StasisCruiser "Prince"
|InterNIC: AR3200                   RIPE: AR1627-RIPE|
|--98 C3 78 8E 90 E3 01 35  87 1F 3F EF FD 6D 84 B3--|

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 5.0i for non-commercial use
Charset: noconv

iQCVAwUBOi+h0CC2QvVu8HIfAQF4hQP/RlPcwtl9ZE1hG9VT9itEB4Sys72Hyik8
Wcn+xo2+Rsl+fT83j9HccB/w/oZyzrKUWQIVC6h9ORU6CFmytD8NWZ28Uta3sQh/
U0YRmPSO860z+ObLSvTiLFexhQGNuwA1A/LSfYovqTfLTS6Lq2E7qNXoP92raebg
yIbeednitf8=
=RG4K
-----END PGP SIGNATURE-----

Trurl McByte <trurl@anything3d.com> writes:
> trurl=# select '["2000-11-01 10:00:00+02" "2000-11-30 10:00:00+02"]'::tinterval =
> trurl=# '["2000-09-01 10:00:00+03" "2000-09-30 10:00:00+03"]'::tinterval;
>  ?column?
> - ----------
>  t
> (1 row)

The tinterval comparison functions consider two tintervals equal if they
have the same length (duration).  Whether this is reasonable I dunno,
but that's how that datatype has always worked.

            regards, tom lane

On Thu, 7 Dec 2000 (Yesterday), Tom Lane wrote:

  TL> Trurl McByte <trurl@anything3d.com> writes:
  TL> > trurl=# select '["2000-11-01 10:00:00+02" "2000-11-30 10:00:00+02"]'::tinterval =
  TL> > trurl=# '["2000-09-01 10:00:00+03" "2000-09-30 10:00:00+03"]'::tinterval;
  TL> >  ?column?
  TL> > - ----------
  TL> >  t
  TL> > (1 row)
  TL>
  TL> The tinterval comparison functions consider two tintervals equal if they
  TL> have the same length (duration).  Whether this is reasonable I dunno,
  TL> but that's how that datatype has always worked.
Ok. But in next sample I have system crash:
=============
trurl=# create table ttable ( id int4, tt tinterval );
CREATE
trurl=# insert into ttable VALUES ( 1, '["2000-11-01 10:00:00" "2000-12-01 10:00:00"]');
INSERT 327690 1
trurl=# insert into ttable VALUES ( 2 );
INSERT 327691 1
trurl=# select * from ttable where tt = '["2000-11-01 10:00:00" "2000-12-01 10:00:00"]'::tinterval;
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!#
=============
NULL value in "tinterval"... :(


  TL>
  TL>             regards, tom lane
  TL>

--
      Trurl McByte, Capt. of StasisCruiser "Prince"
|InterNIC: AR3200                   RIPE: AR1627-RIPE|
|--98 C3 78 8E 90 E3 01 35  87 1F 3F EF FD 6D 84 B3--|