[GENERAL] uuid-ossp for PostGres 8.4 running on Windows
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 to be added back into the EnterpriseDB installer? At any rate my main concern now is to get the uuid-ossp install for 8.4 so that I can use 8.4 for our new development. Best Regards -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax
Re: [GENERAL] uuid-ossp for PostGres 8.4 running on Windows
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\uuid-ossp.sql
Then from psql i fired the below query and got results,
SELECT uuid_generate_v3(uuid_ns_url(), 'http://www.postgresql.org');
Hope it helps.
On 07/18/2009 08:00 PM, Michael Gould wrote:
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 to be added back into the EnterpriseDB installer?
At any rate my main concern now is to get the uuid-ossp install for
8.4 so that I can use 8.4 for our new development.
Best Regards
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax
--
Regards,
Sachin Srivastava
www.enterprisedb.com
Re: [GENERAL] uuid-ossp for PostGres 8.4 running on Windows
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\contrib\uuid-ossp.sql").
>
>This is something that i did:
>
>psql.exe -U postgres -d postgres -f share\contrib\uuid-ossp.sql
>
>Then from psql i fired the below query and got results,
>
>
>SELECT uuid_generate_v3(uuid_ns_url(), 'href="http://www.postgresql.org";>http://www.postgresql.org');
>
>
>Hope it helps.
>
>
>
>On 07/18/2009 08:00 PM, Michael Gould wrote:
>>
>>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 to be added back into the EnterpriseDB installer?
>>
>>
>>At any rate my main concern now is to get the uuid-ossp install for 8.4 so
>>that I can use 8.4 for our new development.
>>
>>
>>
>>
>>
>>Best Regards
>>
>>
>>
>>
>>
>>Michael Gould, Managing Partner
>>Intermodal Software Solutions, LLC904.226.0978904.592.5250 fax
>
>
>
>--
>Regards,
>Sachin Srivastava
>http://www.enterprisedb.com";>www.enterprisedb.com
>
>
[GENERAL] initdb fails on Windows with encoding=LATIN1
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/pgsql-general
Re: [GENERAL] initdb fails on Windows with encoding=LATIN1
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 copypasted error message would be handy. regards, diego -- 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] Best practices for moving UTF8 databases
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_ASCII can yield non-utf8 data? right. But >> According to the OP his 8.3 database is UTF8... >> So there should not be invalid data in there. > > I haven't followed this thread, but older PG versions had less strict > checks on UTF8 data, which meant that some invalid data could creep in. If so, how can I check for them in my old database, which is 8.2.9? I'm now moving first to 8.3 (then to the 84). Really, PG absolutely needs a way to upgrade the database without so much data related downtime and all these silly woes. Several competing database systems are a cinch to upgrade. Anyway this is the annoying error I see as always: ERROR: invalid byte sequence for encoding "UTF8": 0x80 I think my old DB is all utf8. If there are a few characters that are not, how can I work with this? I've done everything I can to take care of the encoding and such. This code was used to initdb: initdb --locale=en_US.UTF-8 --encoding=UTF8 Locale environment variables are all "en_US.UTF-8" too. Thanks for any pointers! -- 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] initdb fails on Windows with encoding=LATIN1
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 version you are using? > Also, the exact copypasted error message would be handy. it's depend on language support installed in windows - postgresql use system services. try to: initdb -D ..\clusters\clusterA --locale=english_britain -E UTF8 http://docs.moodle.org/en/Table_of_locales regards Pavel Stehule > > regards, > > diego > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- 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] Function does not exist
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, > character varying, character varying, character varying, character > varying, character varying, character varying, character varying, > character varying, integer) does not exist Please paste in the full definition of the function and the function call. (Use debug mode to see what is actually being passed to the database). I agree with Andreas that the problem is the parameters in the actual function call is wrong. If you look at the error, the 8th parm being passed in is an unknown. What is it supposed to be? Sim -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
