Re: [pgadmin-support] Linking issues building pgAdmin3 v1.4.2 on

2006-05-30 Thread Miha Radej
Hi! Which version of Suse is that? I've had some problems also but have so far been able to resolve them on all versions of Suse I've used: 9.3, 10.0, 10.1. Only with Suse 9.3 have I built wx from source, on 10.x I use wx available from Yast. With that there were no problems on 10.0, on 10.1 I ge

Re: [pgadmin-support] line number in error output

2006-04-05 Thread Miha Radej
Hi! Dave Page wrote: I'm using Windows version 1.4.2 on Win XP sp1. When I get an error in executing a sql code, I get ERROR: syntax error at or near "45183" at character 5848 There is no line number included. Such information would make very easy to locate the offending code. The er

Re: [pgadmin-support] How to use arrow keys to move to other row

2006-04-04 Thread Miha Radej
Hello! I would like to second this request. Would it be possible/useful perhaps to implement an OOo Calc/Excel - like option to define which cell is activated after pressing perhaps: above, below, left or right of the current one? IMO it would be very convenient to sometimes edit from the gr

[pgadmin-support] Feature request - option to exclude docs when installing

2006-04-04 Thread Miha Radej
Hi! I have the following feature request: is it possible to add an option (maybe at configure time?) which would cause "make install" to exclude installation of the documentation (at least the PostgreSQL and Slony docs)? Thank you, Miha ---(end of broadcast)--

Re: [pgadmin-support] pgAdmin on SUSE 10.0 needing libcrypto.so.5

2006-01-18 Thread Miha Radej
hi! are you installing from source or from a rpm package via yast? if the latter, afaik yast should automagically fix any unresolved dependencies for you usually. if you're building from source, try installing some devel packages from yast, like openssl-devel, postgresql-devel and any others

Re: [pgadmin-support] problem compiling on suse 10 - success

2006-01-13 Thread Miha Radej
huge, powerful primitive tribes with more sophisticated weapons." -- Terry Pratchett, Small Gods Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 11 January 2006 12:28 To: Dave Page Cc: Miha Radej; [EMAIL PROTECTED]; pgadmin-support@postgr

Re: [pgadmin-support] problem compiling on suse 10

2006-01-13 Thread Miha Radej
hi! Dave Page wrote: Did you try this Miha? I should point out that we don't support 2.7 at the moment, and in fact don't intend to if we can help it - 2.6 has all the features we currently need so we don't want to expend effert tracking wx's development releases. 2.6 should definitely work tho

Re: [pgadmin-support] problem compiling on suse 10

2006-01-09 Thread Miha Radej
hi! [EMAIL PROTECTED] wrote: After removing wxWidgets 2.6.2, downloading and compiling wxWidgets development snapshot (2.7 dev) and compiling pgadmin3 configured with --with-wx-version=2.7, now pgadmin3 runs Ok. Both wxWidgets and pgadmin were configure with --enable-debug. Linux is Fedora Cor

[pgadmin-support] problem compiling on suse 10

2006-01-08 Thread Miha Radej
hi! i am having problems compiling pgadmin on suse linux 10. i have downloaded and compiled wxGTK 2.6.2 without problems (the contrib directory also), using the following configure command: ./configure --with-gtk --enable-gtk2 --enable-unicode --enable-mimetype=yes --enable-debug after ins

Re: [pgadmin-support] bug with fkey-dialog in tables belonging to

2005-12-13 Thread Miha Radej
hi! http://archives.postgresql.org/pgadmin-support/2005-11/msg00102.php i've reported what seems to be the same bug about a month ago. i can confirm that, like harald said, it occured when working on a schema with the same name as the user connecting to the database. and in a follow-up to the

Re: [pgadmin-support] bug with fkey-dialog in tables belonging to

2005-12-13 Thread Miha Radej
hi! i seem to be having problems with sending email today so if anyone receives this email twice... i apologize. ** http://archives.postgresql.org/pgadmin-support/2005-11/msg00102.php i've also posted what seems to be the same bug about a month ago. i can confirm that, like

[pgadmin-support] drop constraint/column for v1.4.1

2005-12-02 Thread Miha Radej
hi! as version 1.4.1 will be released soon, i was just wondering if there was any chance of solving this reported issue: http://archives.postgresql.org/pgadmin-hackers/2005-11/msg00277.php some people i know remove constraints and columns separately and are a bit annoyed by the errors they g

Re: [pgadmin-support] newbie question

