Re: [pgadmin-support] [ADMIN] Beginning SSL Questions

2006-09-14 Thread Donald Fraser
y of PostgreSQL and it must be named root.crt. User the pg_hba.conf file to force clients to use ssl or not. Hope that helps. Regards Donald Fraser ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [pgadmin-support] Constraint Triggers request

2006-05-11 Thread Donald Fraser
Andreas Pflug wrote: > Donald Fraser wrote: > >> Donald Fraser wrote: > >> > >>> Do you think in a later version you can show non-system constraint > >>> triggers that have been created by the user via: > >>> CREATE CONSTRAINT TRIGGER ? >

Re: [pgadmin-support] Constraint Triggers request

2006-05-10 Thread Donald Fraser
> Donald Fraser wrote: > > Do you think in a later version you can show non-system constraint > > triggers that have been created by the user via: > > CREATE CONSTRAINT TRIGGER ? Andreas Pflug wrote: > Definitively not. Creating constraint triggers directly is horribly &

[pgadmin-support] Constraint Triggers request

2006-05-09 Thread Donald Fraser
::oid ORDER BY tgname   Obviously you may want to change the reverse engineered SQL accordingly for constraint triggers.   Cheers Donald Fraser

Re: [pgadmin-support] load project problems with pgAdmin II

2004-08-17 Thread Donald Fraser
ng an xl spread sheet - yuk, thought I'd check out your code to give me a head start... thanks again, Regards Donald Fraser.   - Original Message - From: Dave Page To: Donald Fraser ; [pgADMIN] Sent: Tuesday, August 17, 2004 8:56 AM Subject: RE: [pgadmin-sup

[pgadmin-support] load project problems with pgAdmin II

2004-08-16 Thread Donald Fraser
er menu "Project | References..." - all are there.   At this point I'm a bit stuck and my VB skills are insufficient to figure out what I should be doing or looking for next?   Any help would be greatly appreciated, regards Donald Fraser.

Re: [pgadmin-support] pgAdmin III locks up

2004-05-26 Thread Donald Fraser
- Original Message - From: "Andreas Pflug" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Cc: "[pgADMIN]" <[EMAIL PROTECTED]> Sent: Wednesday, May 26, 2004 10:01 AM Subject: Re: [pgadmin-support] pgAdmin III locks up >

[pgadmin-support] pgAdmin III locks up

2004-05-24 Thread Donald Fraser
ok"   4) Press the "Find Next" button.   5) Change direction to up.   6) Press the "Find Next" button.   pgAdmin III locks up   regards Donald Fraser

Re: [pgadmin-support] duplicated Index entries

2004-05-04 Thread Donald Fraser
o say that for certain... Not sure what else I can do to pin point things any further...   Regards Donald Fraser - Original Message - From: Dave Page To: Donald Fraser ; [pgADMIN] Sent: Tuesday, May 04, 2004 9:33 AM Subject: RE: [pgadmin-support] duplicated Index entri

Re: [pgadmin-support] duplicated Index entries

2004-04-29 Thread Donald Fraser
NULL;   - Original Message - From: Donald Fraser To: [pgADMIN] Sent: Thursday, April 29, 2004 5:30 PM Subject: [pgadmin-support] duplicated Index entries pgAdmin III version 1.0.2   On certain tables, under the Indexes tree view I am getting duplicated

[pgadmin-support] duplicated Index entries

2004-04-29 Thread Donald Fraser
: a) each duplicated index has exactly the same details including the oid. b) I deleted one of the duplicated entries and then did a refresh - the second entry was also removed.   Regards Donald Fraser.

[pgadmin-support] Incorrect permissions shown for view.

2004-04-20 Thread Donald Fraser
it is not!     Regards Donald Fraser.

Re: [pgadmin-support] Color

2004-04-15 Thread Donald Fraser
- Original Message - > > Donald Fraser wrote: > > > >> I just upgraded to the latest stable release (1.0.2) of pgAdmin III > >> and noticed that the colour of the SQL text has changed from blue to > >> black. > >> Is there any way o

