Re: [pgadmin-hackers] /sw/share/aclocal/pkg.m4:5: warning: underquoted

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

> I'm getting this warning:
> /sw/share/aclocal/pkg.m4:5: warning: underquoted definition of
> PKG_CHECK_MODULES
>   run info '(automake)Extending aclocal'
>   or see http://sources.redhat.com/automake/automake.html#Extending-aclocal
> 
> on osx, using aclocal-1.9 and autoconf-2.5 (installed from fink) since a
> few
> days. I'm not sure if some pgadmin update, or some fink update caused this.
> 
> Is anyone else getting this warning, or is this (yet another)
> fink+osx+autotools
> problem?

fwiw, bldg svn r5148 on osx 10.4.6 w/ /usr/local/ (not Fink ...) dev
env, all's seems ok on this end ...


& ls -al .../pgAdmin3.app/Contents/MacOS/pgAdmin3
-rwxr-x--- 1 root staff 5038868 May 14 21:54 pgAdmin3

richard

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.3 (Darwin)

iEYEAREDAAYFAkRoCikACgkQlffdvTZxCMbhTQCgpjBiLOY5I3R6IYiqaRRh/DMe
MVYAoMcQ5JXvHrgHqST6jQYz3ARjA0+Q
=Bf6s
-END PGP SIGNATURE-


---(end of broadcast)---
TIP 1: 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] Build failure on OSX

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

> I'm getting linker error on OSX since about two days. Any idea why the
> symbol __ftol is missing,
> and which library should provide it?
...
> /Users/pgadmin3/Installs/PostgreSQL/8.1.3/lib/libpq.a   -lssl -lcrypto
> ld: Undefined symbols:
> __ftol
...


i haven't yet tried a recent build here, but i DO remember seeing ftol
b4 ... though on PC-boxen.

doing a little quick digging, it seems ftol is related to runtime
Floating-Point-to-Int conversion; cref e.g. this thread --

http://lists.apple.com/archives/PerfOptimization-dev/2005/Jan/msg00027.html

reading the thread, i'm fairly certain ftol is NOT avail on PPC ... but
perhaps on Intel?

florian, what box are you building on?

has someone here, perhaps, been monkeying with Intel code for the new macs?

just guessing for now ...

richard


- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.3 (Darwin)

iEYEAREDAAYFAkRLsjwACgkQlffdvTZxCMYkDgCgu6RQ6zQ7E6BYhmfRaAerOu1L
/aAAnjN/I/Gnr8rAczFr+y3vNAs+5pyq
=8ZcZ
-END PGP SIGNATURE-


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

Re: [pgadmin-hackers] SVN Commit by dpage: r5071 - trunk/pgadmin3/pkg/mac

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

dave,


> New Revision: 5071
> 
> Revision summary: 
> http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=5071&view=rev
> 
> Log:
> Fix path modifications made to libraries when completing a Mac appbundle.

w/ 55072 ... back in business w/ .app build on wx263.
thx
richard

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (Darwin)

iEYEAREDAAYFAkQxlUkACgkQlffdvTZxCMb2AACgsAdFB7YzOjXIHX666/z03jkI
1K8AninWjM2ASQTmTJmVod06o/pHdQpS
=Za+e
-END PGP SIGNATURE-


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

Re: [pgadmin-hackers] r5067 + wx563 crash on osx 10.4.5

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi,

> Anyway, back to reality; I'm on the mac now and am seeing failures with
> wx2.6.3 as well, though not what you are seeing.
> 
> A debug build in a debug bundle works fine. Run from a real bundle, it
> starts, then exits without error.
> 
> A release build ran once and crashed on startup, giving me the error log
> below. Subsequent attempts to start it result in a exit without error.
> 
> So there's almost certainly something screwed up in the release build, and
> possibly in the real app bundle. I'll look at the latter now - the former
> will have to wait until I'm less tired.
>

let me know if/what you need ...

g'nite!

r/
- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (Darwin)

iEYEAREDAAYFAkQtq0sACgkQlffdvTZxCMaoywCeJfa48ZrLJiVPV6vuA49R+fQG
A8AAnj4zgfSUK3BKOLDmOTzdJKUJlMx4
=14+e
-END PGP SIGNATURE-


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

   http://www.postgresql.org/docs/faq

Re: [pgadmin-hackers] r5067 + wx563 crash on osx 10.4.5

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

> Yeah, but it doesn't help much when it's turned off and in its bag under my
> bed :-)

heh.

THAT simply indicates that your ssh-fu is weak ...

also, have you tried the latest in quantum-tunneling-ssh?

;-p


- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (Darwin)

iEYEAREDAAYFAkQtpFgACgkQlffdvTZxCMa5XwCgpPQyuM7hGEixzc1r288VhKs0
fVgAoMDNz3vsF5w/iFk+hUkqbiuuIgAl
=1mEn
-END PGP SIGNATURE-


---(end of broadcast)---
TIP 1: 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] r5067 + wx563 crash on osx 10.4.5

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi,

>> nope.  replacing with r5055, same error.
> 
> Oh, good. Well, I mean at least I didn't break it!
> 
>> have YOU attempted a build agains wx2.6.3 release? .3, NOT .2 ?
> 
> No, not yet. I didn't think to bring the Apple with me today
> unfortunately so I'll have to try it over the weekend.
> 
> Regards, Dave.

just fyi, i tried a fresh co & rebuild of wx 263 + pgadmin3

same probs.

let me know what you find.

g'nite.

richard
- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (Darwin)

iEYEAREDAAYFAkQs7PYACgkQlffdvTZxCMZPlwCfaEhhv39wo3EHXPDz24q2z0kL
5/0An0N8PIVxlo4fa4CztcOHmeANJSem
=zdgz
-END PGP SIGNATURE-


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

   http://archives.postgresql.org

Re: [pgadmin-hackers] r5067 + wx563 crash on osx 10.4.5

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi,

>> Completing bundle: pgadmin3.app
>> Found executables: .//Contents/MacOS/pgAdmin3 
>> .//Contents/SharedSupport/helper/pg_dump
>> .//Contents/SharedSupport/helper/pg_restore
>> Post-processing: .//Contents/MacOS/pgAdmin3
>> Post-processing: .//Contents/SharedSupport/helper/pg_dump
>> Post-processing: .//Contents/SharedSupport/helper/pg_restore
>> Bundle completed
> 
> Hmm, nothing about adding libraries?

nope. that's all of it ...

> Well, it's probably about the fastest laptop (well, excluding those from
> the likes of Alienware that have about a 5 minute battery life) money
> can buy ATM, so I'm not complaining too much :-)

must ... resist ... the ... urge ... to ... abuse ... micro$haft ...

>>  libwx_macu_stc-2.6.0.dylib (compatibility version 
>> 3.0.0, current version 3.1.0)


> Do all of that lot exist?

seem to ...

pgAdmin3.app/Contents/Frameworks > ls -al
total 17128
drwxr-xr-x 19 root staff 646 Mar 30 10:36 ./
drwxr-xr-x  8 root staff 272 Mar 30 10:36 ../
- -rwxr-xr-x  1 root staff 1223060 Mar 30 10:36 libSDL-1.2.0.dylib
- -rwxr-xr-x  1 root staff 1217124 Mar 30 10:36 libcrypto.0.9.7.dylib
- -rwxr-xr-x  1 root staff  331928 Mar 30 10:36 libexpat.1.dylib
- -rwxr-xr-x  1 root staff  233872 Mar 30 10:36 libgettextlib-0.14.5.dylib
- -rwxr-xr-x  1 root staff  118532 Mar 30 10:36 libintl.3.dylib
- -rwxr-xr-x  1 root staff  132380 Mar 30 10:36 libjpeg.62.dylib
- -rwxr-xr-x  1 root staff  233308 Mar 30 10:36 libpcre.0.dylib
- -rwxr-xr-x  1 root staff  484772 Mar 30 10:36 libpng.3.dylib
- -rwxr-xr-x  1 root staff  118444 Mar 30 10:36 libpq.4.dylib
- -rwxr-xr-x  1 root staff  458392 Mar 30 10:36 libreadline.5.1.dylib
- -rwxr-xr-x  1 root staff  255536 Mar 30 10:36 libssl.0.9.7.dylib
- -rwxr-xr-x  1 root staff  925832 Mar 30 10:36 libtiff.3.dylib
- -rwxr-xr-x  1 root staff 6769384 Mar 30 10:36 libwx_macu-2.6.0.dylib
- -rwxr-xr-x  1 root staff  450572 Mar 30 10:36 libwx_macu_ogl-2.6.0.dylib
- -rwxr-xr-x  1 root staff 1138324 Mar 30 10:36 libwx_macu_stc-2.6.0.dylib
- -rwxr-xr-x  1 root staff 3328528 Mar 30 10:36 libxml2.2.dylib
- -rwxr-xr-x  1 root staff   84808 Mar 30 10:36 libz.1.dylib

all the MacOSX stuff is there as well ...

> Another thing worth trying would be to get the previous version of
> complete-bundle.sh from SVN (I hacked it about a bit yesterday). 
> 
> http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/*checkout*/trunk/pgadmin3/pkg/mac/complete-bundle.sh?rev=5055

trying ...
nope.  replacing with r5055, same error.

have YOU attempted a build agains wx2.6.3 release? .3, NOT .2 ?

> Regards, Dave (off to bed shortly - sorry!! )

np. g'nite.

r/

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (Darwin)

iEYEAREDAAYFAkQsd/oACgkQlffdvTZxCMYGPwCfTnbjT72eWRVOUPI3pBDS024d
TMkAnA71YicpFeKr3p0gMVupCGyDWOVh
=5M37
-END PGP SIGNATURE-


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

Re: [pgadmin-hackers] r5067 + wx563 crash on osx 10.4.5

[OpenMacNews]

.dylib (compatibility version 7.0.0, current
version 7.3.0)
/usr/lib/libgcc_s.1.dylib (compatibility version 1.0.0, current version
1.0.0)

> On Windows, similar errors can be seen if the library is present, but
> one of it's dependencies is not which prevents it being loaded. I wonder
> if that is what you are seeing. Come to think of it, are you sure your
> libwx_macu_stc-2.6.0.dylib is from 2.6.3 (I believe the version number
> in the filename is supposed to be 2.6.0 whatever the 'real' version is)?

yup.

deleted prior wx installs, started w/ fresh pgadmin ... and rebuilt this
morn.

note the 'ls -al' output's date:  Mar 30 10:36

...

richard
- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (Darwin)

iEUEAREDAAYFAkQsRkcACgkQlffdvTZxCMY+gQCYo8hDVLmxuNIVgbVsn/LhCwVP
/wCdHcHlw+W7RBg0zIWEkD/duKyv2PA=
=5pEX
-END PGP SIGNATURE-


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

   http://archives.postgresql.org

Re: [pgadmin-hackers] r5067 + wx563 crash on osx 10.4.5

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

> No, it's getting there - this is the third copy I've seen I think :-)
> The archives can take a couple o hours to catch up.
> 
> I have flagged the message, just haven't got there yet.


then, my apologies to the list!
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (Darwin)

iEYEAREDAAYFAkQsN74ACgkQlffdvTZxCMakvACcDkNvOeeW9oIOGJMVNc2/iKpT
/vcAoL7Lp/LSpYzrMqb6/Pqp2SKvvN/3
=P5Lj
-END PGP SIGNATURE-


---(end of broadcast)---
TIP 1: 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] r5067 + wx563 crash on osx 10.4.5

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

(hi dave.  i keep getting stalled list post notices, and don't see this
in the archive.  don't know if i've fubar'd something (prob'ly) ...
resubscribing now.  in the meantime, direct send to you as well.  r/)

hi all.

bldg pgadmin head r5067 against latest wx-v2.6.3 release, build complete
w/o apparent error.


on launch, however, app crashes.  CrashReport is:


**

Host Name:  devserver
Date/Time:  2006-03-30 10:37:46.142 -0800
OS Version: 10.4.5 (Build 8H14)
Report Version: 4

Command: pgAdmin3
Path:/Volumes/Develop/DB Tools/pgAdmin3.app/Contents/MacOS/pgAdmin3
Parent:  WindowServer [124]

Version: 1.5 (1.5.0)

PID:14058
Thread: Unknown

Link (dyld) error:

Library not loaded:
@executable_path/Contents/Frameworks/libwx_macu-2.6.0.dylib
  Referenced from: /Volumes/Develop/DB
Tools/pgAdmin3.app/Contents/MacOS/../../Contents/Frameworks/libwx_macu_stc-2.6.0.dylib
  Reason: image not found




but, checking:

% ls -al "/Volumes/Develop/DB
Tools/pgAdmin3.app/Contents/MacOS/../../Contents/Frameworks/libwx_macu_stc-2.6.0.dylib"

-rwxr-xr-x 1 root staff 1138324 Mar 30 10:36 /Volumes/Develop/DB
Tools/pgAdmin3.app/Contents/MacOS/../../Contents/Frameworks/libwx_macu_stc-2.6.0.dylib

and,

% ls -al "/Volumes/Develop/DB
Tools/pgAdmin3.app/Contents/MacOS/../../Contents/Frameworks/libwx_macu-2.6.0.dylib"

-rwxr-xr-x 1 root staff 6769384 Mar 30 10:36 /Volumes/Develop/DB
Tools/pgAdmin3.app/Contents/MacOS/../../Contents/Frameworks/libwx_macu-2.6.0.dylib

the sought lib *does* exist.

cheers,

richard
- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (Darwin)

iEYEAREDAAYFAkQsNrIACgkQlffdvTZxCMbyUwCdH9BiYyjIBoeIa7hB6NJUovMl
aXAAoKRPn+85VRZGaUH50uUuJJBmBQP0
=FRJS
-END PGP SIGNATURE-


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

[pgadmin-hackers] r5067 + wx563 crash on osx 10.4.5

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi all.

bldg pgadmin head r5067 against latest wx-v2.6.3 release, build complete
w/o apparent error.


on launch, however, app crashes.  CrashReport is:


**

Host Name:  devserver
Date/Time:  2006-03-30 10:37:46.142 -0800
OS Version: 10.4.5 (Build 8H14)
Report Version: 4

Command: pgAdmin3
Path:/Volumes/Develop/DB Tools/pgAdmin3.app/Contents/MacOS/pgAdmin3
Parent:  WindowServer [124]

Version: 1.5 (1.5.0)

PID:14058
Thread: Unknown

Link (dyld) error:

Library not loaded:
@executable_path/Contents/Frameworks/libwx_macu-2.6.0.dylib
  Referenced from: /Volumes/Develop/DB
Tools/pgAdmin3.app/Contents/MacOS/../../Contents/Frameworks/libwx_macu_stc-2.6.0.dylib
  Reason: image not found




but, checking:

% ls -al "/Volumes/Develop/DB
Tools/pgAdmin3.app/Contents/MacOS/../../Contents/Frameworks/libwx_macu_stc-2.6.0.dylib"

-rwxr-xr-x 1 root staff 1138324 Mar 30 10:36 /Volumes/Develop/DB
Tools/pgAdmin3.app/Contents/MacOS/../../Contents/Frameworks/libwx_macu_stc-2.6.0.dylib

and,

% ls -al "/Volumes/Develop/DB
Tools/pgAdmin3.app/Contents/MacOS/../../Contents/Frameworks/libwx_macu-2.6.0.dylib"

-rwxr-xr-x 1 root staff 6769384 Mar 30 10:36 /Volumes/Develop/DB
Tools/pgAdmin3.app/Contents/MacOS/../../Contents/Frameworks/libwx_macu-2.6.0.dylib

the sought lib *does* exist.

cheers,

richard
- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (Darwin)

iEYEAREDAAYFAkQsJ74ACgkQlffdvTZxCMaZVQCeJyQtVac09WEl5cd6DzStFh+e
3UAAn2MGv+gJCFP0elo6Lvm/YZ/+W9IQ
=34Ry
-END PGP SIGNATURE-


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

   http://archives.postgresql.org

Re: [pgadmin-hackers] SVN Commit by dpage: r5054 - trunk/pgadmin3/pkg/win32

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

> [Don't hijack threads]

eek. sorry.  it was 1 am.  i was asleep. :-S

> Err, dunno - no Mac to hand atm. It *shouldn't* have changed - can you
> see anything obvious in the source?

i'll take a look ... as well as browse wx list.  i'll let you know ...
in a new thread!

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (Darwin)

iEYEAREDAAYFAkQW/MYACgkQlffdvTZxCMbN/ACeJxdBTaKe7gPLWsHVyBSuSDAz
LMYAn0IbMfG/VNN+pGZMG1qtRo638xqJ
=j+qr
-END PGP SIGNATURE-


---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [pgadmin-hackers] SVN Commit by dpage: r5054 - trunk/pgadmin3/pkg/win32

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi all,

just built up r5053 on OSX ... wha' happen'd to the "Quit ..." menu
item?  greyed out and non-functional ... though closing the main window
now quits the app.

richard

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (Darwin)

iEYEAREDAAYFAkQWggwACgkQlffdvTZxCMbj0gCgoPUL0an6NXADHfKw7nAevu1A
o18AoKwyT0+Kvf2J77fkddo4AlpICYq8
=+E/b
-END PGP SIGNATURE-


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

Re: [pgadmin-hackers] Buildproblems on OSX 10.3 due to libxml2

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi,

> Thanks for that. Given the fun I¹ve had getting it to work, I¹ve 
> decided not
> to change the bootstrap script at the moment, to avoid causing others 
> the
> same pain. I have added AC_PROG_LIBTOOL to configure.ac.in (yes, I 
> know you
> say you don¹t need it at the moment, but it won¹t hurt as far as I¹m 
> aware)
> as well as the automake Rforeign¹ option in Makefile.am which will 
> hopefully
> help anyone who prefers to use autoreconf as you do. Please let me 
> know if
> there¹s anything else that might help without breaking the bootstrap.

i hear you; thx for your time/effort! :-)

_but_ ... just to be clear:

the point of my last post was that it worked w/o problem ... autoconf
did not break the bootstrap, or the build/execute.

at the moment, a fresh 'rinse-n-repeat' w/ r5036 + a (the?)
autoreconf-mod to bootstrap is exec'ing just fine.

