Skip site navigation (1) Skip section navigation (2)

Re: Re: [ADMIN] pg_dump backup problems with password authentication

From: Trurl McByte <trurl(at)anything3d(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Re: [ADMIN] pg_dump backup problems with password authentication
Date: 2000-12-08 07:57:43
Message-ID: Pine.LNX.4.20.0012080953030.10331-100000@trurl.anything3d.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-bugs
On Thu, 7 Dec 2000 (Yesterday), Tom Lane wrote:

  TL> Trurl McByte <trurl(at)anything3d(dot)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--|


In response to

pgsql-admin by date

Next:From: rudyDate: 2000-12-08 14:15:28
Subject: CURSOR HELP
Previous:From: Ørjan VøllestadDate: 2000-12-08 07:55:31
Subject: dump & restore problem

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2000-12-08 15:56:40
Subject: JDBC: connection.isClosed() doesnt throw exception
Previous:From: Tom LaneDate: 2000-12-08 01:01:51
Subject: Re: [SQL] Unable to convert null timestamp to date. Bug?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group