Re: [pgadmin-hackers] Infinite loop in pgAdmin3

2003-06-13 Thread Andreas Pflug
Jean-Michel POURE wrote:

Dear all,

When trying to create a table with a serial column, pgAdmin3 enters an 
infinite loop.

 

fixed.



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


Re: [pgadmin-hackers] gcc3.3 compliance

2003-06-13 Thread Jean-Michel POURE
Dear all,

I tried to rebuild the RedHat9 rpm, here is the log (gcc 3.2):

if g++ -DHAVE_CONFIG_H -I. -I. -I..   -I/usr/include 
-I/usr/local/lib/wx/include/gtk2ud-2.5 -D__WXDEBUG__ -D__WXGTK__ 
-D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -I/usr/local/include 
-DDATA_DIR=\/usr/local/pgadmin3/share/pgadmin3/\ -Wall -g -I./include/ -I 
-g -O2 -MT pgSet.o -MD -MP -MF .deps/pgSet.Tpo \
  -c -o pgSet.o `test -f 'db/pgSet.cpp' || echo './'`db/pgSet.cpp; \
then mv -f .deps/pgSet.Tpo .deps/pgSet.Po; \
else rm -f .deps/pgSet.Tpo; exit 1; \
fi
db/pgSet.cpp: Dans member function « long int pgSet::GetLong(const wxString)
   »:
db/pgSet.cpp:123: choix de « long int pgSet::GetLong(int) const » à la place
   de « long int pgSet::GetLong(const wxString) »
db/pgSet.cpp:123:   parce la plus mauvaise conversion de la déclaration
   initiale est meilleure que la plus mauvaise conversion de la dernière
   déclaration
make[2]: *** [pgSet.o] Erreur 1
make[2]: Quitte le répertoire `/usr/src/redhat/BUILD/pgadmin3-20030613/src'
make[1]: *** [all-recursive] Erreur 1
make[1]: Quitte le répertoire `/usr/src/redhat/BUILD/pgadmin3-20030613'
make: *** [all] Erreur 2
error: Bad exit status from /var/tmp/rpm-tmp.22060 (%build)

Cheers,
Jean-Michel

 Dave Page wrote:
 -Original Message-
 From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]
 Sent: 12 June 2003 16:50
 To: [EMAIL PROTECTED]
 Cc: Adam Pendleton
 Subject: Re: [pgadmin-hackers] gcc3.3 compliance
 
 On Thursday 12 June 2003 17:09, you wrote:
 Can you CVS update please? I fixed that yesterday (unless someone
 un-fixed it again).
 
 This is an error output from today. It only occurs under SuSE
 82. Maybe we
 should wait for Adam patch review and then I will try again
 to compile under
 SuSE.
 
 Dunno what it is then. It is *exactly* the error I saw, on exactly the
 same line of the file after Andreas commited a change. I added the cast
 to long and it was fine.

 This fix breaks win32 compilation, and I really don't know what kind of
 foolishness gcc does here. All GetXXX pairs are defined equally, but
 only GetLong will show that problem.
 The argument to GetLong is an int, and ColNumber returns int, that
 should make a perfect fit. With the fix applied, msdev will complain
 two similar conversions. Maybe it helps if all GetXXX(int) are defined
 as GetXXX(const int); please check this.

 Regards,
 Andreas



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


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

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


Re: [pgadmin-hackers] gcc3.3 compliance

