15,485 reputation
11337
bio website blog.ringerc.id.au
location Western Australia, Australia
age
visits member for 2 years, 8 months
seen 4 hours ago

I'm a PostgreSQL admin/developer, sysadmin, multi-language programmer (lately mostly Java and Java EE, previously C, C++, Python and good old bash) and general IT JOAT.

I work for 2nd Quadrant, a global PostgreSQL consultancy.

I maintain a technical blog at blog.ringerc.id.au. My PostgreSQL writing now appears on the 2nd quadrant blog.

I'll work in most programming languages with varying degrees of competence, though I'll only reluctantly touch PHP or Perl code. I'm more interested in the libraries, tools, and the code that's built on top of the language.

Most of my scrap code lives on https://github.com/ringerc . Most of my open source code is in the form of scattered patches across too many different bugzillas and JIRAs, rather than single new projects. Over time I've done a lot of work on Scribus and PoDoFo, but have moved away from both projects as my focus and interests changed. I contribute patches - rather infrequently - to PostgreSQL and to various Java EE 6 infrastructure components. Most of my contribution is now non-code, in the form of:

  • Detailed bug reporting with test cases, which I spend an unpleasant proportion of my development time preparing and submitting, mostly against JBoss and java.net projects.
  • User support for PostgreSQL on mailing lists and here on SE
  • PostgreSQL patch review and beta testing
  • Usability review of Java EE libs/tools, as well as usability review of PostgreSQL and its tools
  • Writing, editing and enhancing documentation, HOWTOs, etc
  • Blogging in detail on topics likely to be useful to others.

I've turned into a git fiend and no longer understand why anybody uses anything else. I'm also becoming increasingly obsessive about testing, particularly with the advent of Jenkins CI and Arquillian.


4h
comment How to restrict access to current user record and its rights in postgres
@Andrus Rather than greatly changing the meaning of a post please make a new question. Put a link to this post in the new question for context please. Feel free to drop a link to the new question here so I see it.
1d
comment Prevent Primary Key increment when an INSERT statement fail in PostgreSQL
Basically a dup of stackoverflow.com/q/2036571/398670 . Search for "postgresql gapless sequence" ... and read the manual for nextval which discusses this issue.
1d
comment Postgresql dynamic execute with arguments values in array
No, EXECUTE ... USING can't take an array of arguments, because PostgreSQL arrays don't support hetrogenous types. They must be an array of a single concrete type, and the SQL might not have the same type for each parameter. It'd be useless except for very narrow use cases. Instead, USING would have to be able to take an anonymous record, like you create from a ROW(...) constructor ... which is probably possible, but not currently implemented.
1d
comment PostgreSQL Role Configuration
*With further research I found about Default Privileges, which I tried but had no success. I didnt understood quite well this option. *. Details please? What did you attempt? Did you actually try anything or not know where to starT?
2d
comment ST_GeomFromGeoJSON() Causes postgres to crash
If it's reproducible, try to get a backtrace. wiki.postgresql.org/wiki/… . Also, if possible try to reduce the query to the smallest one that still causes the error.
2d
comment remove password requirement for user postgres
@MarcusJuniusBrutus Yes, that appears to be exactly it.
2d
answered remove password requirement for user postgres
2d
comment remove password requirement for user postgres
On what operating system?
2d
answered How to restrict access to current user record and its rights in postgres
2d
comment How to restrict access to current user record and its rights in postgres
Avoid using the name user for a table or data type. There's a built-in pseudo function by that name that means you'll have to write "user" most places, i.e. quote the name. Pick a different name.
2d
comment How many rows will be locked by SELECT … ORDER BY xxx LIMIT 1 FOR UPDATE?
Please show the query plans for the relevant queries, from EXPLAIN. Also show the output of the deadlock detected error message, if that's what you get, and if not please properly explain what you mean by "cause a deadlock".
2d
answered How many rows will be locked by SELECT … ORDER BY xxx LIMIT 1 FOR UPDATE?
2d
comment How many rows will be locked by SELECT … ORDER BY xxx LIMIT 1 FOR UPDATE?
Don't try to roll your own queue system. You'll either get something that performs the same as a single serial worker, or something that's wrong.
Nov
20
comment Copying database to different hard disk
What operating system is this? How did you install PostgreSQL? What version, from where?
Nov
19
comment How to correctly implement optimistic locking in MySQL
@plalx Well, what does the documentation say? What happens if you run an interactive test just like this one?
Nov
19
comment How to create a tablespace on Windows 7 for Postgresql 9.2?
@Stephan Security tab of properties
Nov
19
answered How to create a tablespace on Windows 7 for Postgresql 9.2?
Nov
19
comment Validate MySQL/PostgreSQL backup without running server
This really needs to be two questions, one for each DBMS, since you're not going to find a tool that applies to both. In any case, IMO the only way to validate a backup is to restore it.
Nov
19
comment Postgres: Inconsistent DB transaction snapshot
If they're two separate transactions they'll get different timestamps. If they aren't, they won't. I'm not seeing the issue here. Again, please show a test case, something concrete that demonstrates the problem, as it's most unclear from this description what exactly you're doing, what you're expecting, etc.
Nov
19
comment After upgrade from 9.1 to 9.3, commands still point to 9.1
At a guess you've uninstalled the 9.1 client but not server, and you put the 9.1 server binaries on your PATH manually. Check echo $PATH.