Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?

on't want to press for changing it right now because I'm not particularly bothered by it, and the second sentence of the previous paragraph might just be true. In a future life, a privilege system should give finer grained control about access to PLs, but we might want to think about wh

Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?

Jean-Michel POURE writes: > It is sometimes tricky for Windows users to install a language remotely on > a Linux box (no access to createlang and/or no knowledge of handlers). Why not run createlang on the host that the server runs on? -- Peter Eisentraut [EMAIL PROTECTED]

Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER

whose error codes you ignore. > That way if you see an error, you know you need to do something about it. Technically, it's not an error, it's an "exception condition". This might make you feel better when consciously ignoring it. ;-) -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter

[pgadmin-hackers] Creation of XPM files for wxWidgets

I'm trying to play a little with the standard icon set included in pgAdmin. I've found out that wxWidgets expects a certain variation of the XPM image format that is output by ImageMagick (e.g., the "_xpm" ending in the variable). Does anyone have a conversion script or other way to create thi

Re: [pgadmin-hackers] [Fwd: Re: Bug#245310: pgadmin3-data: pgadmin3 ships duplicate of PostgreSQL]

Dave Page wrote: > BTW, as the local DocBook expert (iirc) if you have any ideas about > how these files could be autogenerated from the SGML source, I'd love > to hear them. This is probably what you want: http://www.dpawson.co.uk/docbook/styling/htmlhelp.html http://docbook.sourceforge.net/rele

Re: [pgadmin-hackers] [Fwd: Re: Bug#245310: pgadmin3-data: pgadmin3 ships duplicate of PostgreSQL]

Am Freitag, 23. April 2004 09:32 schrieb Dave Page: > These files are currently built using the Microsoft HTML Help workshop, If these files cannot be rebuilt using free tools, then they need to be removed from the Debian package. ---(end of broadcast)---

Re: [pgadmin-hackers] [Fwd: Re: Bug#245310: pgadmin3-data: pgadmin3 ships duplicate of PostgreSQL]

Am Freitag, 23. April 2004 11:10 schrieb Dave Page: > The HTML Help Workshop is a free download, but they can be written in vi if > you feel the need - personally I'd rather use the MS program and save a day > or three. I had meant "free" to mean in compliance with the Debian Free Software Guidel

[pgadmin-hackers] Smoother PostgreSQL icons

I noticed that the included PostgreSQL elephant icons (that are used by some packages to create menu entries and so on) are kind of boxy: elephant48.xpm, pgAdmin3.ico, pgAdmin3.xpm. I've created some new ones from the master source in .ai format: http://www.credativ.com/~pei/pgadmin-icons/. Yo

Re: [pgadmin-hackers] Creation of XPM files for wxWidgets

Am Sunday 25 April 2004 19:09 schrieb Andreas Pflug: > IMHO the current icons are not really first choice, and I'd like to > reduce the main toolbar size from 32x32 icons to 16x16 either to save > space (some more opinions about this, guys?). Good idea (looks more consistent with other application

Re: [pgadmin-hackers] Smoother PostgreSQL icons

Andreas Pflug wrote: > These images look better on a white background, unfortunately on a > colored background (e.g. win32 desktop) the smoothing algorithm > causes an ugly white edge. This problem was the reason why I made > them full-color. With smoothing, a gradual transparency would be > needed

Re: [pgadmin-hackers] Next release

Andreas Pflug wrote: > Peter, how is the status of the new fancy icons you've been talking > about some time ago? The icons are available; they are from the KDE icon set. But to use them you should really have support for PNG with transparency. Also, I don't suppose you want to make them the d

Re: [pgadmin-hackers] 8.0 doc

Andreas Pflug wrote: > again we have a bunch of doc changes, and I'm quite tired manually > adding them to pgadmin3.hhc again and again (apart from that being > quite error-prone). We really should have it generated from sgml. > I'm completely unfamiliar with jade, and there's a lot of other stuff

[pgadmin-hackers] Fixed German tips

Here is an update of the German tips file which brings the text closer to actual German. -- Peter Eisentraut http://developer.postgresql.org/~petere/ # To add a new tip, just add a new line to this file. # Blank lines are ignored, lines starting with # are comments. PostgreSQLs Performance

[pgadmin-hackers] pg_autovacuum vs autovacuum

The autovacuum feature in PostgreSQL 8.1 is called "autovacuum", not "pg_autovacuum", as pgAdmin makes one believe. To make the terminology consistent, I propose the following small patch. -- Peter Eisentraut http://developer.postgresql.org/~petere/ Index: src/f

[pgadmin-hackers] Sort encoding names

In the dialog for creating a new database, could you sort the encoding names alphabetically? They are currently sorted by internal number, which doesn't necessarily make sense to the user. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(e

[pgadmin-hackers] Default encoding for new databases

that it matches the initialized locale. This is how the command line works. Other combinations will lead to databases with unusable sorting behavior. Please correct that. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broa

[pgadmin-hackers] Client-side password encryption

code shows that you are also affected by this issue. I ask you to check where you paste cleartext passwords into SQL commands and change those to encrypt the password before sending or storing it anywhere. The required function pg_md5_encrypt() is contained in libpq. -- Peter Eisen

Re: [pgadmin-hackers] Client-side password encryption

The officially sanctioned function for this is now PQencryptPassword() in libpq. Please consider using it when available. I wrote: > Commands like CREATE USER foo PASSWORD 'bar' transmit the password in > cleartext and possibly save the password in various client or server > log files. I have j

Re: [pgadmin-hackers] Client-side password encryption

Am Donnerstag, 5. Januar 2006 12:40 schrieb Andreas Pflug: > Ok, we'll use it ASAP. But how to detect if it's available or not? Some > #define PQENCRYPT_AVAILABLE 1 would be helpful. Just use AC_CHECK_FUNCS(PQencryptPassword) and you will get a definition like that. ---(

[pgadmin-hackers] Menu items beautification

I've gone through the menu items in the main menu and the pop-up menus and fixed them up for ellipses ("...") where the menu item is followed up by a dialog window, and for consistent capitalization (title case). Please take the attached patch into consideration. -- Peter

[pgadmin-hackers] Please include NEWS or changelog in the package

During Debian packaging of pgAdmin III it come up that the distributed package contains no changelog, news, or history information that would allow users to see why they might want to upgrade. Something like should be fine if you put it into a NEWS file. Alte

[pgadmin-hackers] Data type display

es are at the end. Perhaps, as an interface improvement, remove all the array types from the list but instead make a separate checkbox "Array" instead. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)---

[pgadmin-hackers] SQL display of inheriting tables wrong

ns are merged), executing this and redumping it with pg_dump produces this: CREATE TABLE emp ( name text, age integer, "location" point, salary integer, manager name ) INHERITS (person); which is not the same we started out with. I'm not exactly sure what is

[pgadmin-hackers] pgAdmin server properties dialog

me: Password: Store Password: Maintenance DB: Service(?): Connection Now: I would also welcome as a click-saving measure that "Connection Now" be transformed into a button. So replace the OK buttong by, say, "Save" and "Save and Connect". -- Peter Eisentraut http://dev

[pgadmin-hackers] localpipe

(_("%s on "), dbname.c_str()); +str.Printf(_("%s on local socket"), dbname.c_str()); else str.Printf(_("%s on %s:%d"), dbname.c_str(), dbHost.c_str(), GetPort()); return str; -- Peter Eisentraut http://developer.postgresql.org/~petere/

Re: [pgadmin-hackers] pgAdmin server properties dialog

the right term. Maybe "operating system service" would be clearer but it's way too long. > Connect now is the default option, and I think it's almost certainly the > most common case so in most cases it shouldn't cause any extra clicks.

[pgadmin-hackers] German translation

I went through the German translation and removed some excessive anglicisms and made some other corrections. -- Peter Eisentraut http://developer.postgresql.org/~petere/ pgadmin-de_DE-po.diff.bz2 Description: BZip2 compressed data ---(end of broadcast

Re: [pgadmin-hackers] localpipe

ing process, which is the distinguishing characteristic between a pipe and a socket. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [pgadmin-hackers] German translation

7;t have much weight anyway. That said, I will gladly refer you to German database literature, which I regularly use as reference for translations. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)

