Re: [GENERAL] Jenkins

tests \ -b /opt/local/bin/psql84 \ --runtests \ --formatter TAP::Formatter::JUnit > db_testreports.xml Hope this helps Ciao -- Giorgio Valoti -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Rule or Function and Trigger?

situations when using a rule is clearly superior than a trigger? I experimented with rules, with good result, but I’d rethink my approach if triggers are more "reliable". Thank you in advance -- Giorgio Valoti -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

[GENERAL] [Semi-OT]: How to customize locales?

create a custom locale. Does anyone have some suggestions/links? PS Is there any way to use something like DateStyle with numbers? In this way, you could avoid using to_char. Thank you in advance -- Giorgio Valoti -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Invocation overhead for procedural languages

On 06/ago/08, at 16:04, Pavel Stehule wrote: 2008/8/6 Giorgio Valoti <[EMAIL PROTECTED]>: Hi all, I think I've read somewhere in the documentation that the invocation of functions written in procedural languages (with the exception of plpgsql) incur in performance hit due to t

[GENERAL] Invocation overhead for procedural languages

-- Giorgio Valoti -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] UTF8 encoding problem

On 18/giu/08, at 15:00, Michael Fuhr wrote: On Wed, Jun 18, 2008 at 08:25:07AM +0200, Giorgio Valoti wrote: On 18/giu/08, at 03:04, Michael Fuhr wrote: Is the data UTF-8? If the error is 'invalid byte sequence for encoding "UTF8": 0xa3' then you probably need to se

Re: [GENERAL] UTF8 encoding problem

n_GB.UTF-8'" in postgresql.conf but this has no effect. How can I sort this problem? Client_encoding =UTF8. Is the data UTF-8? If the error is 'invalid byte sequence for encoding "UTF8": 0xa3' then you probably need to set client_encoding to latin1, latin9, or win1252

[GENERAL] to_tsvector: error with italian configuration

1 row) Danish’s fine too, but not french (same error). All the .stop files (italian, french, and danish) are utf8-encoded but maybe it doesn’t matter, I just don’t know. I’m using the 8.3 version with Mac OS X 10.5.3 (pg server) and Mac OS X 10.4.11 (psql client). Thank you -- Giorgio Valo

Re: [GENERAL] How to modify ENUM datatypes?

ether you males, females, and unknowns think so or not. +1 Added to TODO: * Allow adding enumerated values to an existing enumerated data type And removing values if possible (fail if values are in use?). And reorder them, too. -- Giorgio Valoti -- Sent via pgsql-general mailing list

[GENERAL] Functions and transactions

e expected behavior? Thank you -- Giorgio Valoti -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] 8.3 and uuid: unable to run uuid-ossp.sql

: psql:share/contrib/uuid-ossp.sql:9: ERROR: could not load library "/ opt/local/pgsql/lib/uuid-ossp.so": libuuid.so.16: cannot open shared object file: No such file or directory Can somebody help me to solve this problem? Or give some hints? Thank you in advance -- Gior

[GENERAL] Locale support on Mac OS X

--- A a b c d e à à à (9 rows) Further points: - The sort command gives the same (wrong) results. - GUI (Cocoa) applications give the expected sort. Any clues? Should I assume that if sort does not give the expected result, postgresql will not be different? Thank you in advance --