true, not a hugely important issue ... but i do not-so-rhetorically
wonder alound -- if (and it's an unclear "if", i know) Darwinports has
introduced some complicating artifacts, what's to say that there aren't
others ...

which is why i've voted with my feet to avoid Darwinports.

NOT my intent to start any sort of flamewar ... just raising a point to
consider.

cheers,

richard

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.1 (Darwin)

iEYEAREDAAYFAkQExIQACgkQlffdvTZxCMaLNQCglM+kXnXLWucxHAG7tfGWLpHh
DH4AnA1Ts3XAxGqUZROXdximRtWm8tA+
=Mcdm
-END PGP SIGNATURE-


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

Re: [pgadmin-hackers] Buildproblems on OSX 10.3 due to libxml2

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

dave,

fwiw, starting w/ r5035

noting that you've removed AC_PROG_RANLIB from configure.ac.in, i don't
replace/add AC_PROG_LIBTOOL.

mod'ing "bootstrap":

=
${EDITOR} /usr/ports/pgadmin3/pgadmin3dyn_wxdyn_262/bootstrap

set -x
if ! ([ -x config ]); then
  mkdir config
fi
- ---   aclocal-1.9 && \
- ---   autoheader && \
- ---   automake-1.9 --foreign --add-missing --copy && \
- ---   autoconf
+++ AUTOMAKE='automake --foreign' autoreconf --force --install --verbose
=

remembering that, on my OSX:

% echo $LIBTOOLIZE
glibtoolize

% which glibtoolize
/usr/local/bin/glibtoolize

then, exec'ing reports:

% sh bootstrap
...
...
/usr/local/share/aclocal-1.9/libmcrypt.m4:17: warning: underquoted
definition of AM_PATH_LIBMCRYPT
  run info '(automake)Extending aclocal'
  or see 
http://sources.redhat.com/automake/automake.html#Extending-aclocal
/usr/local/share/aclocal/libmcrypt.m4:17: warning: underquoted
definition of AM_PATH_LIBMCRYPT
...
...
%

which given:

% aclocal --version
aclocal (GNU automake) 1.9.6

and per cref:

http://tinyurl.com/lbldu

mod'ing:

=
${EDITOR} /usr/local/share/aclocal-1.9/libmcrypt.m4
@17
- ---   AC_DEFUN(AM_PATH_LIBMCRYPT,
+++ AC_DEFUN([AM_PATH_LIBMCRYPT],
=

then, trying again:

% rm -rf config/
% sh bootstrap
autoreconf: Entering directory `.'
autoreconf: configure.ac: not using Gettext
autoreconf: running: aclocal --force
autoreconf: configure.ac: tracing
autoreconf: configure.ac: not using Libtool
autoreconf: running: /usr/local/bin/autoconf --force
autoreconf: running: /usr/local/bin/autoheader --force
autoreconf: running: automake --foreign --add-missing --copy
- --force-missing
configure.ac: installing `config/install-sh'
configure.ac: installing `config/missing'
src/Makefile.am: installing `config/depcomp'
configure.ac:8: installing `config/config.guess'
configure.ac:8: installing `config/config.sub'
autoreconf: Leaving directory `.'
%

which looks 'clean'.

continuing on, as before with:

./configure ...
make
make all-recursive
make install

i see *no* errors, and get the expected:

- -rwxr-xr-x 1 root admin 4865988 Feb 27 19:21
/usr/ports/pgadmin3/pgadmin3dyn_wxdyn_262/pgAdmin3.app/Contents/MacOS/pgAdmin3

which launches/functions ok.

hth,

richard

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.1 (Darwin)

iEYEAREDAAYFAkQDw8oACgkQlffdvTZxCMZntACeJkIcgg0XjnlPvnGndDAyAoc2
cqMAoI1RULRsNoA/dW/JBqyIcUJlGLz7
=a6gu
-END PGP SIGNATURE-


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

   http://archives.postgresql.org

Re: [pgadmin-hackers] Buildproblems on OSX 10.3 due to libxml2

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi,

>> (doncha jus LUV autotools!)
>
> Err, nope.

heh

>> on my sys,
>>
>> % ls -al /usr/local/share/autoconf/Autom4te/FileUtils.pm
>>   -rw-r--r-- 1 root wheel 6670 Oct 22 22:51 FileUtils.pm
>
> No, it's in /opt/local/share/autoconf/Autom4te.
>
>> are you sure your FileUtils.pm is *in* your perl @INC path?
>
> No, it's not. It wouldn't be if it were in /usr/local/ either. From what I
> can gather that is compiled into perl?

can be.  fwiw, e.g., my perl build explicitly specifies ...

./Configure \
- -Dfirstmakefile='GNUmakefile' \
- -Dprefix='/usr/local/perl5' \
- -Dperladmin='[EMAIL PROTECTED]' \
- -Dcf_email='[EMAIL PROTECTED]' \
- -Dloclibpth='/usr/local/berkeley-db/lib /usr/local/lib /usr/lib' \
- -Dlocincpth='/usr/local/berkeley-db/include /usr/local/include
/usr/include' \
- -Dldflags='-L/usr/local/berkeley-db/lib -L/usr/local/lib -L/usr/lib' \
- -Dperllibs='-ldb -lc -lm -ldl' \
- -Dlibs='-ldb -lc -lm -ldl' \
- -Dprivlib='/usr/local/perl_libs/privlib' \
- -Darchlib='/usr/local/perl_libs/privlib/darwin-thread-multi-2level' \
- -Dsitelib='/usr/local/perl_libs/sitelib' \
- -Dsitearch='/usr/local/perl_libs/sitelib/darwin-thread-multi-2level' \
- -Dvendorlib='/usr/local/perl_libs/vendorlib' \
- -Dvendorarch='/usr/local/perl_libs/vendorlib/darwin-thread-multi-2level' \
- -Dvendorbin='/usr/local/perl_libs/bin' \
- -Dvendorprefix='/usr/local/perl_libs' \
 -Dhtml1dir='/var/Documentation/html/Perl' \
 -Dhtml3dir='/var/Documentation/html/Perl' \
 -Dsitehtml1='/var/Documentation/html/Perl' \
 -Dsitehtml3='/var/Documentation/html/Perl' \
 -Dvendorhtml1='/var/Documentation/html/Perl' \
 -Dvendorhtml3='/var/Documentation/html/Perl' \
 -Dman1dir='/var/Documentation/man/man1' \
 -Dman3dir='/var/Documentation/man/man3' \
 -Dsiteman1dir='/var/Documentation/man/man1' \
 -Dsiteman3dir='/var/Documentation/man/man3' \
 -Dman1ext=1 \
 -Dman3ext=3 \
 -Dinstallusrbinperl \
 -Duseshrplib \
 -Duseperlio \
 -Duseithreads

 which results in:

% perl -V
...
  @INC:
/usr/local/perl_libs/privlib/darwin-thread-multi-2level
/usr/local/perl_libs/privlib
/usr/local/perl_libs/sitelib/darwin-thread-multi-2level
/usr/local/perl_libs/sitelib
/usr/local/perl_libs/sitelib
/usr/local/perl_libs/vendorlib/darwin-thread-multi-2level
/usr/local/perl_libs/vendorlib
/usr/local/perl_libs/vendorlib


can also be changed otherwise ...

http://developer.apple.com/internet/opensource/perl.html

>> also, did you 'roll your own' autotools & libtool, or install from rpm?
>>  i've built mine from src, so know where everything goes on OSX ...
>> dunno abt rpm installs.
>
> It's from DarwinPorts

ouch.  then i dunno.  i avoid it like the plague ... sorry.

>> also, run "locate.updatedb" and look for libtoolize ... is it in your
>> exec $PATH?
>
> raptor:~ root# locate libtoolize
> /private/opt/local/bin/glibtoolize
>
/private/opt/local/var/db/dports/software/libtool/1.5.20_0/opt/local/bin/glb
> toolize
> /usr/bin/glibtoolize
>
> Adding a symlink to /usr/bin/glibtoolize actually allows autoreconf to
work
> without any errors, but to be honest, I somewhat dubious about
changing the
> existing bootstrap script given the fun I've just have (between other
work -
> I have been doing other things!!)

agreed.  imho, the script should NOT be made to depend on NON-standard
paths.

all my 'stuff' is generally installed in '/usr/local', which *is*
included in OSX's autosearch path to PRECEDE /usr/local.

obviously, darwinports installs elsewhere ... without explicit path
mgmt, and/or links, you'll be SOL. :-(

>> on my box its:
>>
>> % ls -al /usr/local/bin/*libtool*
>>   -rwxr-xr-x 1 root wheel 217609 Feb 10 11:10 /usr/local/bin/glibtool
>>   -rwxr-xr-x 1 root wheel  10775 Feb 10 11:10 /usr/local/bin/glibtoolize
>>
>> NOTE: of course, on OSX, libtoolXXX is sed'd to glibtoolXXX, as ther is
>> an Apple-spec'd libtool which has other function.
>
> Hmm.
>
>> if/when you find it, what's
>>
>> % libtoolize --version
>>
>> report?
>
> raptor:~ root# libtoolize --version
> libtoolize (GNU libtool) 1.5
>
> Cheers, Dave
>

actually i don't handle libtoolize with a link ... rather, per e.g: 

http://homepage.mac.com/david.pugh/FirebirdOSX/BuildFirebirdOnOSX.html
(i can't remember/find the 'mother' reference)

set the ENV:

which glibtoolize
/usr/

Re: [pgadmin-hackers] Buildproblems on OSX 10.3 due to libxml2

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi,

>> as i don't have your script/changes available, i'll venture a guess --
> Sorry - added:
> 
> AC_PROG_LIBTOOL
> 
> To configure.ac.in, and
> 
> AUTOMAKE_OPTIONS = foreign
> 
> To Makefile.am. Then changed the bootstrap script to call autoreconf -i
> instead of each individual script.

hmm ... looks ok on the surface. but, to be fair, depends on all the
dependencies (doncha jus LUV autotools!)

> I just upgraded to:
> 
> raptor:~/pgadmin3 dpage$ glibtool --version
> ltmain.sh (GNU libtool) 1.5 (1.1220.2.1 2003/04/14 22:48:00)
> 
> Now though, I get: 
> 
> raptor:~/pgadmin3 dpage$ sh bootstrap
> + '[' -x config ']'
> + autoreconf -i
> Can't exec "libtoolize": No such file or directory at
> /opt/local/share/autoconf/Autom4te/FileUtils.pm line 288,  line 4.
> autoreconf: failed to run libtoolize: No such file or directory

??? hrm.

1st,

on my sys,

% ls -al /usr/local/share/autoconf/Autom4te/FileUtils.pm
  -rw-r--r-- 1 root wheel 6670 Oct 22 22:51 FileUtils.pm

are you sure your FileUtils.pm is *in* your perl @INC path?

also, did you 'roll your own' autotools & libtool, or install from rpm?
 i've built mine from src, so know where everything goes on OSX ...
dunno abt rpm installs.

also, run "locate.updatedb" and look for libtoolize ... is it in your
exec $PATH?

on my box its:

% ls -al /usr/local/bin/*libtool*
  -rwxr-xr-x 1 root wheel 217609 Feb 10 11:10 /usr/local/bin/glibtool
  -rwxr-xr-x 1 root wheel  10775 Feb 10 11:10 /usr/local/bin/glibtoolize

NOTE: of course, on OSX, libtoolXXX is sed'd to glibtoolXXX, as ther is
an Apple-spec'd libtool which has other function.

if/when you find it, what's

% libtoolize --version

report?


- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.1 (Darwin)

iEYEAREDAAYFAkQDdc8ACgkQlffdvTZxCMbF/ACfWMo3OFcC06alDQNS8DblHY+l
G0wAoKKtenpKQphdi1hc8URWmdR00muf
=d7qT
-END PGP SIGNATURE-


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

   http://www.postgresql.org/docs/faq

Re: [pgadmin-hackers] Buildproblems on OSX 10.3 due to libxml2

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

> Hmm, OK. Well, I¹ve been playing with autoreconf, and having eventually
> figured out how to get it to run automake in ?-foreign mode, I¹m now stuck
> with it complaining about the macro I queried in the first place:
> 
> raptor:~/pgadmin3 dpage$ sh bootstrap
> configure.ac:17: error: possibly undefined macro: AC_PROG_LIBTOOL
>   If this token and others are legitimate, please use m4_pattern_allow.
>   See the Autoconf documentation.
> autoreconf: /opt/local/bin/autoconf failed with exit status: 1
> 
> I also have upgraded autoconf/automake ­ 2.59 and 1.9.6 respectively. Any
> ideas? I¹m a tad short of time to investigate atm.

as i don't have your script/changes available, i'll venture a guess --

last i saw this was a few version of libtool ago ... don't remember
specifically which.

what version of libtool are you running?

again, mine is:

% glibtool --version
  ltmain.sh (GNU libtool) 1.5.22 (1.1220.2.365 2005/12/18 22:14:06)

richard

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.1 (Darwin)

iEYEAREDAAYFAkQDaHIACgkQlffdvTZxCMa9MgCdHjIJaPfAgTUZpBzC7ApTysNA
mqAAn0nM/ejieykO4/BRkGmkh9kwxW1r
=Dz6Z
-END PGP SIGNATURE-


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

Re: [pgadmin-hackers] Buildproblems on OSX 10.3 due to libxml2

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

> Which is what the line:
> 
> automake-1.9 --foreign --add-missing --copy
> 
> in the bootstrap script does.

hmmm ... cref:
http://www.gnu.org/software/automake/manual/html_mono/automake.html

"People upgrading old packages to newer autotools are likely to face
this issue because older Automake versions used to call libtoolize.
Therefore old build scripts do not call libtoolize.

Since Automake 1.6, it has been decided that running libtoolize was none
of Automake's business. Instead, that functionality has been moved into
the autoreconf command (see Using autoreconf). If you do not want to
remember what to run and when, just learn the autoreconf command.
Hopefully, replacing existing bootstrap.sh or autogen.sh scripts by a
call to autoreconf should also free you from any similar incompatible
change in the future.

and since, on my system:

% automake --version
automake (GNU automake) 1.9.6

and on stock Tiger,

% /usr/bin/automake --version
automake (GNU automake) 1.6.3

also, just fyi, as for the use of 'traditional' bootstrap scripts, cref
@ http://sources.redhat.com/automake/automake.html:


"Many packages come with a script called bootstrap.sh or autogen.sh,
that will just call aclocal, libtoolize, gettextize or autopoint,
autoconf, autoheader, and automake in the right order. Actually this is
precisely what autoreconf can do for you. If your package has such a
bootstrap.sh or autogen.sh script, consider using autoreconf. That
should simplify its logic a lot (less things to maintain, yum!), it's
even likely you will not need the script anymore, and more to the point
you will not call aclocal directly anymore."

richard

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.1 (Darwin)

iEYEAREDAAYFAkQDM8gACgkQlffdvTZxCMZxXQCgmMCfr3hHKY61fx3tPv6TA+V5
MTUAoLBZY2wqmOoJ+wgcs7py3klemhQ/
=HKjC
-END PGP SIGNATURE-


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

Re: [pgadmin-hackers] Buildproblems on OSX 10.3 due to libxml2

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

On 2/27/06 Dave Page wrote:
> OK, you'll have to excuse my bumbling ignorance when it comes to all
> things automake/autoconf - why are you running glibtoolize in the
> pgAdmin source directory? The bootstrap script does everything that's
> required from a clean SVN checkout, and is also sufficient to rebuild
> things if you change anything.

de nada.

simply because you don't call it.

per my earlier post, my invocation is:

glibtoolize --force --copy

which will update the files you've provided in ./config/, namely:

config.guess  config.sub  depcomp  install-sh  ltmain.sh  missing

to be up-to-date with my libtool installation's, which currently is:

% glibtool --version
ltmain.sh (GNU libtool) 1.5.22 (1.1220.2.365 2005/12/18 22:14:06)

whereas what Tiger/XCode2x ships, is a rather dated:

% /usr/bin/glibtool --version
ltmain.sh (GNU libtool) 1.5 (1.1220 2003/04/05 19:32:58)

i presume (without admittedly checking) that you're building with
'stock' Tiger/XCode libs/tools ...

as libtool version issues have -- always annoyingly, often destructively
- -- cropped up for me MANY times, as a rule i always keep all my builds
in synch.

if the glibtoolization *breaks* something, it's usually a flag for me to
 watch out for other issues ...

richard
- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.1 (Darwin)

iEYEAREDAAYFAkQDLWgACgkQlffdvTZxCMa4DQCfZrA95oErvZ7hY9vR/HmX3df3
+gQAn0KXI2ITLNAdHmUJBsAWGSUI4oZ+
=pGY9
-END PGP SIGNATURE-


---(end of broadcast)---
TIP 1: 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] Buildproblems on OSX 10.3 due to libxml2

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

> Why's it even being called? We don't create any libraries at all (and I
> never saw any warnings about it on Tiger, or back when I was running
> Panther).

well, glibtoolize is being called cuz i'm calling it ... as i typically
do given that i've a rather up-to-date env.  just cleaning house, as it
were.

as for why glibtoolize is 'calling' AC_PROG_LIBTOOL, that's to be found
in libtool.m4:

% grep AC_PROG_LIBTOOL /usr/local/lib/aclocal/libtool.m4
# serial 48 AC_PROG_LIBTOOL
# AC_PROG_LIBTOOL
AC_DEFUN([AC_PROG_LIBTOOL],
[AC_REQUIRE([_AC_PROG_LIBTOOL])dnl
])])# AC_PROG_LIBTOOL
# _AC_PROG_LIBTOOL
AC_DEFUN([_AC_PROG_LIBTOOL],
define([AC_PROG_LIBTOOL], [])
])# _AC_PROG_LIBTOOL
# In the future, this macro may have to be called after AC_PROG_LIBTOOL.
AC_DEFUN([AM_PROG_LIBTOOL],   [AC_PROG_LIBTOOL])

which, of course is invoked by glibtoolize ...

cheers,

richard
- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.1 (Darwin)

iEYEAREDAAYFAkQDKEsACgkQlffdvTZxCMYdIACfRFx5dgwATMVmKOF72zvDMYUG
DL4AnRJnLq3ipj6WcEk1iphYCHzDnQlJ
=km7W
-END PGP SIGNATURE-


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

Re: [pgadmin-hackers] Buildproblems on OSX 10.3 due to libxml2

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

On 2/27/06 Dave Page wrote:
> Hmm, actually AC_PROG_RANLIB can go completely - I added that when I 
> was
> playing with the build system recently but then changed tactic, but
> obviously left that there. Similarly, I doubt you need AC_PROG_LIBTOOL
> in reality.
> 

fair nuf.  though without it, glibtoolize complains ... not fatally, fwiw.

richard

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.1 (Darwin)

iEYEAREDAAYFAkQDJJ0ACgkQlffdvTZxCMZQ2QCePI+gPBQLo2A3n3+LVxA3EQtl
Y9IAn13BTciIsaHDN82A+9UR/tsENQ8K
=hz1j
-END PGP SIGNATURE-


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

Re: [pgadmin-hackers] Buildproblems on OSX 10.3 due to libxml2

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi all,

just bouncing by :-) & thought i'd give the latest HEAD a try, and see
if i'm having any of (these) issues.

fwiw, i've installed my own libxml in /usr/local/lib

% which xml2-config
/usr/local/bin/xml2-config
% xml2-config --version
2.6.23
% xml2-config --libs
-L/usr/local/lib -lxml2 -L/usr/local/lib -lz -lpthread -liconv -lm

w/:

% uname -a
Darwin server 8.5.0 Darwin Kernel Version 8.5.0: Sun Jan 22 10:38:46
PST 2006; root:xnu-792.6.61.obj~1/RELEASE_PPC Power Macintosh powerpc

and a pgadmin3 (svn co r5031) build w/:

% setenv TARGET_DIR  "wxwidgets_262_dyn"
% setenv TARGET_INC  "2.6"
% setenv TARGET_INSTALL  "pgadmin3dyn_wxdyn_262"

% setenv CPPFLAGS"-I/usr/local/ssl/include
- -I/usr/local/${TARGET_DIR}/include/wx-${TARGET_INC} -I/usr/local/include"
% setenv LDFLAGS "-ldl -L/usr/local/ssl/lib -lssl -lcrypto
- -L/usr/local/${TARGET_DIR}/lib -L/usr/local/lib -lexpat -lpng -ljpeg
- -ltiff -lintl -lgettextlib -lz"

% cd /usr/ports/pgadmin3/${TARGET_INSTALL}

% gcc_select 4.0

=
${EDITOR} /usr/ports/pgadmin3/pgadmin3dyn_wxdyn_262/configure.ac.in

# Checks for libraries.
- ---   AC_PROG_RANLIB
+++ AC_PROG_LIBTOOL
=

% gcc_select 4.0
% setenv PATH "/usr/local/${TARGET_DIR}/bin:$PATH"
% glibtoolize --force --copy
% sh bootstrap

% ./configure \
- --enable-appbundle \
- --with-wx=/usr/local/${TARGET_DIR} \
- --with-wx-version=${TARGET_INC} \
- --with-wx-config=wx-config \
- --with-pgsql=/usr/local/pgsql \
- --with-pgsql-include=/usr/local/pgsql/include \
- --disable-debug

a first change i note is that i now (iirc, again?) *must* explicitly add:

--disable-static \

to the above config.  without it, configure dies at:

  Warning: No config found to match:
/usr/local/wxwidgets_262_dyn/bin/wx-config --static=yes --libs base
- --unicode=yes --debug=no --version=2.6
   in /usr/local/wxwidgets_262_dyn/lib/wx/config
  If you require this configuration, please install the desired
  library build.  If this is part of an automated configuration
  test and no other errors occur, you may safely ignore it.
  You may use wx-config --list to see all configs available in
  the default prefix.

checking wxWidgets in /usr/local/wxwidgets_262_dyn... failed
configure: error: Your wxWidgets installation cannot support pgAdmin in
the selected configuration. This may be because it was configured
without the --enable-unicode option, or the combination of
dynamic/static linking and debug/non-debug libraries selected did not
match any installed wxWidgets libraries.


that said/done, ./configure completes w/o error:

=
PostgreSQL directory:   /usr/local/pgsql
PostgreSQL pg_config binary:/usr/local/pgsql/bin/pg_config
PostgreSQL version: PostgreSQL 8.1.2

wxWidgets directory:/usr/local/wxwidgets_262_dyn
wxWidgets wx-config binary:
/usr/local/wxwidgets_262_dyn/bin/wx-config
wxWidgets version:  wxWidgets 2.6.2

Building a debug version of pgAdmin:No
Statically linking pgAdmin: No
Building a Mac OS X appbundle:  Yes
=

as do:

% make all
% make all-recursive

, resulting in a launchable binary.app:

% ls -al
/usr/ports/pgadmin3/${TARGET_INSTALL}/pgAdmin3.app/Contents/MacOS/pgAdmin3

-rwxr-xr-x 1 root admin 4865988 Feb 26 19:43
/usr/ports/pgadmin3/pgadmin3dyn_wxdyn_262/pgAdmin3.app/Contents/MacOS/pgAdmin3


% otool -L
/usr/ports/pgadmin3/${TARGET_INSTALL}/pgAdmin3.app/Contents/MacOS/pgAdmin3

/System/Library/Frameworks/QuickTime.framework/Versions/A/QuickTime
(compatibility version 1.0.0, current version 63.0.0)
/System/Library/Frameworks/IOKit.framework/Versions/A/IOKit
(compatibility version 1.0.0, current version 275.0.0)
/System/Library/Frameworks/Carbon.framework/Versions/A/Carbon
(compatibility version 2.0.0, current version 128.0.0)
/System/Library/Frameworks/Cocoa.framework/Versions/A/Cocoa
(compatibility version 1.0.0, current version 11.0.0)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current
version 88.1.5)
/usr/local/lib/libgettextlib-0.14.5.dylib (compatibility version 0.0.0,
current version 0.0.0)
/usr/local/lib/libintl.3.dylib (compatibility version 8.0.0, current
version 8.3.0)
/usr/local/lib/libpng.3.dylib (compatibility version 4.0.0, current
version 4.0.0)
/usr/local/lib/libtiff.3.dylib (compatibility version 11.0.0, current
version 11.4.0)
/usr/local/lib/libjpeg.

Re: [pgadmin-hackers] pgadmin3 + wx27head

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi dave,

>>> what's pgadmin3-head's current wx target?
>>>
>>> v262? or wx head, as well?
> 
> V2.6.2.
> 
>>> debating whether to jump to the hopefully > stable bunch o bug fixes in wx 
>>> head, or
>>> just wait for 263, and a supposedly
>>> concurrent move of support from pgadmin3?
> 
> We're not even thinking about 2.7/HEAD support atm. You might consider 
> pulling the tip of the 2.6 branch though.

ok. fair enuf.

fwiw, tho, it *did* build w/ wx27cvs ...


% ls -al pgAdmin3.app/Contents/MacOS/pgAdmin3
-rwxr-xr-x 1 root admin 4719108 Jan 18 13:36 
pgAdmin3.app/Contents/MacOS/pgAdmin3

% otool -L pgAdmin3.app/Contents/MacOS/pgAdmin3
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current 
version 88.1.2)
/usr/local/ssl/lib/libssl.0.9.7.dylib (compatibility version 0.9.0, 
current version 0.9.7)
/usr/local/ssl/lib/libcrypto.0.9.7.dylib (compatibility version 0.9.0, 
current version 0.9.7)
/usr/local/lib/libexpat.0.dylib (compatibility version 6.0.0, current 
version 6.0.0)
/usr/local/lib/libpng.3.dylib (compatibility version 4.0.0, current 
version 4.0.0)
/usr/local/lib/libjpeg.62.dylib (compatibility version 63.0.0, current 
version 63.0.0)
/usr/local/lib/libtiff.3.dylib (compatibility version 11.0.0, current 
version 11.4.0)
/usr/local/lib/libintl.3.dylib (compatibility version 8.0.0, current 
version 8.3.0)
/usr/local/lib/libgettextlib-0.14.5.dylib (compatibility version 0.0.0, 
current version 0.0.0)
/usr/local/lib/libz.1.dylib (compatibility version 1.0.0, current 
version 1.2.3)
/usr/local//pgsql/lib/libpq.4.dylib (compatibility version 4.0.0, 
current version 4.1.0)
/usr/local/lib/libpcre.0.dylib (compatibility version 1.0.0, current 
version 1.1.0)
/usr/local/lib/libSDL-1.2.0.dylib (compatibility version 8.0.0, current 
version 8.2.0)
/System/Library/Frameworks/QuickTime.framework/Versions/A/QuickTime 
(compatibility version
1.0.0, current version 63.0.0)
/System/Library/Frameworks/IOKit.framework/Versions/A/IOKit 
(compatibility version 1.0.0,
current version 275.0.0)
/System/Library/Frameworks/Carbon.framework/Versions/A/Carbon 
(compatibility version 2.0.0,
current version 128.0.0)
/System/Library/Frameworks/Cocoa.framework/Versions/A/Cocoa 
(compatibility version 1.0.0,
current version 11.0.0)
/usr/local/wxwidgets_cvs_dyn/lib/libwx_macu-2.7.0.dylib (compatibility 
version 1.0.0, current
version 1.0.0)
/usr/local/wxwidgets_cvs_dyn/lib/libwx_macu_stc-2.7.0.dylib 
(compatibility version 1.0.0,
current version 1.0.0)
/usr/local/wxwidgets_cvs_dyn/lib/libwx_macu_ogl-2.7.0.dylib 
(compatibility version 1.0.0,
current version 1.0.0)
/usr/lib/libstdc++.6.dylib (compatibility version 7.0.0, current 
version 7.3.0)
/usr/lib/libgcc_s.1.dylib (compatibility version 1.0.0, current version 
1.0.0)


and it does launch, i can connect to servers, etc etc.

have NOT run it thru its paces, tho ...

cheers,

richard

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEYEAREDAAYFAkPOtpQACgkQlffdvTZxCMYwngCeMlTqVtowP6EsCwL7vSlzeqSd
5u8AoLgFjXmAYyE+U+P8AGU2GFl48sb5
=y3Ts
-END PGP SIGNATURE-


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

   http://archives.postgresql.org

Re: [pgadmin-hackers] copying text from hints windows

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

dave,


>> not sure if this is a 'bug' or a 'feature' of wxwidgets ...
> 
> Definitely a bug in my book.


i was, again, vadim who replied to my msg with this tidbit ... i presume 
(hope?) he's aware that
it needs to be "fixed".

richard


- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEYEAREDAAYFAkPOc00ACgkQlffdvTZxCMZWPgCgkpBAohDNnifCCRL2Iov4HfVY
pdkAoLxK1568QTSY1jetMut+6wkyUxtl
=EV2K
-END PGP SIGNATURE-


---(end of broadcast)---
TIP 1: 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] copying text from hints windows

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi dave,

it seems that one *can* copy selected text from a hints window . just *not* 
with CMD-C, as
is 'standard' on OSX.

rather, one needs to use CONTROL-C.  works just fine.

not sure if this is a 'bug' or a 'feature' of wxwidgets ...

cheers,


richard

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEYEAREDAAYFAkPOcQYACgkQlffdvTZxCMbFnACeJMubKmlfu/fvFolHHuaq952b
i64AoLoM3F0NrWFlt0Yg9qnyrZhvr6Bo
=6HkB
-END PGP SIGNATURE-


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

Re: [pgadmin-hackers] uncopyable selection from hints window

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi dave,

it would seem that wx262 does, in fact, have some challenges w/ OSX's 
install_names:

http://lists.wxwidgets.org/cgi-bin/ezmlm-cgi?8:sss:86907:200601:ojcggikbjepjjjfmdnhf#b

which is why the samples/html/about/about.app was not launching ...

that said, in answer to your earlier question of whether the html samples run, 
exec'ing the
equiv "./about" from the command line *does* launch correctly, as do any/all of 
the other sample
apps i've tried.


now, of particular note, running the htmlctrl sample, selecting the text of the 
sample app is
possible, but *again* it can't be copied ...

i'll file this as well @ wx ...

richard

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEYEAREDAAYFAkPNpysACgkQlffdvTZxCMZXOACgvReulusRjOPrZKgUtSmyQgnv
QFIAoKopHpp7YrxUfzpOUSq4NiVDX4lO
=Jggt
-END PGP SIGNATURE-


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

Re: [pgadmin-hackers] can't open file '/var/root/.pgpass' ?

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi,

> OK, that's a little weird. What is $HOME set to? On my box it's
> /Users/dpage. 

% echo $HOME
  /Users/devuser

i.e., my normal, non-root user's DIR ...

> So it sounds like it's not writing the file properly. The function below is
> the one that figures out the filename. It would appear that it would most
> likely be wxStandardPaths that's getting it wrong if anything, but then it
> works fine for me.
> 
> wxString pgServer::passwordFilename()
> {
> wxStandardPaths stdp;
> wxString fname=stdp.GetUserConfigDir()
> #ifdef WIN32
> + wxT("\\postgresql");
> mkdir(fname.ToAscii());
> fname += wxT("\\pgpass.conf");
> 
> #else
> + wxT("/.pgpass");
> #endif
> 
> wxLogInfo(wxT("Using password file %s"), fname.c_str());return
> fname;
> } 

hrm ... nothing above looks odd.  if wxStandardPaths was broken, there'd be 
lots of *other*
problems as well, i'd think.

it's something else ... :-/

richard


- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEUEAREDAAYFAkPNayMACgkQlffdvTZxCMYZwQCYu3pC17exoeq4/tOe1uVaPmlG
+QCgpKl4YAfD/S+6So2zQsdOmQqLEk8=
=iFVe
-END PGP SIGNATURE-


---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [pgadmin-hackers] can't open file '/var/root/.pgpass' ?

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi dave,

> Oooh, 10.4.4? Updating, please stand by (yes, I did get a copy of Tiger
> for Christmas :-) ).

:-)

>> on connect to server, i now get a new error:
>>
>> can't open file '/var/root/.pgpass' (error 2: No such file or directory)
>>
>> is i dismiss/"OK", the error goes away, and the server opens.
> 
> You're logged into the GUI as root, or running from a command line?

neither.  launching the GUI by dubl-click from my 'normal (non-root)' user 
desktop ...

> Anyway, do you get this only when you opt to save the password?

hrm ... this time, on server connect i get:

"Error connecting to the server: fe_sendauth: no password supplied"

and, yes, it only seems to happen if i "store password" ...

richard

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEYEAREDAAYFAkPNZPoACgkQlffdvTZxCMbz5wCgxhv2B0sFn86ReVMaPjeEGHuw
IU4An2crWXfGD3AVTh/JVrdflBs/bOnu
=VvTV
-END PGP SIGNATURE-


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

[pgadmin-hackers] can't open file '/var/root/.pgpass' ?

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi,

just built up a new instance of pgadmin3-head against wx262 on osx 10.4.4.

on connect to server, i now get a new error:

can't open file '/var/root/.pgpass' (error 2: No such file or directory)

is i dismiss/"OK", the error goes away, and the server opens.

no other effect that i can tell ...

richard

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEYEAREDAAYFAkPNSmkACgkQlffdvTZxCMb19QCglW3jF1mas8A1ljmQNNj2v86S
L24AoIyUVTLXU/iVR0DEb1hHFawzdrmB
=p5VW
-END PGP SIGNATURE-


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

Re: [pgadmin-hackers] no copy from hints windows?

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi dave,

>> Link (dyld) error:
>>
>> Library not loaded: ../../../lib/libwx_macu-2.6.0.dylib
>>   Referenced from:
>> /usr/ports/wxwidgets/wxwidgets_262_dyn/macosx-build/samples/ht
> ml/help/help.app/Contents/MacOS/help
>>   Reason: image not found

> Rats, you're supposed to be sleeping so I can look at Mac stuff tonight
> when you wake up!

heh.

ok ... i'm awake now.  fixed , yes? ;-)

> I don't know how OSX hunts for .dylibs - on Linux it would need its path
> setup in /etc/ld.so.conf. You can also bung it it in the appbundle
> someplace - I imagine our create-bundle.sh script might give some clues
> on where it can be put. Or, try a static build of wx.

hmmm ... now that i'm sortof awake, the referencing is incorrect. cref pending 
msg here:

http://lists.wxwidgets.org/cgi-bin/ezmlm-cgi?8:mss:86885:200601:ojcggikbjepjjjfmdnhf

in the meantime, i'll keep poking around ...

> Failing that I'll have to try to look tonight when I have my Mac to
> hand. Which depends if my 23 month old son decides to go to be at a
> reaonable hour or not tonight.

well, if i didn't, *he* most certainly won't!  :-)

cheers,

richard


- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEYEAREDAAYFAkPNKd0ACgkQlffdvTZxCMaQxwCfW9B4p6e/5WgMoaF6JckSSL+O
/3EAoJJ/2lldh19QPmLKz5j5jBbBdpDh
=IUjR
-END PGP SIGNATURE-


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

   http://www.postgresql.org/docs/faq

Re: [pgadmin-hackers] no copy from hints windows?

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi dave,

> Does the wx HTML sample work ok on your machine?

hmmm  never built the sample app b4.

build goes w/o error, but on dubl-clik-finder-launch of any of the built

./samples/html/*.*.app

i get:

2006-01-17 01:15:28 -0800

Link (dyld) error:

Library not loaded: ../../../lib/libwx_macu-2.6.0.dylib
  Referenced from:
/usr/ports/wxwidgets/wxwidgets_262_dyn/macosx-build/samples/html/help/help.app/Contents/MacOS/help
  Reason: image not found


dunno what's missing here ...

richard

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEYEAREDAAYFAkPMtnEACgkQlffdvTZxCMYFuQCfa8mmO+NGVwzSWUkWgIbNfk9A
eAYAnjd6XiiE3ca26pD9tQep/toi9vk6
=OV5B
-END PGP SIGNATURE-


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

[pgadmin-hackers] missing server instrumentation?

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi,

i've pgadmin3 150/dev + pgsql812 on OSX 10.4.4.

when i create/open a new connection, the hints window pops up with a notice 
that:

"server lacks instrumentation functions"

now, per .../src/admin81/README.admin81, i've built/installed the admin tools. 
no errors.

i've also:

psql -q -f admin81.sql postgres username

and reloaded the server.

am i missing something in the build?

thx,

richard
- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEYEAREDAAYFAkPMfywACgkQlffdvTZxCMYISQCeM/UurqMaDF1t7mq7hbNMUTBd
QboAoJYfggkAiXDQefZEMM7DlLPLLjXv
=gjDQ
-END PGP SIGNATURE-


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

   http://www.postgresql.org/docs/faq

Re: [pgadmin-hackers] no copy from hints windows?

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi dave,

honestly dunno ... hence the "(and earlier?)".

but it should! ;-)

richard

Dave Page wrote:
> Hi Richard,
> 
> Did it ever work? Perhaps with an earlier wx version?
> 
> Regards, Dave.
> 
> -Original Message-
> From: "OpenMacNews"<[EMAIL PROTECTED]>
> Sent: 16/01/06 21:16:02
> To: "pgadmin-hackers@postgresql.org"
> Subject: [pgadmin-hackers] no copy from hints windows?
> 
> hi all,
> 
> w/ latest cvs (and earlier?) i can select text in hints windows, but not 
> 'copy' it ...
> 
> is this a bug or feature?
> 
> richard
> 

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



- -Unmodified Original Message-
- -BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi all,

w/ latest cvs (and earlier?) i can select text in hints windows, but not 'copy' 
it ...

is this a bug or feature?

richard

- - --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
- -BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEYEAREDAAYFAkPMDPgACgkQlffdvTZxCMZTUACgnLuyLnMSveeNzTdJkrcox9vK
GmkAn1Bm7uPncStWb32pD9c53Z0hpW1v
=Bunh
- -END PGP SIGNATURE-


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


- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEYEAREDAAYFAkPMHJQACgkQlffdvTZxCMarywCfbT+iTQfK3Sxf4ZBS/kzX7JU1
Q1oAnjxgAMNMbsdsJeJQW6GmQg37yEBl
=aRxU
-END PGP SIGNATURE-


---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

[pgadmin-hackers] no copy from hints windows?

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi all,

w/ latest cvs (and earlier?) i can select text in hints windows, but not 'copy' 
it ...

is this a bug or feature?

richard

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEYEAREDAAYFAkPMDPgACgkQlffdvTZxCMZTUACgnLuyLnMSveeNzTdJkrcox9vK
GmkAn1Bm7uPncStWb32pD9c53Z0hpW1v
=Bunh
-END PGP SIGNATURE-


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

[pgadmin-hackers] multiple site/db central backup with pitr using pgadmin3?

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi all.

just coming up to speed on the idea-basics, but thought i'd ask (*while* i rtfm 
...) if "it" can
be done in/with pgadmin3.

i've numerous boxes with pgsql instances, and the usual assortment of DBs/box.

backing up, til now, has been script-driven, each box being backed up 
separately ... but, now,
getting to be tedious/messy.

i'd like to back up to a central server, with version control.

from irc chat, sounds like the right way to do this is connect from local to 
remote, pg_dump
remote db to local disk over network, and implement "point in time recovery" 
(cref:
http://www.postgresql.org/docs/current/static/backup-online.html).

in principle, all doable via shell script ...

doable/automated via pgadmin3?

thoughts/comments?

thx!

richard

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 50C9 1C46 2F8F DE42 2EDB  D460 95F7 DDBD 3671 08C6
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEYEAREDAAYFAkN5mXEACgkQlffdvTZxCMY6wwCfQPHO3N32kTozSaHlU6WEwVPE
FOgAni2xtTqiy2c8QpDi9bRzflCsN7ze
=vo4+
-END PGP SIGNATURE-


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

   http://www.postgresql.org/docs/faq

Re: [pgadmin-hackers] Fatal Error: Mismatch ... C++ ABI ...

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

dave,

> i'll rebuild wx w/ gcc4 and report back if probs.

that was the problem.

all's well again with bld from latest head. thx!

now, for the life of me, HOW i ended up with a gcc33-built wxMac ...


richard

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 780A 5C81 D446 C616 B113  AA3A 9BF4 3736 88A5 678E
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEYEAREDAAYFAkNv3HMACgkQm/Q3NoilZ44i2ACgnAR2h8pk2TbV7JasORvPQrwa
VLkAn3RB8s/wNP2o9g84cpmLQ/4GmYWs
=s1Cd
-END PGP SIGNATURE-


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

Re: [pgadmin-hackers] Fatal Error: Mismatch ... C++ ABI ...

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi dave,

> A similar problem reported t'other day (on Suse Linux iirc) was caused by
> pgAdmin and wxWidgets being built with different compiler versions (note the
> ABI versions).

i'm 100% certain i've only used gcc version 4.0.0 for pgadmin ...

and checking for pgadmin ...

% grep "gcc version" config.log
gcc version 3.3 20030304 (Apple Computer, Inc. build 1809)

h  now why/how did that happen?

i'll rebuild wx w/ gcc4 and report back if probs.

thx!

richard

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 780A 5C81 D446 C616 B113  AA3A 9BF4 3736 88A5 678E
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEYEAREDAAYFAkNvtWkACgkQm/Q3NoilZ45hRwCfUIr8PEJWbntvC4gZ8bGrPLJK
Of8AnieeARkEHs3m7QuLWDHqMvi6qM97
=d182
-END PGP SIGNATURE-


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

[pgadmin-hackers] Fatal Error: Mismatch ... C++ ABI ...

[OpenMacNews]

-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

hi all.

with r4701, after src bld on osx 10.4.3, launch attempt results in @console:

Fatal Error: Mismatch between the program and library build versions detected.
The library used 2.6 (no debug,Unicode,compiler with C++ ABI 102,wx 
containers,compatible with 2.4),
and your program used 2.6 (no debug,Unicode,compiler with C++ ABI 1002,wx 
containers,compatible
with 2.4).

???

thx!

richard

- --

/"\
\ /  ASCII Ribbon Campaign
 X   against HTML email, vCards
/ \  & micro$oft attachments

[GPG] OpenMacNews at gmail dot com
fingerprint: 780A 5C81 D446 C616 B113  AA3A 9BF4 3736 88A5 678E
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (Darwin)

iEYEAREDAAYFAkNvq0MACgkQm/Q3NoilZ47tywCgjpLkdRU6gcgfU/uWiPSNrDB/
jrgAoIIEf/h+J9XXNBaVQcnp46GEf57z
=UIcz
-END PGP SIGNATURE-


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

Re: [pgadmin-hackers] trunk > r4326 vs 'suse' subdir on OSX 10.4.1

[OpenMacNews]

> Thanks, fixed


just fyi, w/ r4375, verified as fixed.

r


---(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] trunk > r4326 vs 'suse' subdir on OSX 10.4.1

[OpenMacNews]

hi,


Thanks, fixed - though the correct way is to add the makefile to the
list in configure.ac rather than your "stick your fingers in your ear
and shout 'lalalalala'" method of ignoring the problem.


heh.

i've got so many OTHER fires burning, 'lalalalala' was the fastest way to 
resolution ... no time to dig 'here' at the moment =)


richard

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

[pgadmin-hackers] trunk > r4326 vs 'suse' subdir on OSX 10.4.1

[OpenMacNews]

hi all,

pgadmin3-svn co trunk 4374 on OSX 10.4.1

currently dies at 'make' in subdir /suse ...

changing

   (EDITOR) pkg/Makefile.am
   ---  SUBDIRS = debian fc1 mac mandrake redhat slackware src suse win32
   +++  SUBDIRS = debian fc1 mac mandrake redhat slackware src win32

per:



something re: suse changed in r4326 when i wasn't looking ...

richard

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

Re: [pgadmin-hackers] FW: [pgadmin-support] mac osX edit table data

[OpenMacNews]

hi all,


I don't know if any of you are on the support list, hence this forward.
Could one of you find a few minutes to look at this please?


i no longer have a 10.3.9 box to check on ...

i'm typically working w/ truk on 10.4.1 -- but ca build up a v1.2.2 if still 
needed ..


richard

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

  http://www.postgresql.org/docs/faq

Re: [pgadmin-hackers] latest pgadmin3.app binary from svn ...

[OpenMacNews]

bah! tripod apparently TOS'd ( < 24 hrs!) me for posting pgadmin ...  :-E

use this link:

  



---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

[pgadmin-hackers] latest pgadmin3.app binary from svn ...

[OpenMacNews]

hi all,

for those interested in 'playing', i've UL'd a recent .app build of 
pgadmin3-svn (r4316) built on/for OSX 10.4.1, @:




for ref, build env details are below ...

cheers,

richard

p.s. if i was sloppy abt pkg'ing -- do let me know!

=
pgadmin3-svn r4316

	unsetenv CFLAGS CPPFLAGS CXX CXXFLAGS LDFLAGS LDDLFLAGS LD_PREBIND LC_ALL LANG 
LINGUAS

setenv CFLAGS "-no-cpp-precomp"
setenv CPPFLAGS "-I/usr/local/ssl/include"
	setenv LDFLAGS "-ldl -L/usr/local/ssl/lib -lssl -lcrypto -L/usr/local/lib 
-lexpat -lpng -ljpeg -ltiff -lintl -lgettextlib -lz"


cd /usr/ports/pgadmin3
sh bootstrap

./configure \
--enable-appbundle \
--with-wx=/usr/local/wxwidgets_cvs_dyn \
--with-wx-config=wx-config \
--with-pgsql=/usr/local/pgsql \
--with-pgsql-include=/usr/local/pgsql/include \
--disable-debug

(executable _manually stripped_, cuz auto-strip still duznt work ...)


wxwidgets-cvs (co'd 6/16/05 11:14:00)

../configure \
--prefix=/usr/local/wxwidgets_cvs_dyn \
--with-mac \
--enable-shared \
--disable-debug \
--enable-unicode \
--enable-intl \
--with-regex

w/: stc, ogl & gizmos


pgsql v8.0.3
	unsetenv CFLAGS CPPFLAGS CXX CXXFLAGS LDFLAGS LDDLFLAGS LD_PREBIND 
EXTRA_LDFLAGS EXTRA_LIBS LC_ALL LANG LINGUAS
	setenv CPPFLAGS "-I/usr/local/ssl/include 
-I/Library/Frameworks/Tcl.framework/Headers -I/usr/local/include"
	setenv LDFLAGS "-bind_at_load -ldl -L/usr/local/ssl/lib -lssl -lcrypto 
-F/Library/Frameworks -framework Tcl -L/usr/local/lib -lreadline"


glibtoolize --force --copy
aclocal -I config
autoconf

./configure \
  --prefix=/usr/local/pgsql \
--enable-shared --disable-static \
--disable-debug --enable-cassert \
--with-template=darwin \
--with-pgport=5432 \
--enable-thread-safety \
--with-maxbackends=1024 \
--with-perl \
--with-java \
--with-pam \
--with-python \
--with-rendezvous \
--with-openssl \
--with-includes="/usr/local/ssl/include /usr/local/include" \
--with-libraries="/usr/local/ssl/lib /usr/local/lib" \
--with-tcl \
--with-tclconfig=/Library/Frameworks/Tcl.framework \
--with-tkconfig=/Library/Frameworks/Tk.framework \
--enable-nls

libpng v1.2.8-config
libjpeg v6b
libtiff-cvs (co'd 5/20/05 01:01:32)
libreadline v5.0
tcl/tk v AquaBI-8.4.10.0
gettext v0.14.5
libz v1.2.2
openssl v0.9.7g
libexpat-cvs (co'd 5/19/05 08:54:31)

gcc powerpc-apple-darwin8-gcc-4.0.0 (GCC) 4.0.0 (Apple Computer, Inc. build 
5026)

glibtool ltmain.sh (GNU libtool) 1.5.18 (1.1220.2.245 2005/05/16 08:55:27)
automake (GNU automake) 1.9.5
autoconf (GNU Autoconf) 2.59


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

Re: [pgadmin-hackers] v1.3.0 dev?

[OpenMacNews]

hi,


also ... what project decisions have been made (if any) as to

(a) included libs?


Whatever is appropriate/needed. I think that's port dependent.


ok.

at the very least on OSX, i'm wondering abt:

   /usr/local/lib/libpng.dylib
   /usr/local/lib/libjpeg.dylib
   /usr/local/lib/libtiff.dylib

whick, afaik, are NOT bundled on/with OSX (unless they're hiding in some 
framework ...)


tho, i dunno how 'necessary' they are for pgadmin3 (it's been awhile ... iirc, 
i put them 'in' 4 a reason ...)


also, which ver of pgsql is built against/bundled, and with what config?  not 
sure if ver/config discrepancies with local install will be a prob ...



(b) specific version of wxwidgets?


I upgraded my laptop and developer.pgadmin.org to 2.6.1. Seeing as 2.6
is the stable release, I'd say we track the latest revision unless we
find specific problems. I don't want to go to 2.7.x when it's released
unless we really need to (their release numbering is like ours, where
odd numbers are development versions).


fair nuf.

fwiw, i'm building pgadmin3.dev against:

	cvs -d :pserver:[EMAIL PROTECTED]:/pack/cvsroots/wxwidgets co -d 
wxWidgets-cvs wxWidgets


which is still reporting after build:

/usr/local/wxwidgets_cvs_dyn/bin/wx-config --list
Default config is mac-unicode-release-2.6


richard

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

Re: [pgadmin-hackers] v1.3.0 dev?

[OpenMacNews]

hi,


what else has changed?  anything?


Nope. Untarred, chmod'ed, retarred. On Linux :-)


hmmm ...

just retried with the two 'vers' ... same issue.

odd.

neway, works now :-)

cheers,

r



---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

Re: [pgadmin-hackers] v1.3.0 dev?

[OpenMacNews]

hi dave,


no executable bit is set on the executable. whereas in _my_



That was probably my fault from when I converted the zip file Adam sent
me to a tar.bz2. I've repacked it with the exec bit set.


confirmed to work.


BUT, the "QUIT" menu item is completely disable (grayed out).



Do you know if that is a bug in 1.2.2, or a problem with Adam's build?


hmmm  the repkg'd ver's QuitMenuItem is, now, okay.

what else has changed?  anything?

richard

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

Re: [pgadmin-hackers] v1.3.0 dev?

[OpenMacNews]

hi,

also ... what project decisions have been made (if any) as to

(a) included libs?
(b) specific version of wxwidgets?

e.g.:

% ls -al /Users/dev/Desktop/pgAdmin3.app/Contents/Frameworks/
total 9288
drwxr-xr-x  13 dev wheel 442 Jun 10 01:02 .
drwxr-xr-x   7 dev wheel 238 Jun 10 01:02 ..
-rw-r--r--   1 dev wheel  103172 Jun  9 11:02 libpq.4.dylib
-rw-r--r--   1 dev wheel 1363848 Jun  9 11:02 libwx_base_carbonu-2.6.0.dylib
-rw-r--r--   1 dev wheel  229956 Jun  9 11:02 libwx_base_carbonu_net-2.6.0.dylib
-rw-r--r--   1 dev wheel  181632 Jun  9 11:02 libwx_base_carbonu_xml-2.6.0.dylib
-rw-r--r--   1 dev wheel  749824 Jun  9 11:02 libwx_macu_adv-2.6.0.dylib
-rw-r--r--   1 dev wheel 3985416 Jun  9 11:02 libwx_macu_core-2.6.0.dylib
-rw-r--r--   1 dev wheel  682012 Jun  9 11:02 libwx_macu_html-2.6.0.dylib
-rw-r--r--   1 dev wheel  446384 Jun  9 11:02 libwx_macu_ogl-2.6.0.dylib
-rw-r--r--   1 dev wheel  159032 Jun  9 11:02 libwx_macu_qa-2.6.0.dylib
-rw-r--r--   1 dev wheel  966596 Jun  9 11:02 libwx_macu_stc-2.6.0.dylib
-rw-r--r--   1 dev wheel  619180 Jun  9 11:02 libwx_macu_xrc-2.6.0.dylib

% ls -al /usr/ports/pgadmin3/pgadmin3dyn_wxdyn/pgAdmin3.app/Contents/Frameworks/
total 12148
drwxr-xr-x  21 root admin 714 Jun  8 19:38 .
drwxr-xr-x   7 root admin 238 Jun  8 19:37 ..
-r-xr-xr-x   1 root admin 1260132 Jun  8 19:38 libcrypto.0.9.7.dylib
-rwxr-xr-x   1 root admin  316916 Jun  8 19:38 libexpat.0.dylib
-rwxr-xr-x   1 root admin  217564 Jun  8 19:38 libgettextlib-0.14.4.dylib
-rw-r--r--   1 root admin  112144 Jun  8 19:38 libintl.3.dylib
-rwxr-xr-x   1 root admin  132312 Jun  8 19:38 libjpeg.62.dylib
-rwxr-xr-x   1 root admin  231380 Jun  8 19:38 libpng.3.dylib
-rwxr-xr-x   1 root admin  118392 Jun  8 19:38 libpq.4.dylib
-r-xr-xr-x   1 root admin  272484 Jun  8 19:38 libssl.0.9.7.dylib
-rwxr-xr-x   1 root admin  875944 Jun  8 19:38 libtiff.3.dylib
-rwxr-xr-x   1 root admin 1370500 Jun  8 19:38 libwx_base_carbonu-2.6.0.dylib
-rwxr-xr-x   1 root admin  225796 Jun  8 19:38 
libwx_base_carbonu_net-2.6.0.dylib
-rwxr-xr-x   1 root admin   56776 Jun  8 19:38 
libwx_base_carbonu_xml-2.6.0.dylib

-rwxr-xr-x   1 root admin  753784 Jun  8 19:38 libwx_macu_adv-2.6.0.dylib
-rwxr-xr-x   1 root admin 3502632 Jun  8 19:38 libwx_macu_core-2.6.0.dylib
-rwxr-xr-x   1 root admin  697248 Jun  8 19:38 libwx_macu_html-2.6.0.dylib
-rwxr-xr-x   1 root admin  450512 Jun  8 19:38 libwx_macu_ogl-2.6.0.dylib
-rwxr-xr-x   1 root admin  170328 Jun  8 19:38 libwx_macu_qa-2.6.0.dylib
-rwxr-xr-x   1 root admin  986272 Jun  8 19:38 libwx_macu_stc-2.6.0.dylib
-rwxr-xr-x   1 root admin  651164 Jun  8 19:38 libwx_macu_xrc-2.6.0.dylib


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

Re: [pgadmin-hackers] v1.3.0 dev?

[OpenMacNews]

hi dave,


Adam has stepped up and provided a buid :-). Could you try it out for us
please - its available from
http://developer.pgadmin.org/ftp/release/v1.2.2/osx/.

Cheers, Dave.


DL'd the 1.2.2 pkg.

will NOT launch from Finder o dubl-clik.  nothing.  no console or log entries.

exploring, i note:

   cd ~/Desktop/pgAdmin3.app/Contents/MacOS/
   total 2948
   drwxr-xr-x  3 dev wheel 102 Jun 10 01:02 .
   drwxr-xr-x  7 dev wheel 238 Jun 10 01:02 ..
   -rw-r--r--  1 dev wheel 3017464 Jun  9 11:02 pgAdmin3

no executable bit is set on the executable. whereas in _my_ local, dynamic 
1.3.dev buuild:


   cd /usr/ports/pgadmin3/pgadmin3dyn_wxdyn/pgAdmin3.app/Contents/MacOS/
   total 4228
   drwxr-xr-x  4 root admin 136 Jun  8 19:44 .
   -rwxr-xr-x  1 root admin 3874124 Jun  8 19:44 pgAdmin3
   -rwxr-xr-x  1 root admin  454404 Jun  8 19:38 pgagent
   drwxr-xr-x  7 root admin 238 Jun  8 19:37 ..


checking further:

   % open pgAdmin3

of course, nothing ...

   % chmod 755 pgAdmin3
   % open pgAdmin3

and there it is!

also, now, Finder dubl-clicking works, as well ...

the .app lauches OK, and at 1st glance appears (mostly) operational ...

BUT, the "QUIT" menu item is completely disable (grayed out).  only way out is 
a "Force Quit" fromn finder, or kill @ shell ...


richard

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

Re: [pgadmin-hackers] v1.3.0 dev?

[OpenMacNews]

hi dave,


is anyone dev'ing Mac ports these days?  haven't seen
anything from Florian in recent archive posts.


No, nor have I -


hmmm ... is it August in Europe? no, not yet ... ;-}


in fact I've been waiting for the 'official' 1.2.2 app
bundle before announcing it, but nothing :-(


i'd bundle, but my prereq tree is in a 'bit of a state of flux' at the moment 
...


richard

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

[pgadmin-hackers] v1.3.0 dev?

[OpenMacNews]

hi all,

as i'm building up a new box & revisiting my old notes, i'm wondering ... 
haven't seen much activity on 1.3.0 of late.


a pgadmin3 build on OSX 10.4.1, per a now 'dusty' post of mine, still does not 
auto-strip at install ...


is anyone dev'ing Mac ports these days?  haven't seen anything from Florian in 
recent archive posts.


cheers,

richard


---(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] configure doesn't find my pgsql installation

[OpenMacNews]

hi,


I am using Fedora4test3, the Gcc is 4.0, when I tried to compile the
pgadmin 1.2.2 source codes, I got the following errors by configure:

checking pgsql in /usr/lib/pgsql... failed
configure: error: you must specify a valid pgsql installation with
--with-pgsql=DIR

I changed the DIR to be /usr/share/pgsql and /usr/lib/pgsql, but the
errors still occured.

There is a post in the mailing list which fixed the bug, but in my
instance, it seems don't work.

Can anybody help me?


just a guess/hunch 

have you tried EXPLICITLY defining BOTH:

--with-pgsql-include=/usr/lib/pgsql
--with-pgsql-include=/usr/...path..to..wherever../pgsql/include


richard

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

  http://archives.postgresql.org

Re: [pgadmin-hackers] pgAgent usage string should be reviewed

[OpenMacNews]

hi raphael,


As an aside, you may have noticed that I've been working on
/xtra/pgagent/* recently - can you please take a look over the makefiles
under there and make sure the look OK (Florian in particular, for
obvious reasons)?


At least it builds and installs here.

~$ pgagent
Usage:
pgAgent INSTALL [options] 
options:
-t 
-r =10, default 30)>
-l 



since i'm already pokin' around in here ... fwiw, under OSX 10.4.1:

% ./pgAdmin3.app/Contents/MacOS/pgagent
   Usage:
   pgAgent INSTALL [options] 
   options:
   -t 
   -r =10, default 30)>
   -l 

% ls -al ./pgAdmin3.app/Contents/MacOS/pgagent
   -rwxr-xr-x  1 root admin 324376 May 21 11:00 pgagent

% otool -L ./pgAdmin3.app/Contents/MacOS/pgagent
   pgagent:
   /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current
   version 88.0.0) /usr/local/ssl/lib/libssl.0.9.7.dylib
   (compatibility version 0.9.0, current version 0.9.7)
   /usr/local/ssl/lib/libcrypto.0.9.7.dylib (compatibility version
   0.9.0, current version 0.9.7) /usr/local/lib/libexpat.0.dylib
   (compatibility version 6.0.0, current version 6.0.0)
   /usr/local/lib/libpng.3.dylib (compatibility version 3.0.0, current
   version 3.0.0) /usr/local/lib/libjpeg.62.dylib (compatibility
   version 63.0.0, current version 63.0.0)
   /usr/local/lib/libtiff.3.dylib (compatibility version 11.0.0,
   current version 11.2.0) /usr/local/lib/libintl.3.dylib
   (compatibility version 8.0.0, current version 8.3.0)
   /usr/local/lib/libgettextlib-0.14.4.dylib (compatibility version
   0.0.0, current version 0.0.0) /usr/lib/libz.1.dylib (compatibility
   version 1.0.0, current version 1.2.2)
   /usr/local/pgsql/lib/libpq.4.dylib (compatibility version 4.0.0,
   current version 4.0.0)
   /System/Library/Frameworks/QuickTime.framework/Versions/A/QuickTime
   (compatibility version 1.0.0, current version 47.0.0)
   /System/Library/Frameworks/IOKit.framework/Versions/A/IOKit
   (compatibility version 1.0.0, current version 271.0.0)
   /System/Library/Frameworks/Carbon.framework/Versions/A/Carbon
   (compatibility version 2.0.0, current version 128.0.0)
   /System/Library/Frameworks/Cocoa.framework/Versions/A/Cocoa
   (compatibility version 1.0.0, current version 11.0.0)
   /usr/local/wxwidgets_cvs_dyn/lib/libwx_macu_xrc-2.6.0.dylib
   (compatibility version 2.6.0, current version 2.6.0)
   /usr/local/wxwidgets_cvs_dyn/lib/libwx_macu_qa-2.6.0.dylib
   (compatibility version 2.6.0, current version 2.6.0)
   /usr/local/wxwidgets_cvs_dyn/lib/libwx_macu_html-2.6.0.dylib
   (compatibility version 2.6.0, current version 2.6.0)
   /usr/local/wxwidgets_cvs_dyn/lib/libwx_macu_adv-2.6.0.dylib
   (compatibility version 2.6.0, current version 2.6.0)
   /usr/local/wxwidgets_cvs_dyn/lib/libwx_macu_core-2.6.0.dylib
   (compatibility version 2.6.0, current version 2.6.0)
   /usr/local/wxwidgets_cvs_dyn/lib/libwx_base_carbonu_xml-2.6.0.dylib
   (compatibility version 2.6.0, current version 2.6.0)
   /usr/local/wxwidgets_cvs_dyn/lib/libwx_base_carbonu_net-2.6.0.dylib
   (compatibility version 2.6.0, current version 2.6.0)
   /usr/local/wxwidgets_cvs_dyn/lib/libwx_base_carbonu-2.6.0.dylib
   (compatibility version 2.6.0, current version 2.6.0)
   /usr/local/wxwidgets_cvs_dyn/lib/libwx_macu_stc-2.6.0.dylib
   (compatibility version 2.6.0, current version 2.6.0)
   /usr/local/wxwidgets_cvs_dyn/lib/libwx_macu_ogl-2.6.0.dylib
   (compatibility version 2.6.0, current version 2.6.0)
   /usr/lib/libstdc++.6.dylib (compatibility version 7.0.0, current
   version 7.3.0) /usr/lib/libgcc_s.1.dylib (compatibility version
   1.0.0, current version 1.0.0) /usr/lib/libmx.A.dylib (compatibility
   version 1.0.0, current version 92.0.0)


so, it seems the build (and hence the Makefile?) is OK ... as to fuction, i 
honestly dunno :-}


cheers,

richard

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

[pgadmin-hackers] PgAdmin3 on OSX 10.4.1 w/ gcc4

[OpenMacNews]

hi all,

well this took awhile (not including getting trapped in Yosemite flooding ...); 
userland Tiger is problem free (4 me), but DEV-space is a whole other issue ... 
lots of little prereq issues.  sigh.


anyway, short story:  PGADMIN3 builds ok as a OSX 10.4.1 appbundle using gcc 
4.0.  oe little 'gotcha' i the configure stmt kept me busy for awhile (see 
below).


but, now i have a dubl-clikable executable (again) ...


here are my details:


my ENV:

Mac OSX 10.4.1
TclTkAquaBI-8.4.9.1.dmg
Berkeley-DB v4.3.28 w/ strong crypto
% perl -V
Summary of my perl5 (revision 5 version 8 subversion 6) 
configuration:
  Platform:
osname=darwin, osvers=8.1.0, 
archname=darwin-thread-multi-2level
			uname='darwin devbox 8.1.0 darwin kernel version 8.1.0: tue may 10 18:16:08 
pdt 2005; root:xnu-792.1.5.obj~4release_ppc power macintosh powerpc '


Characteristics of this binary (from libperl):
		  Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES 
PERL_IMPLICIT_CONTEXT

  Built under darwin
  Compiled at May 18 2005 22:18:53
%gcc --version
		powerpc-apple-darwin8-gcc-4.0.0 (GCC) 4.0.0 20041026 (Apple Computer, Inc. 
build 4061)

% glibtool --version
ltmain.sh (GNU libtool) 1.5.18 (1.1220.2.245 2005/05/16 
08:55:27)
% automake --version
automake (GNU automake) 1.9.5
% autoconf --version
autoconf (GNU Autoconf) 2.59
% openssl version
OpenSSL 0.9.7g 11 Apr 2005
% postmaster --version
postmaster (PostgreSQL) 8.0.3

and, libreadline (v5.0) picked up from my external build:
	-r-xr-xr-x  1 root staff 416616 May 18 11:12 
/usr/local/lib/libreadline.5.0.dylib
	lrwxr-xr-x  1 root staff 21 May 18 11:12 /usr/local/lib/libreadline.dylib 
-> libreadline.5.0.dylib


rather than from Tiger's native link to libedit:
	lrwxr-xr-x  1 root wheel 13 May 10 09:40 /usr/lib/libreadline.dylib -> 
libedit.dylib



building a SHARED wxwidgets from cvs:

% login devbox (<-- NON-root user)
% cd /usr/ports/wxwidgets

@ 5/20/05 09:56:18

% cvs -d :pserver:[EMAIL PROTECTED]:/pack/cvsroots/wxwidgets login
% password: anoncvs
	% cvs -d :pserver:[EMAIL PROTECTED]:/pack/cvsroots/wxwidgets co -d 
wxwidgets_cvs_dyn wxWidgets


% sudo chown -R devbox:wheel /usr/ports/wxwidgets

% mkdir -p /usr/ports/wxwidgets/wxwidgets_cvs_dyn/macosx-build
% cd /usr/ports/wxwidgets/wxWidgets_cvs_dyn/macosx-build

	% unsetenv CFLAGS CPPFLAGS CXX CXXFLAGS LDFLAGS LDDLFLAGS LD_PREBIND LC_ALL 
LANG LINGUAS


% ../configure \
--prefix=/usr/local/wxwidgets_cvs_dyn \
--with-mac \
--enable-shared \
--disable-debug \
--enable-unicode \
--enable-intl \
--with-regex

% make
% sudo make install

% cd /usr/ports/wxwidgets/wxwidgets_cvs_dyn/macosx-build/contrib/src/stc
% make
% sudo make install

% cd /usr/ports/wxwidgets/wxwidgets_cvs_dyn/macosx-build/contrib/src/ogl
% make
% sudo make install

% cd 
/usr/ports/wxwidgets/wxwidgets_cvs_dyn/macosx-build/contrib/src/gizmos
% make
% sudo make install

successfully results in:

% /usr/local/wxwidgets_cvs_dyn/bin/wx-config --list
Default config is mac-unicode-release-static-2.6

% otool -L /usr/local/wxwidgets_cvs_dyn/bin/wxrc-2.6
wxrc-2.6:
/System/Library/Frameworks/QuickTime.framework/Versions/A/QuickTime 
(compatibility version 1.0.0, current version 47.0.0)
/System/Library/Frameworks/IOKit.framework/Versions/A/IOKit (compatibility 
version 1.0.0, current version 271.0.0)
/System/Library/Frameworks/Carbon.framework/Versions/A/Carbon 
(compatibility version 2.0.0, current version 128.0.0)
/System/Library/Frameworks/Cocoa.framework/Versions/A/Cocoa (compatibility 
version 1.0.0, current version 11.0.0)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 
88.0.0)
/usr/local/wxwidgets_cvs_dyn/lib/libwx_base_carbonu_xml-2.6.0.dylib 
(compatibility version 2.6.0, current version 2.6.0)
/usr/local/lib/libexpat.0.dylib (compatibility version 6.0.0, current 
version 6.0.0)
/usr/local/wxwidgets_cvs_dyn/lib/libwx_base_carbonu-2.6.0.dylib 
(compatibility version 2.6.0, current version 2.6.0)

/usr/lib/libz.1.dylib (compatibility version 
1.0.0, current version 1.2.2)
/usr/lib/libiconv.2.dylib (compatibility version 5.0.0, current version 
5.0.0)
/usr/lib/libstdc++.6.dylib (compatibility version 7.0.0, current version 
7.3.0)
/usr/lib/libgcc_s.1.dylib (compatibility version 1.0.0, current version 
1.0.0)

  

[pgadmin-hackers] (re)visiting pgadmin3 with-Cocoa on OSX 10.4?

[OpenMacNews]

hi all,
just wondering if there's been any more/recent thought/discussion re: pgadmin3 
on OSX w/ wxwidgets/wxmac built "with-Cocoa" rather than "with-Carbon" ...

i presume its not a trivial job ...
given that Apple now bundles wxwidgewts (albeit an older 2.4.x version, iirc) 
with OSX (>= Tiger), does anyone know if it's built with Cocoa or Carbon?  the 
bundled liibs are certainly .dylibs, rather tha static libs ...

just thinkin'
cheers,
richard
---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org

[pgadmin-hackers] path allocation failure in make of pgadmin3-svn on OSX 10.4 w/ wxwidgets-cvs

[OpenMacNews]

hi all,
after de-fubar'ing my firewall for svn:// access (Thx Dave!), i've been 
catching up on trying to get pgadmin3 built on OSX 10.4.

note that wxWidgets 2.6.0 does not build on 10.4 without patching, and even 
then i'm seeing some issues.  further, it seems that 'corrective efforts' are 
going primarily into cvs ... soo, it's wxwidgets-CVS only for me.

starting w/ the 5/8/05 11:02:24 cvs DL of wxwidgets CVS, i separately 
(successfully) built both static & dynamic variants into:

/usr/local/wxWidgets-cvs-STAT
/usr/local/wxWidgets-cvs-DYN
repectively.
checking out the latest svn rev of pgadmin3 (revision 4172)
svn co svn://svn.pgadmin.org/trunk/pgadmin3 pgadmin3STAT-wxSTAT
Checked out revision 4172.
a successful configure for static, appbundle build w/:
./configure \
--enable-appbundle \
--enable-static \
--disable-debug \
--with-wx=/usr/local/wxWidgets-cvs-STAT \
--with-wx-config=wx-config \
--with-pgsql=/usr/local/pgsql \
--with-pgsql-include=/usr/local/pgsql/include
is dying @:
make all
with:
   then mv -f ".deps/base.Tpo" ".deps/base.Po"; else rm -f ".deps/base.Tpo";
   exit 1; fi
   if g++ -DHAVE_CONFIG_H -I. -I. -I..  -Wall -g -I../src/include
   -I../src/agent/include -I../src/slony/include -I/usr/local/ssl/include
   -I/usr/local/pgsql/include -DSSL
   -I/usr/local/wxWidgets-cvs-STAT/lib/wx/include/mac-unicode-release-static-2
   .6 -I/usr/local/wxWidgets-cvs-STAT/include/wx-2.6 -D__WXMAC__
   -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -DNO_GCC_PRAGMA
   -I/usr/local/wxWidgets-cvs-STAT/include/wx-2.6 -no-cpp-precomp -fno-rtti
   -Wall -g -I../src/include -I../src/agent/include -I../src/slony/include
   -Wall -g -O0 -MT appbase.o -MD -MP -MF ".deps/appbase.Tpo" -c -o appbase.o
   `test -f './base/appbase.cpp' || echo './'`./base/appbase.cpp; \
   then mv -f ".deps/appbase.Tpo" ".deps/appbase.Po"; else rm -f
   ".deps/appbase.Tpo"; exit 1; fi
   ./base/appbase.cpp: In member function `void pgAppBase::InitPaths()':
   ./base/appbase.cpp:76: error: 'path' was not declared in this scope
   ./base/appbase.cpp:78: error: 'path' was not declared in this scope
   make[2]: *** [appbase.o] Error 1
   make[1]: *** [all-recursive] Error 1
   make: *** [all] Error 2
which is referring the to snippet in ./src/base/appbase.cpp:
#if defined(__WXMAC__)M

//When using wxStandardPaths on OSX, wx defaults to the 
unix,
//not to the mac variants. Therefor, we request 
wxStandardPathsCF
//directly.
wxStandardPathsCF stdPaths ;
dataDir = stdPaths.GetDataDir() ;

75  if (wxDir::Exists(dataDir + HELPER_DIR))
76  path.Add(dataDir + HELPER_DIR) ;
77  if (wxDir::Exists(dataDir + SCRIPT_DIR))
path.Add(dataDir + SCRIPT_DIR) ;

#else // other *ixes
i don't immediately understand this path allocation stanza, so need to dig 
...
any quick suggestions as to whether there's an obvious problem here w/ path.Add?
cheers,
richard
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [pgadmin-hackers] Move of translations

[OpenMacNews]

well, as soon as you can get at it Richard :-p
 *&%*^$& &^&^  *&^*^& (^$$( ! 
---(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] svn access?"Can't connect to host

[OpenMacNews]

hi dave,
and the ability for those behind firewalls to only worry
about communicatig
with a "more standard" port 80 ...
As someone who has battled endlessly with a government bodies who insist
on running their Citrix systems on port 80 for that reason
eeek!  politically driven engineering!! RUN AWAY, RUN AWAY!
from OUTSIDE my firewall, @ my ISP-based shell acct:
% telnet svr2.postgresql.org 3690
Trying 65.19.161.25...
telnet: Unable to connect to remote host: Connection refused
BUT, to 'another' server ...
% telnet svn.adiumx.com 3690
Trying 216.133.69.35...
Connected to penguinmilitia.net.
Escape character is '^]'.
( success ( 1 2 ( ANONYMOUS ) ( edit-pipeline ) ) ) ^]
i'm not convinced its NOT your server ... then again, i'm not
convinced it's
not me too =-S
OK, I'm seeing a major problem here. Why are you trying to connect to
svr2.postgresql.org?
cuz i thoughght you' suggested/verified that it works ...
   >> Hi Richard,
   >>
   >> It's probably just the DNS catching up (svn was temporarily on the old
   >> server whilst being tested). Try using dev.pgadmin.org instead (it's the
   >> same box, but the DNS record is much older). I just tried a checkout
   >> from svr2.postgresql.org (which is in the US) and it worked fine, so
   >> this shouldn't be a firewall issue.
   >>
   >> Regards, Dave.
By chance I happen to be root on that box, but it's
nothing to do with pgAdmin (it's the www.postgresql.org backend server),
and is on the wrong side of the pond!! Try svn.pgadmin.org...
fair nuf ...
from INSIDE my LAN/firewall:
   % telnet svn.pgadmin.org 3690
   Trying 194.217.48.45...
   telnet: connect to address 194.217.48.45: Operation timed out
   telnet: Unable to connect to remote host
from OUTSIDE my LAN (@ my ISP):
   % telnet svn.pgadmin.org 3690
   Trying 194.217.48.45...
   Connected to raptor.vale-housing.co.uk.
   Escape character is '^]'.
   ( success ( 1 2 ( ANONYMOUS ) ( edit-pipeline ) ) ) ^]
ok, so the machine's alive ...
it's clear -- i'm being boneheaded.
but where/how?
a SWAG -- i just wonder if there's a version incompatibiolity
between our "subversion versions".  i'm using 1.2rc2 -- you?
1.1.14. I was hoping 1.2 would be gold by the time we moved, but alas
not.
i'm "stuck @ 1.2rc2 cuz of "other issues" left unfixed in 114. argh.
hmmm ... i wonder.
richard
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [pgadmin-hackers] svn access?"Can't connect to host

[OpenMacNews]

hi dave,
i'm wondering why this project has chosen the svnserve'd svn:// schema for
the  repo rather than web-dav + http://.
A number of reasons, but mainly because the Subversion manual's own
comparison points out that it's much simpler to setup and faster to use. The
only feature we might have used that we've lost out on this way is
per-directory access control, but that's no great loss IMNSHO.
and the ability for those behind firewalls to only worry about communicatig 
with a "more standard" port 80 ...

There's no need. Plain old svn has now been tested on various machines and
works OK.
agreed.
Yours is the only failure I've heard of :-(
i'm cursed =(
OK, just tried a telnet to the svn port (3690) from my machine here (at
home), which is unknown to any of the firewalls where the dev box is - I get
a response like:
( success ( 1 2 ( ANONYMOUS ) ( edit-pipeline ) ) )
What do you get?

from behind my firewall, on my LAN ...
   % telnet svr2.postgresql.org 25
   Trying 65.19.161.25...
   Connected to svr2.postgresql.org.
   Escape character is '^]'.
but
   % telnet svr2.postgresql.org 3690
   Trying 65.19.161.25...
   telnet: connect to address 65.19.161.25: Operation timed out
   telnet: Unable to connect to remote host
with nothing in my firewall logs ...
from OUTSIDE my firewall, @ my ISP-based shell acct:
   % telnet svr2.postgresql.org 3690
   Trying 65.19.161.25...
   telnet: Unable to connect to remote host: Connection refused
BUT, to 'another' server ...
   % telnet svn.adiumx.com 3690
   Trying 216.133.69.35...
   Connected to penguinmilitia.net.
   Escape character is '^]'.
   ( success ( 1 2 ( ANONYMOUS ) ( edit-pipeline ) ) ) ^]
i'm not convinced its NOT your server ... then again, i'm not convinced it's 
not me too =-S

a SWAG -- i just wonder if there's a version incompatibiolity between our 
"subversion versions".  i'm using 1.2rc2 -- you?

argh!
cheers,
richard
---(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

Re: [pgadmin-hackers] svn access?"Can't connect to host

[OpenMacNews]

hi,
% svn co svn://svn.pgadmin.org/trunk/pgadmin3 pgadmin3
   svn: Can't connect to host 'svn.pgadmin.org': Operation timed out
_something's_ wonky ...
Maybe something's blocking port 3690 for you. I'm working with that host
without a problem.
shouldn't be  my iptables rules are setup to allow any/all internally (LAN) 
originated traffic, and my debug-level logs show no DENY-als.  but, i admit, 
this 'smells' like firewall trouble ...

reading here:
   
i'm wondering why this project has chosen the svnserve'd svn:// schema for the 
repo rather than web-dav + http://.

altho i'm not entirely clear, Andreas, are you tunneling the ra_svn client 
connect to the repo over SSH, perchance?

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

Re: [pgadmin-hackers] svn access?"Can't connect to host

[OpenMacNews]

hi dave,
svn co svn://svn.pgadmin.org/trunk/pgadmin3 pgadmin3
i simply get ...
svn: Can't connect to host 'svn.pgadmin.org': Operation timed out
Hi Richard,
It's probably just the DNS catching up (svn was temporarily on the old
server whilst being tested). Try using dev.pgadmin.org instead (it's the
same box, but the DNS record is much older). I just tried a checkout
from svr2.postgresql.org (which is in the US) and it worked fine, so
this shouldn't be a firewall issue.
well, simply o luck on this end ...
% svn co svn://svr2.postgresql.org/trunk/pgadmin3 pgadmin3
   svn: Can't connect to host 'svr2.postgresql.org': Operation timed out
% svn co svn://dev.pgadmin.org/trunk/pgadmin3 pgadmin3
   svn: Unknown hostname 'dev.pgadmin.org'
and still,
% svn co svn://svn.pgadmin.org/trunk/pgadmin3 pgadmin3
   svn: Can't connect to host 'svn.pgadmin.org': Operation timed out
_something's_ wonky ...
richard
---(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] svn access?"Can't connect to host 'svn.pgadmin.org': Operation timed out"

[OpenMacNews]

hi all,
i know y'all have mv'd src repo to sv @:
however, when i try to check out, per  
w/:

   svn co svn://svn.pgadmin.org/trunk/pgadmin3 pgadmin3
i simply get ...
   svn: Can't connect to host 'svn.pgadmin.org': Operation timed out
i *can* reliably checkout projects from svn http:// (webdav) servers, so i'm 
wondering ... is there a firewall port issue here? or is the server down? or am 
i just being daft?

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

[pgadmin-hackers] pgadmin3 build executable still not stripping correctly on OSX

[OpenMacNews]

hi all,
i'm now (finally) able to successfully/reproducibly build pgadmin3-cvs against 
both/either wxWidgets-cvs and wxWidgets-2.6.0.

build/install completes without error, though the executable's still not 
stripping correctly:

 case: wxWidgets-2.6.0
	% ls -al /usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3
		-rwxr-xr-x  1 root admin 109547152 Apr 28 17:52 
/usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3
	
	% strip /usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3
	
	% ls -al /usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3
		-rwxr-xr-x  1 root admin 7804308 Apr 28 18:03 
/usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3

 case: wxWidgets-cvs
	% ls -al /usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/MacOS/pgAdmin3
		-rwxr-xr-x  1 root admin 109586060 Apr 28 17:52 
/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/MacOS/pgAdmin3
	
	% strip /usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/MacOS/pgAdmin3
	
	% ls -al /usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/MacOS/pgAdmin3
		-rwxr-xr-x  1 root admin 7839296 Apr 28 18:03 
/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/MacOS/pgAdmin3

the issue, as per earlier post 
(
), still seems to be the autoconf snippet, but "got me" as to what the problem 
is.

ideas?  is there a legit question that can/should be posted to the autoconf 
lists?

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

Re: [pgadmin-hackers] pgadminIII on OSX 10.3.9; w/ wxWidgets-2.6.0

[OpenMacNews]

hi,
Hm.. I have no idea what going on here... Is there an autoconf guru here
who might provide insight?
hmmm ... why/where is "pg_debug_build=no" NOT being set ...
do we need an EXPLICIT test for "--disable-debug" to set the NO case?
i'm gonna try this without the --disable-debug flag ...
I just checked - the nightly builds are done with neither "--enable-debug"
nor "--disable-debug" specified, and things work correctly...
well, i just rebuilt w/ NO debug flag in the config, i.e.:
   ./configure \
   --enable-appbundle \
   --enable-static \
   --with-wx=/usr/local/wxWidgets-260 \
   --with-wx-config=wx-config \
   --with-pgsql=/usr/local/pgsql \
   --with-pgsql-include=/usr/local/pgsql/include
NOW, the 'make install' output shows:
   ...
   make  install-exec-hook
   cd /usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS ;\
   mv pgadmin3 tmp ;\
   mv tmp pgAdmin3 ;\
   echo no ;\
   if test "no" = "no"; then \
   strip pgAdmin3 ;\
   fi
   no
   ...
AND the executable IS properly stripped:
   % ls -al /usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3
   -rwxr-xr-x  1 root admin 7767372 Apr 26 10:18
   /usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3
so, what we're seeing is:
   "./configure --disable-debug", fails to set pg_debug_build=no, i.e. sets = 
yes.

but,
   "./configure" sets it correctly
FYI, configure is autogenerated, and the snipped that checks
for the debug option is found in acinclude.m4 - but it looks
even more correct there (at least for my autoconf-unsavy eyes...)
looking in acinclude.m4:
   ###
   # Debug build of pgAdmin3 #
   ###
   AC_DEFUN([ENABLE_DEBUG],
   [AC_ARG_ENABLE(debug,
   [ --enable-debug   build a debug version of pgAdmin3],
   [pg_debug_build=yes
   CFLAGS="-Wall -g -O0"
   CXXFLAGS="-Wall -g -O0"],
   [pg_debug_build=no])
   ])
   AC_SUBST(pg_debug_build)
looks ok to me as well ...
ok, this has got to be something obvious/simple, but i'm missing it.
richard
---(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] pgadminIII on OSX 10.3.9; w/ wxWidgets-2.6.0 OK,

[OpenMacNews]

hi florian,
--- (CASE wxwidgets-260) --
...
builds completely/successfully, but STILL fails to AUTOSTRIP correctly
...
Hm.. this is strange... I works for the nightly builds...
In src/Makefile.am, you should find the lines:
 if test "$(pg_debug_build)" = "no"; then \
 strip pgAdmin3 ;\
 fi
Could you put an "echo $(pg_debug_build)" before the if,
and post the output?
ok. per request,
   @216
mv tmp pgAdmin3 ;\
   +++   echo $(pg_debug_build) ;\
if test "$(pg_debug_build)" = "no"; then \
strip pgAdmin3 ;\
fi
indeed, NO STRIP occurred:
% ls -al /usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3
   -rwxr-xr-x  1 root admin 109540252 Apr 26 09:03 
/usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3

here's the 'make install' output 
   ...
   make  install-exec-hook
   cd /usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS ;\
   mv pgadmin3 tmp ;\
   mv tmp pgAdmin3 ;\
   echo yes ;\
   if test "yes" = "no"; then \
   strip pgAdmin3 ;\
   fi
   yes
   ...
hmmm, $pg_debug_build is reporting as YES despite  my config as:
   ./configure \
   --enable-appbundle \
   --enable-static \
   --disable-debug \
   --with-wx=/usr/local/wxWidgets-260 \
   --with-wx-config=wx-config \
   --with-pgsql=/usr/local/pgsql \
   --with-pgsql-include=/usr/local/pgsql/include
checking/verifying in "src/Makefile":
   @279
   pg_debug_build = yes
and in /.configure:
   @4872
   # Check whether --enable-debug or --disable-debug was given.
   if test "${enable_debug+set}" = set; then
 enableval="$enable_debug"
 pg_debug_build=yes
   CFLAGS="-Wall -g -O0"
   CXXFLAGS="-Wall -g -O0"
   else
 pg_debug_build=no
   fi;
looks ok (doesn't it?).
hmmm ... why/where is "pg_debug_build=no" NOT being set ...
do we need an EXPLICIT test for "--disable-debug" to set the NO case?
i'm gonna try this without the --disable-debug flag ...
--- (CASE wxwidgets-cvs) --
no longer requires a chmod on complete-bundle.sh
configures OK
'make all' fails at:
ld: Undefined symbols:
wxAssert(int, wchar_t const*, int, wchar_t const*, wchar_t const*)
make[2]: *** [pgadmin3] Error 1
make[1]: *** [all-recursive] Error 1
make: *** [all] Error 2
i'll see what i can find out abt this one ...
Hm... the nighty build currently link against wx-cvs (because
2.6 wasn't released when I set the build-daemon up), and
it links sucessfully
Did you "make clean" your source-tree after switching wx version?
actually, i'm using two separate source trees ...
   /usr/local/pgadmin3-cvs  <-- linking agains wxWidgets-260
   /usr/local/pgadmin3-cvs2 <-- linking agains wxWidgets-cvs
and when i don't do a clean DL, i always run a 'make distclean' (confirmed)
cheers,
richard
---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org

[pgadmin-hackers] pgadminIII on OSX 10.3.9; w/ wxWidgets-2.6.0 OK, w/ wxWidgets-CVS make fail

[OpenMacNews]

hi all,
coming back from vacation :-( i noticed that wxwidgets 2.6.0 has been released, 
and that there are now nightly OSX builds available (nice! florian)

after updating to OSX 10.3.9, i've done a sanity run for myself:
wxWidgets-CVS (4/25/05 11:34:29) & wxWidgets-2.6.0 both:
../configure \
--prefix=/usr/local/wxWidgets-cvs \
--with-mac \
--disable-shared \
--disable-debug \
--enable-unicode \
--with-regex

make
make install
w/o error, where:
% du -s -h /usr/local/wxWidgets-260/*
868K/usr/local/wxWidgets-260/bin
4.8M/usr/local/wxWidgets-260/include
16M /usr/local/wxWidgets-260/lib
12K /usr/local/wxWidgets-260/share
% ls -al /usr/local/wxWidgets-260/bin
	total 868
	drwxr-xr-x  5 rootadmin170 Apr 25 15:18 .
	drwxr-xr-x  6 rootadmin204 Apr 25 15:18 ..
	lrwxr-xr-x  1 rootadmin 69 Apr 25 15:18 wx-config -> 
/usr/local/wxWidgets-260/lib/wx/config/mac-unicode-release-static-2.6
	lrwxr-xr-x  1 rootadmin  8 Apr 25 15:18 wxrc -> wxrc-2.6
	-rwxr-xr-x  1 devuser wheel 879000 Apr 25 13:26 wxrc-2.6

% du -s -h /usr/local/wxWidgets-cvs/*
968K/usr/local/wxWidgets-cvs/bin
4.8M/usr/local/wxWidgets-cvs/include
27M /usr/local/wxWidgets-cvs/lib
12K /usr/local/wxWidgets-cvs/share
% ls -al /usr/local/wxWidgets-cvs/bin
	total 968
	drwxr-xr-x  5 rootadmin170 Apr 25 17:05 .
	drwxr-xr-x  6 rootadmin204 Apr 25 17:05 ..
	lrwxr-xr-x  1 rootadmin 69 Apr 25 17:05 wx-config -> 
/usr/local/wxWidgets-cvs/lib/wx/config/mac-unicode-release-static-2.6
	lrwxr-xr-x  1 rootadmin  8 Apr 25 17:05 wxrc -> wxrc-2.6
	-rwxr-xr-x  1 devuser wheel 980160 Apr 25 17:00 wxrc-2.6

subsequent builds of pgadmin3-cvs (4/25/05 04:04:22) as:
CASE XXX == 260, cvs
./configure \
--enable-appbundle \
--enable-static \
--disable-debug \
--with-wx=/usr/local/wxWidgets-XXX \
--with-wx-config=wx-config \
--with-pgsql=/usr/local/pgsql \
--with-pgsql-include=/usr/local/pgsql/include

make all
make install
--- (CASE wxwidgets-260) --
no longer requires a chmod on complete-bundle.sh (thx!)
builds completely/successfully, but STILL fails to AUTOSTRIP correctly
% ls -al /usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3
	-rwxr-xr-x  1 root admin 109540252 Apr 25 18:20 
/usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3

% strip /usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3
% ls -al /usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3
	-rwxr-xr-x  1 root admin 7800208 Apr 25 18:24 
/usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3

the resultant executable launches from Finder w/o error, and initial poking 
around is error free.  yay!


--- (CASE wxwidgets-cvs) --
no longer requires a chmod on complete-bundle.sh
configures OK
'make all' fails at:
ld: Undefined symbols:
wxAssert(int, wchar_t const*, int, wchar_t const*, wchar_t const*)
make[2]: *** [pgadmin3] Error 1
make[1]: *** [all-recursive] Error 1
make: *** [all] Error 2
i'll see what i can find out abt this one ...
cheers,
richard
---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org

Re: [pgadmin-hackers] pgadmin3 + wxwidgets-cvs (v2.6) ; dies in

[OpenMacNews]

hi,
I used a fresh checkout of pgadmin3, and, apart from

Maybe my limited knowledge of the english language caused confusion here,
so I'll rephrase "I used a fresh checkout of pgadmin3, and, apart from
chmod 755 complete-bundle.sh I had to change nothing and it worked":
What I wanted to say way:
I did a fresh checkout
Then I modified the permissions of complete-bundle.sh
Without _any_ further modifications I did
sh ./bootstrap
./configure 
make
make install
This worked, and produced a valid .app (It crashes when opening a dialog, but
that is a wx problem I guess)
sorry.  it's NOT your english ... it's my morning :-S
you were perfectly clear/correct =)
% /usr/local/wxWidgets-cvs/bin/wx-config --rezflags
   /Developer/Tools/Rez -d __DARWIN__ -t APPL Carbon.r
/usr/local/wxWidgets-cvs/lib/libwx_macud-2.6.0.r -o
% /usr/local/wxWidgets-255/bin/wx-config --rezflags
   /Developer/Tools/Rez -d __DARWIN__ -t APPL Carbon.r
/usr/local/wxWidgets-255/lib/libwx_macu-2.5.5.r -o

Does the file /usr/local/wxWidgets-255/lib/libwx_macu-2.5.5.r
exist on your system? If so, I'd say that your build
of wx cvs is in some way broken - maybe you should
report that to the wx mailinglist.
yes it does exist.
% ls -ald /usr/local/wxWidgets-255/lib/libwx_macu-2.5.5.r
   -rw-r--r--  1 devuser wheel 3205 Apr 14 11:53 
/usr/local/wxWidgets-255/lib/libwx_macu-2.5.5.r

good point.
maybe you should
report that to the wx mailinglist.
will do.
thx,
richard
---(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

Re: [pgadmin-hackers] pgadmin3 + wxwidgets-cvs (v2.6) ; dies in

[OpenMacNews]

( hmmm ... message lost in the aether )
hi florian,
% chmod a+x /usr/ports/pgadmin3-cvs2/pkg/mac/complete-bundle.sh
or a change in the makefile, per my earlier post.

I used a fresh checkout of pgadmin3, and, apart from
chmod 755 complete-bundle.sh
I had to change nothing, and it worked...
ok, i'm confused then too.  how exactly do _you_ execute a script if its 
perms
do not include the execute flag? what happens if you simply attempt to invoke
the script directly at cmd-line?
if you invoke it as an arg to "sh" (sh complete-bundle.sh), then sure ... but
directly (./complete-bundle.sh)?
what ARE your complete-bundle.sh's perms in a virgin DL?
again, mine are:
   -rw-r--r--  1 devuser admin 1306 Apr 12 00:36 pkg/mac/complete-bundle.sh
...
make  install-exec-hook
/usr/ports/pgadmin3-cvs2/config/install-sh -c -m 644 PkgInfo
/usr/ports/pgadmin3-cvs2/pgAdmin3.app/PkgInfo
/usr/ports/pgadmin3-cvs2/config/install-sh -c -m 644 Info.plist
/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/Info.plist
/usr/ports/pgadmin3-cvs2/config/install-sh -c -m 644 "pgadmin3.icns"
"/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/Resources/pgAdmin3.icns"
$(/usr/local/wxWidgets-cvs/bin/wx-config --rezflags | sed
's/-t[[:space:]]*APPL//') \
"/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/Resources/pgAdmin3.rsrc"
-useDF
/System/Library/Frameworks/Carbon.framework/Headers/Carbon.r:43: ###
/Developer/Tools/Rez - SysError 0 during open of
"/usr/local/wxWidgets-cvs/lib/libwx_macu-2.6.0.r".
Fatal Error!
/System/Library/Frameworks/Carbon.framework/Headers/Carbon.r:43: ###
/Developer/Tools/Rez - Fatal Error, can't recover.
/usr/local/wxWidgets-cvs/lib/libwx_macu-2.6.0.r: ###
/Developer/Tools/Rez - Since errors occurred,
/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/Resources/pgAdmin3.rsrc's
resource fork was not written.
make[4]: *** [install-exec-hook] Error 3
make[3]: *** [install-exec-am] Error 2
make[2]: *** [install-am] Error 2
make[1]: *** [install-recursive] Error 1
make: *** [install-recursive] Error 1

looking in:
/usr/local/wxWidgets-cvs/lib  % ls -a
.  libwx_macu_qa-2.6.a
.. libwx_macu_stc-2.6.a
cd libwx_macu_xrc-2.6.a
libwx_base_carbonu-2.6.a   libwx_macud_adv-2.6.a
libwx_base_carbonu_net-2.6.a   libwx_macud_core-2.6.a
libwx_base_carbonu_xml-2.6.a   libwx_macud_gl-2.6.a
libwx_base_carbonud-2.6.a  libwx_macud_html-2.6.a
libwx_base_carbonud_net-2.6.a  libwx_macud_media-2.6.a
libwx_base_carbonud_xml-2.6.a  libwx_macud_ogl-2.6.a
libwx_macu_adv-2.6.a   libwx_macud_qa-2.6.a
libwx_macu_core-2.6.a  libwx_macud_stc-2.6.a
libwx_macu_gl-2.6.alibwx_macud_xrc-2.6.a
libwx_macu_html-2.6.a  libwxregexu-2.6.a
libwx_macu_media-2.6.a libwxregexud-2.6.a
libwx_macu_ogl-2.6.a   wx
For me (with wx-cvs)
.   libwx_macu_core-2.6.a
libwxexpat-2.6.a
..  libwx_macu_gl-2.6.a
libwxjpeg-2.6.a
libwx_base_carbonu-2.6.alibwx_macu_html-2.6.a   libwxpng-2.6.a
libwx_base_carbonu_net-2.6.alibwx_macu_media-2.6.a
libwxregexu-2.6.a
libwx_base_carbonu_xml-2.6.alibwx_macu_ogl-2.6.a
libwxtiff-2.6.a
libwx_macu-2.6.0.r  libwx_macu_qa-2.6.a wx
libwx_macu-2.6.0.rsrc   libwx_macu_stc-2.6.a
libwx_macu_adv-2.6.alibwx_macu_xrc-2.6.a
but, i dunno where the problem stems from as yet ... the "SysError 0
during open" is not very enlightening.
I guess it's the not-human-readable version of "File not found" ;-))
well, given your ls, i'd gather! =)
strange -- i can't imagine what's different abt our 2 systems ...
Could you post the output of wx-config --rezflags ?
here's the output from BOTH wxwidgets-cvs and wxwidgets-255
% /usr/local/wxWidgets-cvs/bin/wx-config --rezflags
   /Developer/Tools/Rez -d __DARWIN__ -t APPL Carbon.r
/usr/local/wxWidgets-cvs/lib/libwx_macud-2.6.0.r -o
% /usr/local/wxWidgets-255/bin/wx-config --rezflags
   /Developer/Tools/Rez -d __DARWIN__ -t APPL Carbon.r
/usr/local/wxWidgets-255/lib/libwx_macu-2.5.5.r -o
richard
---(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

Re: [pgadmin-hackers] pgadmin3 + wxwidgets-cvs (v2.6) ; dies in

[OpenMacNews]

hi florian,
% chmod a+x /usr/ports/pgadmin3-cvs2/pkg/mac/complete-bundle.sh
or a change in the makefile, per my earlier post.

I used a fresh checkout of pgadmin3, and, apart from
chmod 755 complete-bundle.sh
I had to change nothing, and it worked...
ok, i'm confused then too.  how exactly do _you_ execute a script if its perms 
do not include the execute flag? what happens if you simply attempt to invoke 
the script directly at cmd-line?

if you invoke it as an arg to "sh" (sh complete-bundle.sh), then sure ... but 
directly (./complete-bundle.sh)?

what ARE your complete-bundle.sh's perms in a virgin DL?
again, mine are:
   -rw-r--r--  1 devuser admin 1306 Apr 12 00:36 pkg/mac/complete-bundle.sh
...
make  install-exec-hook
/usr/ports/pgadmin3-cvs2/config/install-sh -c -m 644 PkgInfo
/usr/ports/pgadmin3-cvs2/pgAdmin3.app/PkgInfo
/usr/ports/pgadmin3-cvs2/config/install-sh -c -m 644 Info.plist
/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/Info.plist
/usr/ports/pgadmin3-cvs2/config/install-sh -c -m 644 "pgadmin3.icns"
"/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/Resources/pgAdmin3.icns"
$(/usr/local/wxWidgets-cvs/bin/wx-config --rezflags | sed
's/-t[[:space:]]*APPL//') \
"/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/Resources/pgAdmin3.rsrc"
-useDF
/System/Library/Frameworks/Carbon.framework/Headers/Carbon.r:43: ###
/Developer/Tools/Rez - SysError 0 during open of
"/usr/local/wxWidgets-cvs/lib/libwx_macu-2.6.0.r".
Fatal Error!
/System/Library/Frameworks/Carbon.framework/Headers/Carbon.r:43: ###
/Developer/Tools/Rez - Fatal Error, can't recover.
/usr/local/wxWidgets-cvs/lib/libwx_macu-2.6.0.r: ###
/Developer/Tools/Rez - Since errors occurred,
/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/Resources/pgAdmin3.rsrc's
resource fork was not written.
make[4]: *** [install-exec-hook] Error 3
make[3]: *** [install-exec-am] Error 2
make[2]: *** [install-am] Error 2
make[1]: *** [install-recursive] Error 1
make: *** [install-recursive] Error 1

looking in:
/usr/local/wxWidgets-cvs/lib  % ls -a
.  libwx_macu_qa-2.6.a
.. libwx_macu_stc-2.6.a
cd libwx_macu_xrc-2.6.a
libwx_base_carbonu-2.6.a   libwx_macud_adv-2.6.a
libwx_base_carbonu_net-2.6.a   libwx_macud_core-2.6.a
libwx_base_carbonu_xml-2.6.a   libwx_macud_gl-2.6.a
libwx_base_carbonud-2.6.a  libwx_macud_html-2.6.a
libwx_base_carbonud_net-2.6.a  libwx_macud_media-2.6.a
libwx_base_carbonud_xml-2.6.a  libwx_macud_ogl-2.6.a
libwx_macu_adv-2.6.a   libwx_macud_qa-2.6.a
libwx_macu_core-2.6.a  libwx_macud_stc-2.6.a
libwx_macu_gl-2.6.alibwx_macud_xrc-2.6.a
libwx_macu_html-2.6.a  libwxregexu-2.6.a
libwx_macu_media-2.6.a libwxregexud-2.6.a
libwx_macu_ogl-2.6.a   wx
For me (with wx-cvs)
.   libwx_macu_core-2.6.a
libwxexpat-2.6.a
..  libwx_macu_gl-2.6.a
libwxjpeg-2.6.a
libwx_base_carbonu-2.6.alibwx_macu_html-2.6.a   libwxpng-2.6.a
libwx_base_carbonu_net-2.6.alibwx_macu_media-2.6.a
libwxregexu-2.6.a
libwx_base_carbonu_xml-2.6.alibwx_macu_ogl-2.6.a
libwxtiff-2.6.a
libwx_macu-2.6.0.r  libwx_macu_qa-2.6.a wx
libwx_macu-2.6.0.rsrc   libwx_macu_stc-2.6.a
libwx_macu_adv-2.6.alibwx_macu_xrc-2.6.a
but, i dunno where the problem stems from as yet ... the "SysError 0
during open" is not very enlightening.
I guess it's the not-human-readable version of "File not found" ;-))
well, given your ls, i'd gather! =)
strange -- i can't imagine what's different abt our 2 systems ...
Could you post the output of wx-config --rezflags ?
here's the output from BOTH wxwidgets-cvs and wxwidgets-255
% /usr/local/wxWidgets-cvs/bin/wx-config --rezflags
   /Developer/Tools/Rez -d __DARWIN__ -t APPL Carbon.r 
/usr/local/wxWidgets-cvs/lib/libwx_macud-2.6.0.r -o

% /usr/local/wxWidgets-255/bin/wx-config --rezflags
   /Developer/Tools/Rez -d __DARWIN__ -t APPL Carbon.r 
/usr/local/wxWidgets-255/lib/libwx_macu-2.5.5.r -o

richard
---(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] pgadmin3 + wxwidgets-cvs (v2.6) ; dies in 'install-exec-hook"

[OpenMacNews]

hi all,
starting with wxwidgets-cvs (v2.6+), debug = OFF
configure & make of pgadmin3-cvs complete w/o error.
tho, 'sudo make install' still needs to be preceded with:
% chmod a+x /usr/ports/pgadmin3-cvs2/pkg/mac/complete-bundle.sh
or a change in the makefile, per my earlier post.
after THAT change, 'make install' now fails at:
...
make  install-exec-hook
/usr/ports/pgadmin3-cvs2/config/install-sh -c -m 644 PkgInfo 
/usr/ports/pgadmin3-cvs2/pgAdmin3.app/PkgInfo
/usr/ports/pgadmin3-cvs2/config/install-sh -c -m 644 Info.plist 
/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/Info.plist
/usr/ports/pgadmin3-cvs2/config/install-sh -c -m 644 "pgadmin3.icns" 
"/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/Resources/pgAdmin3.icns"
$(/usr/local/wxWidgets-cvs/bin/wx-config --rezflags | sed 
's/-t[[:space:]]*APPL//') \

"/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/Resources/pgAdmin3.rsrc" -useDF
/System/Library/Frameworks/Carbon.framework/Headers/Carbon.r:43: ### 
/Developer/Tools/Rez - SysError 0 during open of 
"/usr/local/wxWidgets-cvs/lib/libwx_macu-2.6.0.r".
Fatal Error!
/System/Library/Frameworks/Carbon.framework/Headers/Carbon.r:43: ### 
/Developer/Tools/Rez - Fatal Error, can't recover.
/usr/local/wxWidgets-cvs/lib/libwx_macu-2.6.0.r: ### /Developer/Tools/Rez - 
Since errors occurred, 
/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/Resources/pgAdmin3.rsrc's 
resource fork was not written.
make[4]: *** [install-exec-hook] Error 3
make[3]: *** [install-exec-am] Error 2
make[2]: *** [install-am] Error 2
make[1]: *** [install-recursive] Error 1
make: *** [install-recursive] Error 1

looking in:
/usr/local/wxWidgets-cvs/lib  % ls -a
.  libwx_macu_qa-2.6.a
.. libwx_macu_stc-2.6.a
cd libwx_macu_xrc-2.6.a
libwx_base_carbonu-2.6.a   libwx_macud_adv-2.6.a
libwx_base_carbonu_net-2.6.a   libwx_macud_core-2.6.a
libwx_base_carbonu_xml-2.6.a   libwx_macud_gl-2.6.a
libwx_base_carbonud-2.6.a  libwx_macud_html-2.6.a
libwx_base_carbonud_net-2.6.a  libwx_macud_media-2.6.a
libwx_base_carbonud_xml-2.6.a  libwx_macud_ogl-2.6.a
libwx_macu_adv-2.6.a   libwx_macud_qa-2.6.a
libwx_macu_core-2.6.a  libwx_macud_stc-2.6.a
libwx_macu_gl-2.6.alibwx_macud_xrc-2.6.a
libwx_macu_html-2.6.a  libwxregexu-2.6.a
libwx_macu_media-2.6.a libwxregexud-2.6.a
libwx_macu_ogl-2.6.a   wx
the problem seems to be that the pgadmin3 make install is expecting (a) a file 
that's NOT there (/usr/local/wxWidgets-cvs/lib/libwx_macu-2.6.0.r), AND (b) has 
a 3-digit version # rather than the other files in the dir, which are 2-digit.

but, i dunno where the problem stems from as yet ... the "SysError 0 during 
open" is not very enlightening.

quick glances at ./pkg/mac/Makefile.in & ./pkg/mac/complete-bundle.sh aren't 
immediately clear (to me) as the source of the problem.

if not immediately obvious to y'all, i'll rebuild all with debug-ON and see 
what ktrace'll do 4 me 

cheers,
richard
---(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] pgadmin3 on OSX ... ALMOST out-of-the-box build; still need fixes --> perms on complete-bundle.sh & autostrip

[OpenMacNews]

hi all,
building w/ wxwidgets-255, now w/ DEBUG = OFF, but still w/ the Csomo patch, a 
'standard' build of pgadmin-cvs HEAD as:

   cd /usr/ports/pgadmin3-cvs
   unsetenv CFLAGS CPPFLAGS CXX CXXFLAGS LDFLAGS LDDLFLAGS LD_PREBIND LC_ALL
   LANG LINGUAS
   setenv CPPFLAGS "-I/usr/local/ssl/include"
   setenv LDFLAGS "-L/usr/local/ssl/lib -lssl -lcrypto -L/usr/local/lib
   -lexpat -lintl -lgettextlib -lpng -ljpeg -ltiff -lz"
   sh bootstrap
   ./configure \
   --enable-appbundle \
   --enable-static \
   --disable-debug \
   --with-wx=/usr/local/wxWidgets-255 \
   --with-wx-config=wx-config \
   --with-pgsql=/usr/local/pgsql \
   --with-pgsql-include=/usr/local/pgsql/include
completes ok.
% make all
is fine too.
% sudo make install
however, fails ...
the problem is in pkg/mac/Makefile.in:
   @314
   @APPBUNDLE_TRUE@./complete-bundle.sh "$(bundledir)"
this will only execute if the perms on complete-bundle.sh are set to EXECUTE.
unfortunately, they're not:
% ls -al pkg/mac/complete-bundle.sh
   -rw-r--r--  1 devuser admin 1306 Apr 14 12:50 
../pgadmin3-cvsORIG/pkg/mac/complete-bundle.sh

to fix either:
(a) change the perms of the file
   % chmod a+x complete-bundle.sh
   % ls -al pkg/mac/complete-bundle.sh
   -rwxr-xr-x  1 devuser admin 1306 Apr 12 00:36 
pkg/mac/complete-bundle.sh
or,
(b) mod the Makefile
   ---@APPBUNDLE_TRUE@./complete-bundle.sh "$(bundledir)"
   +++@APPBUNDLE_TRUE@/bin/sh ./complete-bundle.sh "$(bundledir)"

after making change (a), 'make install' runs/completes fine
% ls -al /usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3
	-rwxr-xr-x  1 devuser admin 108638440 Apr 14 16:07 
/usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3

but, given the executable size, autostrip still doesn't look right
after,
% strip /usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3
it's better
% ls -al /usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3
	-rwxr-xr-x  1 devuser admin 9630924 Apr 13 22:14 
/usr/ports/pgadmin3-cvs/pgAdmin3.app/Contents/MacOS/pgAdmin3

and the .app launches w/o error, and no crashes so far in operation 
richard
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [pgadmin-hackers] [PATCH] acinclude.m4 fixes for wx 2.6,

[OpenMacNews]

hi,
	.) Fixes statically linking against libpq (There is no libcrypt on osx)
that's correct -- and has been annoying in the past!
just fyi, a workaround is a symlink, specifically:
/usr/local/lib/libcrypt.dylib -> 
/System/Library/Frameworks/System.framework/System

for reference, see:
   # http://lists.spread.org/pipermail/spread-users/2001-March/39.html
   # http://developer.apple.com/technotes/tn2002/tn2071.html
   # 
http://developer.apple.com/documentation/Darwin/Reference/ManPages/man3/Config.3pm.html

so far, its served me well.
richard
---(end of broadcast)---
TIP 8: explain analyze is your friend

Re: [pgadmin-hackers] self-fubar'ed? consistent make failures (undef'd

[OpenMacNews]

oops, missed one ...
Which Version of OSX are you using? Is your harddisk formatted
as UFS or HFS+?
HFS+ in all cases ...
richard
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

Re: [pgadmin-hackers] self-fubar'ed? consistent make failures (undef'd

[OpenMacNews]

hi,
Which Version of OSX are you using? Is your harddisk formatted
as UFS or HFS+?
OSX 10.3.8, fully updated
% uname -a
Darwin devbox 7.8.0 Darwin Kernel Version 7.8.0: Wed Dec 22 14:26:17 PST 2004; 
root:xnu/xnu-517.11.1.obj~1/RELEASE_PPC  Power Macintosh powerpc


Dave applied two patches from me today, and additionally
added some wx 2.6 support on his own ;-)
great.  i'll be trying it a little later after a wx 2.5.5 retry
I believe it should work with wx CVS out-of-the-box now - or - at least
compile. It still crashed when opening a dialog when using wx CVS for  me,
so if you don't intent to hunt that bug down, stay with 2.5.5 + fix ;-)
i'll try get to both ...
cheers,
richard
---(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] wxMac CVS & pgadmin3

[OpenMacNews]

hi,
I used wxWidgets CVS, mainly to see if it works... Hm.. well.. it doesn't
The resulting app starts, but crashes when I try to open a dialog ("Add
Server",
"Preferences", ... )
Has anyone here (especially you, OpenMacNews ;-) ) done a build of pgadmin
with wxMac CVS that works? I'm not sure if I made a mistake while building,
or if it's really a wx bug.
not yet ...
as you, i've built succesfully now w/ wx-cvs
pgadmin3.app launches (currently with an error:  "Couldn't open a tips.txt 
file"), but crashes, e.g., on "Add Server" (crashdump below).  but, so far, it 
_seems_ any menu activity causes the prob ...

unfortunately, i've also built pgadmin with DEBUG-off, and/or stripped ... so 
no ktrace.

after rebuilding a wx-v255 pgadmin3 build w/ all today's applied patches, i'll 
give it a try w/ wx-cvs.

cheers,
richard
Date/Time:  2005-04-14 10:08:49 -0700
OS Version: 10.3.8 (Build 7U16)
Report Version: 2
Command: pgAdmin3
Path:/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/MacOS/pgAdmin3
Version: ??? (0.1)
PID: 27571
Thread:  0
Exception:  EXC_BAD_ACCESS (0x0001)
Codes:  KERN_PROTECTION_FAILURE (0x0002) at 0x014c
Thread 0 Crashed:
0   org.postgresql.pgadmin3 	0x00208dd0 wxWindow::MacSuperChangedPosition() + 
0x20 (window.cpp:3121)
1   org.postgresql.pgadmin3 	0x0020b564 
wxMacTopLevelWindowEventHandler(OpaqueEventHandlerCallRef*, OpaqueEventRef*, 
void*) + 0x48c (toplevel.cpp:718)
2   org.postgresql.pgadmin3 	0x0020bc48 
wxMacTopLevelEventHandler(OpaqueEventHandlerCallRef*, OpaqueEventRef*, void*) + 
0xe8 (toplevel.cpp:784)
3   <<>> 	0x927d1fa0 0 + 0x927d1fa0
4   <<>> 	0x927d2214 0 + 0x927d2214
5   <<>> 	0x927d6694 0 + 0x927d6694
6   <<>> 	0x9281312c 0 + 0x9281312c
7   <<>> 	0x9280f434 0 + 0x9280f434
8   <<>> 	0x92850a8c 0 + 0x92850a8c
9   org.postgresql.pgadmin3 	0x0020d9a4 wxTopLevelWindowMac::DoMoveWindow(int, 
int, int, int) + 0x88 (toplevel.cpp:1392)
10  org.postgresql.pgadmin3 	0x00204f28 wxWindow::DoSetSize(int, int, int, int, 
int) + 0x274 (window.cpp:1890)
11  org.postgresql.pgadmin3 	0x00205120 wxWindow::DoSetClientSize(int, int) + 
0xcc (window.cpp:1921)
12  org.postgresql.pgadmin3 	0x006a2eb0 0x1000 + 0x6a1eb0
13  org.postgresql.pgadmin3 	0x00338318 wxDialogXmlHandler::DoCreateResource() 
+ 0x2d0 (xh_dlg.cpp:69)
14  org.postgresql.pgadmin3 	0x001853f8 
wxXmlResourceHandler::CreateResource(wxXmlNode*, wxObject*, wxObject*) + 0x548 
(xmlres.cpp:700)
15  org.postgresql.pgadmin3 	0x00184a78 
wxXmlResource::CreateResFromNode(wxXmlNode*, wxObject*, wxObject*, 
wxXmlResourceHandler*) + 0x3d0 (xmlres.cpp:610)
16  org.postgresql.pgadmin3 	0x0018218c wxXmlResource::LoadDialog(wxDialog*, 
wxWindow*, wxString const&) + 0x6c (xmlres.cpp:204)
17  org.postgresql.pgadmin3 	0x0006fb5c pgDialog::LoadResource(wxWindow*, 
wchar_t const*) + 0x64 (dlgClasses.cpp:134)
18  org.postgresql.pgadmin3 	0x000b1a08 _ZN11dlgPropertyC4EP7frmMainRK8wxString 
+ 0x124 (dlgProperty.cpp:106)
19  org.postgresql.pgadmin3 	0x000b188c dlgProperty::dlgProperty(frmMain*, 
wxString const&) + 0x30 (dlgProperty.cpp:127)
20  org.postgresql.pgadmin3 	0x000bf0a8 _ZN9dlgServerC4EP7frmMainP8pgServer + 
0x48 (dlgServer.cpp:57)
21  org.postgresql.pgadmin3 	0x000bf04c dlgServer::dlgServer(frmMain*, 
pgServer*) + 0x30 (dlgServer.cpp:68)
22  org.postgresql.pgadmin3 	0x00081ee0 frmMain::OnAddServer(wxCommandEvent&) + 
0x40 (events.cpp:674)
23  org.postgresql.pgadmin3 	0x00164428 
wxAppConsole::HandleEvent(wxEvtHandler*, void (wxEvtHandler::*)(wxEvent&), 
wxEvent&) const + 0x88 (appbase.cpp:319)
24  org.postgresql.pgadmin3 	0x0016afe0 
wxEvtHandler::ProcessEventIfMatches(wxEventTableEntryBase const&, 
wxEvtHandler*, wxEvent&) + 0x118 (event.cpp:1183)
25  org.postgresql.pgadmin3 	0x0016a0e8 wxEventHashTable::HandleEvent(wxEvent&, 
wxEvtHandler*) + 0x120 (event.cpp:867)
26  org.postgresql.pgadmin3 	0x0016b2f8 wxEvtHandler::ProcessEvent(wxEvent&) + 
0x198 (event.cpp:1245)
27  org.postgresql.pgadmin3 	0x001f4af8 wxMenuBase::SendEvent(int, int) + 0x120 
(menucmn.cpp:615)
28  org.postgresql.pgadmin3 	0x0019a014 
wxMacAppCommandEventHandler(OpaqueEventHandlerCallRef*, OpaqueEventRef*, void*) 
+ 0x238 (app.cpp:477)
29  org.postgresql.pgadmin3 	0x0019a274 
wxMacAppEventHandler(OpaqueEventHandlerCallRef*, OpaqueEventRef*, void*) + 
0x104 (app.cpp:526)
30  <<>> 	0x927d1fa0 0 + 0x927d1fa0
31  <<>> 	0x927d2214 0 + 0x927d2214
32  <<>> 	0x927e46bc 0 + 0x927e46bc
33  <<>> 	0x927f96b4 0 + 0x927f96b4
34  <<>> 	0x92891874 0 + 0x92891874
35  <<>> 	0x92893450 0 + 0x92893450
36  <<>> 	0x9285d764 0 + 0x9285d764
37  <<>> 	0x92883b64 0 + 0x92883b64
38  org

Re: [pgadmin-hackers] self-fubar'ed? consistent make failures (undef'd

[OpenMacNews]

hi,
since abt the time Dave had announced the commits integrating
Florian's
patches, I'm no longer able to successfully 'make' pgadmin3
CVS HEAD on OSX.
Unless it failed in any of the agent code (for which I also committed an
update at that time) I doubt it's a code problem.
per other posts, turns out this was due to a dependence on wxwidgets needing to 
be built w/ --enable-debug

after a successful build of wxWidgets-255 + StevenCsomor's
patch, any/all
subsequent attempts to build pgadmin3 HEAD:
Did you build the OGL lib from the wx contrib dir? The build system
probably doesn't check for that like it does for stc (Andreas only added
it recently, and I don't think he updated the autoconf stuff).
yes, i've built both the reqts: STC & OGL
cheers,
richard
---(end of broadcast)---
TIP 8: explain analyze is your friend

Re: [pgadmin-hackers] self-fubar'ed? consistent make failures (undef'd

[OpenMacNews]

hi there,
-- On April 14, 2005 2:05:49 PM +0200  "Florian G. Pflug" <[EMAIL PROTECTED]> wrote:
Hm... "touch a; mv a A" works on both macs that I have access too
(Funnily enough, you can just repeat the move, it always succeeds, e.g.
"touch a; mv a A; mv a A")
really?  i've tried this on all my macs, and 'no go'.  i always see
   % touch a
   % mv a A
   mv: `a' and `A' are the same file
   % mv a A2
   % mv A2 A
odd.
is there a setting somewhere abt this?  who knew?
why is the pgadmin3 'make' seemingly dependent on wxwidgets' DEBUG =
on?
I just found out why:
When compiled with debug, the wx-libs are named e.g libwx_macud,
when compiled without, they are named libwx_macu.
The wx-configure check in acinclude.m4 detects wx in both cases,
but doesn't actually add the wx-libs to the list of to-be-linked-to
libs in the second case.
I'm in the process of fixing this - expect a patch later today.
great!  i missed that completely ...
cheers,
richard
---(end of broadcast)---
TIP 8: explain analyze is your friend

Re: [pgadmin-hackers] just fyi: latest 'mysql administrator'

[OpenMacNews]

i KNEW i should've put on my asbestos-wear!
  always lookin' at the glass as half-empty 
as they say, "Hold your friends close and your enemies closer"!
;-D
-- On April 14, 2005 1:51:48 PM +  Andreas Pflug 
<[EMAIL PROTECTED]> wrote:
Dave Page wrote:


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of OpenMacNews
Sent: 14 April 2005 05:37
To: pgadmin-hackers
Subject: [pgadmin-hackers] just fyi: latest 'mysql administrator'
hi all,
i just noticed that 'MySQL Administrator' has released a
version (1.0.6 beta)
for OSX 10.3 (new, isn't it?)
   <http://www.mysql.com/products/administrator/>
some interesting capabilities ... and perhaps a 'conversation
starter' for
those likewise interested here.

Neat - it supports Windows 2004!
Amazing... This proves that MySQL is obviously top-edge software!
Regards,
Andreas

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

[pgadmin-hackers] pgadmin3 on OSX w/ wxwidgets-cvs HEAD V2.6+

[OpenMacNews]

hi all,
explring necessary mods to pgadmin3-cvs to prep for wxwidgets-2.6, a couple of 
changes to 'hardwired' version #'s need to be made in acinclude.m4

this does the trick ...
   perl -pi -e 's/wx-2.5/wx-2.6/g' acinclude.m4
   perl -pi -e 's/2.5\*\)/2.6\*\)/g' acinclude.m4
   perl -pi -e 's/WX_VERSION="2.5"/WX_VERSION="2.6"/g' acinclude.m4
applying some of the same changes from my earlier post, 'bootstrap', 
'configure' then 'make all' complete w/o error =)

however,
   % sudo make install
fails with:
   Making install in mac
   make  install-exec-hook
   /usr/ports/pgadmin3-cvs2/config/install-sh -c -m 644 PkgInfo
   /usr/ports/pgadmin3-cvs2/pgAdmin3.app/PkgInfo
   /usr/ports/pgadmin3-cvs2/config/install-sh -c -m 644 Info.plist
   /usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/Info.plist
   /usr/ports/pgadmin3-cvs2/config/install-sh -c -m 644 "pgadmin3.icns"
   "/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/Resources/pgAdmin3.icns"
   $(/usr/local/wxWidgets-cvs/bin/wx-config --rezflags | sed
   's/-t[[:space:]]*APPL//') \
"/usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/Resources/pgAdmin3
.rsrc" -useDF
   /System/Library/Frameworks/Carbon.framework/Headers/Carbon.r:43: ###
   /Developer/Tools/Rez - SysError 0 during open of
   "/usr/local/wxWidgets-cvs/lib/libwx_macud-2.6.0.r".
   Fatal Error!
   /System/Library/Frameworks/Carbon.framework/Headers/Carbon.r:43: ###
   /Developer/Tools/Rez - Fatal Error, can't recover.
   /usr/local/wxWidgets-cvs/lib/libwx_macud-2.6.0.r: ### /Developer/Tools/Rez
   - Since errors occurred,
   /usr/ports/pgadmin3-cvs2/pgAdmin3.app/Contents/Resources/pgAdmin3.rsrc's
   resource fork was not written.
   make[4]: *** [install-exec-hook] Error 3
   make[3]: *** [install-exec-am] Error 2
   make[2]: *** [install-am] Error 2
   make[1]: *** [install-recursive] Error 1
   make: *** [install-recursive] Error 1
now, to try to figure out what the deal is ... tomorrow
cheers,
richard
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[pgadmin-hackers] just fyi: latest 'mysql administrator'

[OpenMacNews]

hi all,
i just noticed that 'MySQL Administrator' has released a version (1.0.6 beta) 
for OSX 10.3 (new, isn't it?)

   
some interesting capabilities ... and perhaps a 'conversation starter' for 
those likewise interested here.

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

[pgadmin-hackers] self-fubar'ed? consistent make failures (undef'd symbols) on OSX ...

[OpenMacNews]

(hmmm .. odd, this didn't make it b4 ... is there are a msg size limit on the 
list?)

hi all,
i dunno if (yet) if this coincidence or not, but ...
since abt the time Dave had announced the commits integrating Florian's
patches, I'm no longer able to successfully 'make' pgadmin3 CVS HEAD on OSX.
after a successful build of wxWidgets-255 + StevenCsomor's patch, any/all
subsequent attempts to build pgadmin3 HEAD:
/usr/ports/pgadmin-cvs
unsetenv CFLAGS CPPFLAGS CXX CXXFLAGS LDFLAGS LDDLFLAGS LD_PREBIND 
LC_ALL LANG
LINGUAS
setenv CPPFLAGS "-I/usr/local/ssl/include"
setenv LDFLAGS "-L/usr/local/ssl/lib -lssl -lcrypto -L/usr/local/lib 
-lexpat
-lintl -lgettextlib -lpng -ljpeg -ltiff -lz"

./configure \
--enable-appbundle \
--enable-static \
--disable-debug \
--with-wx=/usr/local/wxWidgets-255 \
--with-wx-config=wx-config \
--with-pgsql=/usr/local/pgsql \
--with-pgsql-include=/usr/local/pgsql/include

make all

are resulting in a make failure after scads of undef'd symbol errors (cref
output below)
i've monkeyed w/ the usual assortment of discrete CPPFLAGS & LDFLAGS
assignments, $PATH vars etc, tried both static & shared builds, all to no avail.
the thing is, i *had* this working the other day, but have (?) clearly fubar'ed
something ...
any suggestions would be appreciated -- i'm slowly going nuts over here.  has
something chnged when i wasn't looking?  $$$ sez i'm doing sumthin dumb ...
thx,
richard

...
if g++ -DHAVE_CONFIG_H -I. -I. -I..  -Wall -g -I../src/include
-I../src/agent/include -I../src/slony/include -I/usr/local/ssl/include
-I/usr/local/pgsql/include -DSSL
-I/usr/local/wxWidgets-255/lib/wx/include/mac-unicode-release-static-2.5
-I/usr/local/wxWidgets-255/include/wx-2.5 -D__WXMAC__ -D_FILE_OFFSET_BITS=64
-D_LARGE_FILES -DNO_GCC_PRAGMA   -I/usr/local/wxWidgets-255/include/wx-2.5
-no-cpp-precomp -fno-rtti -Wall -g -I../src/include -I../src/agent/include
-I../src/slony/include -Wall -g -O0 -MT dlgRepSubscription.o -MD -MP -MF
".deps/dlgRepSubscription.Tpo" -c -o dlgRepSubscription.o `test -f
'./slony/dlgRepSubscription.cpp' || echo './'`./slony/dlgRepSubscription.cpp; \
then mv -f ".deps/dlgRepSubscription.Tpo" ".deps/dlgRepSubscription.Po"; else
rm -f ".deps/dlgRepSubscription.Tpo"; exit 1; fi
if g++ -DHAVE_CONFIG_H -I. -I. -I..  -Wall -g -I../src/include
-I../src/agent/include -I../src/slony/include -I/usr/local/ssl/include
-I/usr/local/pgsql/include -DSSL
-I/usr/local/wxWidgets-255/lib/wx/include/mac-unicode-release-static-2.5
-I/usr/local/wxWidgets-255/include/wx-2.5 -D__WXMAC__ -D_FILE_OFFSET_BITS=64
-D_LARGE_FILES -DNO_GCC_PRAGMA   -I/usr/local/wxWidgets-255/include/wx-2.5
-no-cpp-precomp -fno-rtti -Wall -g -I../src/include -I../src/agent/include
-I../src/slony/include -Wall -g -O0 -MT slFunctions.o -MD -MP -MF
".deps/slFunctions.Tpo" -c -o slFunctions.o `test -f './slony/slFunctions.cpp'
|| echo './'`./slony/slFunctions.cpp; \
then mv -f ".deps/slFunctions.Tpo" ".deps/slFunctions.Po"; else rm -f
".deps/slFunctions.Tpo"; exit 1; fi
if g++ -DHAVE_CONFIG_H -I. -I. -I..  -Wall -g -I../src/include
-I../src/agent/include -I../src/slony/include -I/usr/local/ssl/include
-I/usr/local/pgsql/include -DSSL
-I/usr/local/wxWidgets-255/lib/wx/include/mac-unicode-release-static-2.5
-I/usr/local/wxWidgets-255/include/wx-2.5 -D__WXMAC__ -D_FILE_OFFSET_BITS=64
-D_LARGE_FILES -DNO_GCC_PRAGMA   -I/usr/local/wxWidgets-255/include/wx-2.5
-no-cpp-precomp -fno-rtti -Wall -g -I../src/include -I../src/agent/include
-I../src/slony/include -Wall -g -O0 -MT explainCanvas.o -MD -MP -MF
".deps/explainCanvas.Tpo" -c -o explainCanvas.o `test -f
'./ui/explainCanvas.cpp' || echo './'`./ui/explainCanvas.cpp; \
then mv -f ".deps/explainCanvas.Tpo" ".deps/explainCanvas.Po"; else rm -f
".deps/explainCanvas.Tpo"; exit 1; fi
ui/explainCanvas.cpp: In member function `void
  ExplainCanvas::SetExplainString(const wxString&)':
ui/explainCanvas.cpp:94: warning: initialization to `int' from `double'
...

...
wxMemoryFSHandlerBase::FindFirst(wxString const&, int)
wxMemoryFSHandlerBase::wxMemoryFSHandlerBase()
wxMemoryFSHandlerBase::~wxMemoryFSHandlerBase()
wxFileSystemHandler::GetClassInfo() const
vtable for wxFileSystem
make[2]: *** [pgadmin3] Error 1
make[1]: *** [all-recursive] Error 1
make: *** [all] Error 2
---(end of broadcast)---
TIP 8: explain analyze is your friend

[pgadmin-hackers] [ping]

[OpenMacNews]

sorry, haven't seen any posts/replies for awhile.
ignore me.

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

Re: [pgadmin-hackers] Roadmap for pgAdmin3 on OSX

[OpenMacNews]

Hi,
Are you sure you recompiled _all_ pgadmin files - if you just run configure
and specify a different wx-config, the build system doesn't realize it
has to rebuild everything. I had some unresolved symbols when switching
from wx 2.5.4 to 2.5.5, and they went away after doing "make clean; make"
i always do either make clean/distclean
but in these cases i've been re dl'ing into fresh dirs to be sure ...
i'm trying the wxMac 2.5.5 release at the moment ...
Be sure to include fix by "Stefan Csomor":

OK
Well, pgadmin needs to know how to start and stop postgres -
on osx - so we at least need to know the "servicename".
Of course this can be made configureable - but if there
was a "official way" for these things on osx, we could
save some config options.
Well, the 'official way' is to use the StartupItem script in 
/Library/StartupItems for 3rd party, and/or /System/Library/StartupItems for 
Apple-installed ...

I simply don't recall if PGSql installs one automatically ... I don't think so 
-- as I write my own and use in independent of the Apple hierarchy.

that said, its as 'easy' as "(path to)/startup_script start" or "(path 
to)/startup_script start"

the script can be named anything, and controls postmaster/pg_ctl directly.
if you like, i can post my script ...
are you thinking of simply using a LaunchServices assignment (i.e.,
using the GetInfo dialog's "Open with ..." facility?)
Kind of... see my other post in this thread - we'd need a way to remeber
the connection this sql was used in, or a way for the use to specify that.
ah.  my mistake.
i thought your were just worrying about getting the editable-query to open in a 
selectable query editor ...

i see that you're talking about launching a query.
what i've done on occassion is simply write a shell-script and wrap it with a 
finder-dubl-clickable wrapper ...

not "production quality", tho ...
ad 3): This is a bug in configure - but I still don't know how to
fix/workaround this.
do you have a thread reference for the particular problem, or a breif
description?
See my other mail in this thread.
ok.
I've had no apparent issue linking/building against my external SSL
build; however, i haven't gotten as far as testing function ...
Have you checked wether you actually got ssl support - I can link
against a ssl-enabled libpq just fine - but the pgadmin configure
doesn't detect the ssl-support, and disabled ssl-support for pgadmin.
i will as soon as i beat my build problems ... suddenly i've now got unresolved 
symbol issues all over the place. argh.

richard
---(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] Roadmap for pgAdmin3 on OSX

[OpenMacNews]

hi,
Since pgAdmin3 should now compile & run on OSX when using wxMac HEAD
i'm *still* having issues w/ the 'new' 2.6-branch HEAD (cref: my other 
posts).
i'm trying the wxMac 2.5.5 release at the moment ...
and pgAdmin3 HEAD, it guess it's time to think about further improvements.
1) postgres start/stop support
2) open ".sql" with pgadmin?
3) ssl support
4) Standard location for postgresql.conf and pg_hba.conf?
5) Nightly Builds
ad 1), 4): Depends on weather there exists a "official" binary
version of postgres for OSX.
i'm unclear as to why this depends on an "official" bin?  could this not simply 
point to a given 'custom' bin path, or presume that our $PATH has been set 
correctly?

ad 2): Can you click on a saved sql query in windows, and
it is opened in pgadmin3? If so, I could try to do the same
for OSX
are you thinking of simply using a LaunchServices assignment (i.e., using the 
GetInfo dialog's "Open with ..." facility?)

ad 3): This is a bug in configure - but I still don't know how to
fix/workaround this.
do you have a thread reference for the particular problem, or a breif 
description?

I've had no apparent issue linking/building against my external SSL build; 
however, i haven't gotten as far as testing function ...

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

Re: [pgadmin-hackers] wxWidgets version# update (v2.5 --> v2.6) -->

[OpenMacNews]

hi andreas,
i just updated to latest wxWidgets HEAD, which is now reporting as v2.6,
rather than previouly as v2.5, and building/installing; changed sometime
today ...
We should wait a bit to update our sources for 2.6, to avoid breakage of our
nightly builds. OTOH, it's a good idea to test wx CVS to notice possible last
minute problems invented in wx before 2.6 is frozen. I'd really like pgAdmin3
to use vanilla 2.6, without any fixes.
so please continue testing wx CVS, we'll use 2.6 as soon as it is released
(which will be RSN).
although wx-2.6 CVS builds w/o error on OSX 10.3.8, a subsequent pgadmin3 make 
dies w/ HUNDREDS of 'undefined symbol' warnings referencing "wx*" symbols.

although i'd made some testing changes in acinlcude.m4 to reference the 2.6 dir 
tree, and get me past the config checks:

 % perl -pi -e 's/wx-2.5/wx-2.6/g' acinclude.m4
 % perl -pi -e 's/2.5\*\)/2.6\*\)/g' acinclude.m4
 % perl -pi -e 's/WX_VERSION="2.5"/WX_VERSION="2.6"/g' acinclude.m4
i'd venture i've missed some lib/include refs elsewhere ...
i'll see what i can blindly find, but i'd gather you'd know better what 
changes/preparations need to be made for the "2.6" vs "2.5" references.

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

Re: [pgadmin-hackers] CVS Commit by dpage: MAC OSX bundle support

[OpenMacNews]

hi,
ok, 'goal posts' moving in real time here ... =)
Thought you'd gone to bed!
i've actually been asleep for the last 90 minutes ... i'm typing in my sleep. 
|-)

Florian -- does this commit contain your latest
update/correction re: the
missing Makefile?
I'm not Florian, but yes, it does.
well, then, that was fast ... but, clear. thx.
Dave -- have these changes propagated? (if so, Florian, I
assume that I no
longer need to apply your patches, yes?)
Not sure what you mean by propagated? They're in CVS, so if you do a cvs
update you will get them. If you're using source tarballs you'll have to
wait until tomorrow, or apply the patches yourself.
wasn't sure whether y'all commit to the final repository (which, per your 
comment is, apprently, the case), or to an intermediate staging area that 
pushes at a later time (hence, a propagation delay) ...

now i'm, going to sleep for real!
richard
---(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] CVS Commit by dpage: MAC OSX bundle support

[OpenMacNews]

hi,
ok, 'goal posts' moving in real time here ... =)
Florian -- does this commit contain your latest update/correction re: the 
missing Makefile?

Dave -- have these changes propagated? (if so, Florian, I assume that I no 
longer need to apply your patches, yes?)

Thx!
Richard
-- On April 12, 2005 7:36:43 AM +  [EMAIL PROTECTED] wrote:

Log Message:
---
MAC OSX bundle support [Florian G. Pflug]
Modified Files:
--
pgadmin3:
Makefile.am (r1.37 -> r1.38)
acinclude.m4 (r1.43 -> r1.44)
configure.ac (r1.34 -> r1.35)
pgadmin3/pkg/mac:
Info.plist (r1.1 -> r1.2)
pgadmin3/src:
Makefile.am (r1.102 -> r1.103)
Added Files:
---
pgadmin3/pkg:
Makefile.am (r1.1)
pgadmin3/pkg/mac:
Info-Debug.plist (r1.1)
Makefile.am (r1.1)
complete-bundle.sh (r1.1)
debug-bundle.sh (r1.1)
pgadmin3.icns (r1.1)

---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org

Re: [pgadmin-hackers] issues w/ 'new' OSX patches

[OpenMacNews]

hi there,
Ups. I forgot a file _again_. Verry sorry. Just redownload
pgadmin3-newfiles.tgz
again, I just added pkg/Makefile to it...

ok. starting it again ...
time to go to bed, tho ... should be done in the morning.
g'nite, and thx!
richard
---(end of broadcast)---
TIP 8: explain analyze is your friend

[pgadmin-hackers] wxWidgets version# update (v2.5 --> v2.6) --> pgadmin3 fails @ config check for 'stc' 'ogl'

[OpenMacNews]

hi all,
i just updated to latest wxWidgets HEAD, which is now reporting as v2.6, rather 
than previouly as v2.5, and building/installing; changed sometime today ...

% ls -al /usr/local/wxWidgets-cvs/bin
	total 1460
	drwxr-xr-x  5 rootadmin 170 Apr 11 17:59 .
	drwxr-xr-x  6 rootadmin 204 Apr 11 17:59 ..
	lrwxr-xr-x  1 rootadmin  69 Apr 11 17:59 wx-config -> 
/usr/local/wxWidgets-cvs/lib/wx/config/mac-unicode-release-static-2.6
	lrwxr-xr-x  1 rootadmin   8 Apr 11 17:59 wxrc -> wxrc-2.6
	-rwxr-xr-x  1 blakers wheel 1485428 Apr 11 17:56 wxrc-2.6

% ls -ald /usr/local/wxWidgets-cvs/include/wx-2.6/
	drwxr-xr-x  3 root admin 102 Apr 11 17:59 
/usr/local/wxWidgets-cvs/include/wx-2.6/

there need to be some parallel changes in pgadmin3, currently referencing 
"2.5", otherwise installed wxWidgets includes aren't found in config checks for 
'stc;' & 'ogl', i.e. --

% grep -rln "wx-2.5".
./acinclude.m4
% grep "wx-2.5" acinclude.m4
 if test ! -f "${WX_HOME}/include/wx-2.5/wx/wx.h"
if test ! -f "${WX_HOME}/include/wx-2.5/wx/wx.h"
CPPFLAGS="$CPPFLAGS $WX_NEW_CPPFLAGS 
-I${WX_HOME}/include/wx-2.5"
if test ! -f "${WX_HOME}/include/wx-2.5/wx/version.h"
if test ! -f "${WX_HOME}/include/wx-2.5/wx/stc/stc.h"
if test ! -f "${WX_HOME}/include/wx-2.5/wx/ogl/ogl.h"
% perl -pi -e 's/wx-2.5/wx-2.6/g' acinclude.m4
% grep "wx-2.5" acinclude.m4
% grep "wx-2.6" acinclude.m4
 if test ! -f "${WX_HOME}/include/wx-2.6/wx/wx.h"
 if test ! -f "${WX_HOME}/include/wx-2.6/wx/wx.h"
 CPPFLAGS="$CPPFLAGS $WX_NEW_CPPFLAGS -I${WX_HOME}/include/wx-2.6"
 if test ! -f "${WX_HOME}/include/wx-2.6/wx/version.h"
 if test ! -f "${WX_HOME}/include/wx-2.6/wx/stc/stc.h"
 if test ! -f "${WX_HOME}/include/wx-2.6/wx/ogl/ogl.h"
richard
---(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] issues w/ 'new' OSX patches

[OpenMacNews]

hi florian,
back to progress on a scratch build.
first, just fyi, your  'newest' patches are (mis?)named:
pgadmi3-bundle.diff
pgadmi3-newfiles.tgz
rather than
pgadmin3-bundle.diff
pgadmin3-newfiles.tgz
(which kept me guessing for a bit ... amazing how you can stare at similar 
things and NOT see the difference ...)

after successfully re-building today's wxWidgets HEAD
../configure \
--prefix=/usr/local/wxWidgets-cvs \
--with-mac \
--disable-shared \
--disable-debug \
--enable-unicode \
--with-regex
DL'ing latest pgadmin3 HEAD, and applying your two patches:
% patch -p0 < pgadmi3-bundle.diff
patching file Makefile.am
patching file acinclude.m4
patching file configure.ac
patching file pkg/mac/Info.plist
patching file src/Makefile.am
% gnutar zxvf pgadmi3-newfiles.tgz
pkg/mac/Info-Debug.plist
pkg/mac/Makefile.am
pkg/mac/complete-bundle.sh
pkg/mac/debug-bundle.sh
pkg/mac/pgadmin3.icns
a first step of:
% sh bootstrap
now dies at:
	+ '[' -x config ']'
	+ aclocal
	/usr/local/share/aclocal-1.9/libmcrypt.m4:17: warning: underquoted definition 
of AM_PATH_LIBMCRYPT
	  run info '(automake)Extending aclocal'
	  or see http://sources.redhat.com/automake/automake.html#Extending-aclocal
	/usr/local/share/aclocal/libmcrypt.m4:17: warning: underquoted definition of 
AM_PATH_LIBMCRYPT
	+ autoheader
	+ automake --foreign --add-missing --copy
	configure.ac: installing `config/install-sh'
	configure.ac: installing `config/missing'
	src/Makefile.am: installing `config/depcomp'
	configure.ac:8: installing `config/config.guess'
	configure.ac:8: installing `config/config.sub'
	configure.ac:45: required file `pkg/Makefile.in' not found

looking in the 'pgadmi3-bundle.diff' patched configure.ac, i note @ 45:
42  AC_CONFIG_FILES([Makefile
43   src/Makefile
44   pkg/Makefile
45   pkg/mac/Makefile])
46  AC_OUTPUT
yet there's certainly no Makefile* in pkg/ as referenced in line#44, i.e. --
/usr/ports/pgadmin3-cvs % ls pkg
CVS fc1  mandrake  pgadmin3.desktop  slackware  win32
debian  mac  nsis  redhatsrc
so, looking in your patch, 'pgadmi3-bundle.diff', there's the obvious 
source:
139  AC_CONFIG_FILES([Makefile
140 - src/Makefile])
141 + src/Makefile
142 +pkg/Makefile
143 +pkg/mac/Makefile])
144  AC_OUTPUT
but i'm wondering what line#142 is referring to.
hmmm  this worked earlier ...
richard
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faq

Re: [pgadmin-hackers] pgAdmin3.app size?

[OpenMacNews]

hi,
Ok, so it definitly is the missing "stripping phase" ;-)))
stripping would/should only occur then in a 'disable-debug' mode,
correct? or am i misunderstanding?
is it worthwhile to y'all for me to re-build wxwidgets AND pgadmin w/
debug OFF and see what happens?

If you have the time, it would be great. If you rebuild from scratch anyway,
please use the latest patch from www.phlo.org. The bundle is now named
pgAdmin3.app (to please Dave ;-) ), and I'd like this version of the patch
to be committed to cvs. I you manage to test it first, I'd be gratefull.
ok, i'll start from scratch on both wxwidgets & pgadmin3 ... good excuse to go 
get a margarita, anyway.

what build scenario is typically being tested here?  wxwidgets & pgadmin
both static, both shared, etc?
I compiled wxwindows as shared lib, since there were some wx-mac bugs until
about
15 minutes ago, which I wanted to be able to debug... Some kind fellow
from wx-dev provided a fix today, and the other problem was fixed a few days
ago.
I don't know of any other wx bugs influencing pgadmin, so I might switch back
to
a static lib...
ok.
so, i'll build both from HEAD, static, debug off, with your newset patch ...
and will report back when all's done.
cheers,
richard

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

Re: [pgadmin-hackers] pgAdmin3.app size?

[OpenMacNews]

hi,
246 MB?  yikes!  that's big ...

Hm... my debug build are usually that large,
but I have wx built as shared lib, and those
libs are therefore copied into the bundle (by complete-bundle.sh),
to make it self-contained
for reference, my wxWidgets was built statically as:
   ../configure \
   --prefix=/usr/local/wxWidgets-cvs \
   --with-mac \
   --disable-shared \
   --enable-debug \
   --enable-unicode \
   --with-regex
For a non-debug, non-shared wx build I get the following
output from "du -s -h *" for PgAdminIII.app/Contents
   0BFrameworks
4.0KInfo.plist
7.4MMacOS
  48KResources
  10MSharedSupport
The whole bundle is 18MB
Could you try to run "strip"
on the executable inside the bundle, and see if it reduces
the size? Maybe the stripping step is for some reason left on
while installing
let's see what's going on ...
right after a clean build/install of pgadmin3 w/:
   ./configure \
   --enable-appbundle \
   --enable-static \
   --enable-debug \
   --with-wx=/usr/local/wxWidgets-cvs \
   --with-wx-config=wx-config \
   --with-pgsql=/usr/local/pgsql \
   --with-pgsql-include=/usr/local/pgsql/include
../PgAdminIII.app/Contents % du -s -h *
   3.2MFrameworks
   4.0KInfo.plist
   233MMacOS
48KResources
10MSharedSupport
../PgAdminIII.app/Contents/MacOS  % ls -al *
   -rwxr-xr-x  1 root wheel 244080280 Apr 11 08:54 PgAdminIII
../PgAdminIII.app/Contents/MacOS % strip PgAdminIII
../PgAdminIII.app/Contents/MacOS  % ls -al *
   -rwxr-xr-x  1 root wheel 9766288 Apr 11 14:41 PgAdminIII
and, just for completeness
../PgAdminIII.app/Contents % du -s -h *
   3.2MFrameworks
   4.0KInfo.plist
   9.3MMacOS
48KResources
10MSharedSupport
hmmm ... much better.
AND, the .app still launches from Finder nicely.
The .app bundle I analyzed above is quite old, and I remeber that
I stripped it manually - but IIRC I fixed this, and it should
strip while installing now...
hmmm ... unclear, then.
Probably - though 246MB is pretty big!! On slackware linux it's just
under 47MB. You could try stripping it if OSX has a 'strip' program. On
slack that reduces the executable to about 10MB (strip removes the debug
symbols in case you weren't aware).
now i am. thx!

## QUESTION(s)
#
stripping would/should only occur then in a 'disable-debug' mode, correct? or 
am i misunderstanding?

is it worthwhile to y'all for me to re-build wxwidgets AND pgadmin w/ debug OFF 
and see what happens?

what build scenario is typically being tested here?  wxwidgets & pgadmin both 
static, both shared, etc?

Yeah - the original at that :-)
! =)
Err, yes.
Moving swiftly on I'll leave the rest for someone who actually
has a Mac ...
unappreciated in my own time ...
(Dave -- I'll leave you off subsequent cc: on Mac stuff ...)
thanks!
richard
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[pgadmin-hackers] pgAdmin3.app size?

[OpenMacNews]

Name: PgAdminIII
Kind: Application
Size: 246.3 MB on disk
246 MB?  yikes!  that's big ...
i'm presuming that that's:
(a) normal/correct, and
(b) in part, due to:
  --enable-static
  --enable-debug
yes?
just a thought ... it would be nice (eventually) to be able to trim down such 
an admin tool so as to fit 'comfortably' on a USB RAM dongle.

dunno (yet) if disabling debug + any optimizations will help.
for now, size makes no difference ... er ... but whatcha do with it ...
richard
---(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] close-but-not-quite w/ pgadmin3.app on osx 10.3.8

[OpenMacNews]

hi florian & dave,
-- On April 11, 2005 11:29:09 AM +0200  "Florian G. Pflug" <[EMAIL PROTECTED]> 
wrote:
Hm... prefix shouldn't be needed when using "--enable-appbundle".
If you specify "--enable-appebundle", all File necessary
for running pgadmin3 should be installed into the .app.
ok. clear.
% cd /usr/ports/pgadmin3-cvs/PgAdminIII.app/Contents/MacOS
% otool -L pgadmin3
Heres the problem - the executable should be named PgAdminIII, not
pgadminIII.
good gork, man!  i would have been "old(er) & gray(er)" b4 figuring that 
out ;-D
I forgot to include my modifications to src/Makefile.am
in the patch on www.phlo.org - I created a second patch, named
pgadmin3-bundle-2.diff - please apply this one two, and retry.
(It should be sufficient to just do "make install" again, after
applying the patch).
i'd just rebuilt without the enable-app  so i'll re-do here in a minute 
...

Hm... we could do that - but .app bundles are designed to be relocateable
anyway, so just move it to wherever you want it to be ;-)
true & fair point.
-- On April 11, 2005 10:43:06 AM +0100  Dave Page  
wrote:

Heres the problem - the executable should be named PgAdminIII, not
Don't mess with the branding!! :-)
Can that be made 'pgAdmin3' please? The long form is 'pgAdmin III', with
the space. Never an uppercase P though.
hey!  who let the marketing guy in here ?!  ;-P
-- On April 11, 2005 2:18:00 PM +0200  "Florian G. Pflug" <[EMAIL 
PROTECTED]> wrote:
I can do that, but first I'd like to know if the current patch + my addition
from today makes things work for OpenMacNews. If this works, I'll prepare
a new Version of the patch with the bundle renamed. If not, I'd like to fix
all remaining problems before introducing new breakage by renaming things...
i'll let you know as soon as the build finishes in a bit  ( i WANT a DP 
G5!!)

cheers,
richard
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

[pgadmin-hackers] close-but-not-quite w/ pgadmin3.app on osx 10.3.8

[OpenMacNews]

hi all,
fwiw, i understand that this may be 'old news' for many of you, but -- as I'd 
had some issues getting up-n-running, I just thought i'd share details of what 
I've done so far ... and where I'm currently stalled.

in short, I'm on my way to building pgadmin3 cvs head on OSX 10.3.8 as a 
clickable .app.

my dev env is a bit mod'd, and i'm linking against some of my own builds, so 
here's some of the relevant env/version info:

	Darwin tiedgar 7.8.0 Darwin Kernel Version 7.8.0: Wed Dec 22 14:26:17 PST 
2004; root:xnu/xnu-517.11.1.obj~1/RELEASE_PPC  Power Macintosh powerpc
	
	gcc v3.3 20030304 (Apple Computer, Inc. build 1671)
	autoconf v2.59
	automake v1.9.5
	libtoolize v1.5.14
	
	pgsql v8.0.1
	bdb v4.3.27 w/ strong crypto
	perl v5.8.6
	wxWidgets cvsHEAD (config'd "--with-mac")
	python v2.4.1 (framework)
	OpenSSL 0.9.7f 22 Mar 2005
	libxml2 v2.6.18
	expat cvsHEAD
	libpng v1.2.8
	jpeg v6b
	tiff cvsHEAD
	gettext v0.14.3

my procedure is fairly standard, with the exception of the ENV:
% cvs -d :pserver:[EMAIL PROTECTED]:/projects co -d pgadmin3-cvs 
pgadmin3
% cd /usr/ports/pgadmin3-cvs

# NOTE
# Florian Pflug's patch/files for '.app' creation ...
% wget http://www.phlo.org/pgadmin3-bundle.diff
% wget http://www.phlo.org/pgadmin3-newfiles.tgz
% patch -p0 < pgadmin3-bundle.diff
% gnutar zxvf pgadmin3-newfiles.tgz
% sh bootstrap
% unsetenv CFLAGS CPPFLAGS CXX CXXFLAGS LDFLAGS LDDLFLAGS LD_PREBIND LC_ALL 
LANG LINGUAS
% setenv CPPFLAGS "-I/usr/local/ssl/include -I/usr/local/include"
% setenv LDFLAGS "-bind_at_load -L/usr/local/ssl/lib -lssl -lcrypto 
-L/usr/local/lib -lexpat -lintl -lgettextlib -lpng -ljpeg -ltiff -lz"

% ./configure \
--prefix=/usr/local/pgadmin3 \
--enable-appbundle \
--enable-static \
--enable-debug \
--with-wx=/usr/local/wxWidgets-cvs \
--with-wx-config=wx-config \
--with-pgsql=/usr/local/pgsql \
--with-pgsql-include=/usr/local/pgsql/include
% make all
success:
...
Making all in pkg
Making all in mac
make[3]: Nothing to be done for `all'.
make[3]: Nothing to be done for `all-am'.
make[2]: Nothing to be done for `all-am'.
% sudo make install
% cd /usr/ports/pgadmin3-cvs
% ls -ald PgAdminIII.app
drwxr-xr-x  4 root wheel 136 Apr 10 11:56 PgAdminIII.app
% cd /usr/ports/pgadmin3-cvs/PgAdminIII.app/Contents/MacOS
% otool -L pgadmin3
	pgadmin3:
			@executable_path/../Frameworks/libssl.0.9.7.dylib (compatibility version 
0.9.0, current version 0.9.7)
			@executable_path/../Frameworks/libcrypto.0.9.7.dylib (compatibility version 
0.9.0, current version 0.9.7)
			@executable_path/../Frameworks/libexpat.0.dylib (compatibility version 
6.0.0, current version 6.0.0)
			@executable_path/../Frameworks/libintl.3.dylib (compatibility version 8.0.0, 
current version 8.2.0)
			@executable_path/../Frameworks/libgettextlib-0.14.3.dylib (compatibility 
version 0.0.0, current version 0.0.0)
			@executable_path/../Frameworks/libpng.3.dylib (compatibility version 3.0.0, 
current version 3.0.0)
			@executable_path/../Frameworks/libjpeg.62.dylib (compatibility version 
63.0.0, current version 63.0.0)
			@executable_path/../Frameworks/libtiff.3.dylib (compatibility version 
11.0.0, current version 11.2.0)
			/usr/lib/libz.1.2.2.dylib (compatibility version 1.2.0, current version 
1.2.2)
			/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 
71.1.1)
			/System/Library/Frameworks/QuickTime.framework/Versions/A/QuickTime 
(compatibility version 1.0.0, current version 11.0.0)
			/System/Library/Frameworks/IOKit.framework/Versions/A/IOKit (compatibility 
version 1.0.0, current version 184.0.0)
			/System/Library/Frameworks/Carbon.framework/Versions/A/Carbon (compatibility 
version 2.0.0, current version 128.0.0)
			/System/Library/Frameworks/Cocoa.framework/Versions/A/Cocoa (compatibility 
version 1.0.0, current version 9.0.0)
			/System/Library/Frameworks/WebKit.framework/Versions/A/WebKit (compatibility 
version 1.0.0, current version 1.0.0)
			/usr/lib/libiconv.2.dylib (compatibility version 5.0.0, current version 
5.0.0)

so, it all looks ok (?) so far ...
but, when I try to dubl-clik the PgAdminIII, i get a dialog:
 'You cannot open the application"PgAdminII" because it may be damaged or 
incomplete.'

with no output to the Console/System Log  h. ?
also, i'm a little unclear why the install does not install the 
'PgAdminIII.app' where --prefix tells it to, but, rather, in the src tree ... 
but i'd guess that's an arguable point.

gonna google & code-dig a bit; any suggestions in the meantime will be 
appreciated!

richard

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

Re: [RESOLVED] Re: [pgadmin-hackers] getting past wxMac-cvs build?

[OpenMacNews]

hi,
If you want to build an .app bundle for pgadmin, please try the latest version
of the .app support. You can find a diff and a tgz on www.phlo.org.
You need two apply the patch, and then extract the tgz, both while being
int the root-dir if your pgadmin sources.
already there -- got your post abt the patches, read up in thread a bit, 
applied and started over.

should be done building in a little bit.
richard
---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org

[RESOLVED] Re: [pgadmin-hackers] getting past wxMac-cvs build?

[OpenMacNews]

hi florian,
thanks for the helpful reply!
I didn't observe the Rez/DeRez difficulties you had.
apparently, someone had (cref: [wx-dev]) ... for those that are interested, it 
turns out it was a problem with an unavailable display.

after some poking around with no success, i'd moved to another build machine 
and
-- all was OK!?

on the build box, i'd MISconfigured the DISPLAY ... so, although i was locally
exec'ing -- rather than ssh'd somewhere, as in Robin @ [wx-dev]'s example -- 
the display
WAS unavailable.

simply moving to a machine where the local DISPLAY was config'd correctly, and
correcting the misconfig'd box, cleared up my probs ...
   /usr/local/wxMac-cvs/bin  % ls -al wxrc-2.5
   -rwxr-xr-x  1 dev wheel 811808 Apr  8 22:30 wxrc-2.5
it seems others *here* have had success with this, so ...
Building wx was very smooth for me...
If you just want to hack on pgadmin, and not on wx, I could
email you the result of my wx build.
thx for the offer, but i think i'll be OK =)
at the moment, with a 'good' wxMac in place -- i'm building pgadmin3.
i'm just having a minor issue on make w/:
   ld: Undefined symbols:
   _libintl_bindtextdomain
   _libintl_dgettext
   make[2]: *** [pgadmin3] Error 1
   make[1]: *** [all-recursive] Error 1
   make: *** [all] Error 2
and wondering where the trouble is.  my pgsql *is* built with enable-nls, so i 
think there may be some issue ... i'll report back if i find any probs.

cheers,
richard
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

[pgadmin-hackers] getting past wxMac-cvs build?

[OpenMacNews]

hi all,
1st, i know this is not, directly, a pgadmin issue.
i've posted this (er ... similar) issue on wx-dev as well, but as my ultimate 
goal is to 'get to ' pgadminIII on MacOSX *and* there seems to be active 
interest/activity on this list in the same, i'll unabashedly crosspost/beg for 
help *here* ...

i'm diving in to try building the latest wxMac (both v2.5.5 & cvs trunk) on OSX 
10.3.8 on my powerbook G4 (800 MHz, 1 GB RAM).

after reading , a simple/successful
'configure' with:
   mkdir -p macosx-build
   cd macosx-build
   ../configure \
   --prefix=/usr/ports/wxMacINSTALL \
   --with-mac \
   --disable-shared \
   --disable-debug
finishes without errors.
a subsequent 'make all' of wxMac progresses to this point:
   /Developer/Tools/SetFile -t APPL wxrc
   /Developer/Tools/Rez -d __UNIX__ -useDF ../src/mac/carbon/apprsrc.r
../src/mac/carbon/carbrsrc.r ../src/mac/carbon/corersrc.r -o
lib/libwx_mac-2.5.5.rsrc
   /Developer/Tools/DeRez lib/libwx_mac-2.5.5.rsrc Carbon.r -useDF
lib/libwx_mac-2.5.5.r
and just sits.  For a very long time.
Well, actually, it seems to me still active in a DeRez task, as 'top' shows it
still crankin' away after 6+ hours (total time ~ 8 hours) ...
   15904 DeRez   35.8%  6:21:49   125   106   296K  1.82M  6.26M 
60.5M

i've now gotten feedback that this is NOT normal; tho, this behavior HAS been 
seen before ...

I've had this problem too, but only when I run the build when logged in
remotely via ssh.  If I run the build from a local Terminal window then this
step just takes less than a second.  My guess is that DeRez needs to have
access to the display for some reason and isn't smart enough to figure out
that it can't get it.
that said, i *am* building in a local Terminal window ... apparently to no 
avail.

now, i _have_ found is this list's archives that there have been 'issues' with 
v2.5.4, resolved in CVS, but afaik, not THIS issue.

it seems others *here* have had success with this, so ...
any pointers as to how to get wxMac built so I can get to pgadmin work would be 
much appreciated! =)

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