Two novice questions

From: Jonathan Chum <jchum(at)techdevelopers(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Two novice questions
Date: 2001-01-14 08:40:56
Message-ID: 5.0.2.1.1.20010114033715.02b6bac0@mail.bomb.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have two problems. One, I would like to know how to remove a database. It
would always keep saying this:

PostgreSQL said: ERROR: DROP DATABASE: Database "blazeboard" is being
accessed by other users

I'm sure no one else is accessing it because I'm the only one who knows
that the database exists and ps doesn't show any other users connecting to it.

My second question is that I have created a table with a column, FID.
However, when I SELECT FID FROM table, it will result:

blazeboard=# SELECT FID FROM forum;
ERROR: Attribute 'fid' not found

Could this be a bug? I'm using v7.03 if it matters. Thanks, and please
reply also to my email if you do reply.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Richards 2001-01-14 18:19:21 Re: Bug in SQL functions that use a NULL parameter directly
Previous Message Oliver Elphick 2001-01-13 15:58:18 Re: Creating New User?