Dear friends,
This is an off-topic message about a new project called FreeOSZoo involving
two pgAdmin member, Jean-Michel and Raphaël.
You can visit our site on:
http://www.freeoszoo.org
We provide packages for QEMU, a fast PC emulator for GNU/Linux, Win32 and Mac
OS X. The packages and instru
Le jeudi 13 Mai 2004 04:42, Tom Lane a Ãcrit :
> I got tired of reading complaints about how upper/lower don't work with
> Unicode, so I went and prototyped a solution. ÂThe attached code uses
> the C99-standard functions mbstowcs and wcstombs to convert to and from
> a "wchar_t[]" representation t
Dear Tim,
These are execellent proposals. My only remark would be to build a
step-by-step approach.
In a first stage, we could set-up a minimal web page for the Win32 port:
- PostgreSQL Win32 installer (possibly translated),
- translation of the web page in 40 languages,
- step-by-step installat
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> My question is, "What can we learn from MySQL?" I don't know there is
> anything, but I think it makes sense to ask the question.
Dear Bruce,
Taking the example of pgAdmin III, which reached nearly one million hits in
December (http://www.pgadmin
Le Vendredi 23 Janvier 2004 03:08, Satoshi Nagayasu a écrit :
> If you want to install to your hard drive, KNOPPIX installation script
> can help you.
> However, I think "without any installation" is more important for
> newbies.
> Any comments?
Dear Satoshi,
Your Knoppix-based CD-ROM is a great
Dear friends,
In the past, there were several discussions in order to find suitable answers
for MS Windows users willing to install and run PostgreSQL.
Some of you suggested that users should "install GNU/Linux over Windows". Not
so easy for the basic MySQL or Ms Windows user, who need technica
Le Mardi 09 Décembre 2003 16:15, Ivelin Ivanov a écrit :
> I think that a co-bundle between an open source J2EE
> container like JBoss and a scalable database like
> PostgreSQL will be a blast.
Why not cut all trees on earth and replace them with plastic? Before that, we
need to port mankind DNA
Le Mardi 25 Novembre 2003 07:32, Randolf Richardson a Ãcrit :
> I'm curious, has anyone consulted with a lawyer on this?
Yes, the lawyer concluded that the number "2003" had been both registered as a
trademark and a patented invention. Therefore, it is very likely that
Humanity will be able to j
Le Jeudi 27 Novembre 2003 20:56, E.Rodichev a écrit :
> After installing 7.4 I created database completely from scratch
> with cyrillic locale:
Dear Evgeny,
If you want to go 'fast', do not hesitate to install pgAdmin3 GUI from
http://www.pgadmin.org. We will be able to create and manage a databa
Le Lundi 24 Novembre 2003 16:38, Andreas Pflug a Ãcrit :
> And a tiny correction: The farm member for win32 is my machine, and it's
> operated manually :-)
Some GNU/Linux farm animals are living in my garage running on very old 50
euros machines ... Ancient farming :-)
By the way, we would love
Le Vendredi 21 Novembre 2003 19:47, Tom Lane a Ãcrit :
> I think the main value of a build farm is that we'd get nearly immediate
> feedback about the majority of simple porting problems. ÂYour previous
> arguments that it wouldn't smoke everything out are certainly valid ---
> but we wouldn't aban
Le Mardi 18 Novembre 2003 20:22, ow a écrit :
> Not really. I simply think there are more pressing issues than win32 port.
Dear friends,
Porting to Win32 can multiply:
- direct users (i.e. developers) by a factor of two or three,
- indirect users by a larger factor, provided that major projects i
Le Mardi 18 Novembre 2003 06:21, Greg Stark a écrit :
> Oh, and yeah, a win32 port. Yay, another OS port. Postgres runs on dozens
> of OSes already. What's so exciting about one more? Even if it is a
> pathologically hard OS to port to. Just because it was hard doesn't mean
> it's useful.
Dear Gre
Dear friends,
Recently, several pgAdmin3 users complained about missing accentuated
characters. The problems mostly came from the ASCII database encoding, which
provides arbitrary storage of accentuated characters.
During installation of a Debian station, I noticed that the Debian
initialisati
Le Vendredi 14 Novembre 2003 10:19, Karel Zak a écrit :
> KDE project use XML docbook and I think they have same problems and
> maybe already solutions too :-)
> http://i18n.kde.org/translation-howto/doc-translation.html
> Karel
Dear Karel,
Nice link with detailed information.
This is a valid rea
Le Vendredi 14 Novembre 2003 09:26, Karel Zak a écrit :
> What use pure XML Docbook (non-SGML) for 7.5 PostgreSQL docs?
Dear Karel,
For information, how do you plan to translate XML Docbook format?
Is there an easy way to parse XML Docbook and import/export the text into
Gettext format? I was
Dear Jean-Paul,
> Please tell me if my experience can help you in any way, I'd be really
> glad in participating your project.
Thanks for your proposal, welcome in the team.
In short, we plan to port Compiere to PostgreSQL and submit the changes back
to Compiere team. There is no evidence so fa
Le Vendredi 17 Octobre 2003 16:32, Matthew T. O'Connor a écrit :
> This would be wonderful. However, I believe the guys at Compiere tried
> to do this already and gave up on porting it to postgresql due too a
> couple of PostgreSQL limitations. I don't remember what they are
> exactly, I think it
Dear friends,
I would like to port Compiere CRM from Oracle to PostgreSQL (and release it
for free).
At first I would like to convert the data schema. This is not difficult as
Compiere is written using portable types like NUMBER (i,d) which can be
replaced by NUMERIC (i,d), etc... A series of
Le Lundi 13 Octobre 2003 21:28, Dave Page a écrit :
> No more so than would be required under the Data Protection Act in the
> UK, but as the project and pgsql.com servers are neither in France or
> the UK, the content on them doesn't have to comply with those laws.
RedHat is a French company in F
Le Lundi 13 Octobre 2003 14:45, Robert Treat a écrit :
> Someone could have downloaded the package from sourceforge/freshmeat, so
> I don't think it hurts to have a pointer to postgresql.org. What might
> be better than a link for the submit page would just be a blurb
> mentioning we're always loo
French several years ago and noticed it was not an easy game.
We share the same ideas. Please refer to (CVS is down at the moment) :
http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/*checkout*/pgadmin3/docs/en_US/translation_guidelines.html
Any suggestion is welcome.
Cheers,
Je
t a big news? Just my 2 cents...
Best regards,
Jean-Michel POURE
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Le Mercredi 12 Février 2003 15:49, Merlin Moncure a écrit :
> I think there should be a special mailing list set up called
> pg-sql-win32-advocacy where people can continually harass the postgres
> dev team and debate the merits of the win32 operating system.
I realize my views about PostgreSQL
st as
links on the web page.
Just my 2 cents.
Best regards,
Jean-Michel POURE
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
mple: EUC_JP interface and
Latin1 databases.
Maybe a solution would be to use the ISO 10646 notation for PhpPgAdmin
interface localization: "&#XH;", where H is a hexadecimal number.
Cheers,
Jean-MIchel POURE
---(end of broadcast)---
T
Dear all,
We are working on PhpPgAdmin UTF-8 support. I would like to be able to view
UTF-8, ASCII and Latin1 databases in PhpPgAdmin without changing HTML header
encodings.
I guess this can be done using:
SET CLIENT_ENCODING='Unicode'
for all PhpPgAdmin connections.
My question are:
- Are so
Dear all,
Does psql support UTF-8 encoding?
>su postgres
>psql template1
>CREATE DATABASE foo_é WITH encoding = 'Unicode';
does not work.
It seems that Schema objects only accept ASCII letters.
Do I miss something?
Cheers,
Jean-Michel POURE
-
> I'm just curious: why do we need GBorg at all? Does it offer anything
> that SourceForge, or a similar service does not offer?
SAY NO TO SOURCEFORGE !
Please find enclosed some extracts from licensing terms
(http://sourceforge.net/tos/tos.php) :
a) Acceptance of Terms
"We reserve the right,
databases.
Cheers,
Jean-Michel POURE
---(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
Le Mardi 3 Septembre 2002 04:28, Gerhard Häring a écrit :
> PostgreSQL will have a
> native win32 port,
Just out of interest, what is the advancement of the Windows port.
Best regards, Jean-Michel
---(end of broadcast)---
TIP 3: if posting/reading
Le Dimanche 11 Août 2002 17:53, Tom Lane a écrit :
> Hmm. I remember Poure asking repeatedly for CREATE OR REPLACE VIEW,
> and that makes a lot of sense to me, because other things *can* depend
> on a view. (Unfortunately, by the same token it's a lot harder to do.)
> The use-case for replacing
Le Mercredi 31 Juillet 2002 05:50, Bruce Momjian a écrit :
> Here are the open items for 7.3. We have one more month to address them
> before beta.
Is CREATE OR REPLACE VIEW on the list?
---(end of broadcast)---
TIP 3: if posting/reading through U
Le Mercredi 31 Juillet 2002 05:50, Bruce Momjian a écrit :
> Source Code Changes
What about CREATE OR REPLACE VIEW which would be great for pgAdmin2. Thanks to
all of you./Jean-Michel POURE
---(end of broadcast)---
TIP 5: Have you checked
By the way, when will Dave be added to the main developper list? He wrote 99%
of pgAdmin on his own.
Cheers, Jean-Michel POURE
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
PLjava on
http://sourceforge.net/projects/pljava/
Cheers,
Jean-Michel POURE
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ten an ascii UTF-8 safe wrapper to ascii() function? If yes,
would you be so kind to publish this function on the list.
2) Are there plans to add an ascii() UTF-8 safe function to PostrgeSQL?
Best regards,
Jean-Michel POURE
---(end of broadcast)---
T
nese message
> );
Or just
CREATE table t1(
text_locale varchar,
text_content text
);
which is my case.
Just my 2 cents.
/Jean-Michel POURE
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
> Then what is the point?
We need more information about Cygwin. See Jason Tishler mail forwarded by
Dave Page.
> Don't get me wrong, I would love it if Windows were no longer around. I
> think a cygwin version of PostgreSQL will not further your objective.
> Windows users will not be seeing th
Le Vendredi 10 Mai 2002 15:33, mlw a écrit :
> The first time it doesn't work because of anti-virus software, they'll call
> it junk. When they test performance and see that it sucks, they'll remove
> the software.
Dear Mark,
PostgreSQL will work well if cygwin.dll is compiled in a separate work
Dear Mark,
Agreed except for paths (see below). But now that we agree, why not move to
Windows in three steps:
1) Release a minimal Cygwin + PostgreSQL installer,
2) Have 100.000 downloads or more Windows developpers,
3) Work as a team on a Windows port.
By the way : Cygwin accepts both Windows
Dear all,
Here is a copy of a mail received from
"Robert Collins" <[EMAIL PROTECTED]>.
Jean-Michel POURE
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 10, 2002 6:30 PM
>
> Does setup.exe support uninst
Le Vendredi 10 Mai 2002 14:06, mlw a écrit :
> Sorry, I'm not interested in a cygwin version of PostgreSQL. I think it
> will do more harm than good. If we make it something that people want to
> try, and then they TRY it, they will find that is sucks, then we lose. It
> is very hard to remove the
Le Vendredi 10 Mai 2002 13:13, mlw a écrit :
> I am starting to come to the conclusion that the PostgreSQL group is
> satisfied with cygwin, and the will to create a native Win32 version does
> not exist outside of a few organizations that are paying developers to
> create one.
The more important
1) Cygwin latest CVS installer version supports command lines.
2) Cygwin setup.exe is not needed. According to Robert Collins, an appropriate
setup.ini file can be used for automatic installation.
Cheers,
Jean-Michel POURE
---(end of broadcast
remaining is the installer. Is anyone interested in
helping me releasing a W32/Debian Cygwin package?
Cheers, Jean-Michel POURE
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Le Jeudi 9 Mai 2002 16:55, mlw a écrit :
> Can a cygwin version of PostgreSQL see the native file system, like: C:\My
> Database, D:\postgres?
You have the choice to keep Windows or Unix paths. Both are supported.
/Jean-Michel POURE
---(end of bro
ll speed-up your developements.
Do not hesitate to come back to us to tell if it solved your problem.
Cheers,
Jean-Michel POURE
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
l needs, because of open-source code, to have fun) ... and
ultimately it becomes a gift to Humanity.
My feeling is that the PostgreSQL community is making history without even
noticing it. You are all heroes my friends...
Cheers,
Jean-Michel POURE
---(end of broadca
Le Vendredi 3 Mai 2002 04:46, mlw a écrit :
> Corporate bullshit or not, it is a fact of life and a custom that we open
> source people need to accept. We write the best shit, we do the best work.
> We are "more professional" and dedicated than most professionals. Our
> quality is usually much bet
The PostgreSQL community is committed to creating and maintaining the best,
most reliable, open-source multi-purpose standards based database, and with
it, promote free(dom) and open source software world wide.
I hope you don't mind writing "free(dom)" with the idea of fighting patent
abuses.
C
Le Jeudi 2 Mai 2002 01:59, David Terrell a écrit :
> "Provide a really good database and have fun doing it"
PostgreSQL Community is commited to providing Humanity with the best
multi-purpose, reliable, open-source and free database system.
---(end of broadcast)--
e will still be
garbage on Sourceforge in a Google search.
Cheers,
Jean-Michel POURE
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Please disregard my last message which was intended for
[EMAIL PROTECTED]
Jean-Michel POURE
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Dear all,
Here are some issues:
1) PostgreSQL installer (wizard)
http://www.networksimplicity.com/openssh has released an OpenSSH minimal
Cygwin installer. They have had 300.000 tracked downloads so far. If true,
this numer is superior to Cygwin downloads itself.
The installer is incompatibl
, pgsql-general and pgadmin-hackers mailing lists.
Best regards,
Jean-Michel POURE
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Le Lundi 18 Mars 2002 13:23, mlw a écrit :
> Lets face it, MySQL wins a lot of people because they put in features that
> people want.
MySQL is very interested in benchmarks.
It does not really care for data consistency.
Cheers, Jean-Michel POURE
---(end of bro
stgreSQL running on an i586
with IDE drive beats MySQL on a double Pentium. In real life, applications
are always optimized at software level first before hardware level. This is
why PostsgreSQL is *by nature* better than MySQL.
Unless MySQL gets better, there is no real challenge in compari
At 17:09 28/10/01 +0200, you wrote:
>On Sun, Oct 28, 2001 at 02:34:49PM +0100, Jean-Michel POURE wrote:
> >
> > >psql uses your input literally - so is your console/xterm in
> > >UNICODE/UTF8?
> > Client: \encoding returns 'UNICODE'.
> > Server
>psql uses your input literally - so is your console/xterm in
>UNICODE/UTF8?
Client: \encoding returns 'UNICODE'.
Server: \list show databases. All databases are UNICODE (except TEMPLATE0
and TEMPLATE1 which are ASCII of course). I use a Mandrake 8.1 distribution
and think my console is UNICODE
UTF-8. It shows it is not a
back-end problem.
As for me, I typed INSERT INTO source_content VALUES ('Permis de conduire
accepté') in Psql.
Psql does not insert the data and I have to kill it manually. Can you
reproduce this?
Best regards,
Jean-Michel POURE
--
hould I define a *single* locale for postmaster?
Do I miss something?
Best regards,
Jean-Michel POURE
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that
urns the
record;
SELECT * FROM test WHERE source_content ILIKE '%accepté%' ---> returns nothing
SELECT * FROM test WHERE source_content ILIKE '%accepte%' ---> returns nothing
The same happens from ODBC, PHP and psql. Can you reproduce this?
I have tried
Best regards,
Jean-Michel POURE
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
> >CREATE OR DROP VIEW
>Is this for real? If I were a database server I would say to the
>client "please make up your mind" :-)
I meant DROP IF EXISTS and then CREATE.
This is more simple to implement than CREATE OR REPLACE.
Best regards,
Jean-Michel POURE
PostgreSQL, we will go for
pseudo-modification solutions (which is definitely not a good solution).
We are also waiting for a proper ALTER table DROP column but we are day
dreamers...
Thanks for your help and comprehension.
Best regards,
Jean-Michel POURE
pgAdmin team
>No argument here. But the proposed Oracle "packages" are something
>completely different and don't solve any of the problems you list.
Hello,
I agree packages are not designed primarily for library installation. I
also agree packages might need dependency checking. But packages can be
dumpe
>I think Jean-Michael's comments were right. While I'm not sure if things
>will be as overwhelming as he predicted, packages (even as implimented in
>my patch) will help people develop code libraries for PostgreSQL. And that
>will make PostgreSQL applications easier.
PostgreSQL is a fantastic to
possibility of defining
templates? Can this be added to packages in the future with little impact
on PostgreSQL internals?
Now, we can only thank you for bringing Packages to PostgreSQL.
Best regards,
Jean-Michel POURE
pgAdmin Team
---(end of broadcast)---
Windows users to install a language remotely on
a Linux box (no access to createlang and/or no knowledge of handlers). So
why not enable PL/pgSQL by default?
Best regards,
Jean-Michel POURE
---(end of broadcast)---
TIP 1: subscribe and unsubscribe
in pgAdmin II.
Is there any solution which preserves function OID?
Best regards,
Jean-Michel POURE
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hello friends,
int4eq (xid, int4) seems to be needed for proper support of MS Access2K:
CREATE FUNCTION "int4eq" (xid, int4)
RETURNS bool
AS 'int4eq'
LANGUAGE 'internal'
Is int4eq function included in PostgreSQL 7.2?
Regards,
Jean-Michel POURE
--
NAMES?
We need some advice:
1) Client solution: should we add the rebuilding feature to pgAdmin II?
2) Server solution: should we wait until the ALTER OBJECT project is complete?
Please advice. Help needed.
Vote for (1) or (2).
Regards,
Jean-Michel POURE
pgAdmin Team
http://pgadmin.post
Hello,
Are there built-in functions to convert UTF-8 string values into
hexadecimal \u and octal values and conversely?
If yes, can I parse any UTF-8 string safely with PL/pgSQL to return \u
and octal values?
Best regards,
Jean-Michel POURE
---(end of
NAMES?
We need some advice:
1) Client solution: should we add the rebuilding feature to pgAdmin II?
2) Server solution: should we wait until the ALTER OBJECT project is complete?
Please advice. Help needed.
Vote for (1) or (2).
Regards,
Jean-Michel POURE
pgAdmin Team
http://pgadmin.post
d.
Example: function pg_available_encodings -> SQL-ASCII;UNICODE;EUC-JP etc...
Thank you in advance,
Jean-Michel POURE
pgAdmin Team
http://pgadmin.postgresql.org
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Hello friends,
What is the best way to parse and store an XML document in PostgreSQL?
I would like to store fwbuilder (http://www.fwbuilder.org) objects in
PostgreSQL.
Any information is welcome.
Regards, Jean-Michel POURE
pgAdmin Development Team
---(end of
/pgadmin/cvs/cvs.php/pgadmin/help/todo.html
Before downloading pgAdmin from CVS, read this:
http://www.greatbridge.org/project/pgadmin/cvs/cvs.php/binaries/readme.html
We are looking for feedback and help from the community.
Greetings from Jean-Michel POURE, Paris, France
ld not wait too long. When will dependency tracking be available
server-side?
We are now working on more advanced features. See:
http://www.greatbridge.org/project/pgadmin/cvs/cvs.php/pgadmin/help/todo.html
Best regards,
Jean-Michel POURE
pgAdmin Development Team
LANGUAGE 'plpgsql'
Correct me if I am wrong:
It seems that a NULL value is not passed to the function ...
... or is it that a NULL value is not taken into account by PL/pgSQL.
Thank you all for the COALESCE trick.
Greetings from Jean-Michel POURE, Paris, France
pgAdmin development t
?
Regards,
Jean-Michel POURE, pgAdmin development team
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Also, try the other list: http://fts.postgresql.org/db/mw/ and choose
INTERFACE in LIST:all.
This will enable you to query the INTERFACE mailing list.
If you need a good administration and development software:
http://www.greatbridge.org/project/pgadmin/projdisplay.php
Greetings from Jean-Michel
writing PL/PgSQL Wait a few days before it is
ready...
Greetings from Jean-Michel POURE, Paris, France
At 12:24 09/05/01 +0200, you wrote:
>Hi all!
>
>I have to convert functions and procedures from Oracle to PostgreSQL. I
>looked at all the stuff of the Pg-Homepage and I ask me if t
llent tools for developers.
Greetings from Jean-Michel POURE, Paris, France
Axitrad, CEO
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
ults.
Any idea to run the 'SELECT INTO rec xxx, xxxx, xxx, xxx WHERE YY ilike
%$2%' ?
Is there a workaround like using a server-side function similar to
ilike(varchar, varchar)->boolean ?
Greeting from Jean-Michel POURE, Paris
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
tored in PgSchema as I don't know how to do it
with PostgreSQL itself.
Any possibility to embed it in PostgreSQL (remote call ???).
Looking forward to hearing from you,
Greetings from Jean-Michel POURE, Paris
---(end of broadcast)---
TIP 6: Have
Hello all,
Just to ask you if someone is planning to release beta 6 RPMs.
I am running Redhat 7.0 test servers and the compiler is broken.
Regards from Jean-Michel POURE, Paris
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go
86 matches
Mail list logo