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
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 that can
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
-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
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 way to
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 technical
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 to
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 jump
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
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 abandon
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 if
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
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 Greg,
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
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 reason
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 far
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 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 had
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 looking
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
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,
Jean-Michel POURE
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
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]
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
---(end of broadcast
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
.
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)---
TIP 6: Have you searched our list archives?
http
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, at
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 a
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
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 our
.
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
on
http://sourceforge.net/projects/pljava/
Cheers,
Jean-Michel POURE
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
() 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)---
TIP 1: subscribe and unsubscribe commands
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]
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
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 is
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
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 uninstalling just like rpm -e package
name does
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
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
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 broadcast
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
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 better
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 broadcast)---
TIP 1: subscribe
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.
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
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
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
-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 broadcast
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
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 comparing both systems.
Cheers,
Jean-Michel POURE
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.
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: \list show databases. All databases are UNICODE (except
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 your
message can
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
---(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
---(end
in 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
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 tool
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
dumped
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)---
TIP 3
for 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
/docs/faq.html
Hello,
Does CREATE OR REPLACE FUNCTION preserve function OID?
What it the difference with CREATE OR ALTER FUNCTION?
We would like to implement pseudo-editing of functions in pgAdmin II.
Is there any solution which preserves function OID?
Best regards,
Jean-Michel POURE
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
---(end of broadcast
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.postgresql.org
---(end of broadcast
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
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.postgresql.org
---(end of broadcast
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
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
---(end of broadcast
/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
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 team
---(end
, 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 POURE
for 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 there are any
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
on similar to
ilike(varchar, varchar)-boolean ?
Greeting from Jean-Michel POURE, Paris
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
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 you searched our list archives?
http
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
81 matches
Mail list logo