2003-06-13 Thread Dave Page


 -Original Message-
 From: Andreas Pflug [mailto:[EMAIL PROTECTED] 
 Sent: 13 June 2003 09:09
 To: Dave Page; [EMAIL PROTECTED]; Jean-Michel POURE
 Subject: Re: [pgadmin-hackers] gcc3.3 compliance
 
 
 Dave Page wrote:
 
 This fix breaks win32 compilation, and I really don't know 
 what kind of 
 foolishness gcc does here. All GetXXX pairs are defined equally, but 
 only GetLong will show that problem.
 The argument to GetLong is an int, and ColNumber returns int, that 
 should make a perfect fit. With the fix applied, msdev will complain 
 two similar conversions. Maybe it helps if all GetXXX(int) 
 are defined 
 as GetXXX(const int); please check this.

Hmm, see what you mean. In my bleary-eyed attempt to fix it I misread
the code and managed to fix it for me with a non-fix!

I'll try the const fix...

Regards, Dave.

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

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


Re: [pgadmin-hackers] gcc3.3 compliance

2003-06-13 Thread Dave Page


 -Original Message-
 From: Dave Page 
 Sent: 13 June 2003 09:34
 To: Andreas Pflug; [EMAIL PROTECTED]; Jean-Michel POURE
 Subject: Re: [pgadmin-hackers] gcc3.3 compliance
 
 
 
 Hmm, see what you mean. In my bleary-eyed attempt to fix it I 
 misread the code and managed to fix it for me with a non-fix!
 
 I'll try the const fix...

Fixes Win32 but Linux is broken again. Incidently, snake has gcc 3.2.2,
not 3.3.

I'll have a play and see if I can come up with anything else.

Regards, Dave.

---(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] gcc3.3 compliance

2003-06-13 Thread Jean-Michel POURE
On Friday 13 June 2003 10:42, Dave Page wrote:
 Fixes Win32 but Linux is broken again. Incidently, snake has gcc 3.2.2,
 not 3.3.

This does not seem to be a gcc 3.2/3.3 issue. On both RedHat 9 (gcc 3.2) and 
SuSE 8.2 (gcc 3.3), the error is the same:

if g++ -DHAVE_CONFIG_H -I. -I. -I..   -I/usr/include/pgsql 
-I/space/pgadmin/wxGTK/install/lib/wx/include/gtk2ud-2.5 
-I/space/pgadmin/wxGTK/install/include -D__WXDEBUG__ -D__WXGTK__ 
-D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -I/space/pgadmin/wxGTK/install/include 
-DDATA_DIR=\/usr/local/pgadmin3/share/pgadmin3/\ -Wall -g -I./include/ -I 
-g -O2 -MT pgSet.o -MD -MP -MF .deps/pgSet.Tpo \
  -c -o pgSet.o `test -f 'db/pgSet.cpp' || echo './'`db/pgSet.cpp; \
then mv .deps/pgSet.Tpo .deps/pgSet.Po; \
else rm -f .deps/pgSet.Tpo; exit 1; \
fi
db/pgSet.cpp: In member function `long int pgSet::GetLong(const wxString)':
db/pgSet.cpp:123: error: choosing `long int pgSet::GetLong(int) const' over `
   long int pgSet::GetLong(const wxString)'
db/pgSet.cpp:123: error:   because worst conversion for the former is better
   than worst conversion for the latter
make[2]: *** [pgSet.o] Error 1
make[2]: Leaving directory `/space/pgadmin/pgadmin3/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/space/pgadmin/pgadmin3'
make: *** [all] Error 2

Cheers,
Jean-Michel


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


Re: [pgadmin-hackers] gcc3.3 compliance

2003-06-13 Thread Andreas Pflug
Jean-Michel POURE wrote:

On Friday 13 June 2003 10:42, Dave Page wrote:
 

Fixes Win32 but Linux is broken again. Incidently, snake has gcc 3.2.2,
not 3.3.
   

This does not seem to be a gcc 3.2/3.3 issue. On both RedHat 9 (gcc 3.2) and 
SuSE 8.2 (gcc 3.3), the error is the same:

 

This is a really nasty one.
I recoded the method to not use the other, but have the complete code 
instead. Should make both worlds happy.

Regards,
Andreas


---(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] Request for help about Debian packaging

2003-06-13 Thread Dave Page


 -Original Message-
 From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] 
 Sent: 13 June 2003 12:59
 To: Michael Meskes
 Cc: [EMAIL PROTECTED]
 Subject: [pgadmin-hackers] Request for help about Debian packaging
 

Hi Jean-Michel,

I had an offer to help with Debian this morning - currently waiting to
hear back from the guy.

Regards, Dave.

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

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


Re: [pgadmin-hackers] Request for help about Debian packaging

2003-06-13 Thread Jean-Michel POURE
On Friday 13 June 2003 14:16, Dave Page wrote:
 I had an offer to help with Debian this morning - currently waiting to
 hear back from the guy.

Hi Dave,

Sorry, things are going so quickly these days...

Michael Meskes is part of the main hacker team and happens to be a big fan of 
Debian... Let's wait for your Debian Friend, I CC Michael for information.

Cheers,
Jean-Michel


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


Re: [pgadmin-hackers] [GENERAL] graphical sql-query builder

2003-06-13 Thread Dave Page


 -Original Message-
 From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] 
 Sent: 13 June 2003 13:50
 To: Marc Cuypers
 Cc: [EMAIL PROTECTED]
 Subject: Re: [pgadmin-hackers] [GENERAL] graphical sql-query builder
 
 
  I get the message 'Application has failed to start because 
 MSVCRTD.dll 
  was not found.  Reinstalling the application may fix this problem'. 
  Met vriendelijke groeten, Marc Cuypers
 

Hi Marc,

The missing file is a Microsoft dbug library that's obviously not on
your system. I can send it to you off-list if you like, but we may then
find there are more required. Do you mind a few emails and files going
back and forth until we figure out exactly what's required on a
non-development system? Once we know that, we can add them to the Win32
snapshots for others.

Regards, Dave.

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


Re: [pgadmin-hackers] Translation issue: use of %s

2003-06-13 Thread Jean-Michel POURE
Dear Andreas,

 1) In the case of Creating a new %s, I think it would help if %s is
 not only the object name itself (View, Table, ...) but includes new
 (new view, new table,  tableau nouveau, neue Tabelle, neuer
 Operator...). I'll be recoding typeNameList[] the next days for this.
 Are there any other cases you found in pgadmin.pot?

It won't make it in several languages. Non european languages follow strange 
rules that are hard to even imagine (sometimes no verb, sometimes no 
adjective, sometimes only aggregates, etc...).

You should simply create different strings: Create a new view, Create a new 
table, etc... 

 2) do you have an example in pgAdmin3 for that?
No, it was just a 0.02 cents remark.

To summarise, when possible, sentences should never be built by a 
search/replace mechanism like %s. If you use %s, be sure the replaced 
string is completely invariable (the name of a user, etc...).

Cheers,
Jean-Michel


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


[pgadmin-hackers] xrc ressource translation

2003-06-13 Thread Jean-Michel POURE
Hello again,

Sorry to be back again with a 0.02 cents issue. I noticed INNER JOIN, LEFT 
JOIN, etc... and other SQL keywords had been extracted from XRC ressources 
and included in the translation file. Like a fool, I translated these stings, 
which may lead to a few bugs. Any idea to mark these strings unstranslatable?

Cheers,
Jean-Michel


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


Re: [pgadmin-hackers] xrc ressource translation

2003-06-13 Thread Andreas Pflug
Jean-Michel POURE wrote:

Hello again,

Sorry to be back again with a 0.02 cents issue. I noticed INNER JOIN, LEFT 
JOIN, etc... and other SQL keywords had been extracted from XRC ressources 
and included in the translation file. Like a fool, I translated these stings, 
which may lead to a few bugs. Any idea to mark these strings unstranslatable?

 

I noticed this too. There's nothing we can do about that, I believe, 
besides telling all translators to leave ALL UPPER CASE KEYWORDS 
unchanged, especially if they appear as single word.

Regards,
Andreas


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


[pgadmin-hackers] My e-mail address

2003-06-13 Thread Adam H. Pendleton
I inadventantly posted a message to list from my work account.  Please 
use my home account, [EMAIL PROTECTED] for all list postings and CC's, 
etc.  I hardly ever check the work account, and I don't want to miss 
anything (work?  me?  never!)

ahp

---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [pgadmin-hackers] ctlSQLBox ClientEncoding problem on Display?

2003-06-13 Thread Hiroshi Saito
Hi Andreas.
(B
(BI continue it, and try Debug to solve a problem.
(BBut, it wasn't easy
(B
(BThe place to cause a problem seems to be in something of
(Bscintilla/src/Editor.cxx..
(BAn indication position at the time of Wide-Character seems to be moved
(Bdouble.
(B
(BIs this the phenomenon which happens in Japanese only in Windows???
(B
(BWith kindest regards,
(BHiroshi-Saito
(B
(B Hi Andreas.
(B
(B Thank you for the Debug information.
(B
(B(snip)
(B  Hiroshi Saito wrote:
(B 
(B  Hi Andreas.
(B  
(B  UNICODE standard seems to be a correct answer.!
(B  I am examined with the standard so that it can operate it without
(B problem.
(B  
(B  ScreenShot of the reference is a UNICODE version.
(B 
(B
(Bhttp://cre-ent.skcapi.co.jp/~saito/pgadmin/lib/pgadmin3_unicode_debug1.jpg
(B  
(B  
(B  
(B  Hi Hiroshi,
(B  that nasty bug that prevented unicode under gtk might as well be
(B  responsible for this. Please either use wxWindows2.5 = 2003-06-07 or
(B  patch the file common/string.cpp in wxString::wxString(const char *psz,
(B  wxMBConv conv, size_t nLength) around line 269:
(B 
(B 
(B  // MB2WC wants the buffer size, not the string length
(B  if ( conv.MB2WC(m_pchData, psz, nLen + 1) != (size_t)-1 )
(B  {
(B  // initialized ok
(B  m_pchData[nLen] = 0; //  this was missing and left strings
(B unterminated
(B  return;
(B  }
(B
(B Hmm..
(B It was information on 6/8.
(B I see this place being treated with the information , too.
(B
(B Index: common/string.cpp
(B ===
(B RCS file: /pack/cvsroots/wxwindows/wxWindows/src/common/string.cpp,v
(B retrieving revision 1.172
(B retrieving revision 1.173
(B diff -r1.172 -r1.173
(B 7c7
(B  // RCS-ID:  $Id: string.cpp,v 1.172 2003/05/29 14:03:34 GD Exp $
(B ---
(B  // RCS-ID:  $Id: string.cpp,v 1.173 2003/06/06 00:43:21 RD Exp $
(B 269a270
(B  m_pchData[nLen] = 0;
(B
(B bug still lurks besides.
(B It is about to be seen from now.
(B
(B Thank you for taking precious time.
(B
(B With kindest regards,
(B Hiroshi-Saito
(B
(B
(B
(B---(end of broadcast)---
(BTIP 10: the planner will ignore your desire to choose an index scan if your
(B   joining column's datatypes do not match

Re: [pgadmin-hackers] ctlSQLBox ClientEncoding problem on Display?

2003-06-13 Thread Hiroshi Saito
Hi Andreas.

Oh. Thank you very much.
Understanding is difficult if it is not you. !!

It may not be able to explain well.

ScreenShot of the reference is a UNICODE version.
http://cre-ent.skcapi.co.jp/~saito/pgadmin/lib/pgadmin3_unicode_debug1.jpg
Query-Window moves with the same routine.
http://cre-ent.skcapi.co.jp/~saito/pgadmin/lib/pgadmin3_unicode_debug2.jpg
Input is tried.
http://cre-ent.skcapi.co.jp/~saito/pgadmin/lib/pgadmin3_unicode_debug3.jpg

http://cre-ent.skcapi.co.jp/~saito/pgadmin/lib/pgadmin3_unicode_debug4.jpg
Action after that is interesting.
http://cre-ent.skcapi.co.jp/~saito/pgadmin/lib/pgadmin3_unicode_debug5.jpg

Control is delivered from here.

stc.cpp--
// Replace the contents of the document with the argument text.
void wxStyledTextCtrl::SetText(const wxString text) {
SendMsg(2181, 0, (long)(const char*)wx2stc(text));
}

scintilla/include/Scintilla.h-
#define SCI_GETOVERTYPE 2187

scintilla/src/Editor.cxx
sptr_t Editor::WndProc(unsigned int iMessage, uptr_t wParam, sptr_t lParam)
if (recordingMacro)
NotifyMacroRecord(iMessage, wParam, lParam);

switch (iMessage) {
case SCI_GETOVERTYPE:
return inOverstrike ? 1 : 0;

(The starting point that this is a movement)
void Editor::LayoutLine(int line, Surface *surface, ViewStyle vstyle,
LineLayout *ll, int width) {


I am very tired. (x_x)
You are to spend a good holiday, too.

With kindest regards,
Hiroshi-Saito

- Original Message -
From: Andreas Pflug [EMAIL PROTECTED]
To: Hiroshi Saito [EMAIL PROTECTED]
Sent: Saturday, June 14, 2003 4:22 AM
Subject: Re: [pgadmin-hackers] ctlSQLBox ClientEncoding problem on Display?


 Hiroshi Saito wrote:

 Hi Andreas.
 
 I continue it, and try Debug to solve a problem.
 But, it wasn't easy
 
 The place to cause a problem seems to be in something of
 scintilla/src/Editor.cxx..
 An indication position at the time of Wide-Character seems to be moved
 double.
 
 
 
 Hiroshi,

 please tell me the position, maybe I can see something.
 Regards,
 Andreas



---(end of broadcast)---
TIP 8: explain analyze is your friend