Обсуждение: trouble dropping a table

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

"Tena Sakai" <tsakai@gallo.ucsf.edu> wrote:

>    Schema |        Name         | Type  | Owner
>   --------+---------------------+-------+-------
>    public | gallo.plate_subject | table | ysu
>   (1 row)
>
> and I want to get rid of this table.

How about?:

DROP TABLE public."gallo.plate_subject"

It looks like you have a dot in your table name, which would require
quotes like that.

-Kevin

Many thanks, Scott and Kevin.

Regards,

Tena Sakai
tsakai@gallo.ucsf.edu


-----Original Message-----

From:    Scott Whitney [swhitney@journyx.com]    Sent:           Fri 6/26/2009 11:26 AM

Try:
drop table "gallo.plate_subject"

with the quotes.


-----Original Message-----
From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov]
Sent: Fri 6/26/2009 11:31 AM
To: Tena Sakai; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] trouble dropping a table

"Tena Sakai" <tsakai@gallo.ucsf.edu> wrote:

>    Schema |        Name         | Type  | Owner
>   --------+---------------------+-------+-------
>    public | gallo.plate_subject | table | ysu
>   (1 row)
>
> and I want to get rid of this table.

How about?:

DROP TABLE public."gallo.plate_subject"

It looks like you have a dot in your table name, which would require
quotes like that.

-Kevin