[pgadmin-hackers] pgAdmin standard short description

2003-11-30 Thread Andrej Surkov

 Dear Jean-Michel!

 Your proposal description is very good but one point: not everybody knows what is 
PostgreSQL. If we add "wellknown PostgreSQL database server" our description become 
more complete and self-contained. Corrected standard description text then will be:

"pgAdmin is a free 
software offering a complete set of administration and 
development tools for wellknown PostgreSQL database server. 
The software offers a very 
intuitive graphical interface running under multiple 
platforms including MS Windows, GNU/Linux and FreeBSD. 
pgAdmin Project is a collaborative project including hundreds 
of volunteers."

 Another note - "PostgreSQL database server, which is free also." - maybe useful too, 
but is not critical.
 I think that we have to put the description on the main page of pgadmin.org. It will 
never bother a hacker or advanced user but will be very helpful to newbies visiting 
pgAdmin website. We can add another subsection to main page, say "What is pgAdmin?" or 
"About pgAdmin", between "Latest news" and "Features" subsections.
 What will you say about it?

cheers, Andrej


>> -Original Message-
>> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] 
>> Sent: 29 November 2003 21:42
>> To: [EMAIL PROTECTED]
>> Cc: [EMAIL PROTECTED]
>> Subject: Re: [pgadmin-hackers] pgAdmin web site translated 
>> into 11 languages
>> 
>> Le Samedi 29 Novembre 2003 15:30, Andrej Surkov a йcrit :
>> > I have registered pgAdmin web site on russian search engine and 
>> > realizes that there is no direct description of the 
>> software on the site main page.
>> > I think it is not correct and short description in few sentences 
>> > should be published. That's just good style for respectable 
>> software 
>> > and its presentation website. What do you think about it?
>> 
>> Dear Andrej,
>> 
>> You are right. It would be nice to agree on a "standard" 
>> description of
>> pgAdmin3 in a few sentences, for translation and registration 
>> on web search engines. 
>> 
>> [Technically, we could store these sentences in the META 
>> information of the web site and extract them to the 
>> pgadmin_wesite.pot file for translation.]
>> 
>> A possible proposal:
>> 
>> "pgAdmin is a free 
>> software offering a complete set of administration and 
>> development tools for PostgreSQL. The software offers a very 
>> intuitive graphical interface running under multiple 
>> platforms including MS Windows, GNU/Linux and FreeBSD. 
>> pgAdmin Project is a collaborative project including hundreds 
>> of volunteers."
>
>Not sure about that. 'complete set' implies more than one program which there isn't. 
>Also, 'hundreds' is a little one the high side...
>
>Oh, and I object to GNU/Linux.
>
>> Can we all discuss a standard text? We should be quite 
>> carefull as the text could be publised on dozen of sites. I 
>> will be away for the week-end.
>
>We never had a standard desription before, but do have a tagline - for pga2 it was: 
>
>pgAdmin II: PostgreSQL Tools for Windows.
>
>Which I then shortened to:
>
>pgAdmin III: PostgreSQL Tools
>
>In addition, I always try to standardise the capitalisation of pgAdmin.
>
>Regards, Dave.



---(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


[pgadmin-hackers] pgadmin3 1.0.2 and wxGTK rpms for FC1 are ready.

2003-11-30 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1


Hi,

I've build FC1 rpms for pgadmin-1.0.2, wxwindows 2.5-20031010-7 and
uploaded them.

They are on ftp.PostgreSQL.org. They'll be at the nearest mirror after 
sync.

Regards,
- -- 
Devrim GUNDUZ
[EMAIL PROTECTED]   [EMAIL PROTECTED] 
http://www.TDMSoft.com
http://www.gunduz.org
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE/ycpZtl86P3SPfQ4RAvmQAKDoTsCwHdGmnv0V5q4ehBbY0K/0QQCdEGjI
jXgh1jFA/gzsuwAG6YakSkk=
=MGNg
-END PGP SIGNATURE-


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


Re: [pgadmin-hackers] Error message while connecting to a UNICODE

2003-11-30 Thread Andreas Pflug
Raphaël Enrici wrote:

And here is pgadmin3 log file:
2003-11-26 19:25:37 INFO   : Destroying a connect dialogue
2003-11-26 19:25:37 STATUS : Connecting to database...
2003-11-26 19:25:37 INFO   : Creating pgConn object
2003-11-26 19:25:37 INFO   : Server name: 192.169.0.254 (resolved 
to: 192.169.0.254)
2003-11-26 19:25:37 INFO   : Opening connection with connection 
string: hostaddr='192.169.0.254' dbname='template1' user='xxx' 
password='yyy' port=5432
2003-11-26 19:25:37 QUERY  : Set query (192.169.0.254:5432): SELECT 
pg_encoding_to_char(encoding) AS encoding, datlastsysoid
 FROM pg_database WHERE datname='template1'
2003-11-26 19:25:37 INFO   : Creating pgSet object
2003-11-26 19:25:37 INFO   : Setting client_encoding to 'UNICODE'
2003-11-26 19:25:37 ERROR  : 
?T 


Sorry to come back on this so late.

Seems as if a message box is to be displayed, but the error string is 
corrupted, so pango will hickup.
The message originates from the pgConn ctor (line 163), where the 
conversion from UTF8 to wchar_t is missing.
Corrected in cvs, can you verify that your problem's gone?

Regards,
Andreas


---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org


Re: [pgadmin-hackers] v1.0.2 Build

2003-11-30 Thread Raphaël Enrici
Dave Page wrote:



 

-Original Message-
From: Raphaël Enrici [mailto:[EMAIL PROTECTED] 
Sent: 29 November 2003 20:15
To: Dave Page
Cc: [EMAIL PROTECTED]
Subject: Re: [pgadmin-hackers] v1.0.2 Build

Hi all,

debian packages upload in progress :)
   

Thanks :-) BTW, I stripped out all the non-debian snapshots the other day. Can you try to keep it down to a week or so's worth please (assuming you're not already)?
 

