Re: [pgadmin-hackers] The trouble with search_path ...

2004-06-10 Thread Andreas Pflug
Chris Gamache wrote:
Please try to reproduce this bug:
Select properties on a database element. 
Click to the Variables tab

Known bug, fixed in CVS head.
Regards,
Andreas

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


[pgadmin-hackers] The trouble with search_path ...

2004-06-10 Thread Chris Gamache
Please try to reproduce this bug:

Select properties on a database element. 
Click to the Variables tab
Select "search_path" from the drop-down
Set the Variable value textfield to "public, pgcatalog, my_schema"
Click OK.

in the description pane you'll find:

-- Database: data

-- DROP DATABASE data;

CREATE DATABASE data
  WITH ENCODING = 'SQL_ASCII';
ALTER DATABASE data SET "search_path=public,;
ALTER DATABASE data SET pg_catalog,;
ALTER DATABASE data SET my_schema";

Somehow I don't think that's the right syntax... Since I've done this, how can
I undo it?

ALTER DATABASE RESET "search_path=public,;
ALTER DATABASE data SET pg_catalog,;
ALTER DATABASE data SET my_schema";

?

CG




__
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/ 

---(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] pgAdmin3 doesn't work after upgrading FC1 to

2004-06-10 Thread Adam H. Pendleton
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Devrim GUNDUZ wrote:
|
|
| I've rebuilt wxGTK2ud-2.5-20031010.10.tar.bz2 with the usual spec file...
|
Just out of curiosity, just try building pgAdmin3 against a clean CVS
tree from wxWidgets.  Does that work?
ahp
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFAyKNuf/U4M//FQ/URAiVxAKCwPpYbttN6x0cgh4BAEFJUJZF2NQCgsq4N
KZDuFy5qX3gyzhSZ3rwF1ho=
=YU2o
-END PGP SIGNATURE-
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faqs/FAQ.html


Re: [pgadmin-hackers] [pgadmin-support] pgAdmin3 doesn't work after

2004-06-10 Thread Adam H. Pendleton
Jean-Michel POURE wrote:
> Le jeudi 10 Juin 2004 19:12, Adam H. Pendleton a écrit :
>
>>Did you use a binary package of wxWidgets or did you re-build that
>>package on FC2 before you build pgAdmin3?
>
>
> Dear Adam,
>
> Did you try building wx RPMs using the wx custom script? Last time I 
used the
> script (nearly one year ago, a decade in computing!), the script was 
of good
> quality. This is quite a pitty that they do not release RPMs more often.

