Re: psql dumps core

Tom Lane wrote:
>
> "K. Ari Krupnikov" <ari@iln.net> writes:
> > psql on the clent machime aborts with this message:
>
> > psql:recreate-dbdom-db.pgsql:4: \connect: pqReadData() -- backend closed
> > the channel unexpectedly.
> >         This probably means the backend terminated abnormally
> >         before or while processing the request.
> > Segmentation fault (core dumped)
>
> > I get a core dump in the current directory on the client.
>
> No advice possible with so little information.  What is the query
> that triggers the crash?  What are the definitions of the tables
> used in the query?  Can you get a backtrace from the psql coredump
> (and also from the backend coredump, if there is one ... which seems
> likely)?
>

this sequence causes the crash

# drop databse xxx;
# create database xxx;
# \c xxx;

and i was wrong when i said the backend doesn't crash - it does.

is there a limit on how many objects (tables, functions, etc) can be
created and dropped iin postgres?

--
K. Ari Krupnikov

DBDOM - bridging XML and relational databases
http://www.iter.co.il