[GENERAL] uuid-ossp for PostGres 8.4 running on Windows

2009-07-18 Thread Michael Gould
Does anyone have a install or the proper files (not the source) to install the uuid-ossp contrib files for 8.4?  The one thing that I think that EnterpriseDB install is lacking in is the contrib modules that have been in the previous postgres version installation.  Is this something that is going

Re: [GENERAL] uuid-ossp for PostGres 8.4 running on Windows

2009-07-18 Thread Sachin Srivastava
Hello Michael, In the EnterpriseDB installer, uuid-ossp contrib module is available but not loaded/enabled by default. To enable uuid-ossp module simply run the uuid-ossp.sql file (share\contrib\uuid-ossp.sql). This is something that i did: psql.exe -U postgres -d postgres -f

Re: [GENERAL] uuid-ossp for PostGres 8.4 running on Windows

2009-07-18 Thread Michael Gould
Thanks, that worked perfectly. Best Regards Michael Gould   Sachin Srivastava sachin.srivast...@enterprisedb.com wrote:   Hello Michael, In the EnterpriseDB installer, uuid-ossp contrib module is available but not loaded/enabled by default. To enable uuid-ossp module simply run the

[GENERAL] initdb fails on Windows with encoding=LATIN1

2009-07-18 Thread Abraham, Danny
It runs fine with WIN1252. The error message says something about lc_type. Tried with various code pages: 850,1252. Nothing goes through. Any thoughts? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] initdb fails on Windows with encoding=LATIN1

2009-07-18 Thread Diego Schulz
On Sat, Jul 18, 2009 at 1:47 PM, Abraham, Dannydanny_abra...@bmc.com wrote: It runs fine with WIN1252. The error message says something about lc_type. Tried with various code pages: 850,1252. Nothing goes through. Any thoughts? Would you care to mention the PostgreSQL version you are using?

Re: [GENERAL] Best practices for moving UTF8 databases

2009-07-18 Thread Phoenix Kiula
On Tue, Jul 14, 2009 at 9:52 PM, Alvaro Herreraalvhe...@commandprompt.com wrote: Andres Freund wrote: On Tuesday 14 July 2009 11:36:57 Jasen Betts wrote: if you do an ascii dump and the dump starts out SET CLIENT ENCODING 'UTF8' or similar but you still get errors. Do you mean that a dump

Re: [GENERAL] initdb fails on Windows with encoding=LATIN1

2009-07-18 Thread Pavel Stehule
2009/7/18 Diego Schulz dsch...@gmail.com: On Sat, Jul 18, 2009 at 1:47 PM, Abraham, Dannydanny_abra...@bmc.com wrote: It runs fine with WIN1252. The error message says something about lc_type. Tried with various code pages: 850,1252. Nothing goes through. Any thoughts? Would you care to