2005-11-17 Thread Miha Radej
hi! i once had a similair problem, but due to a partial hard drive failure. all i needed was the data directory from the 7.2 version. i then installed pgsql7.2 into a different directory and ran the 7.2 server with the -D parameter pointing to the old data directory. next, i ran pg_dump and p

Re: [pgadmin-support] views, primary keys and guru hints

2005-11-14 Thread Miha Radej
hi! Andreas Pflug wrote: Miha Radej wrote: hi! is it normal for pgadmin3 to display a "you don't have a primary key so i can't edit this table" guru hint when i view data in a view? Yes. Do we need to suppress this for views? yes, please. afaik and as far

[pgadmin-support] views, primary keys and guru hints

2005-11-14 Thread Miha Radej
hi! is it normal for pgadmin3 to display a "you don't have a primary key so i can't edit this table" guru hint when i view data in a view? thanks, Miha ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

Re: [pgadmin-support] problem adding a foreign key in v1.5 and a question re v1.5 vs

2005-11-11 Thread Miha Radej
hi! the foreign key problem seems to come from using an incorrect schema name. ie. in a database i am using i have a few schemas. i am working on one of them and when selecting a referencing table all table names are displayed as 'schema.tablename' except the tables from the current schema i'

[pgadmin-support] problem adding a foreign key in v1.5 and a question re v1.5 vs 1.2.2

2005-11-11 Thread Miha Radej
hi! i'm using pgadmin3 v1.5 devel, built today from a fresh cvs checkout. with this version i am having problems adding foreign keys (to existing tables or when creating a new table) since pgadmin doesn't seem to refresh the columns in the selected table and i cannot select a column to specif

Re: [pgadmin-support] Graphical Explain

2005-11-08 Thread Miha Radej
hi! graphical explain works for me in the sql query tool when i have the query->explain options->verbose option unchecked. then just provide a query, hit f7 and it should work. regards, Miha Obe, Regina DND\MIS wrote: How do you get the Graphical Explain to show? I saw the snapshots on the

[pgadmin-support] pgagent language question

2005-11-03 Thread Miha Radej
hi! i have a question regarding pgagent. if you just run pgagent without any arguments, it displays some options, etc. are these also supposed to be translated? i saw some stings like the ones that get displayed by running pgagent but the only language pgagent was speaking to me was english.

Re: [pgadmin-support] wrong generated sql query order

2005-08-22 Thread Miha Radej
hi! this happens to me on any table i've tried. here is a sample: CREATE TABLE sampletable ( col1 serial NOT NULL, col2 int4 ) WITH OIDS; ALTER TABLE sampletable OWNER TO adocuments; this is a table in a "adocuments" schema, owned by the user "adocuments". in the table properties pane, tab

[pgadmin-support] wrong generated sql query order

2005-08-21 Thread Miha Radej
hi! i had opened the table properties window and on the "columns" tab removed a column and immediately added a new one with the same name only of different type. this change failed due to a wrong sql query order; pgadmin had produced this ALTER TABLE document_data ADD COLUMN locked_by text; A

Re: [pgadmin-support] Network access problem

2005-07-14 Thread Miha Radej
hi! please also try uncommenting the listen_addresses line, ie. to: listen_addresses = '*' then reload the configuration or restart the server and try again. regards, M [EMAIL PROTECTED] wrote: I have installed PostGreSql on my machine. Then I changed “postgresql.conf” file to allow database

Re: [pgadmin-support] Compiling pgadminIII on SuSE 9.3

2005-06-17 Thread Miha Radej
hi! you do not need to install pgsql from source. i've also had the same problem you describe on suse 9.3. following dave's advice i did this to get a successful build: LDFLAGS="-L/usr/lib -lkrb5" ./configure [your configure options] make sudo make install and it works without problems. well

Re: [pgadmin-support] startup error message "cannot convert from

2005-06-07 Thread Miha Radej
_NAME="sl_SI.UTF-8" LC_ADDRESS="sl_SI.UTF-8" LC_TELEPHONE="sl_SI.UTF-8" LC_MEASUREMENT="sl_SI.UTF-8" LC_IDENTIFICATION="sl_SI.UTF-8" LC_ALL= and slovenian (slovenščina) in pgadmin3. i've already tried a few languages before (english, japanese, germa

Re: [pgadmin-support] startup error message "cannot convert from

