Re: Two novice questions - Mailing list pgsql-novice

From Jonathan Chum
Subject Re: Two novice questions
Date
Msg-id 5.0.2.1.0.20010114230610.02ad7860@mail.bomb.net
Whole thread Raw
In response to Re: Two novice questions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Thank you. I figured it out. However I still cannot drop the database, so
each time I want to start fresh/clean, I have to delete the tables and
sequences and then recreate the tables and sequences.

At 09:18 PM 1/14/2001 -0500, Tom Lane wrote:
>Jonathan Chum <jchum@techdevelopers.com> writes:
> > PostgreSQL said: ERROR: DROP DATABASE: Database "blazeboard" is being
> > accessed by other users
>
>It's difficult to see how you could get this error unless there is at
>least one backend connected to the target database.  Check for
>background processes you've forgotten about, etc etc.
>
> > 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
>
>What does "\d forum" show as the column name?
>
>If you created the table along the lines of
>         create table forum ("FID" int, ...);
>then all subsequent references to that column name will have to be
>double-quoted as well.  Unquoted names are implicitly folded to lower
>case ... quoted ones are not.
>
>                         regards, tom lane


pgsql-novice by date:

Previous
From: ashley
Date:
Subject: starting postmaster
Next
From: Francisco Reyes
Date:
Subject: Where docs on transactions?