[pgadmin-support] Color

2004-04-14 Thread Donald Fraser
I just upgraded to the latest stable release (1.0.2) of pgAdmin III and noticed that the colour of the SQL text has changed from blue to black. Is there any way of configuring this so I can select my own colors?   Thanks Donald Fraser.

Fw: [pgadmin-support] View column defaults in pgAdminIII

2003-10-13 Thread Donald Fraser
this one. For example to set the default value of a column of a view you issue the command which is very similar to that of a table: Example: ALTER TABLE vu_someview ALTER COLUMN b_somecolumn SET DEFAULT '0'; Regards Donald Fraser. ---(end of broadcast)---

[pgadmin-support] Reverse engineered Column definition incorrect for DEFAULT

2003-10-02 Thread Donald Fraser
ld read: ALTER TABLE public.tbl_bkgndata ALTER COLUMN id SET DEFAULT nextval('tbl_bkgndata_id_seq'::text);   That is the key word SET is missing.   Regards Donald Fraser.

Re: [pgadmin-support] Pgadmin connection

2003-09-26 Thread Donald Fraser
tabase. You can avoid using a password if you have a line in the pg_hba.conf file as follows: host all all 127.0.0.1 255.255.255.255 trust Regards Donald Fraser ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

[pgadmin-support] Unsupported frontend protocol

2003-09-18 Thread Donald Fraser
pgAdmin III devel 0.9.1 August 24th PostgreSQL 7.3.4 on Redhat 7.2 GCC 2.96 I am getting the following type of messages in the server log file when using pgAdmin III. >Sep 18 09:31:00 CISX_Linux1 postgres[32277]: [2] FATAL: unsupported frontend protocol It does not stop pgAdmin from running in a

Re: [pgadmin-support] pgAdmin III No Trigger Functions available

2003-09-02 Thread Donald Fraser
- Original Message - Subject: Re: [pgadmin-support] pgAdmin III No Trigger Functions available > Donald Fraser wrote: > > > > > > >>the builtin functions (RI_FKey_check_ins etc) if you enable system objects? > >> > >> > > > >Ye

Re: [pgadmin-support] pgAdmin III No Trigger Functions available

2003-09-01 Thread Donald Fraser
- Original Message - From: "Andreas Pflug" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Sent: Friday, August 29, 2003 11:36 PM Subject: Re: [pgadmin-support] pgAdmin III No Trigger Functions available > Donald Fraser wrote: > >

[pgadmin-support] pgAdmin III No Trigger Functions available

2003-08-29 Thread Donald Fraser
.   Regards Donald Fraser.

[pgadmin-support] pgAdmin III Reverse Engineered SQL for RULES

2003-08-14 Thread Donald Fraser
RULES are displayed as CREATE RULE . Slightly more convenient would be CREATE OR REPLACE RULE   Regards Donald Fraser.

Re: [pgadmin-support] pgAdmin III - bug with reverse engineered SQL with function indexes

2003-07-31 Thread Donald Fraser
> Donald Fraser wrote: > > > pgAdmin III July 16th Build > > PostgreSQL 7.3.3 > > > > The reverse engineered SQL for indexes that use a function do not work. > > For example I create an index with the following command: > > CREATE UNIQUE INDEX tbl_s

[pgadmin-support] pgAdmin III - bug with reverse engineered SQL with function indexes

2003-07-31 Thread Donald Fraser
column names as the parameters of the function. If I try to execute pgAdmin's version I get the following error message: ERROR:  parser: parse error at or near "::" at character 220.     Regards Donald Fraser

[pgadmin-support] pgAdmin III - Editing data

2003-07-30 Thread Donald Fraser
et it to some other value first, like 1, and then set it to zero.   Regards Donald Fraser

Re: [pgadmin-support] window scrolling with pgAdmin III

