[pgadmin-hackers] new build dep summary ?

2005-03-04 Thread blacknoz
Hi friends,

I plan to rework on Debian snapshots autobuilds this WE and
to prevent (free)time lost, I'd like to get a small summary
of steps needed to get the actual snapshot to build ok.

Here is what I noticed in past threads:
- wx 2.5.4 is now needed
- wxUSE_DEPRECATED=0 instead of 1 (shall I modify this
directly in the source file basic.h [-- not sure of the
name, my memory is not young anymore] or is it adviced to
pass this with CFLAGS / CXXFLAGS ?)
- I presume there is no more libs to build than before
but maybe I'm missing something ?

anything else ?

Regards,
Raphaƫl


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


Re: [pgadmin-hackers] new build dep summary ?

2005-03-04 Thread Dave Page
 

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of 
 [EMAIL PROTECTED]
 Sent: 04 March 2005 10:02
 To: pgadmin-hackers@postgresql.org
 Subject: [pgadmin-hackers] new build dep summary ?
 
 Hi friends,
 
 I plan to rework on Debian snapshots autobuilds this WE and
 to prevent (free)time lost, I'd like to get a small summary
 of steps needed to get the actual snapshot to build ok.
 
 Here is what I noticed in past threads:
 - wx 2.5.4 is now needed

Yup.

 - wxUSE_DEPRECATED=0 instead of 1 (shall I modify this
 directly in the source file basic.h [-- not sure of the
 name, my memory is not young anymore] 

Pfft - what does that make Andreas, Hiroshi and myself?!?!? Oh, and Mark
- he's just had a birthday making him a year older than me again for the
next few months at least! Dunno 'bout Adam or Jean-Michel

 or is it adviced to
 pass this with CFLAGS / CXXFLAGS ?)

I tried the latter and it didn't work on either Windows or Linux :-(

I editted basic.h on both which worked fine.

 - I presume there is no more libs to build than before
 but maybe I'm missing something ?

Just the OGL lib. XRC is no longer required as it's built in now (but
iirc it was in the last version as well).

Regards, Dave.

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

   http://archives.postgresql.org


Re: [pgadmin-hackers] wxWidgets 2.5.4 is language file can't be used.?

2005-03-04 Thread Andreas Pflug
Hiroshi Saito wrote:
From: Andreas Pflug [EMAIL PROTECTED]
 

Hi Hiroshi,
pgAdmin is translated in more languages than wxWidgets, that's why some 
wxstd are missing.
   

Hmmm,  Even pgadmin3.mo isn't used.:-(
However, This problem doesn't happen with Win-XP. As for it, even your 
snapshots is reproduced in W2K. It gets off a translation. ja_JP can't be used.
I am tracking wxWidgets. Is this phenomenon only Japanese? 
 

The snapshot definitely works for me, so apparently it's indeed a ja_JP 
problem.

Regards,
Andreas
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faq


Re: [pgadmin-hackers] new build dep summary ?

