Re: [GENERAL] Best practices for migrating a development database to a release database

2004-09-11 Thread Thomas F . O'Connell
One thing I used to do (and I won't necessarily claim it as a best practice) was to maintain my entire data model (tables, functions, indexes, sequences) as SQL (plus postgres extensions) CREATE statements in text files that were version controlled (via CVS). I had an entire set of utilities th

Re: [GENERAL] Auto increment/sequence on multiple columns?

2004-09-11 Thread Thomas F . O'Connell
How does this imply one sequence? Is it guaranteed that for each value of a, the values of b will be equivalent to all (and only) values of a? There's plenty of flexibility within postgres for ways to use sequences. Regardless, I think you need to have (and present) a better idea of what you're

[GENERAL] pg_shadow in a constraint

2004-09-11 Thread Anton Nikiforov
Dear All! in my system i would like to use the pg user's usesysid as a key in my tables. But it is not allowed (that was many times described here and in the documentation) But what can i do to get my tables and data to be consistent with the system catalogue? Could you please supply me with a r

Re: [GENERAL] unicode and varchar

2004-09-11 Thread Ian Barwick
On Fri, 10 Sep 2004 14:57:18 +0200, Michael Wimmer <[EMAIL PROTECTED]> wrote: (...) > Is there a way to make this work in 7.4.x too? > May problem is that we are in a rush to do a port of our application > from informix and I will not be able to wait until 8.0 will be released. What encoding does

Re: [GENERAL] national settings

2004-09-11 Thread Peter Eisentraut
ppp wrote: > initdb -E ISO-8859-2 --locale=pl -D ppp > then pg_ctl -D ppp start > and i get: FATAL: invalid value for option 'LC_MESSAGES': 'pl' Maybe your system only understands locale names of the form "pl_PL". -- Peter Eisentraut http://developer.postgresql.org/~petere/ --