[pgadmin-hackers] pgAggregate problem any function

2003-09-08 Thread Hiroshi Saito
Hi Andreas. There is a problem by handling of any of the input type. This patch will just be able to do it. any -> "any" But, Is it likely to be the problem of parser of postgresql? "ANY" is written in the document. But, drop isn't made though "ANY" can be registered. This is with psql. saito=#

[pgadmin-hackers] binary-compatible of pgCast

2003-09-08 Thread Hiroshi Saito
Hi Dave. I have one cast of binary-compatible for largeobject. Though it is hardly made except for it, it thinks that we must show the policy of it. This is made by psql. CREATE CAST (lo AS integer) WITHOUT FUNCTION; It doesn't appear on pgadmin for the limitation. But, though it is binary-comp

Re: [pgadmin-hackers] frmMain_patch

2003-09-08 Thread Dave Page
Thanks Hiroshi, patch applied. Regards, Dave. > -Original Message- > From: Hiroshi Saito [mailto:[EMAIL PROTECTED] > Sent: 08 September 2003 19:51 > To: Andreas Pflug > Cc: [EMAIL PROTECTED]; Dave Page > Subject: frmMain_patch > > > Hi Andreas. > > The SQL command help when it isn't c

[pgadmin-hackers] frmMain_patch

2003-09-08 Thread Hiroshi Saito
Hi Andreas. The SQL command help when it isn't connected with the server does crash. Please Apply it. Regards, Hiroshi Saito frmMain_patch Description: Binary data ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [pgadmin-hackers] MS SQL Migration - Fix to migrate milliseconds

2003-09-08 Thread Dave Page
Hi Alban, Thanks, patch applied to CVS. Regards, Dave. > -Original Message- > From: Alban Colley [mailto:[EMAIL PROTECTED] > Sent: 08 September 2003 18:00 > To: [EMAIL PROTECTED] > Subject: [pgadmin-hackers] MS SQL Migration - Fix to migrate > milliseconds > > > Hi All > > I was att

[pgadmin-hackers] MS SQL Migration - Fix to migrate milliseconds

2003-09-08 Thread Alban Colley
Hi All I was attempting to migrate a large MSSQL2000 DB when I was surprised to be inform that I had duplicate entries on the primary key. I then update the type map for int to be int8 and date to be timestamp which helped but still gave me problems. I then realised that the tables that where fai

Re: [pgadmin-hackers] Build System/translations

2003-09-08 Thread Andreas Pflug
Dave Page wrote: Anyway, my point is, how correct is the list of translations in src/Makefile.am? Should it be restricted to those that are listed in the 'published' section of the website? I'd vote for that. My snapshots are restricted to published languages. Regards, Andreas -

Re: [pgadmin-hackers] About pgAdmin III

2003-09-08 Thread Andreas Pflug
Dmitry A. Mordovin wrote: Hi for all Found bug, then I try to create constraint, unique, you generate SQL code to try to make primary key. About Edit window. You are right, but may be button APPLY for apply my changes in function text.. is it useful maybe? Added to TODO, but maybe this isn't impl

[pgadmin-hackers] Build System/translations

2003-09-08 Thread Dave Page
Hi Jean-Michel, I've just been working on the slackware build system to remove the need to maintain the script when adding translations etc - it is now dependent on 'make install' working correctly as I suspect most of the other build systems are (btw, if anyone has any additional scripts that are

Re: [pgadmin-hackers] About pgAdmin III

2003-09-08 Thread Dmitry A. Mordovin
Hi for all Found bug, then I try to create constraint, unique, you generate SQL code to try to make primary key. About Edit window. You are right, but may be button APPLY for apply my changes in function text.. is it useful maybe? Save window position/size, maybe too? Thanks Best regards -

Re: [pgadmin-hackers] Font problem

2003-09-08 Thread Andreas Pflug
I just posted a question on wx-users about this. Regards, Andreas ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [pgadmin-hackers] Desktop integration

2003-09-08 Thread Dave Page
> -Original Message- > From: Raphaël Enrici [mailto:[EMAIL PROTECTED] > Sent: 03 September 2003 23:03 > To: Dave Page > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] Desktop integration > > > My pgadmin3.desktop looks like this: > <-

Re: [pgadmin-hackers] Font problem

2003-09-08 Thread Andreas Pflug
[EMAIL PROTECTED] wrote: Hi Andreas, can you please quickly explain to me the way fonts are handled in pgAdmin III and which fonts I should check for existence ? I'm currently looking to the problem reported on Debian unstable and I can't reproduce it. You talked about "helvetica", are you reques

Re: [pgadmin-hackers] About pgAdmin III

2003-09-08 Thread Andreas Pflug
Jean-Michel POURE wrote: Le Lundi 8 Septembre 2003 00:12, vous avez écrit : there is a problem fitting greek translations in the dialogs. The same occurs with some other languages too. Dear Yannis, Your translation was publised. Thanks for your fast delivery. To answer your question from

Re: [pgadmin-hackers] About pgAdmin III

2003-09-08 Thread Jean-Michel POURE
Le Lundi 8 Septembre 2003 00:12, vous avez écrit : > there is a problem fitting greek translations in the > dialogs. The same occurs with some other languages > too. Dear Yannis, Your translation was publised. Thanks for your fast delivery. To answer your question from my point of view: - Dialo

Re: [pgadmin-hackers] indirect dereferencing a field in a record

2003-09-08 Thread Andreas Pflug
Conrad, this is the wrong list for your question, use pgsql-hackers instead. Usually, I'd implement your indirect dereferencing using a runtime compiled query string, as the doc show it. Regards, Andreas ---(end of broadcast)--- TIP 3: if posting/re

Re: [pgadmin-hackers] About pgAdmin III

2003-09-08 Thread Andreas Pflug
Dave Page wrote: having the same basic design. I would also like a nice way of editting functions/views of *any* size - There's no intrinsic size limit, it's a question of development cycle. For views and functions, you have a classic edit/compile/debug cycle, which isn' supported by the prope

Re: [pgadmin-hackers] indirect dereferencing a field in a record using plpgsql

2003-09-08 Thread Conrad Vermeulen
Hi, I realized I still have a problem. Apparently there are issues with types with regards to the planner. I only discovered this when I tried accessing the NEW and OLD records in a trigger. The problem that arose was that the type that is being dereferenced is not necessarily what is expected wh

Re: [pgadmin-hackers] About pgAdmin III

2003-09-08 Thread Dave Page
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 07 September 2003 22:31 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] About pgAdmin III > > > Dave Page wrote: > > >I didn't realise the windows were resizable - dialogues generally

[pgadmin-hackers] indirect dereferencing a field in a record using plpgsql

2003-09-08 Thread Conrad Vermeulen
Hi, I had a problem where I needed to indirectly dereference a field from a record. To illustrate: CREATE FUNCTION test2() returns bool as ' DECLARE myrec record; fld text; BEGIN select ''hello'' as a, ''world'' as b into myrec; fld = ''a''; -- the fieldname fro