Re: [GENERAL] Anyone has nls activated on Mac OS X?
Could you run through the make with -k and see what else might be missing the reference? OK. I ran through it again, doing a make clean beforehand (thanks John). The make -k and it still stalls at the same place: make -C ecpglib all gcc -no-cpp-precomp -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -bundle execute.o typename.o descriptor.o data.o error.o prepare.o memory.o connect.o misc.o -L../../../../src/port -L/sw/lib -L../pgtypeslib -lpgtypes -L../../../../src/interfaces/libpq -lpq -lm -o libecpg.so.4.1 ld: Undefined symbols: _bindtextdomain _dgettext make[4]: *** [libecpg.so.4.1] Error 1 make[4]: Target `all' not remade because of errors. make[3]: *** [all] Error 2 make[2]: *** [all] Error 2 make[1]: *** [all] Error 2 make: *** [all] Error 2 Any help will be greatly appreciated. --- Francois Home page: http://www.monpetitcoin.com/ "Would Descartes have programmed in Pascal?" - Umberto Eco ---(end of broadcast)--- TIP 8: explain analyze is your friend
[GENERAL] Anyone has nls activated on Mac OS X?
Hi all, I'm trying to compile PostgreSQL from scratch on Mac OS X 10.3.2 with national language support activated (so that I can work better on the French translation of PostgreSQL). Marc Liyanage's package doesn't have nls. I installed gettext using Fink and then gave it a go. The configure part went ok, but make complained that it couldn't find msgfmt. I downloaded Peter Eisentraut's package of utilities, but I can't get it to make. It complains as follows: Macbeth:~/Desktop/bsd-gettext-20011206 root# make make all-recursive Making all in sup /bin/sh ../libtool --mode=link gcc -g -O2 -o libsup.la rm -fr .libs/libsup.la .libs/libsup.* .libs/libsup.* ar cru .libs/libsup.a ar: no archive members specified usage: ar -d [-TLsv] archive file ... ar -m [-TLsv] archive file ... ar -m [-abiTLsv] position archive file ... ar -p [-TLsv] archive [file ...] ar -q [-cTLsv] archive file ... ar -r [-cuTLsv] archive file ... ar -r [-abciuTLsv] position archive file ... ar -t [-TLsv] archive [file ...] ar -x [-ouTLsv] archive [file ...] make[2]: *** [libsup.la] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive-am] Error 2 Thanks for any help. --- Francois Home page: http://www.monpetitcoin.com/ "Would Descartes have programmed in Pascal?" - Umberto Eco ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] Mailing list? was Postgress and MYSQL
why not use pgsql-chat, which isn't being used at all right now ... ? I would suggest that we consider forming a pgsql-competitive email list for Whatever, but using another mailing is definitely an excellent idea. I actually stopped reading -general recently because it got bogged down in yet another PostgreSQL vs MySQL debate. And the same happens to advocacy too, although less frequently. Then again this means that whoever moderates -general (is that you Marc?) would have to move PostgreSQL vs MySQL threads to the other mailing list whenever they crop up, otherwise any benefits will be lost. Cheers. --- Francois Home page: http://www.monpetitcoin.com/ "Would Descartes have programmed in Pascal?" - Umberto Eco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] Trouble with some concepts
Hi all, As announced previously I am currently working with other people on the translation of PostrgreSQL to French, applications and manuals. We have stumbled on a couple of concepts which are not very clear to us and thus do not know very well how to translate. Can someone explain the following: msgid "the target relation %u is nailed" One translator said that "nailed" was used for permanent network connection. Could this message mean that the relation is locked by a permanent connection to the database? msgid "improper qualified name (too many dotted names): %s" What's a qualified name? msgid "database name may not be qualified" Does this mean that the database with some given name cannot be found, or that the given name is not valid or something else entirely? msgid "" "cannot cluster on expressional index when index access method does not " "handle nulls" Is an expressional index an index built on a calculated field (say two concatenated field or whatever) or something else? Thanks for the help. --- Francois Home page: http://www.monpetitcoin.com/ "Would Descartes have programmed in Pascal?" - Umberto Eco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] 4D to PostgreSQL tools
Thanks. There is a connectivity tool, PostgreSQL for 4D, available from Exenevex at: http://www.exenevex.com/next/us/prod.php?id=9 Yes, I found that with google. What exactly are you having trouble with in doing the migration? I ask as the process is simple enough that a tool for doing the job is really not needed... I personally have no trouble, just forwarding a question. I think the person wanted to know if there was some tool where they could just take their 4D dump, transmogrify it to a PostgreSQL dump and voilà! But if you say that the process is simple enough that no tool is warranted, I consider that a valid answer and will pass it on. Thanks. Bye. --- Francois Home page: http://www.monpetitcoin.com/ "Would Descartes have programmed in Pascal?" - Umberto Eco ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] 4D to PostgreSQL tools
Hi all, Someone asked me today if there are tools to migrate a 4D database to PostgreSQL. Any clue? Some googling turned up a tool to go the other way round and the archives got me an unanswered post about migrating from 4D to PostgreSQL, so I guess there's not much chance... Cheers. --- Francois Home page: http://www.monpetitcoin.com/ "Would Descartes have programmed in Pascal?" - Umberto Eco ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] Visual database structure browser for postgresql?
I am looking for something like visual database structure browser. I need to see all tables and relations beetween them. Something like "Relations" window in Microsoft database products (ex. msaccess) Hi, Try dbVisualizer: http://www.minq.se/products/dbvis/ You can view the relations, but cannot save the view though (it's in the works apparently). Cheers. --- Francois Home page: http://www.monpetitcoin.com/ "Would Descartes have programmed in Pascal?" - Umberto Eco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Mailing list in French
Well, the idea of mailing list is to exchange information and help each other. Obviously if few great things happen on some mailing list and others don't come to know it, defeats the purpose of having a mailing list. I agree. This is one of my worries. If nothing happens on the French list, it will be an empty shell. Then again, there seems to be a demand for something not in English. So here goes and let's just hope it will work out. As an experiment can we have a translation gateway so that these two lists, in general and french-general can interact? I mean the idea should be to help people getting communicate better rather than having a separate list as such. That would be nice, but how could we go about that? Cheers --- Francois Home page: http://www.monpetitcoin.com/ "Would Descartes have programmed in Pascal?" - Umberto Eco ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] Mail server load
So far today:
neptune# awk '{print $7}' /var/log/amavisd | sort | uniq -c
137 BAD
1732 BANNED
4435 INFECTED
6029 Passed,
And still some make it through given some of the messages that are
reaching the list today ("That movie" or "My details"). :-(
---
Francois
Home page: http://www.monpetitcoin.com/
"Would Descartes have programmed in Pascal?" - Umberto Eco
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Mailing list in French
I'd be glad to join, but I couldn't find where or how to subscribe... It's not yet posted on the web site, but you can subscribe by sending a mail to [EMAIL PROTECTED], leave the subject line blank and put in the body "SUBSCRIBE pgsql-fr-generale". Bye --- Francois Home page: http://www.monpetitcoin.com/ "Would Descartes have programmed in Pascal?" - Umberto Eco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[GENERAL] PostgreSQL consulting company in France or Europe?
Hi All, Someone asked me via the advocacy site if there exists a company diffusing and offering support/consulting services for PostgreSQL in France, or more generally in Europe. Is there anything of the sort? This person is obviously interested in a commercial venture. Do you think there would be a market for this? Thanks in advance for any opinion. Cheers. Francois Home page: http://www.monpetitcoin.com/ "We waste our time spending money we don't have to buy things we don't need to impress people we don't like" ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] Optimisation, index use question [long]
> Standard issue. When you specify an unquoted number in a query it's > interpreted as an int4 which doesn't match your indexes. Suggestions are: > > - Put quotes around your numbers or eg. '1' > - Cast them to the right type eg. 1::bigint Huh, yeah, I remember now reading about this. Thanks a lot. Still any idea about why isn't it faster to query on the primary key than on the two foreign keys? Cheers Francois Home page: http://www.monpetitcoin.com/ "We waste our time spending money we don't have to buy things we don't need to impress people we don't like" ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