2005-03-04 Thread Andreas Pflug
[EMAIL PROTECTED] wrote:
Hi friends,
I plan to rework on Debian snapshots autobuilds this WE and
to prevent (free)time lost, I'd like to get a small summary
of steps needed to get the actual snapshot to build ok.
Here is what I noticed in past threads:
- wx 2.5.4 is now needed
- wxUSE_DEPRECATED=0 instead of 1 (shall I modify this
directly in the source file basic.h 

That's how I did it, and I posted a recommendation to wx.
That's all that changed.
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


Re: [pgadmin-hackers] wxWidgets 2.5.4 is language file can't be used.?

2005-03-04 Thread Hiroshi Saito
From: Andreas Pflug [EMAIL PROTECTED]

 I am tracking wxWidgets. Is this phenomenon only Japanese? 
   
 
 The snapshot definitely works for me, so apparently it's indeed a ja_JP 
 problem.

Uga.., I was afraid of it. As for relating and thinking. It isn't indicated 
with 
Japanese W2K if Japanese-font isn't chosen in the case of Query-Font.
However, There is no problem in these with Win-XP. There are many users 
of W2K in Japan. pgAdminIII will be the control-center of the PostgreSQL 
standard.  Therefore, I watch this problem closely. Let me know it if you 
notice something.

Thank you.

regards,
Hiroshi Saito

---(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] CVS Commit by dpage: Add missing version

2005-03-04 Thread cvs
Log Message:
---
Add missing version

Modified Files:
--
pgadmin3:
CHANGELOG.txt (r1.189 - r1.190)

Index: CHANGELOG.txt
===
RCS file: /projects/pgadmin3/CHANGELOG.txt,v
retrieving revision 1.189
retrieving revision 1.190
diff -LCHANGELOG.txt -LCHANGELOG.txt -u -w -r1.189 -r1.190
--- CHANGELOG.txt
+++ CHANGELOG.txt
@@ -17,7 +17,7 @@
 /ul
 br
 ul
-li2005-03-04 DPFix aggregate SQL generation per James Prichard
+li2005-03-04 DP  1.2.1 Fix aggregate SQL generation per James Prichard
 li2005-03-03 APgraphical EXPLAIN
 li2005-03-03 APpgAgent fixes (jobId)
 li2005-03-02 DPRewritie pgAgent browser codee to use pgCollection
---(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] CVS Commit by dpage: Braces for readability

2005-03-04 Thread cvs
Log Message:
---
Braces for readability

Modified Files:
--
pgadmin3/src/ui:
dlgProperty.cpp (r1.115 - r1.116)

Index: dlgProperty.cpp
===
RCS file: /projects/pgadmin3/src/ui/dlgProperty.cpp,v
retrieving revision 1.115
retrieving revision 1.116
diff -Lsrc/ui/dlgProperty.cpp -Lsrc/ui/dlgProperty.cpp -u -w -r1.115 -r1.116
--- src/ui/dlgProperty.cpp
+++ src/ui/dlgProperty.cpp
@@ -265,6 +265,7 @@
 void dlgProperty::AppendNameChange(wxString sql, const wxString objName)
 {
 if (GetObject()-GetName() != GetName())
+   {
if (objName.Length()  0)
{
sql += wxT(ALTER ) + objName
@@ -277,6 +278,7 @@
+  wxT(;\n);
}
 }
+}
 
 
 void dlgProperty::AppendOwnerChange(wxString sql, const wxString objName)
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


[pgadmin-hackers] CVS Commit by dpage: Fix aggregate SQL generation per James Prichard

2005-03-04 Thread cvs
Log Message:
---
Fix aggregate SQL generation per James Prichard

Modified Files:
--
pgadmin3:
CHANGELOG.txt (r1.188 - r1.189)
pgadmin3/src/include:
dlgProperty.h (r1.45 - r1.46)
pgadmin3/src/schema:
pgAggregate.cpp (r1.26 - r1.27)
pgadmin3/src/ui:
dlgAggregate.cpp (r1.22 - r1.23)
dlgProperty.cpp (r1.114 - r1.115)

Index: CHANGELOG.txt
===
RCS file: /projects/pgadmin3/CHANGELOG.txt,v
retrieving revision 1.188
retrieving revision 1.189
diff -LCHANGELOG.txt -LCHANGELOG.txt -u -w -r1.188 -r1.189
--- CHANGELOG.txt
+++ CHANGELOG.txt
@@ -17,8 +17,10 @@
 /ul
 br
 ul
+li2005-03-04 DPFix aggregate SQL generation per James Prichard
 li2005-03-03 APgraphical EXPLAIN
 li2005-03-03 APpgAgent fixes (jobId)
+li2005-03-02 DPRewritie pgAgent browser codee to use pgCollection
 li2005-02-25 APsome more Slony-I stuff
 li2005-02-24 APsome Slony-I stuff
 li2005-02-24 AP  1.2.1 require unicode to compile utffile.cpp
Index: dlgProperty.h
===
RCS file: /projects/pgadmin3/src/include/dlgProperty.h,v
retrieving revision 1.45
retrieving revision 1.46
diff -Lsrc/include/dlgProperty.h -Lsrc/include/dlgProperty.h -u -w -r1.45 -r1.46
--- src/include/dlgProperty.h
+++ src/include/dlgProperty.h
@@ -57,7 +57,7 @@
 
 void CheckValid(bool enable, const bool condition, const wxString msg);
 static dlgProperty *CreateDlg(frmMain *frame, pgObject *node, bool asNew, 
int type=-1);
-void AppendNameChange(wxString sql);
+void AppendNameChange(wxString sql, const wxString 
objname=wxEmptyString);
 void AppendOwnerChange(wxString sql, const wxString 
objName=wxEmptyString);
 void AppendOwnerNew(wxString sql, const wxString objname);
 void AppendComment(wxString sql, const wxString objType, pgSchema 
*schema, pgObject *obj);
Index: pgAggregate.cpp
===
RCS file: /projects/pgadmin3/src/schema/pgAggregate.cpp,v
retrieving revision 1.26
retrieving revision 1.27
diff -Lsrc/schema/pgAggregate.cpp -Lsrc/schema/pgAggregate.cpp -u -w -r1.26 
-r1.27
--- src/schema/pgAggregate.cpp
+++ src/schema/pgAggregate.cpp
@@ -31,7 +31,7 @@
 
 bool pgAggregate::DropObject(wxFrame *frame, wxTreeCtrl *browser)
 {
-return GetDatabase()-ExecuteVoid(wxT(DROP AGGREGATE ) + 
GetQuotedFullIdentifier() + wxT(() + GetInputType() + wxT()));
+return GetDatabase()-ExecuteVoid(wxT(DROP AGGREGATE ) + 
GetQuotedFullIdentifier() + wxT(() + GetInputType() + wxT();));
 }
 
 wxString pgAggregate::GetSql(wxTreeCtrl *browser)
@@ -39,16 +39,18 @@
 if (sql.IsNull())
 {
 sql = wxT(-- Aggregate: ) + GetQuotedFullIdentifier() + wxT(\n\n)
-+ wxT(-- DROP AGGREGATE ) + GetQuotedFullIdentifier() + wxT(() 
+ GetInputType() + wxT())
++ wxT(-- DROP AGGREGATE ) + GetQuotedFullIdentifier() + wxT(() 
+ GetInputType() + wxT();)
 + wxT(\n\nCREATE AGGREGATE ) + GetQuotedFullIdentifier() 
 + wxT((\n  BASETYPE=) + GetInputType()
 + wxT(,\n  SFUNC=) + GetStateFunction()
 + wxT(,\n  STYPE=) + GetStateType();
-AppendIfFilled(sql, wxT(,\n  FFUNC=), qtIdent(GetFinalFunction()));
+AppendIfFilled(sql, wxT(,\n  FINALFUNC=), 
qtIdent(GetFinalFunction()));
 if (GetInitialCondition().length()  0)
   sql += wxT(,\n  INITCOND=) + qtString(GetInitialCondition());
 sql += wxT(\n);\n)
-+ GetOwnerSql(8, 0);
++ GetOwnerSql(8, 0, wxT(AGGREGATE ) + GetQuotedFullIdentifier() 
++ wxT(() + qtIdent(GetInputType())
++ wxT()));
 
 if (!GetComment().IsNull())
 {
Index: dlgProperty.cpp
===
RCS file: /projects/pgadmin3/src/ui/dlgProperty.cpp,v
retrieving revision 1.114
retrieving revision 1.115
diff -Lsrc/ui/dlgProperty.cpp -Lsrc/ui/dlgProperty.cpp -u -w -r1.114 -r1.115
--- src/ui/dlgProperty.cpp
+++ src/ui/dlgProperty.cpp
@@ -262,14 +262,21 @@
 }
 
 
-void dlgProperty::AppendNameChange(wxString sql)
+void dlgProperty::AppendNameChange(wxString sql, const wxString objName)
 {
 if (GetObject()-GetName() != GetName())
+   if (objName.Length()  0)
+   {
+   sql += wxT(ALTER ) + objName
+   +  wxT( RENAME TO ) + qtIdent(GetName())
+   +  wxT(;\n);
+   } else {
 sql += wxT(ALTER ) + GetObject()-GetTypeName()
 +  wxT( ) + GetObject()-GetQuotedFullIdentifier()
 +  wxT( RENAME TO ) + qtIdent(GetName())
 +  wxT(;\n);
 }
+}
 
 
 void dlgProperty::AppendOwnerChange(wxString sql, const wxString objName)
Index: dlgAggregate.cpp

[pgadmin-hackers] CVS Commit by dpage: Fix aggregate SQL generation per James Prichard

2005-03-04 Thread cvs
Log Message:
---
Fix aggregate SQL generation per James Prichard

Tags:

REL-1_2_0_PATCHES

Modified Files:
--
pgadmin3:
CHANGELOG.txt (r1.171.2.3 - r1.171.2.4)
pgadmin3/src/include:
dlgProperty.h (r1.41.2.1 - r1.41.2.2)
pgadmin3/src/schema:
pgAggregate.cpp (r1.25.2.1 - r1.25.2.2)
pgadmin3/src/ui:
dlgAggregate.cpp (r1.21.2.1 - r1.21.2.2)
dlgProperty.cpp (r1.106.2.1 - r1.106.2.2)

Index: CHANGELOG.txt
===
RCS file: /projects/pgadmin3/CHANGELOG.txt,v
retrieving revision 1.171.2.3
retrieving revision 1.171.2.4
diff -LCHANGELOG.txt -LCHANGELOG.txt -u -w -r1.171.2.3 -r1.171.2.4
--- CHANGELOG.txt
+++ CHANGELOG.txt
@@ -17,6 +17,7 @@
 /ul
 br
 ul
+li2005-03-04 DP  1.2.1 Fix aggregate SQL generation per James Prichard
 li2005-02-07 AHP 1.2.1 fix libpq/ssl library detection
 li2005-01-13 DP  1.2.1 fix EXPLICIT CAST sql generation (r: Merlin 
Moncure)
 li2004-12-06 AP  1.2.1 Fix tablespace reference in namespace
Index: dlgProperty.h
===
RCS file: /projects/pgadmin3/src/include/dlgProperty.h,v
retrieving revision 1.41.2.1
retrieving revision 1.41.2.2
diff -Lsrc/include/dlgProperty.h -Lsrc/include/dlgProperty.h -u -w -r1.41.2.1 
-r1.41.2.2
--- src/include/dlgProperty.h
+++ src/include/dlgProperty.h
@@ -56,7 +56,7 @@
 
 void CheckValid(bool enable, const bool condition, const wxString msg);
 static dlgProperty *CreateDlg(frmMain *frame, pgObject *node, bool asNew, 
int type=-1);
-void AppendNameChange(wxString sql);
+void AppendNameChange(wxString sql, const wxString 
objname=wxEmptyString);
 void AppendOwnerChange(wxString sql, const wxString 
objName=wxEmptyString);
 void AppendOwnerNew(wxString sql, const wxString objname);
 void AppendComment(wxString sql, const wxString objType, pgSchema 
*schema, pgObject *obj);
Index: pgAggregate.cpp
===
RCS file: /projects/pgadmin3/src/schema/pgAggregate.cpp,v
retrieving revision 1.25.2.1
retrieving revision 1.25.2.2
diff -Lsrc/schema/pgAggregate.cpp -Lsrc/schema/pgAggregate.cpp -u -w -r1.25.2.1 
-r1.25.2.2
--- src/schema/pgAggregate.cpp
+++ src/schema/pgAggregate.cpp
@@ -31,7 +31,7 @@
 
 bool pgAggregate::DropObject(wxFrame *frame, wxTreeCtrl *browser)
 {
-return GetDatabase()-ExecuteVoid(wxT(DROP AGGREGATE ) + 
GetQuotedFullIdentifier() + wxT(() + GetInputType() + wxT()));
+return GetDatabase()-ExecuteVoid(wxT(DROP AGGREGATE ) + 
GetQuotedFullIdentifier() + wxT(() + GetInputType() + wxT();));
 }
 
 wxString pgAggregate::GetSql(wxTreeCtrl *browser)
@@ -39,16 +39,18 @@
 if (sql.IsNull())
 {
 sql = wxT(-- Aggregate: ) + GetQuotedFullIdentifier() + wxT(\n\n)
-+ wxT(-- DROP AGGREGATE ) + GetQuotedFullIdentifier() + wxT(() 
+ GetInputType() + wxT())
++ wxT(-- DROP AGGREGATE ) + GetQuotedFullIdentifier() + wxT(() 
+ GetInputType() + wxT();)
 + wxT(\n\nCREATE AGGREGATE ) + GetQuotedFullIdentifier() 
 + wxT((\n  BASETYPE=) + GetInputType()
 + wxT(,\n  SFUNC=) + GetStateFunction()
 + wxT(,\n  STYPE=) + GetStateType();
-AppendIfFilled(sql, wxT(,\n  FFUNC=), qtIdent(GetFinalFunction()));
+AppendIfFilled(sql, wxT(,\n  FINALFUNC=), 
qtIdent(GetFinalFunction()));
 if (GetInitialCondition().length()  0)
   sql += wxT(,\n  INITCOND=) + qtString(GetInitialCondition());
 sql += wxT(\n);\n)
-+ GetOwnerSql(8, 0);
++ GetOwnerSql(8, 0, wxT(AGGREGATE ) + GetQuotedFullIdentifier() 
++ wxT(() + qtIdent(GetInputType())
++ wxT()));
 
 if (!GetComment().IsNull())
 {
Index: dlgProperty.cpp
===
RCS file: /projects/pgadmin3/src/ui/dlgProperty.cpp,v
retrieving revision 1.106.2.1
retrieving revision 1.106.2.2
diff -Lsrc/ui/dlgProperty.cpp -Lsrc/ui/dlgProperty.cpp -u -w -r1.106.2.1 
-r1.106.2.2
--- src/ui/dlgProperty.cpp
+++ src/ui/dlgProperty.cpp
@@ -251,14 +251,23 @@
 }
 
 
-void dlgProperty::AppendNameChange(wxString sql)
+void dlgProperty::AppendNameChange(wxString sql, const wxString objName)
 {
 if (GetObject()-GetName() != GetName())
+{
+   if (objName.Length()  0)
+   {
+   sql += wxT(ALTER ) + objName
+   +  wxT( RENAME TO ) + qtIdent(GetName())
+   +  wxT(;\n);
+   } else {
 sql += wxT(ALTER ) + GetObject()-GetTypeName()
 +  wxT( ) + GetObject()-GetQuotedFullIdentifier()
 +  wxT( RENAME TO ) + qtIdent(GetName())
 +  wxT(;\n);
 }
+}
+}
 
 
 void dlgProperty::AppendOwnerChange(wxString sql, const wxString objName)
Index: dlgAggregate.cpp

[pgadmin-hackers] CVS Commit by dpage: New splash screen

2005-03-04 Thread cvs
Log Message:
---
New splash screen

Removed Files:
-
pgadmin3/src/include/images:
splash.mic

Binary files src/include/images/splash.mic and /dev/null differ
---(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