Re: [PATCHES] French translation updates for 8.0

2004-11-02 Thread Peter Eisentraut
Am Dienstag, 2. November 2004 00:33 schrieb Guillaume LELARGE:
 Here are all french .po files for 8.0 branch except postgres-fr.po. This
 one is still under heavy work.

 Please apply. Thanks.

Done.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [PATCHES] Translation updates for 8.0: libpq-ru, pg_ctl-ru, pg_dump-ru

2004-11-02 Thread Peter Eisentraut
Am Montag, 1. November 2004 22:09 schrieb Serguei Mokhov:
 Please intall the attached updates for 8.0. All fuzzy messages should be
 fixed in these.

Done.
-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])


Re: [PATCHES] [HACKERS] Open Items

2004-11-02 Thread Joshua D. Drake

It is my opinion that we should allow pg to run as Admin on Windows, at least 
with an override option. Services that run under a specified user are a headache
on Win32, because you need to store a password, and a lot of systems only have 
one user.
 

Well I don't know that I agree with this. Probably the biggest
problem with Windows is not Windows, it is lazy admins.
You either want to do it right, or you don't. Most Windows admins
just want it to work as quickly as possible, throwing caution and
and common sense to the wind.
And no, I am not a Windows hater, I am just someone who used to
make a lot of money fixing the mistakes of all those lazy admins.
Sincerely,
Joshua D. Drake

 

I have attached a patch that I think fixes this. The problem I saw 
and fixed is, that the shmem created in a terminal services client is not 
visible to the console (or services.msc).
 

The decision is simple. If we want the shmem to be global on the machine we need 
the patch. I think we want that, but can not give an authoritative answer.

 

I think in addition the system global name sharemem.1 should be made more 
pg specific, like PostgreSQL.1. I have not done this since a new compile 
would not detect a running old beta. But now would be the time (or never).
 

I think all agreed that this is good.
Andreas
---(end of broadcast)---
TIP 8: explain analyze is your friend
 


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
begin:vcard
fn:Joshua Drake
n:Drake;Joshua
org:Command Prompt, Inc.
adr:;;PO Box 215 ;Cascade Locks;OR;97014;US
email;internet:[EMAIL PROTECTED]
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
x-mozilla-html:FALSE
url:http://www.commandprompt.com
version:2.1
end:vcard


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


Re: [PATCHES] [HACKERS] Open Items

2004-11-02 Thread Zeugswetter Andreas DAZ SD

 o fix shared memory on Win2k terminal server
   
 We might be able to just mark this as not supported.

The shmem code works in a terminal server session with or without the patch.
Magnus had a different problem, probably permissions. Since I do not have a
non admin user (on a TS server) I disabled the win32_is_admin check.

It is my opinion that we should allow pg to run as Admin on Windows, at least 
with an override option. Services that run under a specified user are a headache
on Win32, because you need to store a password, and a lot of systems only have 
one user.

  I have attached a patch that I think fixes this. The problem I saw 
  and fixed is, that the shmem created in a terminal services client is not 
  visible to the console (or services.msc).

The decision is simple. If we want the shmem to be global on the machine we need 
the patch. I think we want that, but can not give an authoritative answer.

  I think in addition the system global name sharemem.1 should be made more 
  pg specific, like PostgreSQL.1. I have not done this since a new compile 
  would not detect a running old beta. But now would be the time (or never).

I think all agreed that this is good.

Andreas

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[PATCHES] don't create $DESTDIR/include/internal/lib

2004-11-02 Thread Neil Conway
Tom changed make install to no longer install dllist.h to
$DESTDIR/include/internal/lib, so AFAICS the lib/ subidrectory is no
longer used. This patch stops the Makefile from creating it during make
install.

Will apply to HEAD before end-of-day barring any objections.

-Neil

# Old manifest: 2f3c559fdce982241561a34407f8f220d7d24995
# New manifest: a8c6fcc946cd7b6b8caaa79de9a181c57755a6da
# Summary of changes:
# 
#   patch src/include/Makefile
#from 0a02bcd9d17092f499fd7fa439d830ff2419fa81
#  to 386c7c387231d8319d7a3eac3466ec45470c9742
# 
--- src/include/Makefile
+++ src/include/Makefile
@@ -46,7 +46,7 @@
 	done
 
 installdirs:
