[svn:DBD-Pg] r12780 - DBD-Pg/trunk

Author: turnstep
Date: Mon May 18 11:33:29 2009
New Revision: 12780

Modified:
   DBD-Pg/trunk/Changes
   DBD-Pg/trunk/README

Log:
Improved Win32 notes - Curtis Jewell


Modified: DBD-Pg/trunk/Changes
==============================================================================
--- DBD-Pg/trunk/Changes	(original)
+++ DBD-Pg/trunk/Changes	Mon May 18 11:33:29 2009
@@ -3,6 +3,8 @@
 2.13.2
 
   - Make foreign_key_info() respect FetchHashKeyName (CPAN bug #46103) [GSM]
+  - Fix problem with foreign_key_info() and NAME_uc (CPAN bug #46109) [GSM]
+  - Improve Win32 README notes [Curtis Jewell]
 
 2.13.1 Released April 23, 2009 (subversion r12713)
 

Modified: DBD-Pg/trunk/README
==============================================================================
--- DBD-Pg/trunk/README	(original)
+++ DBD-Pg/trunk/README	Mon May 18 11:33:29 2009
@@ -210,36 +210,38 @@
 
 * Strawberry Perl issues:
 
-One file change only needed to make in DBD::Pg source is:
- 
-Makefile.PL -
-add 'use DBI::DBD;'.
-comment out "unlink $output->{MAKEFILE};" at line 247
-
-set required environment:
-
-set PATH=C:\PROGRA~1\PostgreSQL\8.3\bin;%PATH%
-set DBI_DSN=dbi:Pg:dbname=testdb
-set DBI_USER=username
-set DBI_PASS=password
-set POSTGRES_HOME=C:/PROGRA~1/PostgreSQL/8.3
-set POSTGRES_INCLUDE=C:/PROGRA~1/PostgreSQL/8.3/include
-set POSTGRES_LIB=C:/PROGRA~1/PostgreSQL/8.3/lib
-
-
-perl Makefile.PL
-
-Now here's the ugly bit: edited both EXTRALIBS and LDLOADLIBS in the resulting 
-Makefile to include
-C:\PROGRA~1\PostgreSQL\8.3\lib\libpq.lib
-
-then
-
-dmake
-dmake test
-
-all works fine.
-
+You'll need to create a .a library from the .dll before 
+running the Makefile.PL, by running pexports and dlltool
+as shown below, within the C:\Program Files\PostgreSQL\8.3\bin
+directory:
+
+  pexports libpq.dll > libpq.def
+  dlltool -dllname libpq.dll --def libpq.def --output-lib ..\lib\libpq.a
+
+Then you'll need to set the required environment:
+
+  set PATH=C:\PROGRA~1\PostgreSQL\8.3\bin;%PATH%
+  set DBI_DSN=dbi:Pg:dbname=testdb
+  set DBI_USER=*PostgreSQL username*
+  set DBI_PASS=*PostgreSQL password*
+  set POSTGRES_HOME=C:/PROGRA~1/PostgreSQL/8.3
+  set POSTGRES_INCLUDE=C:/PROGRA~1/PostgreSQL/8.3/include
+  set POSTGRES_LIB=C:/PROGRA~1/PostgreSQL/8.3/lib
+
+Note that the username and password are the ones for PostgreSQL, NOT the 
+ones for the Windows account that the PostgreSQL installer creates to run 
+the service safely.
+  
+(You may wish to set these variables on the system level, by going to
+Control Panel > System > Advanced tab > Environment Variables button and
+adding the environment variables there.)
+  
+Now the Makefile.PL can be ran:
+
+  perl Makefile.PL
+  dmake
+  dmake test
+  dmake install
 
 * SGI issues: