Re: [GENERAL] PGbouncer for Windows 2008

2012-01-23 Thread Hiroshi Saito
Hi. John-san, thanks! to Edison-san. It is necessary to perform it in an administrator's mode. Please see, http://winpg.jp/~saito/pgbouncer/try_64bit/regsvr32_pgevent.png http://winpg.jp/~saito/pgbouncer/try_64bit/running_pgbouncer.png Regards, Hiroshi Saito (2012/01/23 10:09), John R P

Re: [GENERAL] Windows x64 : How do I get OSSP-UUID.sql contrib for postgresql x64

2011-06-30 Thread Hiroshi Saito
. Regards, Hiroshi Saito (2011/06/30 22:52), Grace Batumbya wrote: Hey Hiroshi, Do you have a make file to compile for x64 windows? May be if that is made available then ossp-uuid for x64 versions will become standard. *Grace Batumbya* Research Assistant | Seneca CDOT Phone: 416-491-5050 x3548

Re: [GENERAL] Windows x64 : How do I get OSSP-UUID.sql contrib for postgresql x64

2011-06-29 Thread Hiroshi Saito
Hi. here is an excuse... http://archives.postgresql.org/pgsql-general/2011-06/msg00738.php Regard, Hiroshi Saito (2011/06/30 1:50), Grace Batumbya wrote: Thanks Hiroshi, that solved the problem. If you do not mind, how did you go about to build ossp-uuid? *Grace Batumbya* Research Assistant

Re: [GENERAL] Windows x64 : How do I get OSSP-UUID.sql contrib for postgresql x64

2011-06-29 Thread Hiroshi Saito
Hi Grace-san. Is this helpful to you? http://winpg.jp/~saito/pg_work/OSSP_win32/build-x86-64/ Regards, Hiroshi Saito (2011/06/30 1:14), Grace Batumbya wrote: The installer for windows for 64bit versions of postgresql doesn't include ossp-uuid.sql. Does anyone know where or how to get

Re: [GENERAL] UUID-OSP contrib module

2011-06-24 Thread Hiroshi Saito
ly support for GUID's like most other > databases. > > Best Regards > > Michael Gould > > > "Hiroshi Saito" wrote: >> Hi Michael-san. >> >> Sorry very late reaction. >> >> Although it is several years ago, I did the work origin

Re: [GENERAL] UUID-OSP contrib module

2011-06-24 Thread Hiroshi Saito
to all. If this offer is helpful, I am wishing it is supplied from EnterpriseDB. Thanks! Regards, Hiroshi Saito (2011/06/23 23:46), Michael Gould wrote: I remember a few months ago that someone said that the UUID-OSP contrib module did not work on Windows 64. Is this still a limitation? Best

Re: [GENERAL] [HACKERS] PostgreSQL Core Team

2011-04-27 Thread Hiroshi Saito
Congratulations!! (2011/04/28 3:48), Dave Page wrote: I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in the development and ongoing maintenan

Re: [GENERAL] Problems with ODBC Driver

2010-09-01 Thread Hiroshi Saito
xx; ERROR: column "field" does not exist LINE 1: SELECT Field FROM xx; postgres=# SELECT "Field" FROM xx; Field --- (0 rows) If my misunderstand, the error message which you show will be able to be solved. Regards, Hiroshi Saito - Original Message - From

Re: [GENERAL] psql language

2009-07-10 Thread Hiroshi Saito
ostgres psql (8.4.0) Type "help" for help. Have I missed something? Regards, Hiroshi Saito - Original Message - From: "Stuart McGraw" To: Sent: Friday, July 10, 2009 11:00 AM Subject: [GENERAL] psql language Hello, I just installed pg-8.4 on Windows XP but r

Re: [GENERAL] encoding of PostgreSQL messages

