FreshPorts -- The Place For Ports If you buy from Amazon USA, please support us by using this link.
Follow us
Blog
Twitter

I am looking for an LTO tape library. Do you have one to spare?
found NOTHING in cache
			SELECT count(DISTINCT CL.id) AS count
			  FROM element_pathname EP, commit_log_elements CLE, commit_log CL
			 WHERE EP.pathname   = '/ports/head/databases/postgis20/pkg-plist'
			   AND EP.element_id = CLE.element_ID
			   AND CL.id         = CLE.commit_log_id
PageNumber='1'
Offset='0'
		SELECT DISTINCT
			CL.commit_date - SystemTimeAdjust()                                                                 AS commit_date_raw,
			CL.id                                                                                               AS commit_log_id,
			CL.encoding_losses                                                                                  AS encoding_losses,
			CL.message_id                                                                                       AS message_id,
			CL.committer                                                                                        AS committer,
			CL.description                                                                                      AS commit_description,
			to_char(CL.commit_date - SystemTimeAdjust(), 'DD Mon YYYY')                                         AS commit_date,
			to_char(CL.commit_date - SystemTimeAdjust(), 'HH24:MI')                                             AS commit_time,
			element.name                                                                                                AS port,
			element_pathname(element.id)                                                                                AS pathname,
			element.status                                                                                              AS status,
			element_pathname.pathname                            as element_pathname,
			CL.message_subject,
			NULL AS port_id,
			0    AS needs_refresh,
			NULL AS forbidden,
			NULL AS broken,
			NULL AS deprecated,
			NULL AS ignore,
			commit_log_elements.element_id,
			NULL AS version,
			NULL AS epoch,
			NULL as date_added,
			NULL AS short_description,
			NULL AS category_id,
			NULL AS category,
			NULL AS watch,
			NULL AS vulnerable_current,
			NULL AS vulnerable_past,
			NULL AS restricted,
			NULL AS no_cdrom,
			NULL AS expiration_date,
			NULL AS is_interactive,
			NULL AS only_for_archs,
			NULL AS not_for_archs,
			NULL AS stf_message,
			commit_log_elements.revision_name as revision,
			R.name         AS repo_name,
			R.svn_hostname AS hostname,
			R.path_to_repo AS path_to_repo 
    FROM commit_log_elements, commit_log CL LEFT OUTER JOIN repo R on  CL.repo_id = R.id, element_pathname, element 
	  WHERE CL.id IN (SELECT tmp.ID FROM (SELECT DISTINCT CL.id, CL.commit_date
  FROM element_pathname EP, commit_log_elements CLE, commit_log CL
 WHERE EP.pathname   = '/ports/head/databases/postgis20/pkg-plist'
   AND EP.element_id = CLE.element_ID
   AND CL.id         = CLE.commit_log_id
ORDER BY CL.commit_date DESC 
LIMIT 100) AS tmp)
	    AND commit_log_elements.commit_log_id = CL.id
	    AND commit_log_elements.element_id    = element.id
        AND element_pathname.element_id       = element.id
   ORDER BY 1 desc,
			commit_log_id, element_pathname
That would give us 469 rows
non port: head/databases/postgis20/pkg-plist
SVNWeb

Number of commits found: 5

Mon, 20 Oct 2014
[ 10:41 bapt ] Original commit 
371255 databases/WWWdb/pkg-plist
371255 databases/adminer/pkg-plist
371255 databases/adodb/pkg-plist
371255 databases/adodb5/pkg-plist
371255 databases/akonadi-googledata/pkg-plist
371255 databases/bbdb/pkg-plist
371255 databases/buzhug/pkg-plist
371255 databases/c3p0/pkg-plist
371255 databases/cassandra/pkg-plist
371255 databases/cassandra2/pkg-plist

(Only the first 10 of 451 ports in this commit are shown above. View all ports for this commit)
Cleanup plist
Mon, 28 Jul 2014
[ 12:54 sunpoet ] Original commit 
363139 databases/postgis20/Makefile
363139 databases/postgis20/pkg-install
363139 databases/postgis20/pkg-plist
- Convert to new options helper
- Sort LIB_DEPENDS
- Use CONFLICTS_INSTALL instead of CONFLICTS
- Use USES=libtool
- Use WANT_PGSQL
- Fix shebang
- Remove PKGINSTALL
- Do not silence post-install:
- Cosmetic change
- Bump PORTREVISION for package change
Mon, 23 Dec 2013
[ 20:59 rm ] Original commit 
337295 databases/postgis20/Makefile
337295 databases/postgis20/distinfo
337295 databases/postgis20/files
337295 databases/postgis20/files/patch-configure
337295 databases/postgis20/pkg-descr
337295 databases/postgis20/pkg-plist
- update to 2.0.4
- replace LATEST_LINK with PKGNAMESUFFIX
- add conflicts with other postgis branches
- add staging support
- add patch to link with json-c (upstream ticket #2213)
- define LICENSE (GPLv2)
- update COMMENT

PR:		182031
Submitted by:	Trevor Caira <trevor@bitba.se>, romain
Approved by:	maintainer timeout (3 months)
Wed, 27 Mar 2013
[ 09:35 ohauer ] Original commit 
315362 databases/postgis20/Makefile
315362 databases/postgis20/pkg-plist
- fix pkg-plist
Tue, 19 Feb 2013
[ 20:35 ohauer ] Original commit 
312601 databases/Makefile
312601 databases/postgis20
312601 databases/postgis20/Makefile
312601 databases/postgis20/distinfo
312601 databases/postgis20/pkg-descr
312601 databases/postgis20/pkg-install
312601 databases/postgis20/pkg-plist
- new port postgis20

PostGIS adds support for geographic objects to the PostgreSQL object-relational
database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing
it to be used as a backend spatial database for geographic information systems
(GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS follows the
OpenGIS "Simple Features Specification for SQL" and has been certified as
compliant with the "Types and Functions" profile.

PostGIS development was started by Refractions Research as a project in open
source spatial database technology. PostGIS is released under the GNU General
Public License. PostGIS continues to be developed by a group of contributors led
by a Project Steering Committee and new features continue to be added.

WWW: http://www.postgis.org/

PR:		174620
Submitted by:	Matthew Trisoline <matt.trisoline@intermedix.com>

Number of commits found: 5

Login
User Login
Create account

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

This site
What is FreshPorts?
About the authors
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
muttDec 23
muttDec 23
ntpDec 20
ntp-develDec 20
gitDec 19
otrsDec 16
mod_dav_svnDec 15
subversionDec 15
subversion16Dec 15
subversion17Dec 15
nvidia-driverDec 14
nvidia-driver-173Dec 14
nvidia-driver-304Dec 14
asterisk11Dec 11
bind99Dec 11

10 vulnerabilities affecting 28 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 24433
Broken 149
Deprecated 74
Ignore 400
Forbidden 2
Restricted 207
No CDROM 93
Vulnerable 20
Expired 0
Set to expire 69
Interactive 0
new 24 hours 1
new 48 hours3
new 7 days17
new fortnight42
new month100

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2014 Dan Langille. All rights reserved.