-	$(mkinstalldirs) $(DESTDIR)$(includedir)/libpq $(DESTDIR)$(includedir_internal)/libpq $(DESTDIR)$(includedir_internal)/lib
+	$(mkinstalldirs) $(DESTDIR)$(includedir)/libpq $(DESTDIR)$(includedir_internal)/libpq
 	$(mkinstalldirs) $(addprefix $(DESTDIR)$(includedir_server)/, $(SUBDIRS))
 
 

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])


[PATCHES] contrib build fixes

2004-11-02 Thread Neil Conway
Attached is a patch that makes some improvements to the contrib/ build.
Most of these are from the Debian folks:

- add some additional files to the dbmirror install (approved by
ssinger)

- add a makefile for contrib/mysql, and add mysql to the list of
contribs build by default

- use xml2-config to pickup -I flags for libxml2 in contrib/xml and
contrib/xml2

I'll apply this today or tomorrow, barring any objections.

-Neil

--- contrib/mysql/Makefile
+++ contrib/mysql/Makefile
@@ -0,0 +1,16 @@
+# mysql conversion Perl scripts
+# $PostgreSQL$
+
+MODULES = 
+SCRIPTS = my2pg.pl  mysql2pgsql
+DOCS = README.mysql
+
+ifdef USE_PGXS
+PGXS = $(shell pg_config --pgxs)
+include $(PGXS)
+else
+subdir = contrib/mysql
+top_builddir = ../..
+include $(top_builddir)/src/Makefile.global
+include $(top_srcdir)/contrib/contrib-global.mk
+endif
--- contrib/Makefile
+++ contrib/Makefile
@@ -22,6 +22,7 @@
 		lo		\
 		ltree		\
 		miscutil	\
+		mysql		\
 		noupdate	\
 		oid2name	\
 		pg_autovacuum	\
@@ -47,7 +48,6 @@
 #		ipc_check	\ (does not have a makefile)
 #		mSQL-interface	\ (requires msql installed)
 #		mac		\ (does not have a makefile)
-#		mysql		\ (does not have a makefile)
 #		oracle		\ (does not have a makefile)
 #		pg_upgrade	\ (does not have a makefile)
 #		reindexdb	\ (does not have a makefile)
--- contrib/dbmirror/Makefile
+++ contrib/dbmirror/Makefile
@@ -1,6 +1,8 @@
 # $PostgreSQL: pgsql/contrib/dbmirror/Makefile,v 1.3 2004/08/20 20:13:03 momjian Exp $
 
 MODULES = pending
+SCRIPTS = clean_pending.pl DBMirror.pl
+DATA = AddTrigger.sql MirrorSetup.sql slaveDatabase.conf
 DOCS = README.dbmirror
 
 ifdef USE_PGXS
--- contrib/mysql/mysql2pgsql
+++ contrib/mysql/mysql2pgsql
@@ -1 +1 @@
-# -*- perl -*-
+#!/usr/bin/perl
--- contrib/xml/Makefile
+++ contrib/xml/Makefile
@@ -1 +1 @@
-# $Header: /var/lib/cvs/pgsql/contrib/xml/Makefile,v 1.9 2004/08/20 20:13:10 momjian Exp $
+# $PostgreSQL$
@@ -6,6 +6,8 @@
 DATA_built = pgxml_dom.sql
 DOCS = README.xml
 
+override CFLAGS += $(shell xml2-config --cflags)
+
 ifdef USE_PGXS
 PGXS = $(shell pg_config --pgxs)
 include $(PGXS)
--- contrib/xml2/Makefile
+++ contrib/xml2/Makefile
@@ -11,6 +11,7 @@
 DATA_built = pgxml.sql
 DOCS = README.xml2
 
+override CFLAGS += $(shell xml2-config --cflags)
 
 ifdef USE_PGXS
 PGXS = $(shell pg_config --pgxs)

---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [PATCHES] don't create $DESTDIR/include/internal/lib

2004-11-02 Thread Neil Conway
On Wed, 2004-11-03 at 12:12, Neil Conway wrote:
 Tom changed make install to no longer install dllist.h to
 $DESTDIR/include/internal/lib, so AFAICS the lib/ subidrectory is no
 longer used. This patch stops the Makefile from creating it during make
 install.

Applied.

-Neil



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]