2003-07-29 Thread Donald Fraser
- Original Message - From: "Andreas Pflug" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Cc: "[pgADMIN]" <[EMAIL PROTECTED]> Sent: Tuesday, July 29, 2003 10:56 PM Subject: Re: [pgadmin-support] window scrolling with pgAdmin III

[pgadmin-support] pgAdmin II - table name shows column name

2003-07-29 Thread Donald Fraser
pgAdmin III July 16th Build   reverse engineered SQL statements for columns do not show the correct DROP statement.   For example: -- ALTER TABLE public.s_name16 DROP COLUMN s_name16   "public.s_name16" should show the table name but it shows the column name instead.   Regards Donald Fraser.  

[pgadmin-support] window scrolling with pgAdmin III

2003-07-29 Thread Donald Fraser
adjusts to the true width and from that point onwards I can scroll using the scroll bar.   Regards Donald Fraser.

Re: [pgadmin-support] Maybe Basic Questions ....

2003-07-28 Thread Donald Fraser
sure on this one. What about trying -U option instead of install and also which rpm files did you down-load - were they built for Redhat 8.0? > 4 - Last Questions > - What Platforms are supported by PostGreSQL ? > - This Database Run in Windows with some stange way (whats that

Re: [pgadmin-support] timestamps

2003-07-21 Thread Donald Fraser
- Original Message - From: "Andreas Pflug" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Cc: "[pgADMIN]" <[EMAIL PROTECTED]> Sent: Monday, July 21, 2003 12:39 AM Subject: Re: [pgadmin-support] timestamps > Donald Fraser w

[pgadmin-support] timestamps

2003-07-18 Thread Donald Fraser
amp (0)",  which is a step forward.   My question: is it planned for pgAdmin III to be displaying timestamps correctly with respect to time zones?   Regards Donald Fraser.  

[pgadmin-support] pgAdmin III - SECURE DEFINER instead of SECURITY DEFINER

2003-07-17 Thread Donald Fraser
it is appending the text "SECURE DEFINER" instead of "SECURITY DEFINER".   Regards Donald Fraser.

Re: FW: [pgadmin-support] pgAdmin3: adding comments to existing tables

2003-07-16 Thread Donald Fraser
ve to do a manual refresh on the item in the tree view to see the changes or select a different item in the tree view and then re-select the original item. Regards Donald Fraser. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [pgadmin-support] BUG: pgAdmin III View table with empty strings

2003-07-16 Thread Donald Fraser
represents empty string, whereas an empty >box represents NULL. Might I add my 2 cents worth: If you have a string type column with a value of lets say two or more spaces e.g. ' '::text, you cannot see the difference between that and a column that returns NULL. May be in this day and age of

Re: [pgadmin-support] Overloading functions that are used by operators.

2003-07-14 Thread Donald Fraser
Title: Message Just to say that I tested the July 10th snap-shot and all works with Operators etc.. Many thanks to Dave and Andreas for your patience.   Regards Donald Fraser.

Re: [pgadmin-support] Overloading functions that are used by operators.

2003-07-10 Thread Donald Fraser
- Original Message - From: "Andreas Pflug" <[EMAIL PROTECTED]> To: "Dave Page" <[EMAIL PROTECTED]> Cc: "Donald Fraser" <[EMAIL PROTECTED]>; "[pgADMIN]" <[EMAIL PROTECTED]> Sent: Thursday, July 10, 2003 11:03 AM Subje

Re: [pgadmin-support] Overloading functions that are used by operators.

2003-07-09 Thread Donald Fraser
Title: Message   - Original Message - From: Dave Page To: Donald Fraser Cc: [ADMIN] ; [pgADMIN] Sent: Tuesday, July 08, 2003 9:49 PM Subject: RE: [pgadmin-support] Overloading functions that are used by operators. Ahh, thanks. Was just looking at that

Fw: [pgadmin-support] Overloading functions that are used by operators.

2003-07-08 Thread Donald Fraser
Title: Message Whoops did it again - used the reply again without changing the to:   - Original Message - From: Donald Fraser To: Dave Page Sent: Tuesday, July 08, 2003 9:26 PM Subject: Re: [pgadmin-support] Overloading functions that are used by operators. Hi Dave, if you want

Re: [pgadmin-support] Overloading functions that are used by operators.

2003-07-08 Thread Donald Fraser
ve Page To: Donald Fraser ; [ADMIN] Cc: [pgADMIN] Sent: Tuesday, July 08, 2003 9:12 PM Subject: RE: [pgadmin-support] Overloading functions that are used by operators.   -Original Message-From: Donald Fraser [mailto:[EMAIL PROTECTED] Sent: 08 July 2003

[pgadmin-support] Overloading functions that are used by operators.

2003-07-08 Thread Donald Fraser
rator.oprjoin and pg_operator.oprrest have identical names defined by the column pg_proc.proname for which they are also retrieving? If so then those corresponding joins are also unnecessarily.   Many thanks in advance, regards Donald Fraser.

[pgadmin-support] pgAdmin III Issues when creating tables

2003-07-07 Thread Donald Fraser
TABLE public.tbl_test ALTER COLUMN pgadmin_tmpcol SET STORAGE PLAIN; 6) This one may be something to do with 5). The property named "Storage" is listed twice in the main window when viewing a column.     Regards Donald Fraser

