Re: [HACKERS] Re: Problem dropping databases - Mailing list pgsql-hackers

From Sferacarta Software
Subject Re: [HACKERS] Re: Problem dropping databases
Date
Msg-id 1608.980924@bo.nettuno.it
Whole thread Raw
In response to Re: Problem dropping databases  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
Hello Bruce,

martedì, 22 settembre 98, you wrote:

>> I was working on docs and notice that Postgres no longer responds with a
>> warning if a database is dropped multiple times:
>>
>> postgres=> drop database yahoo;
>> DESTROYDB
>> postgres=> drop database yahoo;
>> DESTROYDB
>> postgres=> \c yahoo
>> connecting to new database: yahoo
>> FATAL 1:  Database 'yahoo' does not exist.
>> golem$ psql
>> postgres=> drop database yahoo;
>> DESTROYDB
>>
>> The destroydb command behaves similarly. The behavior documented by
>> Jose' was:

Sorry for interference, I'm Jose'.
Seems that my problem is a little bit different. I've tried almost all
PostgreSQL commands and the result is that only the following commands
kill the backend, i.e.:

   - DELETE
   - DROP DATABASE
   - DROP USER
   - LOCK TABLE

PQexec() -- Request was sent to backend, but backend closed the channel before
responding.
        This probably means the backend terminated abnormally before or while
processing the request.

-------------------------------------------------------------
I tried also with success the following commands:

alter table
alter user
begin
copy
create aggregate
create database
create function
create index
create language
create operator
create sequence
create table
create trigger
create type
create user
create view
declare
drop aggregate
drop function
drop index
drop language
drop operator
drop sequence
drop table
drop trigger
drop type
drop view
fetch
grant
insert
move
revoke
rollback
select
update
vacuum
---------------------------------------------
Any ideas ?

 Jose'



pgsql-hackers by date:

Previous
From: Theo Kramer
Date:
Subject: ...
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] Re: [SQL] 2 questions.