PostgreSQL
- When a commit goes wrong
- Fixing permissions on the packages_raw table
- Moving from storing the tsvector values to a tsvector index
- When tsvector was working as expected on most hosts, but not one
- note to self: restoring a database
- missing ports_categories entries
- Commit cache clearing
- to_tsquery gives ‘ERROR: syntax error in tsquery’ when it contains a space
- A PostgreSQL query runs in 1.7s – add a LIMIT 10, runs in 28.2 seconds
- Replacing a column search with a full text search solution
- Adding FreeBSD14 to the list of build packages
- Found new repo release – automatically imported it
- Updating the packages table – INSERT, UPDATE, DELETE – plus some ZFS configuration
- Using DEFERRABLE INITIALLY DEFERRED on constraints
- Procedural vs query approaches
- What packages are now available for this port?
- creating a Nagios check on a PostgreSQL table
- Changing a column type
- Cache clearing issue
- Moving the email notifications to the new server
- procedure OK under 10.6 but starts acting up under 11.1
- Adding and populating CONFLICTS
- Duplicate dependency issues – avoiding duplicate rows
- Where is en-aspell?
- When dependencies change, both ports need to be updated
- Improving the home page query
- Improving date search
- Session variables! Almost. Not quite.
- Multiple repos – good progress
- Adding code, removing more code to reduce duplication
- Fixing up a referential integrity issue
- Bad SQL corrupts search results
- Tracking port changes by branch – first fix
- Listening daemon out of date
- Creating the new repo base directories
- Updates to vuxml ranges fails
- An index can make all the difference
- Creating the new repo base directories
- The committer field is not always an email address
- mail/horde4-imp vulnerability
- What ports are dependant upon this port?
- RESTRICTED not correctly reported
- Master/slave relationships
- more on the X.org 7.2 commit deadlock
- Stripping HTML from announcements
- repo copies are evil
- Merging from branch to HEAD
- The PostgreSQL Conference
- FreshPorts downtime
- Improved Watch List sorting
- Improving the search – pagination
- Python listening now in production
- Adding stubs for listening – data driven
- Data driven listening
- More on Python Listen
- Python, PostgreSQL, and LISTEN