Re: [pgadmin-support] pgAdmin III - No security privileges shown for Groups

2003-07-07 Thread Donald Fraser
My apologies, I must have been looking at a table that use to have group privileges on it... All is working today. Donald - Original Message - From: "Andreas Pflug" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Cc: "[pgADMIN]" &

[pgadmin-support] pgAdmin III - No security privileges shown for Groups

2003-07-04 Thread Donald Fraser
st in case it only read them at start-up).   Regards Donald Fraser.

[pgadmin-support] Email + attachments

2003-07-01 Thread Donald Fraser
still cannot see it posted anywhere. I searched the archives today and can see no evidence of the one I posted on 20th June or yesterday on the 30th June.   Is there a problem with emails + attachments?   Regards Donald Fraser.   Ps. The attachment was the log for pgAdmin III to help locate some bugs

[pgadmin-support] Bug report for pgAdmin III

2003-06-19 Thread Donald Fraser
ays that in a different colour). When I view the function via the properties page then the contents is nicely displayed with all the key words etc. in different colours.   8) Crash: Pressing the "Options" item on the "File" menu crashes the application. Windows reports that a log is being created... I can't find one anywhere - typical windows!   Regards Donald Fraser

[pgadmin-support] pgAdmin III

2003-06-19 Thread Donald Fraser
Hi Dave & pgAdmin III developers. Just wanted to know if you wanted reports back about bugs in pgAdmin III. I haven't seen any been reported or may be I just missed them?   Regards Donald Fraser  

Re: [pgadmin-support] Strange bug...

2003-01-21 Thread Donald Fraser
index tbl_cmpycat_desc_key because constraint tbl_cmpycat_desc_key on table tbl_cmpycat requires it  You may drop constraint tbl_cmpycat_desc_key on table tbl_cmpycat instead   Regards Donald Fraser   - Original Message - From: Dave Page To: Donald Fraser ; [EMAIL PROTECTED] Sent: Tu

[pgadmin-support] Strange bug...

2003-01-17 Thread Donald Fraser
chema: public; Owner: postgresCREATE UNIQUE INDEX tbl_usertype_s_desc_key ON tbl_usertype USING btree (s_desc);   Regards Donald Fraser.

[pgadmin-support] Bug with foreign keys

2003-01-16 Thread Donald Fraser
Hiya Dave, hope you had a good new years and all that. I know you're busy, probably working on the new version or something.   Anyway found another bug in pgAdmin. When you add foreign key constraints pgAdmin doesn't always tell the truth about them. This seems to be the case only when you h

