Re: psql dumps core

"K. Ari Krupnikov" <ari@iln.net> writes:
>>>> I get a core dump in the current directory on the client.

> 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.

Can't reproduce this with current sources:

template1=# drop database xxx;
DROP DATABASE
template1=# create database xxx;
CREATE DATABASE
template1=# \c xxx;
FATAL 1:  Database "xxx;" does not exist in the system catalog.
Previous connection kept
template1=# \c xxx
You are now connected to database xxx.
xxx=#

It's possible that 7.0.* psql has some since-repaired bug when trying
to \c to a nonexistent database name --- Peter, do you recall anything
like that?

            regards, tom lane