[pgadmin-hackers] pgadmin.log

Could you rename pgadmin.log to .pgadmin.log on Unix systems? It's quite annoying to have this file reappearing all the time in the home directory. Other programs hide their per-user log files as well. -- Peter Eisentraut http://developer.postgresql.org/~p

Re: [pgadmin-hackers] pgadmin.log

Am Montag, 27. März 2006 16:17 schrieb Dave Page: > > It's not configurable? > > Yes, it is: http://www.pgadmin.org/docs/1.4/options-tab4.html By default then. :) -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---

[pgadmin-hackers] Automake error

x27;t defined anywhere. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

[pgadmin-hackers] libxslt missing

d -lxslt to the link line to get it to work. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTE

[pgadmin-hackers] Crashes when setting refresh interval to 0

When setting the refresh interval in the server tools to 0 (clicking on the arrows or pressing the 0 key), pgadmin3 segfaults immediately. This happens both in 1.4 and 1.5 devel. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast

Re: [pgadmin-hackers] libxslt missing

Am Freitag, 16. Juni 2006 16:08 schrieb Dave Page: > I imagine this could also be caused by a need to rerun bootstrap.sh... Yes, I didn't realize there was another level of indirection. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of b

[pgadmin-hackers] Dave Page's PGP key

Either I'm doing something wrong or Dave Page's PGP key that is used to sign pgAdmin releases does not have any signatures on it. That would make the process of verifying the releases rather impossible. -- Peter Eisentraut http://developer.postgresql.o

Re: [pgadmin-hackers] Dave Page's PGP key

gning them with signature-less PGP keys, which gives exactly nil additional security. > Compare that to the md5sum's that Greg(?) produces That is not the standard you want to compare with. But Greg actually does have signatures on his key. -- Peter Ei