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

Specify your codepage : SET CLIENT_ENCODING TO 'LATIN1' ; SELECT * FROM table1 ; Your database woul be coded as LATIN1. Luc - Original Message - From: "Ying Lu" <[EMAIL PROTECTED]> To: Sent: Wednesday, April 13, 2005 5:49 PM Subject: [GENERAL] About ERROR: could not convert UTF-8 characte

[GENERAL] Localization problems between Access and PostgresSQL 8

Hello, I've dumped the content of MS-Access 2002 SP3 tables on a PC with Windows XP Pro in French localization.Then I COPY these files, on the same PC hosting an PostgreSQL 8.0.1 database.I've problems with the accents !? Why ? What kind of encoding must I use to create the PG database under

[GENERAL] Localization problems between Access and PostgresSQL 8

Hello, I've dumped the content of MS-Access 2002 SP3 tables on a PC with Windows XP Pro in French localization.Then I COPY these files, on the same PC hosting an PostgreSQL 8.0.1 database.I've problems with the accents !? Why ? What kind of encoding must I use to create the PG database unde

Re: [GENERAL] Update rule

déric Caillaud" <[EMAIL PROTECTED]> To: "Secrétariat" <[EMAIL PROTECTED]>; Sent: Thursday, December 30, 2004 7:08 PM Subject: Re: [GENERAL] Update rule You get infinite recursion because your ON UPDATE rule does another UPDATE which of course calls the rule ; so no, it

[GENERAL] Update rule

Hello !   I wish to create a rule to write in records who and when modified them. I wrote : CREATE OR REPLACE RULE tarif_upd AS   ON UPDATE TO tarifs   DO ALSO   UPDATE tarifs    SET dmodtar = current_date, umodtar = current_user  WHERE dmodtar <> current_date AND umodtar

[GENERAL] Delete function

Hello !   I create a delete function : CREATE FUNCTION delalpha(varchar, integer) RETURNS boolean    AS 'DELETE FROM public.params WHERE soc = $1 AND numpar = $2 ;  SELECT  TRUE ;'    LANGUAGE sql ;Is there a way to return the number of deleted row ? Thanks.   Luc

Re: [GENERAL] PostegreSQL 8.0.0 Beta4 Win32

ed). - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Secrétariat" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, November 19, 2004 5:02 PM Subject: Re: [GENERAL] PostegreSQL 8.0.0 Beta4 Win32 =?iso-8859-1?Q?Secr=E9tariat?= <

[GENERAL] PostegreSQL 8.0.0 Beta4 Win32

Hello !   The RC2 is great but : I use an other filesystem for the data. So I have C:\Program file\PostgreSQL... and I have F:\PostgreSQL\8.0.0-beta4\data.   In the file C:\Program Files\PostgreSQL\8.0.0-beta4\data\postgresql.conf I modify the files locations : data_directory = 'F:/PostgreS

Re: [GENERAL] RAD with postgreSQL

You have also RealBasic, with cross-platform to Windows, Mac and linux... Luc - Original Message - From: "Eric" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, September 05, 2004 8:48 PM Subject: [GENERAL] RAD with postgreSQL > Hi, > > Any suggestion to Rapid Application Dev w

[GENERAL] PL-PGSQL language

Hello !   I use PostgreSQL 7.4.5-1mdk on an Mandrake Linux 10.0 server. I've installed libpq3, postgresql, postgresql-server and postgresql-docs for that version. I've restarted my server. My database works correctly, but I can't install the PL-PGSQL.I can't find the librairy plpgsql.so on my

Re: [GENERAL] No connection to a PG 8.0 Beta 1 win32 server

I see in the log file that parameter "tcpip_socket" was invalid, but how can I connect my W2k client with pgAdmin III to my XP Pro server using Beta1 ? Is the Beta1 à standalone version ? regards, luc. > Tom Lane write : > No, it's easier than that: there is no "tcpip_socket" parameter anymore, >

[GENERAL] Connection to a PG 8.0 Beta 1 win32 server

Hello !   I've installed the Beta 1 on Win XP Pro, it seem working correctly. I load a database from Linux 7.4.3 with pgdumpall, it works too. But I can't connect from other PC over the LAN (I modified pg_hba.conf for the hosts). If I write in postgresql.conf : tcpip_socket = true port = 54

[GENERAL] Stored procedures

Hello ! My ODBC driver in MS Visual Basic 6 refers also to "Stored procedures" as Record source. What are these stored procedures, I don't find anything in the 7.4 documentation, Where can I find documentation ? Many thanks. Luc

Re: [GENERAL] pg_hba.conf changes without restarting postmaster

If you launch your progress server at startup (in init.d), you only have to type : # service postgresql reload It works fine. Luc - Original Message - From: "Christopher Browne" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 31, 2004 3:09 AM Subject: Re: [GENERAL] pg_hba

[GENERAL] Using view

Hello ! Why can't I update data when I use a VIEW instead of a TABLE ?How can I do similar action ? Thanks. Luc  

Re: [GENERAL] Connexion to Postgresql using TCP/IP

- Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Secrétariat" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, July 23, 2004 4:33 PM Subject: Re: [GENERAL] Connexion to Postgresql using TCP/IP > =?iso-8859-1?Q?Secr=E9taria