[GENERAL] PostgreSQL 8.2 beta 1 on Windows Vista RC1

Hello,   I install today the PG 8.2 beta1 on my Windows Vista RC1 Workstation : - No problem with the PGInstaller (The 8.1.4 have bugs), - No problem when reloading the data using command line psql, - First tests with my own application appear Ok... (but my production server stay on my LINUX

[GENERAL] PostgreSQL 8.1.4 on Vista RC1

I receive Windows Vista RC1 for testing, so I try to install PG 8.1.4.The installer fails : - On the creation of the user Postgres, - On the creation of the service. I found workaround for that : - I create manually the Postgres user with a password, - I install PG 8.1.4 WITHOUT creating th

Re: [GENERAL] SCSI disk: still the way to go?

Hello,   3 weeks ago I install a PostgreSQL 8.1.3 server on Windows 2003 server standar edition. The box is a NEC express5800 TM800 with 4 SATA/300 250 Gb 7200 rpm in RAID10 (0+1). It works fine, faster than the old server ALTOS with SCSI-3 disks Ultra160 1 rpm. I upgraded to 8.1.4. The e

[GENERAL] Couldn't create a database in PG 8.1.3 win32

Hello,   When I try to create a database with pgAdmin III I obtain : "An error as occured : Could not signal for checkpoint : no such process" What can I do ?   Best regards.   Luc BEGIN:VCARD VERSION:2.1 N:ROLLAND;Ets FN:Ets ROLLAND ORG:Ets ROLLAND TEL;WORK;VOICE:04 66 81 56 62 TEL;CELL;VOICE

[GENERAL] Pb d'installation de postgreSQL 8.1.3-1 win32

Hello !   I experience problem with PG 8.1.3 on an Win XP Pro box. PG hang on that box, I don't know why, I use PG 8 since 8.0 was available on Windows. So I uninstall PG 8.1.3 (I have a backup with pgAdmin3), and I try to reinstall PG 8.1.3, but the installation failed ! I redo after deleti

[GENERAL] Problem with PostgreSQL 8.1.3 on Windows XP Pro

Hello,   I have an XP Pro Box, 1 Go RAM, 160 Go HD, with PostgreSQL 8.1.3 win32. The service pgsql-8.1 appear to be started, but when I try to connect with PgAdmin III 1.4.1, it hangs and I need to terminate the program. The pg_log gave : 2006-02-28 15:36:52 LOG:  database system was shut do

[GENERAL] PG 8 stop working !?

Hello,   I've a development workstation using Win XP Pro SP2 with PostgreSQL 8.1 win32. This box use P4 3.2 Ghz, 1 Go RAM, 160 Go disk, no hardware problem detected. From several weeks PG seem to start (it appear as started in the services), but when I want to use PG it hangs in the connexio

Fw: [GENERAL] Connecting form Access or VB6 to PostgreSQL 8

Hello !   you have to configure : PostgreSQL 8 conf files on the server, Install psqlodbc on the client, and create an ODBC data system source for your data. In Access you have to link the PG tables.   Luc - Original Message - From: Aman Tur To: pgsql-general@postgresql.org

[GENERAL] Bad locking with MS-Access

Hello !   I made the port of an Access 2002 Database to PostgreSQL 8, it seems to work. I still use MS-Access 2002 for the application, using ODBC with linked tables.   For all the data created BEFORE the transfert to PostgreSQL, all works fine. For the records created SINCE this transfert, i

[GENERAL] Pb with boolean between MS-Access and PostgreSQl 8.0.3

Hello !   I use psql ODBC v.8.00.0101 with MS-Access 2002 under XP Pro. If I use a System Data Source configured with : Datasource using : - Bool AS Char, - True is -1. So Query with criteria "true" work but checked fields don't work !?   If Datasource use : - Bool NOT char, - True is -1. So

Re: **SPAM** Re: [GENERAL] Pb with linked tables on PG8

Many thanks for this very usefull information.   Luc - Original Message - From: Zlatko Matic To: Ets ROLLAND ; pgsql-general@postgresql.org Sent: Thursday, June 09, 2005 6:52 PM Subject: **SPAM** Re: [GENERAL] Pb with linked tables on PG8 Hello.   I

[GENERAL] Pb with linked tables on PG8

Hello !   I have an Access database using linked tables on PG 8.0.3 (on Windows 2003 server).I use pgODBC 8.00.01.01. Some tables appear like deleted !In Access I see : Categ : Tablevt_cat            vt_libcat #Supprimé    #Supprimé #Supprimé    #Supprimé #Supprimé    #Supprimé #Supprimé   

[GENERAL] Carriage return in text fields

Hello !   I have to transfert data from MS-Access to PostgreSQL 8.03 under Windows 2003 server. Text fields may contain a carriage return (CR-LF). I use the copy instruction. Under Pg-Admin III 1.21, I obtain an error message for that carriage return and a hint : use \n. If I use a filter on

Re: [GENERAL] MS-Access and Stored procedures

Many thanks to Philippe Lang and Hervé Inisan for all these very interseting  tips ! I've solved all my problems...   Best regards.   Luc - Original Message - From: Ets ROLLAND To: pgsql-general@postgresql.org Sent: Thursday, May 12, 2005 5:28 PM Su

[GENERAL] MS-Access and Stored procedures

Hello !   How can I use stored procedures (functions) with MS-Access 2002 connected to PostgreSQL 8.0 ?   Best regards.   Luc  

Re: [GENERAL] About ERROR: could not convert UTF-8 character 0x00e9

Hello ! I was out today ... In order to translate from heterogeneous Databases, you must have to change the client side encoding : I've done between an SCO UNIX 3.2 v4.2 using PROGRESS V6 and a Windows 2003 server using PostgreSQL 8.0. If you are using PGadmin 3 use : SET CLIENT_ENCODING TO 'xxx'