2009-03-05 Thread Hiroshi Saito
Hi. Karsten-san. Yeah, It was a problem unsolvable by the driver to relay. although perseverance keeping without giving up! -- arigatougozaimasu:-) Regards, Hiroshi Saito - Original Message - From: "Karsten Hilbert" On Tue, Mar 03, 2009 at 12:35:37AM +0900, Hiroshi S

Re: [GENERAL] encoding of PostgreSQL messages

2009-03-02 Thread Hiroshi Saito
60) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at jdbctestx.main(jdbctestx.java:21) Then, server log is this. http://winpg.jp/~saito/pg_work/LC_MESSAGE_CHECK/connect_problem/server.log Regards, Hiroshi Saito -

Re: [GENERAL] Linked server query problem

2008-12-04 Thread Hiroshi Saito
Hi. Probably, it need the new feature of Ver 8.4. See, http://archives.postgresql.org/pgsql-committers/2008-02/msg00172.php Regards, Hiroshi Saito - Original Message - I have SQL Server 2005 that is linked to Postgresql 8.3.1-1 The following query does not work SELECT id FROM

Re: [GENERAL] pglib.dll for windows ce

2008-11-28 Thread Hiroshi Saito
Hi Julius-san. Is this helpful? http://libpqwce.projects.postgresql.org/ However, I'm busy and work has stagnated. Regards, Hiroshi Saito - Original Message - From: "Julius Tuskenis" <[EMAIL PROTECTED]> To: Sent: Friday, November 28, 2008 10:07 PM

Re: [GENERAL] Trying Compile libpq.dll with VC++ 9.0, but need help

2008-11-17 Thread Hiroshi Saito
\psql. http://winpg.jp/~saito/pg_work/WIN32_BUILD_INF/LOG_PSQL_WIN32MAK.txt However, It will be necessary what is bad and to investigate in your environment. I think 1. One proposal nmake -f win32.mak clean Regards, Hiroshi Saito - Original Message - From: "Tony Caduto&quo

Re: [GENERAL] UUID-OSSP Contrib Module Compilation Issue

2008-10-28 Thread Hiroshi Saito
Do I need to use a specific version of the ossp-uuid libraries for this module? The 1.6.2 stable version which you use is right. Regards, Hiroshi Saito -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] UUID-OSSP Contrib Module Compilation Issue

2008-10-28 Thread Hiroshi Saito
Hi. Um, you are reconfigure of postgresql then. It is necessary to specify with-ossp-uuid. Regards, Hiroshi Saito - Original Message - From: "Bruce McAlister" <[EMAIL PROTECTED]> To: "pgsql" Sent: Wednesday, October 29, 2008 8:01 AM Subject: [GENERAL

Re: [GENERAL] error compiling postgres source

2008-10-03 Thread Hiroshi Saito
Hi Roshni-san. First, thank you for the report of a good result. However, I don't know well about libpqxx Therefore, pushes on GENERAL-ML. Someone may be able to support.? Regards, Hiroshi Saito - Original Message - From: "Roshni Mani" <[EMAIL PROTECTED]>

Re: [GENERAL] error compiling postgres source

2008-10-01 Thread Hiroshi Saito
Hi. It is strange?_? pg_config.h and pg_config_os.h must be copied as below. C:\MinGW\home\HIROSHI\postgresql-8.3.3\src\interfaces\libpq>nmake -f win32.mak Microsoft (R) Program Maintenance Utility Version 8.00.50727.42 Copyright (C) Microsoft Corporation. All rights reserved. Building the Wi

Re: [GENERAL] psqlodbc on Vista Ultimate 64

2008-08-08 Thread Hiroshi Saito
Hi. Is this helpful? http://winpg.jp/~saito/psqlODBC/psqlODBC64/ as for AMD64. http://www.geocities.jp/inocchichichi/psqlodbc/index.html Regards, Hiroshi Saito - Original Message - From: Lucas Felix To: pgsql-general@postgresql.org Sent: Saturday, August 09, 2008 12:00 AM Subject

Re: [GENERAL] [EMAIL PROTECTED]

2008-08-04 Thread Hiroshi Saito
Hi Robert-san Ahh yes.. I'm sorry delaying release bugfix was not included in pg8.3.3. Then,I will adjust next release(1.6.3/4) with Rarf-san again. Regards, Hiroshi Saito. >Hiroshi-san, > >Is this something specific to windows? If so, should this be consider a bug? > &g

Re: [GENERAL] [EMAIL PROTECTED]

2008-08-03 Thread Hiroshi Saito
Hi. Sorry, it was not included in release. please see, http://winpg.jp/~saito/pg_work/OSSP_win32/ Regards, Hiroshi Saito >Hi all, > >I installed postgresql-8.3.3-1 for win2000 with UUID-OSSP. Following >the documentation I issued this query: > >SELECT uuid_generate_v3(uu

Re: [GENERAL] FW: make rows unique across db's without UUIP on windows?

2008-06-02 Thread Hiroshi Saito
Hi Kimball-san Thanks, This problem concentrated the discussions by the reason with not pgsql but uuid-ossp. Certainly, I think that uuid is effective and the best for the deflecting solution. Regards, Hiroshi Saito >Hiroshi, > >Thank you very much. I will look forward to it. &

Re: [GENERAL] FW: make rows unique across db's without UUIP on windows?

2008-06-02 Thread Hiroshi Saito
Hi Kimball-san Thanks, This problem concentrated the discussions by the reason with not pgsql but uuid-ossp. Certainly, I think that uuid is effective and the best for the deflecting solution. Regards, Hiroshi Saito >Hiroshi, > >Thank you very much. I will look forward to it. &

Re: [GENERAL] FW: make rows unique across db's without UUIP on windows?

2008-06-02 Thread Hiroshi Saito
Hi. Ahh,yes. Patch is inspected for me now. Please wait for a while. Regards, Hiroshi Saito >From: Kimball Johnson [mailto:[EMAIL PROTECTED] >Sent: Monday, June 02, 2008 7:42 PM >To: 'pgsql-general@postgresql.org' >Subject: make rows unique across db

Re: [GENERAL] Compiling trigger function with MinGW

2008-05-13 Thread Hiroshi Saito
Hi. One of question... Was 8.3 of a main part built for yourself(MinGW)? When it is official pginstaller, you should use it by MS-VC+. Regards, Hiroshi Saito - Original Message - From: "Anton Burkun" <[EMAIL PROTECTED]> Hello All. Now I try to link dll with MinGW

Re: [GENERAL] UUID-OSSP for windows.

2008-02-26 Thread Hiroshi Saito
d as MinGW+GCC. http://winpg.jp/~saito/pg_work/OSSP_win32/ Then, It is now exposed to verification. I want to include in the next release. Thanks! Regards, Hiroshi Saito ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] character conversion problem about UTF-8-->SHIFT_JIS_2004

2008-02-08 Thread Hiroshi Saito
List of databases Name| Owner | Encoding ---+--+-- postgres | postgres | UTF8 template0 | postgres | UTF8 template1 | postgres | UTF8 (3 rows) Probably, your database is SQL_ASCII ? Regards, Hiroshi Saito ---(end of

Re: [GENERAL] character conversion problem about UTF-8-->SHIFT_JIS_2004

2008-02-08 Thread Hiroshi Saito
not have a conversion table. Then, It will catch with another problem. It is necessary to analyze it in detail. However, A database can be operated normally. Regards, Hiroshi Saito - Original Message - From: "bh yuan" <[EMAIL PROTECTED]> I think i can export olddb(

Re: [GENERAL] character conversion problem about UTF-8-->SHIFT_JIS_2004

2008-02-08 Thread Hiroshi Saito
Oops again.. or -- set PGCLIENTENCODING=SJIS pg_dump or copy of psql's. -- However, an environmental setup is as follows again. export PGCLIENTENCODING=SJIS :-) Regards, Hiroshi Saito - Original Message - From: "Hiroshi Saito" <[EMAIL PROTECTED]> Hi. -

Re: [GENERAL] character conversion problem about UTF-8-->SHIFT_JIS_2004

2008-02-08 Thread Hiroshi Saito
ide of .csv file which you acquired is SJIS...However, as one method, If you were operating by SERVER_ENCODING of UTF-8, it will be able to bring without conversion. Then, an environment variable will be helpful. -- set PGCLIENTENCODING=UTF-8 pg_dump -- Regards, Hiroshi Saito And >> to ex

Re: [GENERAL] character conversion problem about UTF-8-->SHIFT_JIS_2004

2008-02-07 Thread Hiroshi Saito
s loose check but after I chaged to Postgresql8.3 ,the error was occured. Can I ignore the error message ? or any othe method to solve this problem. "0xe9ab99" which you use is famous UNICODE. Then, An error is right. (not SJIS) Regards, Hiroshi Saito --

Re: [GENERAL] character conversion problem about UTF-8-->SHIFT_JIS_2004

2008-02-07 Thread Hiroshi Saito
gnore the error message ? or any othe method to solve this problem. "0xe9ab99" which you use is famous UNICODE. Then, An error is right. (not SJIS) Regards, Hiroshi Saito ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Question for Postgres 8.3

2008-02-04 Thread Hiroshi Saito
Hi. This reply is very glad for me!:-) However, There is still a locale problem. Anyway, thanks Regards, Hiroshi Saito - Original Message - From: "Clemens Schwaighofer" <[EMAIL PROTECTED]> I'm surprised your clients haven't been screaming abo

Re: [GENERAL] Question for Postgres 8.3

2008-02-04 Thread Hiroshi Saito
that LOCAL=C is clear as a sorting of a dictionary. It seems that selection is good by the situation well. See, Although you may be unable to see (However, this is Japanes shift-jis) http://winpg.jp/~saito/pg_bug/Japanese_LowerUpper_sort.txt Regards, Hiroshi Saito

Re: [GENERAL] Question for Postgres 8.3

2008-02-04 Thread Hiroshi Saito
ases are utf-8, but I have some clients that created EUC_JP databases, will the upgrade affect this? When using server encoding for EUC_JP and UTF-8 simultaneously, it is not allowed except LOCALE=C. Moreover, it can also use SQL_ASCII satisfactory natural. please initdb --no-local

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

2008-02-04 Thread Hiroshi Saito
x27;t remember the environment which received the report by RC2.?_? It is likely to be necessary to investigate the environment of Hermann-san. P.S) However, It seems that a VISTA user's problem remains. Regards, Hiroshi Saito - Original Message - From: "Hiroshi Saito&quo

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

2008-02-04 Thread Hiroshi Saito
n deep as a clear problem. Regards, Hiroshi Saito ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

2008-02-04 Thread Hiroshi Saito
Hi. Umm, Please investigate msm under the following. C:\Program Files\Common Files\Merge Modules Microsoft_VC80_CRT_x86.msm Please investigate the date and size of that.? Regards, Hiroshi Saito - Original Message - From: "Hermann Muster" <[EMAIL PROTECTED]> Konb

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

2008-02-04 Thread Hiroshi Saito
&DisplayLang=en The adjustment of Installer may be necessity. It must consider many situations. However, The solution method was not found even in MSDNIt seems that what is used in the middle of install can't be execute. to Dave. Did you already find the solution method? Regards, Hiro

Re: [GENERAL] Insert returning Npgsql

2008-01-06 Thread Hiroshi Saito
Hi. It can be referred to from the page by which we were renewed. http://npgsql.projects.postgresql.org/ I want it to be useful for you. P.S) [EMAIL PROTECTED] is the place of best discussion. Regards, Hiroshi Saito - Original Message - From: "Cesar Alvarez" <[EM

Re: [GENERAL] Slony-I creation scripts not available

2007-11-29 Thread Hiroshi Saito
s you. http://developer.pgadmin.org/~hiroshi/Slony-I/ Anyhow, the first setup recommends slonik. Regards, Hiroshi Saito --- Hiroshi Saito <[EMAIL PROTECTED]> wrote: Hi. From: "Glyn Astill" <[EMAIL PROTECTED]> > From within pgAdminIII I get this message in the status

Re: [GENERAL] Slony-I creation scripts not available

2007-11-29 Thread Hiroshi Saito
icult to set up if it does not have full knowledge of slony. Moreover, if it is the script of slonik, Slony-ML([EMAIL PROTECTED]) will be help more. Regards, Hiroshi Saito ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL]about Command Prompt.

2007-10-09 Thread Hiroshi Saito
- Original Message - From: longlong thanks ! :-) P.S) GUI edit can do pgpass.conf in pgAdminIII. Please use it.! Regards, Hiroshi Saito 2007/10/10, Hiroshi Saito <[EMAIL PROTECTED]>: Hi. - Original Message - From: longlong if it is not in Command Prompt how can i w

