这是indexloc提供的服务,不要输入任何密码
Skip to content

Postgresql If Not Exists #3766

@nrakochy

Description

@nrakochy

Hi there,

Thanks for the great tool. It seems as though the if not exists syntax is not supported by the SQL runner. I went ahead and dropped the syntax and created the table correctly, but perhaps this is useful information.

  1. Go to Data > SQL
  2. Attempt to create a table
CREATE TABLE IF NOT EXISTS article_tag (
  article_id INT
  tag_id INT
  PRIMARY KEY (article_id, tag_id)
)
  1. Error

Screen Shot 2020-01-23 at 11 43 16 AM

Metadata

Metadata

Assignees

No one assigned

    Labels

    c/consoleRelated to consolee/quickfixcan be wrapped up in few hoursgood first issueGood for newcomershelp wantedGood candidate for contribution. Community help wanted!k/bugSomething isn't workingp/mediumnon-urgent issues/features that are candidates for being included in one of the upcoming sprints

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions