trouble dropping a table - Mailing list pgsql-admin

From Tena Sakai
Subject trouble dropping a table
Date
Msg-id FE44E0D7EAD2ED4BB2165071DB8E328C04E84BEF@egcrc-ex01.egcrc.org
Whole thread Raw
Responses Re: trouble dropping a table  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin

Hi Everybody,

I have a strange problem:

  canon=# \dt *plate*
                List of relations
   Schema |        Name         | Type  | Owner
  --------+---------------------+-------+-------
   public | gallo.plate_subject | table | ysu
  (1 row)

and I want to get rid of this table.  I thought I could

  canon=# drop table gallo.plate_subject;
  ERROR:  table "plate_subject" does not exist
  canon=#

and I did this:

  canon=# drop table public.gallo.plate_subject;
  ERROR:  cross-database references are not implemented: "public.gallo.plate_subject"
  canon=#

Can someone please tell me what I am doing wrong?

Thank you in advance.

Regards,

Tena Sakai
tsakai@gallo.ucsf.edu

pgsql-admin by date:

Previous
From: donghe@caltech.edu
Date:
Subject: Re: PHP cann't access to postgres databse
Next
From: Scott Marlowe
Date:
Subject: Re: PHP cann't access to postgres databse