2005-06-07 Thread Miha Radej
05 INFO : Destroying a splash screen i've configured wxwidgets exactly as stated on the pgadmin3 website (except playing with the --enable-debug and --disable-debug switches) and have followed the instructions on compiling pgadmin3 as well. Andreas Pflug wrote: Miha Radej wrote: hi! i'

[pgadmin-support] startup error message "cannot convert from the charset ..."

2005-06-07 Thread Miha Radej
hi! i've been playing and compiling with various combinations, omitting --enable-debug and/or using --disable-debug with wxwidgets, a fresh pgadmin3 checkout and pgadmin3 1.2.2. in all cases the result is the same: i still get the startup error message: http://mcajvar.prkoritu.net/images/pga

Re: [pgadmin-support] compiling pgadmin3 on suse 9.3

2005-06-03 Thread Miha Radej
hi again! upon executing the binary, i get the following error message: Cannot convert from the charset '@LOCALE,UTF-8,ISO-8859-2,CP1250'! after clicking ok, everything seems to work without problems. is this message a result of using the "--enable-debug" switch? does it go away if i were to

[pgadmin-support] compiling pgadmin3 on suse 9.3

2005-06-03 Thread Miha Radej
hi! firstly, i am very new to linux, so forgive me for asking stupid questions (it's easy to install in windows. next, next, use defaults, finish ;)) i have recently migrated to suse linux 9.3 and have, after hearing from a friend having problems installing from fedora rpm's (suse 8.2 rpm d

Re: [pgadmin-support] pgAdminIII and the LogFile - useless for debugging

2005-03-01 Thread Miha Radej
hi scott! if you only need the tail command, you will probably find this package _very_ useful, and with it you probably will not need cygwin: http://unxutils.sourceforge.net/ hope this will help you with your work until you will be able to manage everything you need from within pgadmin. regar

Re: [pgadmin-support] [ANNOUNCE] pgAdmin III 1.2.0 Released

2004-12-03 Thread Miha Radej
hello! Dave Page wrote: FreeBSD is done. But, It leaves warning of some wxWidgets. However, It is probably and just Debug information. There are BSD5.2(5.2.1R). BSD5.3 will be dealt with soon. Thanks Hiroshi :-) Incidently - the last version of pgAdmin was in BSD ports - do you know if there are

[pgadmin-support] copying sql code to clipboard

2004-11-04 Thread Miha Radej
hi! this is more sort of a feature request than anything else. if i do _anything_ where there is an "SQL" tag where the generated code is displayed and i copy it into clipboard, pgadmin III clears it from clipboard when it's closed. is it possible for pgadmin III to leave anything that's put in

[pgadmin-support] translation bug/problem

2004-10-25 Thread Miha Radej
hi! i've noticed that a certain string is written in english even though it is translated in many languages. the "offending" string that was written in english, regardless of the language i had set in the options dialogue, is "Disable $$ quoting" i have translated this string but still get the en

Re: [pgadmin-support] refreshing object tree

2004-10-25 Thread Miha Radej
hi! Andreas Pflug wrote: Please describe *exactly* what and how you do the delete: which object selected, menu/context menu/keyboard command etc. of course. this is the procedure: in the object tree i browse to the table listing. table count (in brackets) is 21, sequence count shows 20. click on

Re: [pgadmin-support] refreshing object tree

2004-10-25 Thread Miha Radej
hi! Andreas Pflug wrote: using pgadmin III 1.2.0 post-beta2, oct 16 2004 snapshot on win2k, sp4. database is pgsql 8.0 beta1 running on the same machine. i experienced the described behaviour in some earlier snapshots also. I noticed too, and fixed that yesterday. New snapshot will be uploaded t

[pgadmin-support] refreshing object tree

2004-10-21 Thread Miha Radej
hi! using pgadmin III 1.2.0 post-beta2, oct 16 2004 snapshot on win2k, sp4. database is pgsql 8.0 beta1 running on the same machine. i experienced the described behaviour in some earlier snapshots also. i noticed this: in the object tree i have 19 sequences listed and 20 tables. after deleting a

Re: [pgadmin-support] Cannot add non-null columns

2004-10-05 Thread Miha Radej
hi! afaik you cannot add a not null column to a table because (in a table where there is already some data) the field values are null. the option to add a not null column perhaps only works on an empty table with no rows yet. so this behaviour is expected. therefore you need to add a column, upd

Re: [pgadmin-support] locally running servers

2004-09-10 Thread Miha Radej
Andreas Pflug wrote: This requirement appears quite exotic to me. I don't see how to prevent discovering it for you without degrading the usefulness of the feature for others. perhaps if there were an option somewhere, like "disable server autodiscovery at startup", which would be enabled by def

Re: [pgadmin-support] locally running servers

2004-09-10 Thread Miha Radej
key exists (and existed when the error was reported). if i remember correctly, there was something about a missing file in the error i got. in this key i have the following data stored: data dir, superuser, display name, encoding, locale and service account. regards, M Andreas Pflug wrote: Miha

[pgadmin-support] locally running servers

2004-09-10 Thread Miha Radej
hi! i noticed that pgadmin found i have a server running on the same machine and it automatically added it to the object browser. the first few times it also reported an error about not being able to read the pgsql key from the registry but it still added the server to the list, now it just add

Re: [pgadmin-support] strange (win32 only?) row deletion bug report

2004-09-08 Thread Miha Radej
hi! Andreas Pflug wrote: We had this on the BUGS list, but I wasn't able to reproduce this. Your oops, forgot to check :) description is very detailed, so maybe we'll catch it this time. Since we're in the middle of rolling 1.2 Beta-1, this might take some days, please be patient. it is merely a

[pgadmin-support] strange (win32 only?) row deletion bug report

2004-09-08 Thread Miha Radej
hi! i've come across a strange bug. i have a table, some rows inserted and i'm viewing the data inside. in the table i can edit data, i have some unique constraints and a pk set. column user_id (primary key) has rows with values from 59 to 69. if i select the rows by clicking on the row number f

[pgadmin-support] database backup with pg_dump via pgadmin3 problem

2004-09-03 Thread Miha Radej
hi! on windows 2000 sp4 i get to the following problem while trying to do a database backup using pgadmin3 version 1.1.0 devel (jul 23 2004): ** pg_dump.exe -h localhost -p 5432 -U delo -F p -v -f "c:\trusted_backup.sql" explorer pg_dump.exe: server version: 8.0.0beta1; pg_dump.

Re: [pgadmin-support] Help not modeless

2004-04-25 Thread Miha Radej
Hi! I'm using version 1.1.0 devel (Mar 26 2004) on Win2k and I can confirm the same situation. If I open up pgAdmin III and press F1 (or, for that matter, choose Help... from the menu), the help window opens up. I can see pgAdmin III or other aplications in the background and if I click anywher

Re: [pgadmin-support] pgAdmin III truncates numeric values in

2003-08-28 Thread Miha Radej
Hi! I was wondering, if one double clicks on a field (truncated or not) and doesn't make any changes, then pgAdmin doesn't need to change the data? If I understand correctly, the value entered was 1.51515151515151512 and displayed as 1.515152. If Masoud wouldn't have double clicked on the field

[pgadmin-support] Nonexistent URL on the pgAdmin3 website

2003-08-19 Thread Miha Radej
Hi! On the pgAdmin3 site (http://www.pgadmin.org/pgadmin3/development.php#dev_snap) there's a link, pointing to daily snapshots for Windows. It is currently pointing to http://www.pgadmin.org/snapshots/windows which doesn't exist, it should be either http://www.pgadmin.org/snapshots/win32/ or

Re: [pgadmin-support] Viewing data in pgAdmin3

2003-08-18 Thread Miha Radej
At 13:51 18.8.2003 +0100, you wrote: > With pgAdmin3 0.9.0 beta 1 (Aug 6 2003) I connected to a > database (). I executed a 'SELECT * FROM "TableName";' query > and it showed all the data > contained within the table. But when I wanted to looak at the > data using > the "View Data" option, an empty

[pgadmin-support] Viewing data in pgAdmin3

2003-08-18 Thread Miha Radej
Hi! With pgAdmin3 0.9.0 beta 1 (Aug 6 2003) I connected to a database (). I executed a 'SELECT * FROM "TableName";' query and it showed all the data contained within the table. But when I wanted to looak at the data using the "View Data" option, an empty window opened up and that was it. No data

[pgadmin-support] Foreign key creation error

2003-08-14 Thread Miha Radej
Hi! I've tried creating in pgAdmin3. The generated SQL output was CREATE TABLE public."KOMENTARJI" ( "idKomentarja" bigserial NOT NULL, "idRecepta" int8 NOT NULL, "idUporabnika" int8 NOT NULL, "Komentar" text NOT NULL, "DatumVnosa" text NOT NULL, "IPVnosa" text NOT NULL, CONS