Re: [GENERAL] Function does not exist

2009-07-18 Thread Sim Zacks
DIPESH WROTE: > org.postgresql.util.PSQLException: ERROR: function addnewuser(bigint, > character varying, character varying, character varying, character > varying, character varying, character varying, unknown, character > varying, character varying, character varying, character varying, > charac

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

2009-07-18 Thread Pavel Stehule
2009/7/18 Diego Schulz : > On Sat, Jul 18, 2009 at 1:47 PM, Abraham, Danny 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 versi

Re: [GENERAL] Best practices for moving UTF8 databases

2009-07-18 Thread Phoenix Kiula
On Tue, Jul 14, 2009 at 9:52 PM, Alvaro Herrera 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 from SQL_ASCI

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, Danny 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? Also, the exact c

[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: http://www.postgresql.org/mailpref/

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" 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 >uuid-ossp.sql file ("share\cont

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 share\contrib

[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 t