Well, I'm toying with the idea of getting into helping pgAdmin development
specifically on one or both of the above potential features. In order to
assess whether I can/should/will etc. I thought I'd put out a general
thread starter by asking those present here about requested / hoped-for
li
> Is there a cvs faq for would-be developers for pgAdmin?
Dear Tim,
Thanks, your help on pgAdmin2 is welcome.
You are using command line CVS, right? Maybe you should try
http://www.wincvs.org for these reasons
1) Nice GUI with extensive documentation.
2) It can well handle text and windows bin
Create a column (default initally empty).
Set default to a valid value.
Setting default back to 'empty' doesn't work. Must set NULL.
While this is fine, it's kinda confusing. Could the interface display
NULL where it's not otherwise set?
--
Rod Taylor
Your eyes are weary from staring at the
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 26 February 2002 17:21
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-hackers] Wine support
>
>
> Dear all,
>
> I saw on CVS that pgAdmin2 had been updated for Wine. How
> compatible is
> pgAdmin2 with W
> -Original Message-
> From: Tim Finch, FosterFinch Ltd [mailto:[EMAIL PROTECTED]]
> Sent: 26 February 2002 19:00
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-hackers] cvs download of VB files a problem
>
>
> Dave or anyone!
>
> I have downloaded, via cvs, pgadmin2, binaries, pgschema
> -Original Message-
> From: Tim Finch, FosterFinch Ltd [mailto:[EMAIL PROTECTED]]
> Sent: 26 February 2002 17:58
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-hackers] CVS co -c failure on pgadmin cvs server??
>
>
> Hi,
>
> I'm trying to log into the cvs for pgadmin2 for the first
>
Dave or anyone!
I have downloaded, via cvs, pgadmin2, binaries, pgschema and activex trees
from the cvs, generally with no problems.
I use VB6 SP5 here! Can't open the main pgadminII project - every form dies
on load giving this sort of log file output :
'0' could not be loaded
Line 0: The fi
Hi,
I'm trying to log into the cvs for pgadmin2 for the first time. This is the
first time using cvs as well.
I understand that
cvs co -c
tells you what modules are available. Nothing is returned (I have done the
CVSROOT variable setting and then cvs login first as an anonymouse user).
Is th
Dear all,
I saw on CVS that pgAdmin2 had been updated for Wine. How compatible is
pgAdmin2 with Wine? I know nothing about Wine but would be happy to build an
installation RPM.
Cheers,
Jean-Michel
> -Original Message-
> From: Hiroshi Inoue [mailto:[EMAIL PROTECTED]]
> Sent: 26 February 2002 15:27
> To: Dave Page
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
> [EMAIL PROTECTED]
> Subject: RE: [pgadmin-hackers] pgAdmin2 Japanese display
>
>
>
> It would compile properly but the b
> -Original Message-
> From: Dave Page [mailto:[EMAIL PROTECTED]]
> > -Original Message-
> > From: Hiroshi Inoue [mailto:[EMAIL PROTECTED]]
> >
> > Dave Page wrote:
> > >
> > > Hiroshi, will the multibyte version work OK with Latin encodings? I
> > > suppose what I'm asking is, sho
> -Original Message-
> From: Henshall, Stuart - WCP
> [mailto:[EMAIL PROTECTED]]
> Sent: 26 February 2002 12:47
> To: 'Cedar Cox'; Dave Page
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: [ODBC] [pgadmin-hackers] pgAdmin2 Japanese display
>
>
> > From: Cedar Cox [mailto:[E
> From: Cedar Cox [mailto:[EMAIL PROTECTED]]
>
> On Tue, 26 Feb 2002, Dave Page wrote:
> > >
> > > According to Eiji Tokuya who introduced the multibyte
> > > support, the multibyte version has no problem with single
> > > byte encodings.
> >
> > Would you have any objections if we only distr
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 26 February 2002 12:09
> To: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] Database->ServerEncoding,
> ClientEncoding
>
>
> Le Mardi 26 Février 2002 12:20, Dave Page a écrit :
> > That will work fo
> -Original Message-
> From: Cedar Cox [mailto:[EMAIL PROTECTED]]
> Sent: 26 February 2002 13:24
> To: Dave Page
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [ODBC] [pgadmin-hackers] pgAdmin2 Japanese display
>
>
>
> On Tue, 26 Feb 2002, Dave Page wrote:
> > >
> > > Acc
On Tue, 26 Feb 2002, Dave Page wrote:
> >
> > According to Eiji Tokuya who introduced the multibyte
> > support, the multibyte version has no problem with single
> > byte encodings.
>
> Would you have any objections if we only distributed that version from now
> on then?
>
> BTW, I assume it
Le Mardi 26 Février 2002 12:27, Dave Page a écrit :
> No, and your probably right, we could drop them altogether and just keep
> the text ones. We're already changing the name of the encoding string
> property so changing the interface again ain't gonna hurt.
OK, I am doing it.
Le Mardi 26 Février 2002 12:20, Dave Page a écrit :
> That will work for System stuff. On the User/Data side, those queries
> *only* come from frmSQLInput or a 'View Data' (iirc). For these types of
> query, *if* we had a second connection to the database, then it could
> maintain it's client enco
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 26 February 2002 11:01
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-hackers] Locale, Encoding
>
>
> > LCID is the Windows Locale ID
> > If it's not important, ignore it.
>
> Locales and encodings are dif
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 26 February 2002 10:54
> To: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] Database->ServerEncoding,
> ClientEncoding
>
>
> Le Mardi 26 Février 2002 11:21, Dave Page a écrit :
> > Do we set system
> LCID is the Windows Locale ID
> If it's not important, ignore it.
Locales and encodings are different:
Locale : "fr_fr",
Encoding : "Latin1".
I guess LCID is not a locale but a font ID. What should $M express locales
using IDs?
Still I don't know if we should keep ServerEncodingID (Long) and
Le Mardi 26 Février 2002 11:21, Dave Page a écrit :
> Do we set system encoding per database, or per server.
> Where do we set it?
> How do we set it?
Yesterday, tried a hack in SQLExecute, applying CLIENT_ENCODING on the fly at
the beginning of each SQL query. There does not seem to be a real o
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 26 February 2002 09:44
> To: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] Database->ServerEncoding,
> ClientEncoding
>
>
> > ServerEncodingID (Long)
> > ServerEncodingName (String)
> I still wonde
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 26 February 2002 09:28
> To: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] fake vs real CREATE OR REPLACE VIEW
>
>
> Le Mardi 26 Février 2002 09:40, Dave Page a écrit :
> > Yes. I thought I suggeste
> ServerEncodingID (Long)
> ServerEncodingName (String)
I still wonder why ServerEncodingID is needed. It adds complexity to pgSchema
without beeing used. Can't ServerEncodingID be masked?
> ClientEncodingID (Long)
> The ClientEncodingID would be the Windows LCID (I assume that's relevant
> in
Le Mardi 26 Février 2002 09:46, Dave Page a écrit :
> I forgot I added the query types (that was a recent change to support the
> session recorder). Something like that will probably do it, yes. From a
> sensible user interface point of view, you could select the system encoding
> when logging on
Le Mardi 26 Février 2002 09:40, Dave Page a écrit :
> Yes. I thought I suggested adding a warning to that effect at one time.
You are right. We could query using existing views with ILIKE %view_bar% and
issue a warning if some view matches, but this wron't fix the broblem. We
need CREATE OR REPL
... has now been committed to CVS.
I've also added Commit methods to relevant collection classes in pgSchema to
allow commits of multiple objects at once, and modified the table commit
code to recursively commit sub objects.
Regards, Dave.
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 25 February 2002 21:07
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] Database->ServerEncoding,
> ClientEncoding
>
>
> Hi Dave,
>
> 1) We need two client encodings :
> - one f
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 26 February 2002 08:09
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-hackers] fake vs real CREATE OR REPLACE VIEW
>
>
> Dear Dave,
>
> + create "view_a" querying "view_b",
> + alter "view_b",
> = "view_a
> -Original Message-
> From: Hiroshi Inoue [mailto:[EMAIL PROTECTED]]
> Sent: 26 February 2002 05:51
> To: Dave Page
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
> [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] pgAdmin2 Japanese display
>
>
> Dave Page wrote:
> >
> > Jean-Michel P
Dear Dave,
+ create "view_a" querying "view_b",
+ alter "view_b",
= "view_a "is broken because "view_b" changed OIDs.
This to say we really need CREATE OR REPLACE VIEW in PostgreSQL. Do you
remember the email of the developper who proposed to add this feature to
PostgreSQL? Could you contact h
Le Lundi 25 Février 2002 21:30, Dave Page a écrit :
> As I said in my previous message, we can only set it once for each
> database, otherwise it will become unpredictable as you jump from window
> to window.
> The only other option I can think of, would be to open a dedicated
> connection for eac
Dave Page wrote:
>
> Jean-Michel POURE allegedly said:
> > Le Lundi 25 F$BqW(Brier 2002 17:19, Hiroshi Inoue a $BqD(Brit :
> >> SET CLIENT_ENCODING to 'SJIS'
> >> Strictly speaking, you need a multibyte psqlodbc driver
> >> to handle SJIS(Shift Jis) properly.
> >
> > 2) Is the multibyte psqlo
Jean-Michel POURE wrote:
>
> Le Lundi 25 F$BqW(Brier 2002 17:19, Hiroshi Inoue a $BqD(Brit :
> > SET CLIENT_ENCODING to 'SJIS'
> > Strictly speaking, you need a multibyte psqlodbc driver
> > to handle SJIS(Shift Jis) properly.
>
> Dear Hiroshi,
>
> Thank you for your answer. Could you tell
35 matches
Mail list logo
