Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

6
  • 1
    The issue is with DbVisualizer, not Postgres. Commented Sep 16, 2014 at 20:02
  • @ypercube: I've updated the post. Commented Sep 16, 2014 at 20:26
  • 1
    Probably DbVis created the table with the column quoted: "LOOP". As a result, if you do that, you then have to always quote the column. loop or LOOP will not work, the column has to be referred as "LOOP". Commented Sep 16, 2014 at 20:34
  • @ypercube I used psql to create the table, I use DbVisualizer only to view the DDL on the server side. Even if I had used DbVisualizer, the column is not "LOOP" as attested by the output of psql. Commented Sep 16, 2014 at 21:25
  • 1
    @ypercube: created SSCCE: dba.stackexchange.com/q/76776/34332 Commented Sep 16, 2014 at 21:39