Hello,
I've dumped the content of MS-Access 2002
SP3tables 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
Hello,
I've dumped the content of MS-Access 2002
SP3tables 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
Hello !
I wish to create a rule towrite
inrecords 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_userWHERE dmodtar
current_date AND umodtar current_user ;But I obtain an
Hello !
I createa 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
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 =
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?= [EMAIL PROTECTED] writes:
The file F:\PostgreSQL\8.0.0-beta4\data
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
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 with
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,
so
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 =
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.conf
Hello !
My ODBC driver in MS Visual Basic 6 refers also to
"Stored procedures" asRecord source.
What are these stored procedures, I don't find
anything in the 7.4 documentation,
Where can I find documentation ?
Many thanks.
Luc
Hello !
Why can't I update data when I use a VIEW instead
of a TABLE ?How can I do similar action ?
Thanks.
Luc
- 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=E9tariat?= [EMAIL PROTECTED] writes:
I use a PostgreSQL
14 matches
Mail list logo