Done. I did a backup on my disc before, but, I think it's a good idea. I 
now purge all files older than 7 days in the debian snapshot directory.

Regards,
Raphaël
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[pgadmin-hackers] debian package patch

2003-11-30 Thread Raphaël Enrici
Dear all,

here is a patch for pkg/debian tree in cvs:
- adds support for the .desktop file.
- adds entries that were done in 1.0.2 maintenance update to the 
debian/changelog.
- corrects the wx build dependencies

I hope to produce another patch soon including the "one shot package" 
which should become the official package for debian

If someone can apply it to cvs... :)

Regards,
Raphaël.
diff -ru pkg.orig/debian/changelog pkg/debian/changelog
--- pkg.orig/debian/changelog   Fri Sep  5 09:28:33 2003
+++ pkg/debian/changelogSun Nov 30 17:15:59 2003
@@ -1,3 +1,23 @@
+pgadmin3 (1.0.2-0.1) unstable; urgency=low
+
+  * Second maintenance update.
+  * Added desktop file
+
+ -- Raphael Enrici <[EMAIL PROTECTED]>  Sat, 29 Nov 2003 18:06:42 +
+
+pgadmin3 (1.0.1-0.1) unstable; urgency=low
+
+  * First maintenance update.
+  * SSL support should be ok
+
+ -- Raphael Enrici <[EMAIL PROTECTED]>  Sat, 18 Oct 2003 09:27:12 +
+
+pgadmin3 (1.0.0-0.1) unstable; urgency=low
+
+  * First stable release.
+
+ -- Raphael Enrici <[EMAIL PROTECTED]>  Fri, 26 Sep 2003 20:43:49 +
+
 pgadmin3 (0.9.2-0.0) unstable; urgency=low
 
   * Second BETA Release.
diff -ru pkg.orig/debian/control pkg/debian/control
--- pkg.orig/debian/control Fri Sep  5 09:28:33 2003
+++ pkg/debian/control  Sun Nov 30 17:15:59 2003
@@ -2,7 +2,7 @@
 Section: misc
 Priority: optional
 Maintainer: pgAdmin project <[EMAIL PROTECTED]>
-Build-Depends: debhelper (>> 3.0.0), postgresql-dev, pgadmin3-libwxgtk2ud2.5-dev (>= 
2.5.0-0.0+cvs20030831.1), pgadmin3-libwxgtk2ud2.5-contrib (>= 2.5.0-0.0+cvs20030831.1)
+Build-Depends: debhelper (>> 3.0.0), postgresql-dev, pgadmin3-libwxgtk2ud2.5-dev (>= 
2.5.0-0.0+cvs20031010.7), pgadmin3-libwxgtk2ud2.5-contrib (>= 2.5.0-0.0+cvs20031010.7)
 Standards-Version: 3.5.2
 
 Package: pgadmin3
diff -ru pkg.orig/debian/dirs pkg/debian/dirs
--- pkg.orig/debian/dirsFri Sep  5 09:28:33 2003
+++ pkg/debian/dirs Sun Nov 30 17:15:59 2003
@@ -1,3 +1,4 @@
 usr/bin
 usr/sbin
 usr/share/pixmaps
+usr/share/applications
diff -ru pkg.orig/debian/rules pkg/debian/rules
--- pkg.orig/debian/rules   Fri Sep  5 09:28:33 2003
+++ pkg/debian/rulesSun Nov 30 17:16:00 2003
@@ -59,7 +59,7 @@
dh_testdir
 
# Add here commands to compile the package.
-   $(MAKE)
+   $(MAKE) WX_HOME=/usr
#/usr/bin/docbook-to-man debian/pgadmin3.sgml > pgadmin3.1
 