Re: [GENERAL]about Command Prompt.

2007-10-09 Thread Hiroshi Saito
\h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit postgres=# \q I want this to help you.:-) Regards, Hiroshi Saito ---(end of broadcast)--- TIP 5: don&#x

Re: [GENERAL]about Command Prompt.

2007-10-09 Thread Hiroshi Saito
Hi. runas is not required. for example) C:\Program Files\PostgreSQL\8.3-beta1\bin>psql -f filename.sql postgres postgres Password for user postgres: pleae see. psql --help Regards, Hiroshi Saito - Original Message - From: longlong To: pgsql-general@postgresql.org Sent: Tues

Re: [GENERAL] Migration from PervasiveSQL

2007-09-24 Thread Hiroshi Saito
bases. However, Now odbclink has not equipped cursor yet *shrug* There's code in the scm repository if you look, and if that doesn't seem workable try emailing Hiroshi directly. I'm pretty sure you can get this wokring; Hiroshi gave a lightening talk on it at PGCon. I progress little by little. It seems to be a tortoise completely.:-) Thanks.! Regards, Hiroshi Saito ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Restore 8.1.4 backup in 8.2.5

2007-09-19 Thread Hiroshi Saito
Hi. pgAdminIII uses pg_restore by restoration. Then, pg_restore does not recognize a PlainText format. Please use psql from a command line... Regards, Hiroshi Saito - Original Message - From: [EMAIL PROTECTED] I have a backup file from Postgresql 8.1.4. When I try to use 8.2.5

Re: [GENERAL] Npgsql GUI problem C#.net

2007-08-29 Thread Hiroshi Saito
Hi. Please see, http://npgsql.projects.postgresql.org/exampleprograms.html This is DataGrid sample. It is very simple composition. However, Operation may be somewhat difficult at the property of VS2005. Then, ADO.NET2.0 and Npgsql are not congenial. Regards, Hiroshi Saito - Original

Re: [GENERAL] postgresql connection string to Vb.NET

2007-08-29 Thread Hiroshi Saito
Hi. Please see, http://npgsql.projects.postgresql.org/ and http://psqlodbc.projects.postgresql.org/ Regards, Hiroshi Saito - Original Message - From: smithveg To: pgsql-general@postgresql.org Sent: Thursday, August 30, 2007 12:49 AM Subject: [GENERAL] postgresql connection string to

Re: [GENERAL] psql-odbc configure error

2007-07-20 Thread Hiroshi Saito
test long_test.c inet% long_test 4 4 4 4 inet% ldd long_test long_test: libc.so.6 => /lib/libc.so.6 (0x28074000) inet% gcc -v Using built-in specs. Configured with: FreeBSD/i386 system compiler Thread model: posix gcc version 3.4.4 [FreeBSD] 20050518 I want these to be help you.! Regards