[Bug 226689] [NEW PORT] databases/pgsanity: Check syntax of PostgreSQL SQL files

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=226689

            Bug ID: 226689
           Summary: [NEW PORT] databases/pgsanity:  Check syntax of
                    PostgreSQL SQL files
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: freebsd-ports-bugs at FreeBSD.org
          Reporter: 0mp at FreeBSD.org
 Attachment #191589 text/plain
         mime type:

Created attachment 191589
  --> https://bugs.freebsd.org/bugzilla/attachment.cgi?id=191589&action=edit
Shell archive of a new databases/pgsanity port (version: v0.2.8.20170811)

PgSanity is a utility to check syntax of PostgreSQL SQL files. I find it pretty
handy and it would be nice to have it in our ports tree.

The Makefile is pretty straightforward. The package requires ecpg, which is an
embedded SQL C preprocessor installed with a PostgreSQL server. Unfortunately,
I have not found a way to avoid adding PostgreSQL as a dependency. Another
issue is that the upstream maintainer haven't tagged the newest 0.2.9 release
on GitHub. Because of this I suggest to use 0.2.8.20170811 for the time being.
This way the future transition should be easy.

QA:
 - poudriere: 11.1-RELEASE amd64 (with postgresql95-server)
 - portlint
 - my machine: FreeBSD 12.0-CURRENT r330529 amd64 (with postgresql10-server)

Cheers!

-- 
You are receiving this mail because:
You are the assignee for the bug.