agora inbox for postgres@postgres.berkeley.edu  
help / color / mirror / Atom feed
From: alfredos@tamu.edu
To: postgres@postgres.Berkeley.EDU
Subject: no response from backend with new dbs
Date: Mon, 26 Sep 94 09:31:51 CDT
Message-ID: <9409261431.AA17998@ bush.cs.tamu.edu> (raw)


I can use any databases that already exist but when I create
a new one I get no response from the backend. I have tried 
killing and restarting the postmaster and ipccleaning without
any success. Any suggestions anyone?

Thanks in advance,

-J. Alfredo Sanchez.                            alfredo@bush.cs.tamu.edu
________________________________________________________________________

P.S. I am using postgres 4.1. An example session follows:

hrl6%> monitor asmtest
Welcome to the C POSTGRES terminal monitor

Go 
* retrieve (Objects.all)\g

Query sent to backend is "retrieve (Objects.all)"
-----------------------------
| id          | components  |
-----------------------------
| 59552       | 0           |
-----------------------------
| 60224       | (null)      |
-----------------------------
| 76718       | 0           |
-----------------------------

Go 
* \q
I live to serve you.

hrl6%> createdb newdb
hrl6%> monitor newdb
Welcome to the C POSTGRES terminal monitor

Go 
* create  Objects(id=oid, components=oid) \g

Query sent to backend is "create  create Objects(id=oid, components=oid) "
Error: No response from the backend, exiting...

hrl6%> 

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================



reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: alfredos@tamu.edu
  Subject: Re: no response from backend with new dbs
  In-Reply-To: <9409261431.AA17998@ bush.cs.tamu.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox