Re: Table appears on listing but can't drop it

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Fernando Morgenstern <fernando(at)consultorpc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Table appears on listing but can't drop it
Date: 2010-01-11 11:04:56
Message-ID: 20100111110456.GA12536@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jan 11, 2010 at 08:58:57AM -0200, Fernando Morgenstern wrote:
> Em 09/01/2010, às 19:40, hubert depesz lubaczewski escreveu:
>
> > On Fri, Jan 08, 2010 at 02:39:03PM -0200, Fernando Morgenstern wrote:
> >> postgres=# drop database skynet;
> >> ERROR: database "skynet" does not exist
> >
> > do:
> >
> > psql -l | hexump -C
> > and examine output.
> >
> > Best regards,
> >
> > depesz
> >
> > --
> > Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
> > jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007
>
>
> Hi,
>
> I have done:
>
> # psql -U postgres -p 4000 -l | hexdump -C
>
> And got the two databases: http://pastebin.ca/1746711
>
> I couldn't find any difference here.

Could you add -qAt to psql options and rerun the command?

Best regards,

depesz

--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fernando Morgenstern 2010-01-11 11:08:27 Re: Table appears on listing but can't drop it
Previous Message Fernando Morgenstern 2010-01-11 10:58:57 Re: Table appears on listing but can't drop it