Re: DROP TABLE Appears to Fail
| От | Rick Genter |
|---|---|
| Тема | Re: DROP TABLE Appears to Fail |
| Дата | |
| Msg-id | BANLkTin3p6=XN2ScVSs8wBC===f5wFDxxg@mail.gmail.com обсуждение исходный текст |
| Ответ на | DROP TABLE Appears to Fail (Rich Shepard <rshepard@appl-ecosys.com>) |
| Ответы |
Re: DROP TABLE Appears to Fail
|
| Список | pgsql-general |
Silly question, but did you try it with a semicolon after the drop table?
--
Rick Genter
rick.genter@gmail.com
# drop table station_type;
I've noticed that if you are in the middle of a statement and issue a \ command, psql ignores the SQL you've typed in and just does the \ command.
On Tue, Jun 28, 2011 at 3:34 PM, Rich Shepard <rshepard@appl-ecosys.com> wrote:
I cannot recall issuing a DROP TABLE command from psql that did not work,
but seem to have this as a new experience.
When I look at the database table list with '\d' I see
public | station_type | table | rshepard
public | station_type_statype_seq | sequence | rshepard
and I want to drop and recreate these with a typo fixed. But, the drop
commands do not appear to work:
# drop table station_type
# \d
public | station_type | table | rshepard
public | station_type_statype_seq | sequence | rshepard
I fail to see what I'm doing incorrectly and would appreciate a clue stick
to set me on the proper path.
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Rick Genter
rick.genter@gmail.com
В списке pgsql-general по дате отправления: