Re: [GENERAL] PGbouncer for Windows 2008
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 Pierce wrote: On 01/22/12 4:55 PM, Edison So wrote: I downloaded the 64-bit version and extracted it. Unfortunately. it seems that the pbbouncer.exe file is needed to be rebulit (ie. recompiled) according to the following statements from the README file: those statements you reference may well be from the generic pgbouncer source readme. if someone has already built and tested a 64bit binary, whats the problem? -- 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] Windows x64 : How do I get OSSP-UUID.sql contrib for postgresql x64
Hi Grace-san. It is the same as windows. http://winpg.jp/~saito/pg_work/OSSP_win32/ 1. Deployment of tar.gz 2. apply the patch 3. configure and build by Linux or MinGW 4. config.h and win32.mak are set at the head of a source tree. 5. nmake -f win32.mak It can be used by 32 bits and 64 bits. 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 cdot.senecac.on.ca http://cdot.senecac.on.ca/ On 6/29/2011 1:02 PM, Hiroshi Saito wrote: 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 | Seneca CDOT Phone: 416-491-5050 x3548 cdot.senecac.on.ca http://cdot.senecac.on.ca/ On 6/29/2011 12:38 PM, Hiroshi Saito wrote: 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 this? Thanks -- *Grace Batumbya* Research Assistant | Seneca CDOT Phone: 416-491-5050 x3548 cdot.senecac.on.ca http://cdot.senecac.on.ca/ -- 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] Windows x64 : How do I get OSSP-UUID.sql contrib for postgresql x64
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 this? Thanks -- *Grace Batumbya* Research Assistant | Seneca CDOT Phone: 416-491-5050 x3548 cdot.senecac.on.ca http://cdot.senecac.on.ca/ -- 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] Windows x64 : How do I get OSSP-UUID.sql contrib for postgresql x64
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 | Seneca CDOT Phone: 416-491-5050 x3548 cdot.senecac.on.ca http://cdot.senecac.on.ca/ On 6/29/2011 12:38 PM, Hiroshi Saito wrote: 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 this? Thanks -- *Grace Batumbya* Research Assistant | Seneca CDOT Phone: 416-491-5050 x3548 cdot.senecac.on.ca http://cdot.senecac.on.ca/ -- 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] UUID-OSP contrib module
Hi Michael-san. Sorry very late reaction. Although it is several years ago, I did the work origin of OSSP-UUID on windows platform with Ralf-san. He is Great developer!. http://www.ossp.org/pkg/lib/uuid/ However, I made the mistake in patch then After late, correction patch was made this. http://winpg.jp/~saito/pg_work/OSSP_win32/ At this time, Ralf-san was passing the individual very busy time. He has full knowledge of these contents. then, In the new version, it will to be released with build by VisualStudio. But, but...It is not released yet by various reasons.:-( sorry again 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 Regards Michael Gould Intermodal Software Solutions Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax -- 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] UUID-OSP contrib module
Yeah, although cheap contribution by me.:-) Thanks! (2011/06/25 2:10), Michael Gould wrote: Thanks for the reply. We're using Windows 32 of Postgres in development but would like to deploy windows 64 when we are ready. I agree, I think that Postgres ought to provide fully support for GUID's like most other databases. Best Regards Michael Gould Hiroshi Saitohiro...@winpg.jp wrote: Hi Michael-san. Sorry very late reaction. Although it is several years ago, I did the work origin of OSSP-UUID on windows platform with Ralf-san. He is Great developer!. http://www.ossp.org/pkg/lib/uuid/ However, I made the mistake in patch then After late, correction patch was made this. http://winpg.jp/~saito/pg_work/OSSP_win32/ At this time, Ralf-san was passing the individual very busy time. He has full knowledge of these contents. then, In the new version, it will to be released with build by VisualStudio. But, but...It is not released yet by various reasons.:-( sorry again 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 Regards Michael Gould Intermodal Software Solutions Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax -- 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] [HACKERS] PostgreSQL Core Team
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 maintenance of the native Windows port, quickly becoming a committer to help with his efforts. He's one of the project's webmasters and sysadmins and also contributes to related projects such as pgAdmin. In his spare time, he serves as President of the Board of PostgreSQL Europe. Regards, Dave. -- 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] Problems with ODBC Driver
Hi. There is very little information which explores a problem. What thing is an actual error message? The following is my imagination As for specific field, it may be the LOWER problem of a character. example) -- CREATE TABLE xx(Field TEXT); postgres=# SELECT Field FROM 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: Phil Jackson sapi...@clear.net.nz I have a notebook that I am using as a server for testing purposes and it has the official ODBC driver installed. I can access this and use it connect to PostreSql. On a second machine on the same network - I also have the same ODBC driver installed. The behaviour of this one is quite different. I have a test program that works on the server but when I run it on this workstation, it can create a file with a couple of fields which I can verify by looking inside PostgreSQL. But when I go to open up that file and refer to one of its fields, I get an error message saying the field doesn't exist. I am running XP Professional on both machines. I have no idea what is happening - I have opened up the firewall on both machines to allow port 5432 to be used by all applications with TCP (also tried TCP and UDP). Does anyone have any suggestions? Cheers Phil Jackson -- 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] psql language
Hi Stuart-san. Is the state where you wish this? example C:\Program Files\PostgreSQL\8.4\binpsql -p 5433 postgres postgres psql (8.4.0) help でヘルプを表示します. C:\Program Files\PostgreSQL\8.4\binset LANG=C C:\Program Files\PostgreSQL\8.4\binpsql -p 5433 postgres postgres psql (8.4.0) Type help for help. Have I missed something? Regards, Hiroshi Saito - Original Message - From: Stuart McGraw smcg2...@frii.com To: pgsql-general@postgresql.org Sent: Friday, July 10, 2009 11:00 AM Subject: [GENERAL] psql language Hello, I just installed pg-8.4 on Windows XP but ran into some unexpected problems. I am working on some tools to aid English-speaking learners of Japanese. This of course requires me to regularly display and enter Japanese text on my machine, so I have the Regional setting, Language for non-unicode programs set to Japanese although the locale language is English. This allows me to to work with both english and japanese text in the windows console (cmd.exe) just fine. Psql also worked fine until 8.4. With 8.4 though, psql presents messages in Japanese. Since I am still a beginner at Japanese myself, this is a problem. FWIW, I tried doing SET LANGUAGE en_US and with every other locale-related variable LC_ALL, LANG, LC_MESSAGES, etc, I could think of, before running psql but with no effect. How can I tell psql (and any other command line tools) to use english messages? -- 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] encoding of PostgreSQL messages
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 karsten.hilb...@gmx.net On Tue, Mar 03, 2009 at 12:35:37AM +0900, Hiroshi Saito wrote: Sorry very late reaction. I desire problem solution. So do I :-) Ganbatte ! Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 -- 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] encoding of PostgreSQL messages
Hi. Sorry very late reaction. I desire problem solution.Therefore, one evidence I tried jdbc program. http://winpg.jp/~saito/pg_work/LC_MESSAGE_CHECK/connect_problem/jdbctestx.java C:\home\HIROSHIjava jdbctestx org.postgresql.util.PSQLException: FATAL: ???[??postgres?? at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(Conn ectionFactoryImpl.java:444) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Conne ctionFactoryImpl.java:99) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactor y.java:66) at org.postgresql.jdbc2.AbstractJdbc2Connection.init(AbstractJdbc2Conn ection.java:124) at org.postgresql.jdbc2.Jdbc2Connection.init(Jdbc2Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:386) at org.postgresql.Driver.connect(Driver.java:260) 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 - Original Message - From: Hiroshi Inoue in...@tpf.co.jp Tom Lane wrote: Peter Eisentraut pete...@gmx.net writes: Bruce Momjian wrote: Can someone comment on this? Looks like a horrible hack to me. Recoding stuff to the client encoding in the server outside the existing recoding mechanism looks pretty evil to me. Plus, it does not address the problem of what happens to messages sent before this, it just moves the point of before a bit earlier for some special cases. I think we have discussed more proper solutions earlier in this thread. IMO the best approach would be for the client to include the client encoding in the startup package. Huh? Clients already do that (or at least some are capable of it, including libpq). Yes the psqlodbc driver has done it because protocol 3 allowed it from the first. The hard problems are (1) there's still a before, Yes but isn't it an improvement that properly localized password error or no database error etc can be seen? Currently I see unreadable error messages for those cases via psqlodbc driver. The attatched patch in my previous posting is an example to solve the problem. regards, Hirosh Inoue -- 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] Linked server query problem
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 ALERT.novastar.[public].[point] Error: OLE DB provider MSDASQL for linked server ALERT returned message ERROR: syntax error at or near Col1004; Error while executing the query. Msg 7320, Level 16, State 2, Line 1 Cannot execute the query SELECT Tbl1002.id Col1004 FROM novastar.public.point Tbl1002 against OLE DB provider MSDASQL for linked server ALERTIII. This query does work from MS SQL: EXEC ('SELECT id FROM point') at ALERT Any ideas as what the problem is Thank you Steven Anderson City of Dallas Streets Department Flood Control 2255 Irving Blvd. Dallas, TX 75207-6201 (214)671-0424 fax - (214)670-6526 web http://fc.dallascityhall.com wireless web http://fc.dallascityhall.com/wap -- 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] pglib.dll for windows ce
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: pgsql-general@postgresql.org Sent: Friday, November 28, 2008 10:07 PM Subject: Re: [GENERAL] pglib.dll for windows ce Sorry - its libpq.dll Julius Tuskenis Julius Tuskenis rašė: Hello List, I'm writing a program to be run on WinCE. Are there dll's for wince client (pglib.dll and others)? -- 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] Trying Compile libpq.dll with VC++ 9.0, but need help
Hi. It is very strange I checked that it was ready in VC9 again. http://winpg.jp/~saito/pg_work/WIN32_BUILD_INF/LOG_LIBPQ_WIN32MAK.txt Furthermore, even psql was checked. http://winpg.jp/~saito/pg_work/WIN32_BUILD_INF/psql_win32_pg83.mak Please move psql_win32_pg83 win32.mak on src\bin\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 [EMAIL PROTECTED] Dann Corbit wrote: Change from /MD to /MT and it will not use the runtime DLL. Look under: Properties - Configuration Properties - C/C++ - Code Generation - Runtime Library Hi Dann, I changed that in the win32.mak file and now it gives this error: link.exe @C:\DOCUME~1\20659\LOCALS~1\Temp\nmA6.tmp Creating library .\Release\libpqdll.lib and object .\Release\libpqdll.exp LIBCMT.lib(dosmap.obj) : error LNK2005: __dosmaperr already defined in libpq.lib(win32error.obj) .\Release\libpq.dll : fatal error LNK1169: one or more multiply defined symbols found NMAKE : fatal error U1077: 'C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\BIN\link.exe' : return code '0x491' Stop. -- 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] UUID-OSSP Contrib Module Compilation Issue
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 pgsql-general@postgresql.org Sent: Wednesday, October 29, 2008 8:01 AM Subject: [GENERAL] UUID-OSSP Contrib Module Compilation Issue Hi All, I am trying to build the uuid-ossp contrib module for PostgreSQL 8.3.4. I am building on Solaris x86 with Sun Studio 12. I built the ossp-uuid version 1.6.2 libraries and installed them, however, whenever I attempt to build the contrib module I always end up with the following error: -- + cd contrib + cd uuid-ossp + make all sed 's,MODULE_PATHNAME,$libdir/uuid-ossp,g' uuid-ossp.sql.in uuid-ossp.sql /usr/bin/cc -Xa -I/usr/sfw/include -KPIC -I. -I../../src/include -I/usr/sfw/include -c -o uuid-ossp.o uuid-ossp.c uuid-ossp.c, line 29: #error: OSSP uuid.h not found cc: acomp failed for uuid-ossp.c make: *** [uuid-ossp.o] Error 2 -- I have the ossp uuid libraries and headers in the standar locations (/usr/include, /usr/lib) but the checks within the contrib module dont appear to find the ossp uuid headers I have installed. Am I mising something here, or could the #ifdefs have something to do with it not picking up the newer ossp uuid defnitions? Any suggestions would be greatly appreciated. Thanks Bruce -- 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] UUID-OSSP Contrib Module Compilation Issue
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/mailpref/pgsql-general
Re: [GENERAL] error compiling postgres source
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] To: Hiroshi Saito [EMAIL PROTECTED] Sent: Friday, October 03, 2008 1:27 PM Subject: RE: [GENERAL] error compiling postgres source Hi, Thanks a lot for the help..i was able to compile postgres. I wanted to use libpqxx in windows.it was specified in install.txt to compile postgresql source,and it is said we hav to change the common file in win32 folder and run the libpqxx.mak file to compile libpqxx.But there is no libpqxx.mak.A file named vc-libpqxx.mak.template is there .should I hav to modify that file to compile libpqxx ??if u hav any idea plz help me on that. Thanks and regards Roshni. -Original Message- From: Hiroshi Saito [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2008 6:31 PM To: Roshni Mani Subject: Re: [GENERAL] error compiling postgres source Hi . Ok, You can choose the environment of specification of SDK from a start menu.! Please see:-) Regards, Hiroshi Saito - Original Message - From: Roshni Mani [EMAIL PROTECTED] To: Hiroshi Saito [EMAIL PROTECTED] Sent: Wednesday, October 01, 2008 7:54 PM Subject: RE: [GENERAL] error compiling postgres source Hi, I have installed SDK separatelycan you tell me what environment variables to set??i'm new to this kind of things.. Thanks in advance, Roshni -Original Message- From: Hiroshi Saito [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2008 3:01 PM To: Roshni Mani Subject: Re: [GENERAL] error compiling postgres source Hi. Is SDK set in the environment which you use? win32.mak can be used with Microsoft Visual C++ 2005 Edition However, SDK is independently required. and environment settings. Regards, Hiroshi SAito - Original Message - From: Roshni Mani [EMAIL PROTECTED] To: Hiroshi Saito [EMAIL PROTECTED] Sent: Wednesday, October 01, 2008 6:14 PM Subject: RE: [GENERAL] error compiling postgres source Hi, Thanks for the reply .i deleted the said files ...but still the same errors are coming.. Thanks and regards, Roshni -Original Message- From: Hiroshi Saito [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2008 2:38 PM To: Roshni Mani; pgsql-general@postgresql.org Subject: Re: [GENERAL] error compiling postgres source 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\libpqnmake -f win32.mak Microsoft (R) Program Maintenance Utility Version 8.00.50727.42 Copyright (C) Microsoft Corporation. All rights reserved. Building the Win32 static library... (snip) copy ..\..\include\pg_config.h.win32 ..\..\include\pg_config.h 1 file(s) copied. echo #define SYSCONFDIR pg_config_paths.h copy ..\..\include\port\win32.h ..\..\include\pg_config_os.h 1 file(s) copied. (snip) Please delete following two files before compile. del ..\..\include\pg_config.h ..\..\include\pg_config_os.h - Original Message - From: Roshni Mani To: pgsql-general@postgresql.org Sent: Wednesday, October 01, 2008 3:13 PM Subject: [GENERAL] error compiling postgres source Hi , Can somebody tell me the solution for this.i tried compiling postgres as follows in vs2005 .its giving the following errors E:\postgresql-8.3.1\src\interfaces\libpqnmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 8.00.50727.42 Copyright (C) Microsoft Corporation. All rights reserved. Building the Win32 static library... Using default OpenSSL Include directory: C:\OpenSSL\include Using default OpenSSL Library directory: C:\OpenSSL\lib\VC Using default Kerberos Include directory: C:\kfw-2.6.5\inc Using default Kerberos Library directory: C:\kfw-2.6.5\lib\i386 cl.exe @C:\DOCUME~1\roma\LOCALS~1\Temp\nm3E.tmp getaddrinfo.c ..\..\include\libpq/pqcomm.h(64) : error C2079: 'addr' uses undefined struct 'sockaddr_storage' ..\..\port\getaddrinfo.c(144) : error C2079: 'hints' uses undefined struct 'addrinfo' ..\..\port\getaddrinfo.c(159) : error C2224: left of '.ai_family' must have struct/union type ..\..\port\getaddrinfo.c(160) : error C2224: left of '.ai_socktype' must have struct/union type ..\..\port\getaddrinfo.c(165) : error C2224: left of '.ai_family' must have struct/union type ..\..\port\getaddrinfo.c(165) : error C2224: left of '.ai_family' must have struct/union type ..\..\port\getaddrinfo.c(168) : error C2224: left of '.ai_socktype' must have struct/union type ..\..\port\getaddrinfo.c(169) : error C2224: left of '.ai_socktype' must have struct/union type ..\..\port\getaddrinfo.c(182) : error C2224: left of '.ai_flags' must have struct/union type ..\..\port\getaddrinfo.c(223) : error C2224: left of '.ai_flags' must have struct/union type ..\..\port\getaddrinfo.c(236
Re: [GENERAL] error compiling postgres source
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\libpqnmake -f win32.mak Microsoft (R) Program Maintenance Utility Version 8.00.50727.42 Copyright (C) Microsoft Corporation. All rights reserved. Building the Win32 static library... (snip) copy ..\..\include\pg_config.h.win32 ..\..\include\pg_config.h 1 file(s) copied. echo #define SYSCONFDIR pg_config_paths.h copy ..\..\include\port\win32.h ..\..\include\pg_config_os.h 1 file(s) copied. (snip) Please delete following two files before compile. del ..\..\include\pg_config.h ..\..\include\pg_config_os.h - Original Message - From: Roshni Mani To: pgsql-general@postgresql.org Sent: Wednesday, October 01, 2008 3:13 PM Subject: [GENERAL] error compiling postgres source Hi , Can somebody tell me the solution for this.i tried compiling postgres as follows in vs2005 .its giving the following errors E:\postgresql-8.3.1\src\interfaces\libpqnmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 8.00.50727.42 Copyright (C) Microsoft Corporation. All rights reserved. Building the Win32 static library... Using default OpenSSL Include directory: C:\OpenSSL\include Using default OpenSSL Library directory: C:\OpenSSL\lib\VC Using default Kerberos Include directory: C:\kfw-2.6.5\inc Using default Kerberos Library directory: C:\kfw-2.6.5\lib\i386 cl.exe @C:\DOCUME~1\roma\LOCALS~1\Temp\nm3E.tmp getaddrinfo.c ..\..\include\libpq/pqcomm.h(64) : error C2079: 'addr' uses undefined struct 'sockaddr_storage' ..\..\port\getaddrinfo.c(144) : error C2079: 'hints' uses undefined struct 'addrinfo' ..\..\port\getaddrinfo.c(159) : error C2224: left of '.ai_family' must have struct/union type ..\..\port\getaddrinfo.c(160) : error C2224: left of '.ai_socktype' must have struct/union type ..\..\port\getaddrinfo.c(165) : error C2224: left of '.ai_family' must have struct/union type ..\..\port\getaddrinfo.c(165) : error C2224: left of '.ai_family' must have struct/union type ..\..\port\getaddrinfo.c(168) : error C2224: left of '.ai_socktype' must have struct/union type ..\..\port\getaddrinfo.c(169) : error C2224: left of '.ai_socktype' must have struct/union type ..\..\port\getaddrinfo.c(182) : error C2224: left of '.ai_flags' must have struct/union type ..\..\port\getaddrinfo.c(223) : error C2224: left of '.ai_flags' must have struct/union type ..\..\port\getaddrinfo.c(236) : error C2027: use of undefined type 'addrinfo' ..\..\include\getaddrinfo.h(153) : see declaration of 'addrinfo' ..\..\port\getaddrinfo.c(249) : error C2037: left of 'ai_flags' specifies undefined struct/union 'addrinfo' ..\..\port\getaddrinfo.c(250) : error C2037: left of 'ai_family' specifies undefined struct/union 'addrinfo' ..\..\port\getaddrinfo.c(251) : error C2037: left of 'ai_socktype' specifies undefined struct/union 'addrinfo' ..\..\port\getaddrinfo.c(251) : error C2224: left of '.ai_socktype' must have struct/union type ..\..\port\getaddrinfo.c(252) : error C2037: left of 'ai_protocol' specifies undefined struct/union 'addrinfo' ..\..\port\getaddrinfo.c(252) : error C2224: left of '.ai_protocol' must have struct/union type ..\..\port\getaddrinfo.c(253) : error C2037: left of 'ai_addrlen' specifies undefined struct/union 'addrinfo' ..\..\port\getaddrinfo.c(254) : error C2037: left of 'ai_addr' specifies undefined struct/union 'addrinfo' ..\..\port\getaddrinfo.c(255) : error C2037: left of 'ai_canonname' specifies undefined struct/union 'addrinfo' ..\..\port\getaddrinfo.c(256) : error C2037: left of 'ai_next' specifies undefined struct/union 'addrinfo' ..\..\port\getaddrinfo.c(282) : error C2037: left of 'ai_addr' specifies undefined struct/union 'addrinfo' ..\..\port\getaddrinfo.c(283) : error C2037: left of 'ai_addr' specifies undefined struct/union 'addrinfo' ..\..\port\getaddrinfo.c(283) : error C2198: 'free' : too few arguments for call NMAKE : fatal error U1077: 'C:\Program Files\Microsoft Visual Studio 8\VC\BIN\cl.exe' : return code '0x2' Stop. Regards, Roshni -- 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] psqlodbc on Vista Ultimate 64
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: [GENERAL] psqlodbc on Vista Ultimate 64 Olá, estou com um problema, o Windows Vista não reconhece o odbc do PostgreSQL, alguma dica? Hello, I have a problem, Windows Vista does not recognize the odbc of PostgreSQL, any hint? -- Lucas Felix de Sousa Técnico em Informática [EMAIL PROTECTED] Se enxerguei mais longe que outros homens, foi porque me ergui em ombros de gigantes. -- 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] [EMAIL PROTECTED]
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? Robert Treat On Sunday 03 August 2008 18:01:05 Hiroshi Saito wrote: 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(uuid_ns_url(), 'http://www.postgresql.org'); but the DB returns with this error message: ERROR: function uuid_ns_url() does not exist SQL state: 42883 Hint: No function matches the given name and argument types. You might need to add explicit type casts. Character: 25 Any hint to use UUID within my database tirggers? Thank you, Laci -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- 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] [EMAIL PROTECTED]
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(uuid_ns_url(), 'http://www.postgresql.org'); but the DB returns with this error message: ERROR: function uuid_ns_url() does not exist SQL state: 42883 Hint: No function matches the given name and argument types. You might need to add explicit type casts. Character: 25 Any hint to use UUID within my database tirggers? Thank you, Laci -- 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] FW: make rows unique across db's without UUIP on windows?
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's without UUIP on windows? Considering the discussions on the pgsql-bugs user list regarding ossp-uuip: Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows, What is the normal solution in pgsql-land for making a serious number of rows unique across multiple databases? I mean particularly databases of different types (every type) used at various places (everywhere) on all platforms (even MS[TM])? You know. a UNIVERSAL id? I gotta have it! I'm doing distributed list management. Anyone got a real good, dependable, easy, and universally manageable solution? Thanks, Kimball Johnson -- 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] FW: make rows unique across db's without UUIP on windows?
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. However, I really wanted to know what PGSQL people are doing now and have done in the past to address this kind of issue. Surely the need to have unique rows across databases has come up before? Thanks, Kimball -Original Message- From: Hiroshi Saito [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 8:46 PM To: [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] FW: make rows unique across db's without UUIP on windows? 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's without UUIP on windows? Considering the discussions on the pgsql-bugs user list regarding ossp-uuip: Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows, What is the normal solution in pgsql-land for making a serious number of rows unique across multiple databases? I mean particularly databases of different types (every type) used at various places (everywhere) on all platforms (even MS[TM])? You know. a UNIVERSAL id? I gotta have it! I'm doing distributed list management. Anyone got a real good, dependable, easy, and universally manageable solution? Thanks, Kimball Johnson -- 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] FW: make rows unique across db's without UUIP on windows?
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. However, I really wanted to know what PGSQL people are doing now and have done in the past to address this kind of issue. Surely the need to have unique rows across databases has come up before? Thanks, Kimball -Original Message- From: Hiroshi Saito [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 8:46 PM To: [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] FW: make rows unique across db's without UUIP on windows? 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's without UUIP on windows? Considering the discussions on the pgsql-bugs user list regarding ossp-uuip: Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows, What is the normal solution in pgsql-land for making a serious number of rows unique across multiple databases? I mean particularly databases of different types (every type) used at various places (everywhere) on all platforms (even MS[TM])? You know. a UNIVERSAL id? I gotta have it! I'm doing distributed list management. Anyone got a real good, dependable, easy, and universally manageable solution? Thanks, Kimball Johnson -- 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] Compiling trigger function with MinGW
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 from Example in Postgres Help. Linker show me this error: D:\users\anthony\kursor\abzcrm\c\foogcc -shared foo.o -o foo.dll -L d:/files/local/PostgreSQL/8.3/lib -l postgres Cannot export postgres_NULL_THUNK_DATA: symbol not found collect2: ld returned 1 exit status What should I do? -- Anton Burkun +380 66 757 70 27 -- 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] UUID-OSSP for windows.
Hi. - Original Message - From: Scott Marlowe [EMAIL PROTECTED] On Tue, Feb 26, 2008 at 9:44 PM, Tim Uckun [EMAIL PROTECTED] wrote: Where can I get uuid-ossp for windows? Also where can I get citext for windows. These two are missing from the windows installer. Search the archives. There was a conversation about this in the last week or two. Basically, windows has it's own uuid, and there's a discussion on how to exploit that instead of importing uuid-ossp. I enabled it to offer it after the joint work of one time with Mr. Ralf S.Engelschall. http://archives.postgresql.org/pgsql-hackers/2008-02/msg00844.php http://lists.pgfoundry.org/pipermail/pginstaller-devel/2008-February/001056.html PostgreSQL is required for compile.(It is not regular.) http://winpg.jp/~saito/pg_work/OSSP_win32/msvc/ However, It is publicly released 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
Hi. - Original Message - From: bh yuan [EMAIL PROTECTED] Thanks for your replay. The 0xe9ab99 is not SJIS nor SHIFT_JIS_2004. Ahh Ok, you already understood. :-) But I shoud export data with not regular SJIS character from old database(7.4.3) to new database(8.3), and use the old programe which export data as SJIS encoding .csv file. Can I modify conf file to ignore the error? or check inigore character from the database and convert it to regular SJIS encoding character with some tools ? Although it is unknown in whether the inside 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 export data as .csv file, I use set client_encoding='SJIS' at client. No, you should use UTF-8 of default. means export a UTF-8 encoding csv file? Thanks 2008/2/8, Hiroshi Saito [EMAIL PROTECTED]: Ooops, shortage of information..sorry. Please see, http://winpg.jp/~saito/pg83/HASHIGODATA/ Hi. - Original Message - From: bh yuan [EMAIL PROTECTED] hi I used Postgresql7.4.3 with php for more than 3years. Now I want to change my database to Postgresql8.3. But I occur such problem -- ERROR: character 0xe9ab99 of encoding UTF8 has no equivalent in SJIS ERROR: character 0xe9ab99 of encoding UTF8 has no equivalent in SHIFT_JIS_2004 -- The database was encoded by UTF-8, It SERVER_ENCODING=UTF-8 is Ok. to export data as .csv file, I use set client_encoding='SJIS' at client. No, you should use UTF-8 of default. When I use Postgresql7.4.3,no problem occur, It seems that it has 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 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] character conversion problem about UTF-8--SHIFT_JIS_2004
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. - Original Message - From: bh yuan [EMAIL PROTECTED] Thanks for your replay. The 0xe9ab99 is not SJIS nor SHIFT_JIS_2004. Ahh Ok, you already understood. :-) But I shoud export data with not regular SJIS character from old database(7.4.3) to new database(8.3), and use the old programe which export data as SJIS encoding .csv file. Can I modify conf file to ignore the error? or check inigore character from the database and convert it to regular SJIS encoding character with some tools ? Although it is unknown in whether the inside 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 export data as .csv file, I use set client_encoding='SJIS' at client. No, you should use UTF-8 of default. means export a UTF-8 encoding csv file? Thanks 2008/2/8, Hiroshi Saito [EMAIL PROTECTED]: Ooops, shortage of information..sorry. Please see, http://winpg.jp/~saito/pg83/HASHIGODATA/ Hi. - Original Message - From: bh yuan [EMAIL PROTECTED] hi I used Postgresql7.4.3 with php for more than 3years. Now I want to change my database to Postgresql8.3. But I occur such problem -- ERROR: character 0xe9ab99 of encoding UTF8 has no equivalent in SJIS ERROR: character 0xe9ab99 of encoding UTF8 has no equivalent in SHIFT_JIS_2004 -- The database was encoded by UTF-8, It SERVER_ENCODING=UTF-8 is Ok. to export data as .csv file, I use set client_encoding='SJIS' at client. No, you should use UTF-8 of default. When I use Postgresql7.4.3,no problem occur, It seems that it has 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 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] character conversion problem about UTF-8--SHIFT_JIS_2004
Hi. use set client_encoding=''SJIS be the same to export PGCLIENTENCODING=SJIS. But can not export the data to csv file corecttly without errror, just because the character which is not SJIS encoding. Um, Please show the information on your database of 7.3. ex) postgres=# \l 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 broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] character conversion problem about UTF-8--SHIFT_JIS_2004
Hi. Oh ok, About the data in a database. From the pre- report, you are operating by UTF-8. Therfore, you should take it out by UTF-8 first. It is reload to new 8.3 of UTF-8. Then, conversion does not occur there. To the next. when SJIS is required by the client , some character codes may 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(7.4) by encoding SJIS, but can not import it into new db(8.3) for some unregular sjis character. And I create the database by encoding UTF-8 . --- createdb -E UNICODE db --- I think it is the same to set PGCLIENTENCODING=UTF-8 . use set client_encoding=''SJIS be the same to export PGCLIENTENCODING=SJIS. But can not export the data to csv file corecttly without errror, just because the character which is not SJIS encoding. The main problem is that , I want to ignore the none SJIS character, but I do not know how todo it ... :( Such as iconv function in php - If you append the string //TRANSLIT to out_charset transliteration is activated. This means that when a character can't be represented in the target charset, it can be approximated through one or several similarly looking characters. If you append the string //IGNORE, characters that cannot be represented in the target charset are silently discarded. Otherwise, str is cut from the first illegal character. - Of course it is not the best way , but I just want to resolve this problem immediately Thanks 2008/2/8, Hiroshi Saito [EMAIL PROTECTED]: 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. - Original Message - From: bh yuan [EMAIL PROTECTED] Thanks for your replay. The 0xe9ab99 is not SJIS nor SHIFT_JIS_2004. Ahh Ok, you already understood. :-) But I shoud export data with not regular SJIS character from old database(7.4.3) to new database(8.3), and use the old programe which export data as SJIS encoding .csv file. Can I modify conf file to ignore the error? or check inigore character from the database and convert it to regular SJIS encoding character with some tools ? Although it is unknown in whether the inside 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 export data as .csv file, I use set client_encoding='SJIS' at client. No, you should use UTF-8 of default. means export a UTF-8 encoding csv file? Thanks 2008/2/8, Hiroshi Saito [EMAIL PROTECTED]: Ooops, shortage of information..sorry. Please see, http://winpg.jp/~saito/pg83/HASHIGODATA/ Hi. - Original Message - From: bh yuan [EMAIL PROTECTED] hi I used Postgresql7.4.3 with php for more than 3years. Now I want to change my database to Postgresql8.3. But I occur such problem -- ERROR: character 0xe9ab99 of encoding UTF8 has no equivalent in SJIS ERROR: character 0xe9ab99 of encoding UTF8 has no equivalent in SHIFT_JIS_2004 -- The database was encoded by UTF-8, It SERVER_ENCODING=UTF-8 is Ok. to export data as .csv file, I use set client_encoding='SJIS' at client. No, you should use UTF-8 of default. When I use Postgresql7.4.3,no problem occur, It seems that it has 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 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] character conversion problem about UTF-8--SHIFT_JIS_2004
Hi. - Original Message - From: bh yuan [EMAIL PROTECTED] hi I used Postgresql7.4.3 with php for more than 3years. Now I want to change my database to Postgresql8.3. But I occur such problem -- ERROR: character 0xe9ab99 of encoding UTF8 has no equivalent in SJIS ERROR: character 0xe9ab99 of encoding UTF8 has no equivalent in SHIFT_JIS_2004 -- The database was encoded by UTF-8, It SERVER_ENCODING=UTF-8 is Ok. to export data as .csv file, I use set client_encoding='SJIS' at client. No, you should use UTF-8 of default. When I use Postgresql7.4.3,no problem occur, It seems that it has 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 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] character conversion problem about UTF-8--SHIFT_JIS_2004
Ooops, shortage of information..sorry. Please see, http://winpg.jp/~saito/pg83/HASHIGODATA/ Hi. - Original Message - From: bh yuan [EMAIL PROTECTED] hi I used Postgresql7.4.3 with php for more than 3years. Now I want to change my database to Postgresql8.3. But I occur such problem -- ERROR: character 0xe9ab99 of encoding UTF8 has no equivalent in SJIS ERROR: character 0xe9ab99 of encoding UTF8 has no equivalent in SHIFT_JIS_2004 -- The database was encoded by UTF-8, It SERVER_ENCODING=UTF-8 is Ok. to export data as .csv file, I use set client_encoding='SJIS' at client. No, you should use UTF-8 of default. When I use Postgresql7.4.3,no problem occur, It seems that it has 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 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP
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] Konbanwa Hiroshi-san, thanks for your fast reply. I installed the Microsoft Visual C++ 2005 SP1 Redistributable Package (x86) before running the PostgreSQL 8.3 setup. However, the PostgreSQL installation does still not find the msvcr80.dll. It seems, that the PostgreSQL setup has to be adjusted or is there any other possibility to get it working under XP? Background is that our application's setup is installing it's database on PostgreSQL and can't completely do that with the dll missing. Greetings, Hermann Hiroshi Saito schrieb: Hi. It seems that MSVCR80.dll is not registered to InstallFinalize on the problem of the timing of an installer. It is not found at the time of initdb. Therefore, please before install this. http://www.microsoft.com/downloads/details.aspx?FamilyID=200b2fd9-ae1a-4a14-984d-389c36f85647DisplayLang=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, Hiroshi Saito - Original Message - From: Hermann Muster [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: Monday, February 04, 2008 11:43 PM Subject: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP Hi, I installed today's release setup of PostgreSQL 8.3. Unfortunately Libpq.dll has a dependancy to msvcr80.dll, which can't be found on my system. I checked the msi installer file and found that this dll will not be installed under Windows XP. Does anyone has any suggestions concerning this serious problem? Thanks for your help, Hermann ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP
Hi. - Original Message - From: Dave Page [EMAIL PROTECTED] So, is there some reason the runtimes might not install in non-English versions of Windows? We're using the Windows Installer merge module as per Microsoft's recommendations. Surely your examination is passed. Therfore, It may be the problem of some languages. However, It seems that MSVCR80 also has the version problem. Furthermore, the problem was seen by VISTA...but but, I did not have a spare time Anyway, If there are again in addition to this situation, we need investigation 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
Hi. MSVCR80.dll which the binary of 8.3 refers to is this. C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6b128700\MSVCR80.dll I tried again in the beautiful environment which does not have 8.0.50727.762 in the environment of XP-SP2. Then, It was fine. I can'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 [EMAIL PROTECTED] 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] Konbanwa Hiroshi-san, thanks for your fast reply. I installed the Microsoft Visual C++ 2005 SP1 Redistributable Package (x86) before running the PostgreSQL 8.3 setup. However, the PostgreSQL installation does still not find the msvcr80.dll. It seems, that the PostgreSQL setup has to be adjusted or is there any other possibility to get it working under XP? Background is that our application's setup is installing it's database on PostgreSQL and can't completely do that with the dll missing. Greetings, Hermann Hiroshi Saito schrieb: Hi. It seems that MSVCR80.dll is not registered to InstallFinalize on the problem of the timing of an installer. It is not found at the time of initdb. Therefore, please before install this. http://www.microsoft.com/downloads/details.aspx?FamilyID=200b2fd9-ae1a-4a14-984d-389c36f85647DisplayLang=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, Hiroshi Saito - Original Message - From: Hermann Muster [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: Monday, February 04, 2008 11:43 PM Subject: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP Hi, I installed today's release setup of PostgreSQL 8.3. Unfortunately Libpq.dll has a dependancy to msvcr80.dll, which can't be found on my system. I checked the msi installer file and found that this dll will not be installed under Windows XP. Does anyone has any suggestions concerning this serious problem? Thanks for your help, Hermann ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP
Hi. It seems that MSVCR80.dll is not registered to InstallFinalize on the problem of the timing of an installer. It is not found at the time of initdb. Therefore, please before install this. http://www.microsoft.com/downloads/details.aspx?FamilyID=200b2fd9-ae1a-4a14-984d-389c36f85647DisplayLang=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, Hiroshi Saito - Original Message - From: Hermann Muster [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: Monday, February 04, 2008 11:43 PM Subject: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP Hi, I installed today's release setup of PostgreSQL 8.3. Unfortunately Libpq.dll has a dependancy to msvcr80.dll, which can't be found on my system. I checked the msi installer file and found that this dll will not be installed under Windows XP. Does anyone has any suggestions concerning this serious problem? Thanks for your help, Hermann ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
Re: [GENERAL] Question for Postgres 8.3
Hi. - Original Message - From: Clemens Schwaighofer [EMAIL PROTECTED] hi, on the page: http://www.postgresql.org/docs/8.3/static/release-8-3.html in point E.1.2.3: * Disallow database encodings that are inconsistent with the server's locale setting (Tom) does this mean, if my server LOCALE is for example UTF-8.en_US, and I want to create a EUC_JP database it gets rejected? do I missunderstand that? Normaly my servers have default locale set to UTF-8.en_US but also have the locales for UTF-8.ja_JP and EUC_JP there, 99.9% of my databases 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-locale. 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
I'm surprised your clients haven't been screaming about bogus sorting and upper/lowercasing behavior. Umm, This is a mere information. (Since you dislike, this may be a noise.?) As for upper/lower. It does not change, even if uses which locale in us Japanese. (there is nothing with the alphabet) Then, In spite of using a small letter and a capital letter properly clearly. As for sorting. It has a difference, if sorting of a dictionary is desired. However, each is the not Japanese order of the JIS X 4061:1996(Collation of Japanese character string), probably. but, I think 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 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Question for Postgres 8.3
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 about bogus sorting and upper/lowercasing behavior. Umm, This is a mere information. (Since you dislike, this may be a noise.?) As for upper/lower. It does not change, even if uses which locale in us Japanese. (there is nothing with the alphabet) Then, In spite of using a small letter and a capital letter properly clearly. As for sorting. It has a difference, if sorting of a dictionary is desired. However, each is the not Japanese order of the JIS X 4061:1996(Collation of Japanese character string), probably. but, I think 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 もしかしたらLinux LOCALEはUTF-8.en_USとPostgresのLOCALEはCその日本語の ソートは正しくない?僕はいつでもLOCAL=Cある、と今テストしました。ソート は正しいです。 ありがとうございます。 -- [ Clemens Schwaighofer -=:~ ] [ IT Engineer/Manager, TEQUILA\ Japan IT Group ] [6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN ] [ Tel: +81-(0)3-3545-7703Fax: +81-(0)3-3545-7343 ] [ http://www.tequila.co.jp ] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] Insert returning Npgsql
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 [EMAIL PROTECTED] Good day every one . Im trying to make and insert returning with the connector Npgsql, where can i read more about the syntax of the insert string? or how to configure the Npgsql.command class. Regards Cesar Alvarez. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Slony-I creation scripts not available
Hi. From: Glyn Astill [EMAIL PROTECTED] From within pgAdminIII I get this message in the status bar when I go to setup slony-I replication. I have the scripts in pgdir /shared after installing from source, should they be somewhere else, or should I have some environment variables set? I can't judge in what stage you encountered the problem. Probably , you can grasp the right place by the installer. and as for an early setting script, creating to slonik is desirable. Then, the detailed information developed in large quantities GUI of pgAdminIII will be difficult 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] Slony-I creation scripts not available
Hi. From: Glyn Astill [EMAIL PROTECTED] Sorry Hiroshi, I failed to understand exactly what you're saying there. Ahh, Sorry... So far I've installed Slony as per the docs, all seems to be well and the installer ahs put the replication *.sql files in pgsql/shared. I haven't started the slon daemons yet. I thought once slony was set up you could then use the scripts from pgAdminIII to setup slony before starting the slon daemons. I have the scripts, but pgAdmin is telling me it can't find them. Um, Here may be the material which helps 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 bar when I go to setup slony-I replication. I have the scripts in pgdir /shared after installing from source, should they be somewhere else, or should I have some environment variables set? I can't judge in what stage you encountered the problem. Probably , you can grasp the right place by the installer. and as for an early setting script, creating to slonik is desirable. Then, the detailed information developed in large quantities GUI of pgAdminIII will be difficult 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 Glyn Astill ___ Yahoo! Answers - Got a question? Someone out there knows the answer. Try it now. http://uk.answers.yahoo.com/ ---(end of broadcast)--- TIP 6: explain analyze is your friend ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL]about Command Prompt.
Hi. runas is not required. for example) C:\Program Files\PostgreSQL\8.3-beta1\binpsql -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: Tuesday, October 09, 2007 9:25 PM Subject: [GENERAL]about Command Prompt. what i want is using the psql to excute a serial SQL command like create table in a file. but i have tried runas /noprofile /env /user:postgres f:\postgre\bin\psql -f filename in Windows cmd ,it doesn't work. Is there any way to do this or How can I make my order work just like in Command Prompt? ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
Re: [GENERAL]about Command Prompt.
Hi. - Original Message - From: longlong if it is not in Command Prompt how can i work in a .bat file like that. and i don't want the user input password,no interaction. Ahh, Ok. Please see. http://developer.postgresql.org/pgdocs/postgres/libpq-pgpass.html notepad %APPDATA%\postgresql\pgpass.conf --edit-sample-- *:5433:postgres:postgres:postgres It follows. This is not request password. C:\Program Files\PostgreSQL\8.3-beta1\binpsql postgres postgres Welcome to psql 8.3beta1, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \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't forget to increase your free space map settings
Re: [GENERAL]about Command Prompt.
- 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 work in a .bat file like that. and i don't want the user input password,no interaction. Ahh, Ok. Please see. http://developer.postgresql.org/pgdocs/postgres/libpq-pgpass.html notepad %APPDATA%\postgresql\pgpass.conf --edit-sample-- *:5433:postgres:postgres:postgres It follows. This is not request password. C:\Program Files\PostgreSQL\8.3-beta1\binpsql postgres postgres Welcome to psql 8.3beta1, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \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 4: Have you searched our list archives? http://archives.postgresql.org/
Re: [GENERAL] Migration from PervasiveSQL
Hi. Sorry, very late reaction... - Original Message - From: Robert Treat [EMAIL PROTECTED] On Friday 21 September 2007 22:43, Merlin Moncure wrote: On 9/21/07, Robert Treat [EMAIL PROTECTED] wrote: On Thursday 20 September 2007 18:38, Merlin Moncure wrote: On 9/20/07, Collin [EMAIL PROTECTED] wrote: Well, the subject says it pretty well but to elaborate: I have a database from our ERP package that uses btrieve (PervasiveSQL) for it's database engine. I'd like to transition all of the data to PostgreSQL. I've been having trouble finding a suitable program to automatically get all of the data transferred over. I have the proper DDF files and an ODBC link in place to the data. Maestro DataDump (from the Postgresql Data Wizard program) only locks my machine up and it seemed to be the only think I could find that would take an ODBC link to the btrieve data and use it to extract the table defs and data to postgresql. Is there some other utility I could use or am I stuck writing a custom program to do it? I could maybe extract the btrieve data to CSV files but I don't have any easy way of doing that quickly for so many tables (and there are a lot!) dump to csv would be ideal (you could then use the built in csv import through pg via COPY). barring that you need to roll some scripts or use a tool. There are many ways to do this of varying quality, mostly pretty dubious. In the microsoft world you have DTS which has an ok migrator. Perhaps odbclink could be of help here? http://odbclink.projects.postgresql.org/ Thanks great information.:-) Development Status: 1 - Planning :-) Yes, I'm the stage which has searched the figure which should desire it. I see the figure of the application business used realized with two or more databases. Then, I have explored the solution method which does not spoil those property. Probably, ORACLE, DB2, SQLServer, and PostgreSQL live together. On that occasion, They wish data to flow smoothly between those databases. 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
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 pg_restore the restore doesn't recognize the archive format. The archive file was made with the command below. Is there a way to get 8.2.5 to recognize the file, or a way to run the file as a script from a different program like PG_ADMIN III? As far as I can see the archive is text. My postgresql 8.1.4 installation is no longer working. su --command=/usr/local/pgsql/bin/pg_dump -p 55432 -U postgres -C -D -f /tmp/$(date +%F)owl.sql owl *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297 This e-mail message and any attachment(s) are for the sole use of the intended recipient(s) and may contain proprietary and/or confidential information which may be privileged or otherwise protected from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient(s), please contact the sender by reply email and destroy the original message and any copies of the message as well as any attachment(s) to the original message. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] postgresql connection string to Vb.NET
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 Vb.NET Hi, I got a source of connection string at this page, http://www.connectionstrings.com/default.aspx?carrier=postgresql I can't test it because it seems i do not add a reference in visual studio 2005. Where can i download the ODBC or .NET data provider in order to successfully connect to postgresql from vb.net Thanks. -- Smithveg ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Npgsql GUI problem C#.net
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 Message - From: Jessie [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: Tuesday, August 28, 2007 4:04 AM Subject: [GENERAL] Npgsql GUI problem C#.net Hi all, I'm using C#.net 2005 dealing with Npgsql. I have a very newbie question about how to use the data received from the database. I've already connected the database with the program and reading data from database works very well in the Console application. But in windows form application, I want use form_load function to call the reading function, which is confusing since the parameter of the function String[ ] args. How should I combine this reading function with my windows form application. This seems a simple question happens in every GUI application form when accessing to the database, but I couldn't find any source to help on this yet. I appreciate any of your help! Jessie ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] psql-odbc configure error
Hi. Umm, I don't understand your build environment well However, The following examination may help to find a problem. -- long_test.c - start --- long longval () { return (long) (sizeof (long)); } unsigned long ulongval () { return (long) (sizeof (long)); } #include stdio.h #include stdlib.h int main () { long i = longval (); unsigned long ui = ulongval (); printf (%ld\n, ((long) (sizeof (long; printf (%ld\n, i); printf (%lu\n, ((long) (sizeof (long; printf (%lu\n, ui); return 0; } -- long_test.c - end --- inet% gcc -o long_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, Hiroshi Saito From: djisgitt This message bounced from psql-odbc (I suppose because I am not subscribed there), so I am hoping some kindly soul here will help me! Hi developers, In attempting to build psqlodbc from source, I receive the following error in configure after invoking it by /configure --with-unixodbc=/usr/local checking for ssize_t... yes checking for long... yes checking size of long... configure: error: cannot compute sizeof (long) See `config.log' for more details. I have attached the config.log in order to avoid snipping the important thing. I notice in the log that it fails reading libodbcinst.so.1, but lrwxrwxrwx1 root root 20 Jul 19 16:59 /usr/local/lib/libodbcinst.so.1 - libodbcinst.so.1.0.0 [EMAIL PROTECTED] psqlodbc-08.02.0400]$ ls -l /usr/local/lib/libodbcinst.so.1.0.0 and -rwxr-xr-x1 root root 310919 Jul 19 16:59 /usr/local/lib/libodbcinst.so.1.0.0 and /usr/local/lib is in the ldconfig path. Just prior to this, I installed from source unixodbc 2.2.12 in /usr/local So, please tell me what I did wrong, and how to fix it. Thank you. Don ---(end of broadcast)--- TIP 6: explain analyze is your friend ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq