[pgadmin-support] Error Message: Object variable or With block variable not set
-- System Information -- Platform: Windows XP Version: 5.1 Build: 2600 Service Pack 1 -- Application Information -- Name: pgAdmin II Version: 1.6.0 Descripton: Name: pgSchema Version: 1.6.0 Descripton: PostgreSQL Schema Objects v1.6.0 -- Database Information -- Version: 0.0.0 Descripton: -- Driver Information -- Name: Version: 0.0.0 Descripton: -- Error Information -- Description: Object variable or With block variable not set Number: 91 Routine: pgAdmin II:frmUpgradeWizard.UpgradeCheck Insert your comment: Error occurred whenrunning Upgrade CheckWizard upon PgAdmin startup pgAdmin II_3976.Log Description: Binary data ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-support] Error Message: Object variable or With block variable not set
Hi Gerard, This error should be fixed now - there was a typo in the data file on the pgAdmin webserver. Regards, Dave > -Original Message- > From: Gerard Talbert [mailto:[EMAIL PROTECTED] > Sent: 30 September 2003 20:51 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Error Message: Object variable or > With block variable not set > > > > -- System Information -- > > Platform: Windows XP > Version: 5.1 > Build: 2600 Service Pack 1 > > -- Application Information -- > > Name: pgAdmin II > Version: 1.6.0 > Descripton: > > Name: pgSchema > Version: 1.6.0 > Descripton: PostgreSQL Schema Objects v1.6.0 > > -- Database Information -- > > Version: 0.0.0 > Descripton: > > -- Driver Information -- > > Name: > Version: 0.0.0 > Descripton: > > -- Error Information -- > > Description: Object variable or With block variable not set > Number: 91 > Routine: pgAdmin II:frmUpgradeWizard.UpgradeCheck > > > > Insert your comment: > Error occurred whenrunning Upgrade CheckWizard upon PgAdmin startup > ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-support] Error Message: Variabile oggetto o variabile del blocco With non impostata
Hi Riccardo, This error should be fixed now - there was a typo in the data file on the pgAdmin webserver. Regards, Dave > -Original Message- > From: Riccardo [mailto:[EMAIL PROTECTED] > Sent: 30 September 2003 10:57 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Error Message: Variabile oggetto o > variabile del blocco With non impostata > > > > -- System Information -- > > Platform: Windows NT > Version: 4.0 > Build: > ---(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-support] Error Message: Object variable or With block variable not set
Hi Angel, This error should be fixed now - there was a typo in the data file on the pgAdmin webserver. Regards, Dave > -Original Message- > From: Angel Vicente Perez [mailto:[EMAIL PROTECTED] > Sent: 30 September 2003 11:19 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Error Message: Object variable or > With block variable not set > > > -- System Information -- > > Platform: Windows 2000 > Version: 5.0 > Build:2195 Service Pack 4 > > -- Application Information -- > > Name: pgAdmin II > Version: 1.6.0 > Descripton: > > Name: pgSchema > Version: 1.6.0 > Descripton: PostgreSQL Schema Objects v1.6.0 > > -- Database Information -- > > Version: 7.3.4 > Descripton: PostgreSQL 7.3.4 on i386-pc-linux-gnu, compiled by GCC > i386-linux-gcc (GCC) 3.3.2 20030831 (Debian prerelease) > > -- Driver Information -- > > Name: PostgreSQL > Version: 7.3.100 > Descripton: PostgreSQL 7.3.4 on i386-pc-linux-gnu, compiled by GCC > i386-linux-gcc (GCC) 3.3.2 20030831 (Debian prerelease) > > -- Error Information -- > > Description: Object variable or With block variable not set > Number: 91 > Routine: pgAdmin II:frmUpgradeWizard.UpgradeCheck > > > > Insert your comment: > ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[pgadmin-support] pgAdminIII bug
Hi All, Dave - as I've posted once before in reference to pgAdminII - GREAT JOB. The pgAdmin team always creates a great tool. I have found a bug however in the 1.0 release of pgAdminIII. If you create a trigger linked to a stored procedure (normal means of creating a trigger), the trigger path does not reference the schema correctly so PG looks for the procedure in the public schema. Will eventually get around to submitting a few patches myself but I've been a bit lazy at getting wxWindows installed ;) Rgds, Jason ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-support] pgAdminIII bug
Hi Jason, > -Original Message- > From: Jason Godden [mailto:[EMAIL PROTECTED] > Sent: 01 October 2003 08:55 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] pgAdminIII bug > > > Hi All, > > Dave - as I've posted once before in reference to pgAdminII - > GREAT JOB. The > pgAdmin team always creates a great tool. Thanks :-) > I have found a bug however in the 1.0 release of pgAdminIII. > If you create a > trigger linked to a stored procedure (normal means of > creating a trigger), > the trigger path does not reference the schema correctly so > PG looks for the > procedure in the public schema. I fixed that on Monday :-). It's been patched in the main CVS branch, and the REL1_0_0_PATCHES branch. > Will eventually get around > to submitting a > few patches myself but I've been a bit lazy at getting > wxWindows installed ;) I look forward to them. Thanks for the bug report, Regards, Dave ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-support] Question: Russian data
Hello, Please use the [EMAIL PROTECTED] mailing list for support queries. I know little about the unicode support myself, (though others on the list do) but I suspect the first thing to find out is what encoding your database in? Regards, Dave. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 01 October 2003 09:11 > To: '[EMAIL PROTECTED]' > Subject: Question: Russian data > > > Hello > Why russian data from tables is not visible in pgadmin 3 release? > > Thanks. > ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[pgadmin-support] Cannot create index if table name contains uppercase characters
-- PGAdmin --
version: PGAdmin III version 1.0.0
OS: Windows XP Professional SP1
-- postgres --
Postgres: 7.3.4 on i686-pc-linux-gnu
OS: RedHat Linux 9
- steps to reproduce --
1. Create table with uppercase characters in name (like "tTable")
2. Create index on that table
-- Actual results --
Index is not created
PGAdmin states that reference "public.ttable" does not exist
-- Expected results --
Index is created
-- Comment --
It looks like the PGAdmin lowercases the table name before sending it to
postgres. If you see the SQL pane when creating the index, the table
name is correct ("tTable") but in the error message it it lowercased
("ttable").
Same error is when the SQL command is copied into SQL query tool.
When the same SQL command is entered on psql command line (on linux),
the index is created
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-support] Cannot create index if table name contains uppercase characters
Hi,
This problem occurs because pgAdmin doesn't quote the table name as it should when
mixed case names are involved. I have fixed this in CVS for the next release.
In order to create your indexes, you may use the SQL generated by pgAdmin, but add the
quotes manually around the table name in the query tool eg.:
CREATE INDEX foo ON public."Bar" (colname);
Thanks for the bug report.
Regards, Dave.
> -Original Message-
> From: Oldr(ich Dlouhý [mailto:[EMAIL PROTECTED]
> Sent: 01 October 2003 10:27
> To: PGAdmin support forum
> Subject: [pgadmin-support] Cannot create index if table name
> contains uppercase characters
>
>
> -- PGAdmin --
>
> version: PGAdmin III version 1.0.0
> OS: Windows XP Professional SP1
>
> -- postgres --
>
> Postgres: 7.3.4 on i686-pc-linux-gnu
> OS: RedHat Linux 9
>
> - steps to reproduce --
>
> 1. Create table with uppercase characters in name (like
> "tTable") 2. Create index on that table
>
> -- Actual results --
>
> Index is not created
> PGAdmin states that reference "public.ttable" does not exist
>
> -- Expected results --
>
> Index is created
>
> -- Comment --
>
> It looks like the PGAdmin lowercases the table name before
> sending it to
> postgres. If you see the SQL pane when creating the index, the table
> name is correct ("tTable") but in the error message it it lowercased
> ("ttable").
>
> Same error is when the SQL command is copied into SQL query tool.
>
> When the same SQL command is entered on psql command line (on linux),
> the index is created
>
>
> ---(end of
> broadcast)---
> TIP 5: Have you checked our extensive FAQ?
>
http://www.postgresql.org/docs/faqs/FAQ.html
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[pgadmin-support] Russian data in SQL_ASCII encoding
Hi!!! Why russian data from tables in pgadmin 3 release in SQL_ASCII coding is not visible, but this data visible in pgadmin 2? What is the different between pgadmin3 and pgadmin2 for this problem? Thanks. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-support] Russian data in SQL_ASCII encoding
Моисеев Алексей Николаевич wrote: Hi!!! Why russian data from tables in pgadmin 3 release in SQL_ASCII coding is not visible, but this data visible in pgadmin 2? What is the different between pgadmin3 and pgadmin2 for this problem? Thanks. Hm, I suspect that the server isn't able to translate your SQL_ASCII data to Unicode to send it over the line. Currently, pgAdmin3 tells the backend to send all data in Unicode, which should fit everything (if convertible). Maybe we should leave the client connection SQL_ASCII if this is the server encoding, because there are probably many SQL_ASCII encoded databases around that actually contain non-ascii (thus non-convertible) data. Regards, Andreas ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [pgadmin-support] installation of pgAdmin3 on SuSE8.2
Dear Mark and List Members,
Thanks for your help. The source installation of vxWindows worked as you
suggested. I installed agnome system as suggested. After running the
configure script, the foist make reported some missing files, I unhashed
the following lines in /etc/profile
LD_LIBRARY_PATH=/usr/lib:/opt/gnome/lib:/opt/gnome2/lib
export LD_LIBRARY_PATH
rebooted and re-run make and the compilation worked.
I then encountered a problem when I tried to install pgadmin3.
I downloaded pgadmin3-1.0.0 tarball from the postgresql site. I decompressed
the tarball and did the following:
1) I ran './configure --enable-static --enable-debug '
2.) I ran 'make all'and I received the following:
make[2] : *** [pgadmin3.0] Error 1
make[2]: leaving directory /opt/pgadmin3-1.0.0/src
make[1]: *** [all recursive] Error 1
make[1]: leaving directory /opt/pgadmin3-1.0.0/src
make: ***[all] Error 2
I am using gcc3.2 (the default with SuSE8.2). All suggestions are
welcomed.
regards
CT
On Tuesday 30 September 2003 05:20, Mark A. Taff wrote:
> I had the same problems. Assuming a default SuSE 8.2:
>
> Use YaST to install glib2-devel, pango-devel, atk-devel packages. I also
> reccommend installing a _full_ gnome system, as it will save you headaches
> later. :) Also install the 100dpi fonts.
>
> Then build as per the instructions on the pgadmin website. If you still
> have problems compiling, run: `pkg-config --modversion --debug`. This will
> check a long line of dependencies, and report any dependencies not found,
> i.e. package "foo" not found. Then use YaST to install package "foo".
> Continue in this fashion until all packages are found, then try to
> recompile from scratch.
>
> After compiling, add the following lines to /etc/X11/gtk2rc-keramik (as
> root):
>
> style "defaultfont"
> {
> font_name = "Arial 8"
> }
> widget_class "*" style "defaultfont"
>
> This controls the font face and size used by pgadmin (and other GTK apps).
> Note you will need to close and restart pgadmin3 for the changes in font to
> take effect.
>
> Edit /etc/X11/XF86Config so that the line with 100dpi fonts comes before
> the line for 75 dpi fonts. This way X will find the 100 dpi fonts first,
> and use them.
>
> Also log into gnome, and change the font dpi to 120 in the font properties
> (something like starthere-->desktop properties-->fontproperties-->details)
> dialog. This will help minimize font display differrences between KDE and
> Gnome.
>
> This worked for me, YMMV.
>
> Also note that the configure command is case sensitive, and spaces are
> important. It should be:
> ./configure --with-gtk --enable-gtk2 --enable-unicode --disable-shared
> --enable-debug
>
> Regards,
> Mark
>
> On Monday 29 September 2003 12:55, b-vol wrote:
> > Greetings,
> >
> > I am new to this list. I need some help with the installaion of
> > pgAdminIII. The machine is a PC running SuSE Linux8.2.
> >
> > I downloaded vxWindows tarball and decompressed it into a directory
> >
> > :vxWindows-pgAdmin3. I then run the configure script with the following
> >
> > settings:
> >
> > ./configure
> > --with-gtk--enable-gtk2--enable-unicode--disambe-shared--enable-debug
> >
> > I obtain the following error message:
> > configure error
> > Please check that gtk-config is in the path, the directory where GTK+
> > libraries are installed (returned by gtk-config --libs' command) in the
> > LD_LIBRARY PATH or equivalent variable and the GTH+ is version 1.2.3 or
> > higher.
> >
> >
> > I installed all the GTK rpms and I checked and found gtk-config in
> > /usr/bin. I found libglade-config in /opt/gnome/bin. (The gtk-config
> > --libs command (last paragraph) show most are in /usr/lib.) I then made
> > the following entries in /etc/profile:
> >
> > LD_LIBRARY_PATH=/usr/lib:/opt/gnome/lib:/opt/gnome2/lib
> > export LD_LIBRARY_PATH
> > export PATH=${PATH}:/usr/bin/gtk-config
> > export PATH=${PATH}:/opt/gnome/bin//libglade-config
> >
> > Then I restarted the machine, but I still obtained the same error. Some
> > help would be appreciated.
> >
> > Sincerely
> > CT
> >
> > ---(end of broadcast)---
> > TIP 6: Have you searched our list archives?
> >
> >http://archives.postgresql.org
>
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faqs/FAQ.html
---(end of broadcast)---
TIP 8: explain analyze is your friend
[pgadmin-support] bit length not correct in pgAdmin III 1.0
Hi, First of all thumbs up to all pgAdmin developers: it's a great tool and I've been happy using it for quite some time now. I would like to report a small bug in pgAdmin III 1.0 with regard to bitlength: - A column that is defined as bit(32) will appear in pgAdmin as bit(28) (both in the column properties and the sql view). -Also when you try to edit the bitlength things the bitlength will not be what you entered (if you enter a bitlength of 32 it will actually create a column with bitlength 36) Note that creating a new column with bitlength 32 will create the correct bitlength 32 (but will appear as bit(28) Hope this is usefull info, Jacco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-support] installation of pgAdmin3 on SuSE8.2
hi b-vol, b-vol wrote: Dear Mark and List Members, Thanks for your help. The source installation of vxWindows worked as you suggested. I installed agnome system as suggested. After running the configure script, the foist make reported some missing files, I unhashed the following lines in /etc/profile LD_LIBRARY_PATH=/usr/lib:/opt/gnome/lib:/opt/gnome2/lib export LD_LIBRARY_PATH rebooted and re-run make and the compilation worked. Just a word: you dont have to reboot on *nix unless you do kernel developement. In your case you would just set the variable in the current shell and or add it to your .bashrc, .cshrc or whatever and open a new shell :-) Btw: it would be nice if you can set a real name on your mail client. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-support] installation of pgAdmin3 on SuSE8.2
Dear Tino, you wrote: > Just a word: you dont have to reboot on *nix unless > you do kernel developement. In your case you would > just set the variable in the current shell and or > add it to your .bashrc, .cshrc or whatever and open > a new shell :-) I know, I know - it is habit I sometime practice. you wrote: > Btw: it would be nice if you can set a real name on your > mail client. You can address me as Tim On main issue, I wrote: I downloaded pgadmin3-1.0.0 tarball from the postgresql site. I decompressed the tarball and did the following: 1) I ran './configure --enable-static --enable-debug ' 2.) I ran 'make all'and I received the following: make[2] : *** [pgadmin3.0] Error 1 make[2]: leaving directory /opt/pgadmin3-1.0.0/src make[1]: *** [all recursive] Error 1 make[1]: leaving directory /opt/pgadmin3-1.0.0/src make: ***[all] Error 2 Have you any ideas why the compilation is failing? I also tried downloading the rpm for suse 8.2 from http://www.pgadmin.org/pgadmin3/download.php#binaries but the effort fails half-way through on every attempt. Suggesions welcomed Sincerely, Tim On Wednesday 01 October 2003 12:54, you wrote: > hi b-vol, > > b-vol wrote: > > Dear Mark and List Members, > > > > Thanks for your help. The source installation of vxWindows worked as you > > suggested. I installed agnome system as suggested. After running the > > configure script, the foist make reported some missing files, I > > unhashed the following lines in /etc/profile > > > > LD_LIBRARY_PATH=/usr/lib:/opt/gnome/lib:/opt/gnome2/lib > > export LD_LIBRARY_PATH > > > > rebooted and re-run make and the compilation worked. > > Just a word: you dont have to reboot on *nix unless > you do kernel developement. In your case you would > just set the variable in the current shell and or > add it to your .bashrc, .cshrc or whatever and open > a new shell :-) > > Btw: it would be nice if you can set a real name on your > mail client. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[pgadmin-support] Sorting questions and an SSL question
Greetings everyone, First of all, thank you for pgAdmin III. Its a very nice tool and I used it in on Winblowz 2000 and I also installed it on one of my Linux laptops (Slackware9 Package). I've got serveral questions that concern me in moving forward recommending this tool be used. I hoping the answer evade be because of my own ignorance. One of the things I remember doing in pgAdmin II is that I could view the table data and then (I think click) a column so that the data would be sorted. However now it seems like that functional is gone altogether. So the question is how does one sort the data that is being viewed. Ideally, I was hoping that pgAdmin III would go to the next step of being able to view data in the way that the old version of pgAccess did. That is to say, the user could entry multiple sort parameters (i.e. an order by clause). Futher more a filter (i.e. where clause) would be nice too. I still use pgAcess on the *nix side because I can do at least the sorting piece in their current version (though, the orginal version had exactly what stated above). pgAccess hasn't had a release in quite awhile and although I haven't contacted the developers there, I've been leaning towards using pgAdmin as the single tool I use. In any event, I hoping this is something that I'm either missing or is in the works for a future release. Also, on the Slackware 9 client, the SSL drop down box is empty. Is there something I have to do to get the options to appear? Thanks in advance... -- Keith C. Perry Director of Networks & Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http://vcsn.com ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-support] Sorting questions and an SSL question
Hi Keith, > -Original Message- > From: Network Administrator [mailto:[EMAIL PROTECTED] > Sent: 01 October 2003 15:47 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Sorting questions and an SSL question > > > Greetings everyone, > > First of all, thank you for pgAdmin III. Its a very nice > tool and I used it in on Winblowz 2000 and I also installed > it on one of my Linux laptops (Slackware9 Package). > > I've got serveral questions that concern me in moving forward > recommending this tool be used. I hoping the answer evade be > because of my own ignorance. > > One of the things I remember doing in pgAdmin II is that I > could view the table data and then (I think click) a column > so that the data would be sorted. > However now it seems like that functional is gone altogether. > So the question is how does one sort the data that is being > viewed. Currently you cannot unfortunately. This is something I hope to implement, but is not nearly as straightforward with wxWindows as it was in Visual Basic. > Ideally, I was hoping that pgAdmin III would go to > the next step of being able to view data in the way that the > old version of pgAccess did. That is to say, the user could > entry multiple sort parameters (i.e. an order by clause). > Futher more a filter (i.e. where > clause) would be nice too. I still use pgAcess on the *nix > side because I can do at least the sorting piece in their > current version (though, the orginal version had exactly what > stated above). pgAccess hasn't had a release in quite awhile > and although I haven't contacted the developers there, I've > been leaning towards using pgAdmin as the single tool I use. :-) I haven't used pgAccess since about 1997, so cannot comment on it's capabilities. Entering of sort/filter parameters does seem useful though. I'll take a look at that as well. > > In any event, I hoping this is something that I'm either > missing or is in the works for a future release. > > Also, on the Slackware 9 client, the SSL drop down box is > empty. Is there something I have to do to get the options to appear? So it is :-( That's odd. I'll check that out as well (you shouldn't have to do anything). Regards, Dave. ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-support] Sorting questions and an SSL question
Network Administrator wrote: Greetings everyone, First of all, thank you for pgAdmin III. Its a very nice tool and I used it in on Winblowz 2000 and I also installed it on one of my Linux laptops (Slackware9 Package). I've got serveral questions that concern me in moving forward recommending this tool be used. I hoping the answer evade be because of my own ignorance. One of the things I remember doing in pgAdmin II is that I could view the table data and then (I think click) a column so that the data would be sorted. However now it seems like that functional is gone altogether. So the question is how does one sort the data that is being viewed. Ideally, I was hoping that pgAdmin III would go to the next step of being able to view data in the way that the old version of pgAccess did. That is to say, the user could entry multiple sort parameters (i.e. an order by clause). Futher more a filter (i.e. where clause) would be nice too. I still use pgAcess on the *nix side because I can do at least the sorting piece in their current version (though, the orginal version had exactly what stated above). pgAccess hasn't had a release in quite awhile and although I haven't contacted the developers there, I've been leaning towards using pgAdmin as the single tool I use. We'll probably add some features to the EditGrid, and user supplied sorting is one of that, better input checking is another. Sorting works very different from pgAdmin2, because we do *not* retrieve all data and sort in memory, instead sorting is done on the server. Currently, the ORDER BY clause is tied to the primary key (or OID), reordering will need a requery. Regards, Andreas ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-support] Russian data in SQL_ASCII encoding
Andreas Pflug wrote: Моисеев Алексей Николаевич wrote: Hi!!! Why russian data from tables in pgadmin 3 release in SQL_ASCII coding is not visible, but this data visible in pgadmin 2? What is the different between pgadmin3 and pgadmin2 for this problem? Thanks. Hm, I suspect that the server isn't able to translate your SQL_ASCII data to Unicode to send it over the line. Currently, pgAdmin3 tells the backend to send all data in Unicode, which should fit everything (if convertible). Maybe we should leave the client connection SQL_ASCII if this is the server encoding, because there are probably many SQL_ASCII encoded databases around that actually contain non-ascii (thus non-convertible) data. I updated pgConn.cpp and pgConn.h to be SQL_ASCII aware. There's some heavy work in cvs underway. If you have a pgAdmin3 source installation to test it, you should get these two files only. Regards, Andreas Regards, Andreas ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-support] Sorting questions and an SSL question
Quoting Dave Page <[EMAIL PROTECTED]>: > Hi Keith, > > > -Original Message- > > From: Network Administrator [mailto:[EMAIL PROTECTED] > > Sent: 01 October 2003 15:47 > > To: [EMAIL PROTECTED] > > Subject: [pgadmin-support] Sorting questions and an SSL question > > > > > > Greetings everyone, > > > > First of all, thank you for pgAdmin III. Its a very nice > > tool and I used it in on Winblowz 2000 and I also installed > > it on one of my Linux laptops (Slackware9 Package). > > > > I've got serveral questions that concern me in moving forward > > recommending this tool be used. I hoping the answer evade be > > because of my own ignorance. > > > > One of the things I remember doing in pgAdmin II is that I > > could view the table data and then (I think click) a column > > so that the data would be sorted. > > However now it seems like that functional is gone altogether. > > So the question is how does one sort the data that is being > > viewed. > > Currently you cannot unfortunately. This is something I hope to > implement, but is not nearly as straightforward with wxWindows as it was > in Visual Basic. > > > Ideally, I was hoping that pgAdmin III would go to > > the next step of being able to view data in the way that the > > old version of pgAccess did. That is to say, the user could > > entry multiple sort parameters (i.e. an order by clause). > > Futher more a filter (i.e. where > > clause) would be nice too. I still use pgAcess on the *nix > > side because I can do at least the sorting piece in their > > current version (though, the orginal version had exactly what > > stated above). pgAccess hasn't had a release in quite awhile > > and although I haven't contacted the developers there, I've > > been leaning towards using pgAdmin as the single tool I use. > > :-) I haven't used pgAccess since about 1997, so cannot comment on it's > capabilities. Entering of sort/filter parameters does seem useful > though. I'll take a look at that as well. > > > > > In any event, I hoping this is something that I'm either > > missing or is in the works for a future release. > > > > Also, on the Slackware 9 client, the SSL drop down box is > > empty. Is there something I have to do to get the options to appear? > > So it is :-( That's odd. I'll check that out as well (you shouldn't have > to do anything). > > Regards, Dave. > > ---(end of broadcast)--- > TIP 8: explain analyze is your friend > Ok, thanks Dave. One of the networks I manage needs HIPAA compliancies and althought those would be Windows clients (where the SSL appears to be available and would meet any requirements). It would be good for people like myself who would also be connecting from the Slackware Linux side of things. As far as the sorting, I hope wxWindows isn't too much of a headache :) -- Keith C. Perry Director of Networks & Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http://vcsn.com ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-support] Sorting questions and an SSL question
Quoting Andreas Pflug <[EMAIL PROTECTED]>: > Network Administrator wrote: > > >Greetings everyone, > > > >First of all, thank you for pgAdmin III. Its a very nice tool and I used it > in > >on Winblowz 2000 and I also installed it on one of my Linux laptops > (Slackware9 > >Package). > > > >I've got serveral questions that concern me in moving forward recommending > this > >tool be used. I hoping the answer evade be because of my own ignorance. > > > >One of the things I remember doing in pgAdmin II is that I could view the > table > >data and then (I think click) a column so that the data would be sorted. > >However now it seems like that functional is gone altogether. So the > question > >is how does one sort the data that is being viewed. Ideally, I was hoping > that > >pgAdmin III would go to the next step of being able to view data in the way > that > >the old version of pgAccess did. That is to say, the user could entry > multiple > >sort parameters (i.e. an order by clause). Futher more a filter (i.e. > where > >clause) would be nice too. I still use pgAcess on the *nix side because I > can > >do at least the sorting piece in their current version (though, the orginal > >version had exactly what stated above). pgAccess hasn't had a release in > quite > >awhile and although I haven't contacted the developers there, I've been > leaning > >towards using pgAdmin as the single tool I use. > > > > We'll probably add some features to the EditGrid, and user supplied > sorting is one of that, better input checking is another. > Sorting works very different from pgAdmin2, because we do *not* retrieve > all data and sort in memory, instead sorting is done on the server. > Currently, the ORDER BY clause is tied to the primary key (or OID), > reordering will need a requery. > > Regards, > Andreas > Ahhh, ok so in the meantime what I'll do is make a query and include the oids. Then I can find and edit table data that way. -- Keith C. Perry Director of Networks & Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http://vcsn.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-support] Sorting questions and an SSL question
> -Original Message- > From: Network Administrator [mailto:[EMAIL PROTECTED] > Sent: 01 October 2003 16:35 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] Sorting questions and an SSL question > > > > Ok, thanks Dave. One of the networks I manage needs HIPAA > compliancies and althought those would be Windows clients > (where the SSL appears to be available and would meet any > requirements). It would be good for people like myself who > would also be connecting from the Slackware Linux side of things. I'm working on it now! > As far as the sorting, I hope wxWindows isn't too much of a > headache :) No it's not :-). In pgAdmin II we retrieved the entire recordset and sorted using methods provided by the Microsoft Listview control. In wx there are no such methods, so we would have to write them ourselves. This is no problem in itself, apart from the fact that the grid can handle many times the amount of data of pga2, partly because we don't download it all at once. Regards, Dave. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-support] feature suggestion
Hi, I've just installed PGAdmin 1.0 and ma very impressed! Well done guys. We've been using phppgadmin until now but this seems like its a good alternative. Anyway, one of the reasons I installed this was to see if it had any features for viewing current locks on the system. It doesn't seem to. Maybe this could be an idea for a feature to add. I'd been using "select * from pg_locks" from the console and was about to rework this to display some user friendly data with all the relation names etc when I thought to try pgadmin. It could be useful for people trying to fix up their deadlocking code (as I am currently). Anyway, thanks for the hard work! Tim ---(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-support] feature suggestion
Tim McAuley wrote: Hi, I've just installed PGAdmin 1.0 and ma very impressed! Well done guys. We've been using phppgadmin until now but this seems like its a good alternative. Anyway, one of the reasons I installed this was to see if it had any features for viewing current locks on the system. It doesn't seem to. Maybe this could be an idea for a feature to add. I'd been using "select * from pg_locks" from the console and was about to rework this to display some user friendly data with all the relation names etc when I thought to try pgadmin. It could be useful for people trying to fix up their deadlocking code (as I am currently). I put this on the TODO list. Might take a day or two... Regards, Andreas ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [pgadmin-support] bit length not correct in pgAdmin III 1.0
Jacco Beije wrote: Hi, First of all thumbs up to all pgAdmin developers: it's a great tool and I've been happy using it for quite some time now. Thanks! I would like to report a small bug in pgAdmin III 1.0 with regard to bitlength: - A column that is defined as bit(32) will appear in pgAdmin as bit(28) (both in the column properties and the sql view). -Also when you try to edit the bitlength things the bitlength will not be what you entered (if you enter a bitlength of 32 it will actually create a column with bitlength 36) Note that creating a new column with bitlength 32 will create the correct bitlength 32 (but will appear as bit(28) Hope this is usefull info, Hi Jacco, this is helpful indeed. Catching all little bugs takes time, especially finding them. This one will take a little more time to fix, because I'll be recoding things to make datatypes more consistent. Since we modify internal pgsql tables, we can't use the pgsql supplied functions, and need to find out all typmod values ourselves. bit is obviously wrong, it behaves different from char and varchar. Dunno why... Regards, Andreas ---(end of broadcast)--- TIP 8: explain analyze is your friend
