As an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photos
All times are UTCnotbug
Ukraine
Menu ☰ Menu
Search engines are not blocked. Try using "site:www.freshports.org" and your search terms.
Volunteers wanted to help translate FreshPorts
Searches without login should now work. You must get asked to click a button.
Port details on branch 2023Q3
rubygem-pg_query Parses SQL queries using a copy of the PostgreSQL server query parser
4.2.1 databases Σ=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 4.2.1Version of this port present on the latest quarterly branch.
Maintainer: mfechner@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2023-07-08 11:01:31
Last Update: 2023-07-08 09:07:46
Commit Hash: b266641
Also Listed In: rubygems
License: BSD3CLAUSE
WWW:
https://github.com/lfittl/pg_query
Description: #
This Ruby extension uses the actual PostgreSQL server source to parse SQL queries and return the internal PostgreSQL parsetree. In addition the extension allows you to normalize queries (replacing constant values with ?) and parse these normalized queries into a parsetree again.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages: #
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist #
Expand this list (3 items)
Collapse this list.
  1. /usr/local/share/licenses/rubygem-pg_query-4.2.1/catalog.mk
  2. /usr/local/share/licenses/rubygem-pg_query-4.2.1/LICENSE
  3. /usr/local/share/licenses/rubygem-pg_query-4.2.1/BSD3CLAUSE
Collapse this list.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
Dependency lines:
  • rubygem-pg_query>0:databases/rubygem-pg_query
To install the port: #
cd /usr/ports/databases/rubygem-pg_query/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/rubygem-pg_query
  • pkg install rubygem-pg_query
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: rubygem-pg_query
Flavors: there is no flavor information for this port. #
distinfo: #
TIMESTAMP = 1687446390 SHA256 (rubygem/pg_query-4.2.1.gem) = b04820a9d1c0c1608e3240b7d84baabbee1b95a7302f29fdd0f00e901c604833 SIZE (rubygem/pg_query-4.2.1.gem) = 2274816
No package information for this port in our database #
Sometimes this happens. Not all ports have packages. Perhaps there is a build error. Check the fallout link: pkg-fallout
Dependencies #
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies: #
  1. rubygem-pathname>0 : devel/rubygem-pathname
  2. ruby31 : lang/ruby31
  3. gem : devel/ruby-gems
Runtime dependencies: #
  1. rubygem-google-protobuf>=3.22.3 : devel/rubygem-google-protobuf
  2. ruby31 : lang/ruby31
  3. gem : devel/ruby-gems
Patch dependencies: #
  1. ruby31 : lang/ruby31
Extract dependencies: #
  1. ruby31 : lang/ruby31
  2. gem : devel/ruby-gems
This port is required by: #
for Build #
  1. www/gitlab-ce
for Run #
  1. www/gitlab-ce
Configuration Options: #
No options to configure
Options name: #
databases_rubygem-pg_query
USES: #
gem
FreshPorts was unable to extract/find any pkg message #
Master Sites: #
Expand this list (1 items)
Collapse this list.
  1. https://rubygems.org/downloads/
Collapse this list.

Number of commits found: 1 #

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
4.2.1
08 Jul 2023 09:07:46
commit hash: b2666416ecf29fccd8098142e58b2e93bbed7f40commit hash: b2666416ecf29fccd8098142e58b2e93bbed7f40commit hash: b2666416ecf29fccd8098142e58b2e93bbed7f40commit hash: b2666416ecf29fccd8098142e58b2e93bbed7f40 files touched by this commit		 Matthias Fechner (mfechner) search for other commits by this committer 
databases/rubygem-pg_query: update to 4.2.1

Required for gitlab-ce 16.1
Changelog:
https://github.com/pganalyze/pg_query/blob/main/CHANGELOG.md

Upstream was a fix committed which breaks the compilation:
https://github.com/pganalyze/pg_query/commit/684aa77a21eb46188de0ab9bfdabcef71f591614
this is undone with a patch included here.
I reported this upstream:
https://github.com/pganalyze/pg_query/issues/291
Till this is fixed, we can keep the patch that undo 684aa77a21

(cherry picked from commit 03804b40854e11e4749ec488783d7ebfeb5119e6)

Number of commits found: 1

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
Security Policy
Privacy
Blog
Contact

Latest Vulnerabilities
libX11Oct 17
libXpmOct 17
libXrenderOct 17
libXtstOct 17
traefikOct 17
miniupnpdOct 16
mod_wsgiOct 16
p5-Text-CSV_XSOct 16
newsboatOct 15
nginxOct 15
nginx-develOct 15
nginx-fullOct 15
nginx-liteOct 15
nginx-module-cache-purgeOct 15
nsdOct 15

34 vulnerabilities affecting 399 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last processed:
2026-10-17 23:29:23 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 35268
Broken 74
Deprecated 339
Ignore 191
Forbidden 0
Restricted 1
No CDROM 1
Vulnerable 45
Expired 8
Set to expire 264
Interactive 0
new 24 hours 9
new 48 hours13
new 7 days42
new fortnight106
new month223
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2026 Dan Langille. All rights reserved.