touch build-stamp
@@ -90,7 +90,19 @@
# Add here commands to install the package into debian/pgadmin3.
$(MAKE) install prefix=$(CURDIR)/debian/pgadmin3/usr
cp $(CURDIR)/src/include/images/elephant48.xpm 
$(CURDIR)/debian/pgadmin3/usr/share/pixmaps/pgadmin3.xpm
+   cp $(CURDIR)/src/include/images/elephant48.xpm 
$(CURDIR)/debian/pgadmin3/usr/share/pgadmin3/pgadmin3.xpm
chmod 644 $(CURDIR)/debian/pgadmin3/usr/share/pixmaps/pgadmin3.xpm
+   chmod 644 $(CURDIR)/debian/pgadmin3/usr/share/pgadmin3/pgadmin3.xpm
+   #
+   # desktop files
+   # TODO:
+   # May be we should use desktop-file-install but it does not exist in woody...
+   # 
+   cp $(CURDIR)/pkg/pgadmin3.desktop 
$(CURDIR)/debian/pgadmin3/usr/share/applications/.
+   chmod 644 $(CURDIR)/debian/pgadmin3/usr/share/applications/pgadmin3.desktop
+   #
+   # Avoid dpkg-buildpackage errors
+   #
touch TODO.txt  # To avoid error while building package if this file does not 
exist
 
 

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


[pgadmin-hackers] Microsoft installer

2003-11-30 Thread Andreas Pflug
Hi Dave,

right before the first pgadmin3 release, we were discussing about how to 
distribute the win32 version. You stated it should be a MSI package, and 
claimed to do that. Apparently, you don't find the time, and I don't 
have the tools to do it.

I've been creating a NSIS project (nsis.sourceforge.net), using the 
current NSIS 2.0B4.

IMHO instead of having an ugly zip file, we should use NSIS as long 
there's no better solution available. Checked in for cvs head, but works 
with 1.0.2 trunk too.

Regards,
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


Re: [pgadmin-hackers] Microsoft installer

2003-11-30 Thread Dave Page
 

> -Original Message-
> From: Andreas Pflug [mailto:[EMAIL PROTECTED] 
> Sent: 30 November 2003 20:02
> To: Dave Page
> Cc: pgadmin-hackers
> Subject: Microsoft installer
> 
> Hi Dave,
> 
> right before the first pgadmin3 release, we were discussing 
> about how to distribute the win32 version. You stated it 
> should be a MSI package, and claimed to do that. Apparently, 
> you don't find the time, and I don't have the tools to do it.

Huh? It is an MSI file. What did you think I've been distributing?

The project file is in pkg/win32.

Regards Dave.



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


Re: [pgadmin-hackers] debian package patch

2003-11-30 Thread Dave Page
Sorry, maybe it's late, but which branch am I applying this to - 1.0.2 or 1.1.0?

Regards, Dave. 

> -Original Message-
> From: Raphaël Enrici [mailto:[EMAIL PROTECTED] 
> Sent: 30 November 2003 16:23
> To: pgadmin-hackers
> Subject: [pgadmin-hackers] debian package patch
> 
> Dear all,
> 
> here is a patch for pkg/debian tree in cvs:
> - adds support for the .desktop file.
> - adds entries that were done in 1.0.2 maintenance update to 
> the debian/changelog.
> - corrects the wx build dependencies
> 
> I hope to produce another patch soon including the "one shot package" 
> which should become the official package for debian
> 
> If someone can apply it to cvs... :)
> 
> Regards,
> Raphaël.
> 

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [pgadmin-hackers] debian package patch

2003-11-30 Thread Raphaël Enrici
Dave Page wrote:

Sorry, maybe it's late, but which branch am I applying this to - 1.0.2 or 1.1.0?
 

Hi Dave,
sorry I didn't tell it.
It would be nice if you could apply them to both branches: 1.0.2 in case 
we produce a 1.0.3 and 1.1.0 because that's what they were designed for.

Regards,
Raphaël
Regards, Dave. 

 

-Original Message-
From: Raphaël Enrici [mailto:[EMAIL PROTECTED] 
Sent: 30 November 2003 16:23
To: pgadmin-hackers
Subject: [pgadmin-hackers] debian package patch

Dear all,

here is a patch for pkg/debian tree in cvs:
- adds support for the .desktop file.
- adds entries that were done in 1.0.2 maintenance update to 
the debian/changelog.
- corrects the wx build dependencies

I hope to produce another patch soon including the "one shot package" 
which should become the official package for debian

If someone can apply it to cvs... :)

Regards,
Raphaël.
   

 



---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faqs/FAQ.html


Re: [pgadmin-hackers] Microsoft installer

2003-11-30 Thread Andreas Pflug
Dave Page wrote:





Huh? It is an MSI file. What did you think I've been distributing?

The project file is in pkg/win32.
 

I can see it in cvs, but there are only *.zip files under release/win32!

Regards,
Andreas


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