Re: Cannot drop column

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wednesday, December 18, 2024, Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote:
> On Wed, 18 Dec 2024, Rich Shepard wrote:
>
> > > Since your column name has an Upper case character, you will have to use
> > > double quotes to drop it. Try alter table statustypes drop column
> > > "Suspect";
>
> > Thanks for the lesson.
>
> But,
>
> bustrac=# alter table statustypes drop column "Suspect"; ERROR:  column "Suspect" of relation "statustypes" does not exist
> bustrac=#
>
> Double quoting didn't resolve the issue.

Red Ron’s email…

David J.