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
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 ?
>
> 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
&
::oid
ORDER BY tgname
Obviously you may want to change the reverse engineered SQL
accordingly for constraint triggers.
Cheers
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
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.
- 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
>
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
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
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
:
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.
it is not!
Regards
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
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.
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)---
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.
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 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
- 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
- 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:
>
>
.
Regards
Donald Fraser.
RULES are displayed as CREATE RULE
.
Slightly more convenient would be CREATE OR REPLACE
RULE
Regards
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
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
et it to some other value first, like 1, and
then set it to zero.
Regards
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 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.
adjusts to
the true width and from that point onwards I can scroll using the scroll
bar.
Regards
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
- 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
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.
it is appending the text "SECURE
DEFINER" instead of "SECURITY
DEFINER".
Regards
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
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
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.
- 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
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
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
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
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.
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
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]" &
st in case it only read them at
start-up).
Regards
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
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
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
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
chema: public; Owner: postgresCREATE UNIQUE INDEX tbl_usertype_s_desc_key
ON tbl_usertype USING btree (s_desc);
Regards
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
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
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
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: 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 ???
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
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
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
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 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 -
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
59 matches
Mail list logo