SELECT count(DISTINCT CL.id) AS count
			  FROM element_pathname EP, commit_log_elements CLE, commit_log CL
			 WHERE EP.pathname   = '/ports/head/databases/postgresql73/Makefile'
			   AND EP.element_id = CLE.element_ID
			   AND CL.id         = CLE.commit_log_id

		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/postgresql73/Makefile'
   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

non port: head/databases/postgresql73/Makefile

SVNWeb

Number of commits found: 14

Mon, 31 Jan 2005

[ 00:39 girgen ]   1.130 databases/postgresql7/Makefile 1.36 databases/postgresql7/distinfo 1.6 databases/postgresql7/files/502.pgsql 1.3 databases/postgresql7/files/dot.cshrc.in 1.6 databases/postgresql7/files/dot.profile.in 1.2 databases/postgresql7/files/patch-configure 1.2 databases/postgresql7/files/patch-src:backend:utils:misc:postgresql.conf.sample 1.17 databases/postgresql7/files/pgsql.sh.tmpl 1.4 databases/postgresql7/files/pkg-message.server 1.20 databases/postgresql7/files/post-install-notes (Only the first 10 of 25 ports in this commit are shown above. ) Split the postgresql ports into a server and a client part. Hence, remove this port. Please see UPDATING for more info. PR: 75344 Approved by: portmgr@ (kris), ade & sean (mentors)

Mon, 6 Dec 2004

[ 03:59 girgen ]   1.39 databases/p5-Pg/Makefile 1.14 databases/p5-postgresql-plperl/Makefile 1.41 databases/pgaccess/Makefile 1.7 databases/postgresql-contrib/Makefile 1.10 databases/postgresql-docs/Makefile 1.14 databases/postgresql-jdbc/Makefile 1.7 databases/postgresql-libpq++/Makefile 1.15 databases/postgresql-libpqxx/Makefile 1.8 databases/postgresql-odbc/Makefile 1.13 databases/postgresql-pltcl/Makefile (Only the first 10 of 23 ports in this commit are shown above. ) Add myself as committer, and use my @FreeBSD.org address. Approved by: ade (mentor)

Fri, 5 Nov 2004

[ 19:23 ade ]   1.128 databases/postgresql7/Makefile 1.35 databases/postgresql7/distinfo 1.127 databases/postgresql73/Makefile 1.35 databases/postgresql73/distinfo Update postgresql 7.3.7 -> 7.3.8 and 7.4.5 -> 7.4.6 due to security advisories in http://www.postgresql.org/news/234.html Note that postgresql 7.2.x is NOT being updated here since it is due for termination real soon now. Submitted by: maintainer, also referenced in ports/73142 (no patch)

Tue, 31 Aug 2004

[ 13:44 eik ]   1.126 databases/postgresql73/Makefile 1.34 databases/postgresql73/distinfo - update to version 7.3.7: * Prevent possible loss of committed transactions during crash. PR: 71179 Submitted by: SUGIMURA Takashi <sugimura@jp.FreeBSD.org> Reviewed by: Palle Girgensohn <girgen@pingpong.net> (maintainer)

Fri, 14 May 2004

[ 13:16 edwin ]   1.125 databases/postgresql73/Makefile Fix CONFLICTS variable.

[ 13:13 edwin ]   1.124 databases/postgresql73/Makefile 1.32 databases/postgresql73/distinfo [PATCH] databases/postgresql73: update to 7.3.6 * Revert erroneous changes in rule permissions checking * Repair incorrect order of operations in GetNewTransactionId() * Ensure configure selects -fno-strict-aliasing even when an external value for CFLAGS is supplied * Make pg_restore handle 64-bit off_t correctly * Make contrib/dblink not assume that local and remote type OIDs match (Joe) * Quote connectby()'s start_with argument properly (Joe) * Don't crash when a rowtype argument to a plpgsql function is NULL * Avoid generating invalid character encoding sequences in corner cases when planning LIKE operations * Ensure text_position() cannot scan past end of source string in multibyte cases (Korea PostgreSQL Users' Group) * Fix index optimization and selectivity estimates for LIKE operations on bytea columns (Joe) This version, as with most minor versions, does not require a dump/reload to put into place. PR: ports/63698 Submitted by: Palle Girgensohn <girgen@pingpong.net>

Thu, 5 Feb 2004

[ 12:59 trevor ]   1.123 databases/postgresql73/Makefile Add WITHOUT_NLS knob. PR: 61836 Submitted by: Palle Girgensohn (maintainer)

Wed, 4 Feb 2004

[ 04:36 marcus ]   1.26 arabic/kde3-i18n/Makefile 1.4 arabic/koffice-i18n/Makefile 1.5 archivers/dpkg/Makefile 1.40 archivers/gtar/Makefile 1.17 archivers/libcomprex/Makefile 1.48 archivers/rpm/Makefile 1.19 astro/fooseti/Makefile 1.17 astro/gpsdrive/Makefile 1.15 astro/spacechart/Makefile 1.41 audio/aumix/Makefile (Only the first 10 of 312 ports in this commit are shown above. ) Add USE_GETTEXT and bump PORTREVISION. Submitted by: trevor Tested by: bento

Thu, 29 Jan 2004

[ 11:56 kris ]   1.10 databases/postgresql72/Makefile 1.121 databases/postgresql73/Makefile Use a unique LATEST_LINK

Fri, 23 Jan 2004

[ 18:12 trevor ]   1.25 arabic/kde3-i18n/Makefile 1.3 arabic/koffice-i18n/Makefile 1.4 archivers/dpkg/Makefile 1.39 archivers/gtar/Makefile 1.16 archivers/libcomprex/Makefile 1.47 archivers/rpm/Makefile 1.18 astro/fooseti/Makefile 1.16 astro/gpsdrive/Makefile 1.14 astro/spacechart/Makefile 1.40 audio/aumix/Makefile (Only the first 10 of 314 ports in this commit are shown above. ) Now gettext 0.12.1 is gettext-old.

Sun, 18 Jan 2004

[ 05:46 seanc ]   1.133 databases/postgresql-devel/Makefile 1.120 databases/postgresql7/Makefile 1.119 databases/postgresql73/Makefile Update the PostgreSQL ports to use the KRB5_HOME variable instead of LOCALBASE to find krb5-config in the MIT case. Prodded by: Our friendly folks at the ISC who want to use FreeBSD's PostgreSQL ports instead of an unmanaged build from a tarball.

Sun, 11 Jan 2004

[ 10:32 edwin ]   1.118 databases/postgresql73/Makefile 1.31 databases/postgresql73/distinfo [MAINTAINER] databases/postgresql73: wrong MD5_FILE for subports Just realized that after the repo-copy, the MD5_FILE pointer for subports was never updated. PR: ports/61193 Submitted by: Palle Girgensohn <girgen@pingpong.net>

Thu, 4 Dec 2003

[ 10:08 seanc ]   1.117 databases/postgresql73/Makefile Preemptive strike against future bogons for PORTREVSION bumps.

[ 09:19 seanc ]   1.288 databases/Makefile 1.116 databases/postgresql73/Makefile 1.30 databases/postgresql73/distinfo Update to PostgreSQL 7.3.5. See the release notes for details. A dump is *not* required when upgrading from any 7.3 release to 7.3.5. Release notes: http://developer.postgresql.org/docs/postgres/release-7-3-5.html Notified: maintainer Repo-copy by: joe

Number of commits found: 14