[GENERAL] Adapting existing extensions to use CREATE EXTENSION

2011-05-17 Thread Roger Leigh
der of things. I'll release it and make it available on PGXN once I'm happy it's OK. Many thanks, Roger -- .''`. Roger Leigh : :' : Debian GNU/Linux http://people.debian.org/~rleigh/ `. `' Printing on GNU/Linux? http://gutenprint.sourc

Re: [GENERAL] Adapting existing extensions to use CREATE EXTENSION

2011-08-15 Thread Roger Leigh
On Mon, Aug 15, 2011 at 08:41:06PM +0200, Dimitri Fontaine wrote: > Hi, > > Roger Leigh writes: > > I've been looking at converting my existing "debversion" datatype > > extension to use the proper "CREATE EXTENSION" facility for 9.1, > > w

Re: [GENERAL] Using psql -f to load a UTF8 file

2012-09-21 Thread Roger Leigh
or 8-bit charsets, so an external means of specifying the encoding is preferable and more robust. Regards, Roger -- .''`. Roger Leigh : :' : Debian GNU/Linuxhttp://people.debian.org/~rleigh/ `. `' schroot and sbuild http://alioth.debian.org/projects/buildd-tools

Re: [GENERAL] Locale query

2009-11-28 Thread Roger Leigh
me thing. Regards, Roger -- .''`. Roger Leigh : :' : Debian GNU/Linux http://people.debian.org/~rleigh/ `. `' Printing on GNU/Linux? http://gutenprint.sourceforge.net/ `-GPG Public Key: 0x25BFB848 Please GPG sign your mail. signature.asc Description: Digital signature

[GENERAL] Escaping input from COPY

2011-12-19 Thread Roger Leigh
r escaping rules are in use by the server, which I've seen documented in the manual; but in order to cope with any future changes to these rules, and ensure identical behaviour, are there any standard functions I can use to escape the data before loading it? Thanks, Roger -- .&#

Re: [GENERAL] Escaping input from COPY

2011-12-21 Thread Roger Leigh
format is when escaping. If neither are sufficiently robust, I'll need to stick with parameterised inserts, which handle arbitrary stuff without problems, other than being slow. Regards, Roger -- .''`. Roger Leigh : :' : Debian GNU/Linux http://people.deb

Re: [GENERAL] Schema version control

2012-01-23 Thread Roger Leigh
s were installed. If this were optionally also accessible via an SQL syntax such as an analogue of CREATE and/or ALTER EXTENSION, it would provide a reliable and standardised method for installing and upgrading a schema, which would potentially prevent a great deal of wheel-reinvention bet

[GENERAL] The scope of extensions

2012-04-16 Thread Roger Leigh
ation and upgrade of all the objects relating to a single application installed in the database. Thanks, Roger -- .''`. Roger Leigh : :' : Debian GNU/Linuxhttp://people.debian.org/~rleigh/ `. `' schroot and sbuild http://alioth.debian.org/projects/buildd-tools

Re: [GENERAL] The scope of extensions

2012-04-16 Thread Roger Leigh
On Mon, Apr 16, 2012 at 10:22:19AM -0500, Merlin Moncure wrote: > On Mon, Apr 16, 2012 at 10:05 AM, Roger Leigh wrote: > > The reason for the above is that I'd very much like to be able to > > version my entire application's schema using the extension mechanism > &g

Re: [GENERAL] The scope of extensions

2012-04-17 Thread Roger Leigh
On Mon, Apr 16, 2012 at 09:20:14PM +0200, Guillaume Lelarge wrote: > On Mon, 2012-04-16 at 21:16 +0200, Guillaume Lelarge wrote: > > On Mon, 2012-04-16 at 16:46 +0100, Roger Leigh wrote: > > > On Mon, Apr 16, 2012 at 10:22:19AM -0500, Merlin Moncure wrote: > > > > On

[GENERAL] Custom type, operators and operator class not sorting/indexing correctly

2009-01-20 Thread Roger Leigh
#x27;m not aware of (this is my first attempt at defining operators, and I am also a newcomer to using procedural languages). Could anyone suggest what I've done wrong here? Many thanks, Roger Leigh -- .''`. Roger Leigh : :' : Debian GNU/Linux

Re: [GENERAL] Custom type, operators and operator class not sorting/indexing correctly

2009-01-21 Thread Roger Leigh
On Wed, Jan 21, 2009 at 02:03:03AM -0500, Tom Lane wrote: > Roger Leigh writes: > > I've created a new domain (debversion) derived from TEXT, which > > includes its own operators (< <= = >= > and <>), and also its > > own operator class for BTREE indic

Re: [GENERAL] Custom type, operators and operator class not sorting/indexing correctly

2009-01-25 Thread Roger Leigh
On Wed, Jan 21, 2009 at 08:52:19PM +0100, Martijn van Oosterhout wrote: > On Wed, Jan 21, 2009 at 10:48:09AM +0000, Roger Leigh wrote: > > Ah, thanks for the clarification. So I need to use CREATE TYPE > > rather than CREATE DOMAIN. Because I'm essentially just storing &g

Re: [GENERAL] Custom type, operators and operator class not sorting/indexing correctly

2009-01-25 Thread Roger Leigh
On Sun, Jan 25, 2009 at 05:08:54PM +0100, Martijn van Oosterhout wrote: > On Sun, Jan 25, 2009 at 03:52:02PM +0000, Roger Leigh wrote: > > > > I'm duplicating text* to char* by hand. > > Is the text_to_cstring available internally also accessible by > > external

Re: [GENERAL] Pet Peeves?

2009-01-31 Thread Roger Leigh
- PostgreSQL database server driver for libdbi postgresql-contrib-8.3 - additional facilities for PostgreSQL libaprutil1-dbd-pgsql - The Apache Portable Runtime Utility Library - PostgreSQL Driver libdbd-pg-ruby1.9 - Ruby/DBI PostgreSQL driver for Ruby 1.9 % apt-cache search 'dbd.*

Re: [GENERAL] Pet Peeves?

2009-01-31 Thread Roger Leigh
g) libpq-dev: /usr/bin/pg_config Regards, Roger -- .''`. Roger Leigh : :' : Debian GNU/Linux http://people.debian.org/~rleigh/ `. `' Printing on GNU/Linux? http://gutenprint.sourceforge.net/ `-GPG Public Key: 0x25BFB848 Please GPG sign