> 
> Bruce, it is failing on the first select:
> 
> -->findLastBuiltinOid(void) {
> --> SELECT oid from pg_database where datname = 'template1'
> }
> 
> template1=> SELECT oid from pg_database where datname = 'template1';
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally before
> or while pr
> ocessing the request.
> We have lost the connection to the backend, so further processing is
> impossible.
>   Terminating.
> 
> 
> That's where it bombs out.
> 
> Tim
> 

Can someone suggest why this would be happening?  The SELECT looks
pretty simple.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 16 Mar 1999 15:11:26 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] "CANNOT EXTEND" -
Thus spake Bruce Momjian
> > template1=> SELECT oid from pg_database where datname = 'template1';
> > pqReadData() -- backend closed the channel unexpectedly.
> >         This probably means the backend terminated abnormally before
> 
> Can someone suggest why this would be happening?  The SELECT looks
> pretty simple.

It works for me but I have the same thing happening on a database
where I do the following.

  SELECT * INTO TABLE tempset FROM trash WHERE "Shape" ~* 'Prow' ;

The tempset table doesn't exist and trash is just a table that the
user is trying to grab a subselect from.  I don't know if there is
a connection here but it brought to mind a question I have been meaning
to ask, how do I read the pg_log file?  I can't seem to find anything
that reads this.  Also, what sort of stuff gets put into that log?

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.

Tue, 16 Mar 1999 15:54:39 -0500 (EST)
"D'Arcy" "J.M." Cain <darcy@druid.net>
Re: [HACKERS] "CANNOT EXTEND" -