[pgadmin-support] Bug for view with rules

2002-12-23 Thread Donald Fraser
Hi Dave, thanks for the latest fix.   Have spent all morning creating the situation for a view that causes a crash - here it is...   First create a simple table such as:   CREATE TABLE public.tbl_catchbug ( id int4, s_sometext text ) WITHOUT OIDS; GRANT ALL ON TABLE public.tbl_catchbug TO

Re: [pgadmin-support] The bugs are getting harder to find...

2002-12-20 Thread Donald Fraser
Dave Page To: Donald Fraser ; [EMAIL PROTECTED] Sent: Friday, December 20, 2002 8:31 AM Subject: RE: [pgadmin-support] The bugs are getting harder to find...   -----Original Message-From: Donald Fraser [mailto:[EMAIL PROTECTED]] Sent: 17 Dece

[pgadmin-support] Bugs

2002-12-18 Thread Donald Fraser
played.   I'm not in any hurry to have fixes, as I've got by since version 1.3. with most things. Version 1.4.12 is even better and have to congratulate you on a good job. Just letting you know so bugs don't get ported to the new C++ version.   Regards Donald Fraser  

[pgadmin-support] The bugs are getting harder to find...

2002-12-17 Thread Donald Fraser
pgAdmin: 1.4.12 PostgreSQL: 7.3 OS: W2K SP2   1) Edit a view and you loose any comments that you have made about it. Have not tested this but it probably means that you loose any rules that you have made too which is even worse!   2) Trigger functions that take parameters show up as ???

[pgadmin-support] Run function privileges

2002-12-12 Thread Donald Fraser
Title: Message Thanks for that Dave, you're a STAR when it come to response time. Not use to such fast responses.   I have another question about functions. Functions in 7.3 support running with the privileges of the creator (SECURITY DEFINER) this is incredibly useful (no more view work-aro

[pgadmin-support] More bugs

2002-12-12 Thread Donald Fraser
PostgreSQL 7.3 OS: W2K SP2 pgAdminII: 1.4.8   1) This is probably a bug in the back end and so not sure if I should be reporting it here. Dropping a rule on a table fails. 12/12/2002 16:11:59 - SQL (CISX): DROP RULE public.rul_tbl_contrib_ins ON tbl_contrib12/12/2002 16:11:59 - Error in pgAd

[pgadmin-support] Bug on functions

2002-12-12 Thread Donald Fraser
Forgot to say that I'm using PostgreSQL 7.3. Cheers Don - Original Message - From: Donald Fraser To: [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 3:51 PM Subject: [pgadmin-support] Bug on functions OS: W2K SP2 pgAdmin: 1.4.8  

[pgadmin-support] Bug on functions

2002-12-12 Thread Donald Fraser
OS: W2K SP2 pgAdmin: 1.4.8   When creating a function there are two problems relating to security rights. 1) It always adds a GRANT EXECUTE ON FUNCTION blalba.. TO PUBLIC even when I don't add it. 2) It doesn't handle secuirty on groups.If I add a group to the secuirty rights pgAdmin complani

[pgadmin-support] Can't delete rules

2002-11-29 Thread Donald Fraser
pgAdmin Version 1.4.2   1) The syntax for the DROP RULE statement generated by pgAdmin is incorrect. If you try to drop a rule you get the following error.   2002-11-28 13:58:47 - SQL (CISX): DROP RULE rul_setpasswd ON vtbl_user_setpasswd   2002-11-28 13:58:47 -

[pgadmin-support] pgAdmin bugs observed.

2002-11-28 Thread Donald Fraser
I apologise if these bugs have already been reported but I find searching for a list of acknowledged bugs close to impossible using the mailing support system.   Name: Donald Fraser Os: Windows 2000 professional SP2. pgAdmin: 1.4.0 build 0. My skills: Embedded systems, C, C++, Java, 10