Re: Two novice questions

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(at)techdevelopers(dot)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