Thread: Re: [HACKERS] "CANNOT EXTEND" -

> 
> 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,
Pennsylvania19026
 

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.