I never build the RPMs...:-(
ahp
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [pgadmin-hackers] pgAdmin3 doesn't work after upgrading FC1 to

2004-06-10 Thread Devrim GUNDUZ



Hi,

On Thu, 10 Jun 2004, Adam H. Pendleton wrote:

> | I got the same error while building the rpm:
> 
> Hmmm, I built pgAdmin3 on FC2 without issue.  Of course I was messing
> with the CVS version of wxWidgets, but
> 
> Did you use a binary package of wxWidgets or did you re-build that
> package on FC2 before you build pgAdmin3?

I've rebuilt wxGTK2ud-2.5-20031010.10.tar.bz2 with the usual spec file...

-- 
Devrim GUNDUZ  
devrim~gunduz.org   devrim.gunduz~linux.org.tr 
http://www.tdmsoft.com
http://www.gunduz.org


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

   http://archives.postgresql.org


Re: [pgadmin-hackers] [pgadmin-support] pgAdmin3 doesn't work after

2004-06-10 Thread Jean-Michel POURE
Le jeudi 10 Juin 2004 19:12, Adam H. Pendleton a écrit :
> Did you use a binary package of wxWidgets or did you re-build that
> package on FC2 before you build pgAdmin3?

Dear Adam,

Did you try building wx RPMs using the wx custom script? Last time I used the 
script (nearly one year ago, a decade in computing!), the script was of good 
quality. This is quite a pitty that they do not release RPMs more often. 

Cheers,
Jean-Michel

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


Re: [pgadmin-hackers] [pgadmin-support] pgAdmin3 doesn't work after

2004-06-10 Thread Adam H. Pendleton
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Devrim GUNDUZ wrote:
| I got the same error while building the rpm:
Hmmm, I built pgAdmin3 on FC2 without issue.  Of course I was messing
with the CVS version of wxWidgets, but
Did you use a binary package of wxWidgets or did you re-build that
package on FC2 before you build pgAdmin3?
ahp
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFAyJZ6f/U4M//FQ/URAhF1AJ9g7z3CQR9MMF7s3/W8m3aCB4g+YQCeO2nf
0nUPIx4EaOH2KllkfLBEO84=
=7oqA
-END PGP SIGNATURE-
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [pgadmin-hackers] [pgadmin-support] pgAdmin3 doesn't work after upgrading FC1 to

2004-06-10 Thread Devrim GUNDUZ

Hi,

On Thu, 10 Jun 2004, Dave Page wrote:

> > I upgraded Fedora Core 1 to Fedora Core 2 and pgAdmin3 
> > doesn't work any more. When launched on the terminal, the error is:
> > "pgadmin3: error while loading shared libraries: pgadmin3: undefined
> > symbol: _gtk_accel_group_attach"
> > 
> > Thanks for any help.
> > 
> > (version is pgadmin3-1.1.0-cvs20031211)
> 
> The GTK libraries have changed in FC2, requiring a different build of
> pgAdmin (which none of us provide yet).

I got the same error while building the rpm:

===
g++ -DDATA_DIR=\"/usr/share/pgadmin3/\" -Wall -g -I../src/include 
-I../src/agent/include -Wall -g -O0  -L/usr/lib -L/usr/lib -o pgadmin3  
pgAdmin3.o pgConn.o pgSet.o keywords.o pgAggregate.o pgCast.o pgCheck.o 
pgCollection.o pgColumn.o pgConstraints.o pgConversion.o pgDatabase.o 
pgDomain.o pgForeignKey.o pgFunction.o pgGroup.o pgIndex.o 
pgIndexConstraint.o pgLanguage.o pgObject.o pgOperator.o pgOperatorClass.o 
pgRule.o pgSchema.o pgSequence.o pgServer.o pgTable.o pgTrigger.o pgType.o 
pgUser.o pgView.o pgDatatype.o pgaAgent.o pgaJob.o pgaStep.o pgaSchedule.o 
dlgJob.o dlgSchedule.o dlgStep.o xh_sqlbox.o xh_calb.o xh_timespin.o 
calbox.o timespin.o ctlListView.o ctlSQLBox.o ctlSQLResult.o frmExport.o 
dlgAddTableView.o dlgEditGridOptions.o events.o frmAbout.o frmIndexcheck.o 
frmChildTableViewFrame.o frmConnect.o frmMain.o frmOptions.o frmPassword.o 
frmQuery.o frmQueryBuilder.o frmHelp.o frmQBJoin.o frmSplash.o 
frmMaintenance.o frmEditGrid.o dlgProperty.o dlgUser.o dlgGroup.o 
dlgDatabase.o dlgLanguage.o dlgSchema.o dlgDomain.o dlgTable.o dlgColumn.o 
dlgIndex.o dlgFunction.o dlgView.o dlgRule.o dlgOperator.o dlgAggregate.o 
dlgCast.o dlgConversion.o dlgIndexConstraint.o dlgForeignKey.o 
dlgSequence.o dlgTrigger.o dlgType.o dlgCheck.o frmStatus.o misc.o 
sysLogger.o sysSettings.o utffile.o xrcDialogs.o  /usr/lib/libpq.a -lcrypt  
-lssl -lcrypto /usr/lib/libwx_gtk2ud_stc-2.5.a 
/usr/lib/libwx_gtk2ud_xrc-2.5.a  -pthread  /usr/lib/libwx_gtk2ud-2.5.a 
-Wl,--export-dynamic -pthread -lgtk-x11-2.0 -lgdk-x11-2.0 -latk-1.0 
-lgdk_pixbuf-2.0 -lm -lpangoxft-1.0 -lpangox-1.0 -lpango-1.0 -lgobject-2.0 
-lgmodule-2.0 -ldl -lgthread-2.0 -lglib-2.0 -Wl,--export-dynamic 
-lpangoft2-1.0 -lpango-1.0 -lgobject-2.0 -lgmodule-2.0 -ldl -lglib-2.0 
-lpng -ljpeg -ltiff -lz -ldl -lm
/usr/lib/libwx_gtk2ud-2.5.a(monolib_settings.o)(.text+0x930): In function 
`wxSystemSettingsNative::GetFont(wxSystemFont)':
: undefined reference to `_gtk_rc_context_get_default_font_name'
/usr/lib/libwx_gtk2ud-2.5.a(monolib_menu.o)(.text+0xbdd): In function 
`wxMenubarUnsetInvokingWindow(wxMenu*, wxWindow*)':
: undefined reference to `_gtk_accel_group_detach'
/usr/lib/libwx_gtk2ud-2.5.a(monolib_menu.o)(.text+0xcd9): In function 
`wxMenubarSetInvokingWindow(wxMenu*, wxWindow*)':
: undefined reference to `_gtk_accel_group_attach'
/usr/lib/libwx_gtk2ud-2.5.a(monolib_menu.o)(.text+0xd8e): In function 
`wxMenuBar::SetInvokingWindow(wxWindow*)':
: undefined reference to `_gtk_accel_group_attach'
/usr/lib/libwx_gtk2ud-2.5.a(monolib_menu.o)(.text+0xe00): In function 
`wxMenuBar::UnsetInvokingWindow(wxWindow*)':
: undefined reference to `_gtk_accel_group_detach'
collect2: ld returned 1 exit status
make[2]: *** [pgadmin3] Error 1
make[2]: Leaving directory `/usr/src/redhat/BUILD/pgadmin3-1.1.0/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/src/redhat/BUILD/pgadmin3-1.1.0'
make: *** [all] Error 2
error: Bad exit status from /var/tmp/rpm-tmp.56985 (%build)
 
RPM build errors:
Bad exit status from /var/tmp/rpm-tmp.56985 (%build)
== 


-- 
Devrim GUNDUZ  
devrim~gunduz.org   devrim.gunduz~linux.org.tr 
http://www.tdmsoft.com
http://www.gunduz.org




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