>> Thanks Dave.
>>
>> But I am having some trouble trying to get replication to work.
>>
>> Here is what I did:
>>
>> 1) On master server:
>>a) I registered: lib/slevent.dll
>>b) I register as a service: slon -regservice
>>c) slon -listengines
>> 2 engine(s) registered for serv
Jason Best wrote:
> 1.6.3
Yeah, that code has changed a lot since then. Can you try 1.8b5 please?
Thanks, Dave.
---(end of broadcast)---
TIP 6: explain analyze is your friend
Bob wrote:
> Right click on a table-> go to properties-> create pk constraint and add
> column click ok. A unhandled exception occurs on my machine and pgadmin
> exits.
This has been fixed in SVN trunk already.
Thanks, Dave
---(end of broadcast)---
> --- Original Message ---
> From: Charlie Clark <[EMAIL PROTECTED]>
> To: pgAdmin Support
> Sent: 17/09/07, 19:33:58
> Subject: Re: [pgadmin-support] How do I report pgAdmin going bang?
>
> Am 17.09.2007 um 19:40 schrieb Charlie Clark:
>
> > There I was just editing a table definition
Uh, forgot to also mention that the pgAdmin exe icon is missing
and shows some sort of an image but not that of ol' ele ;)
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] Behalf Of Daniel B.
>Thurman
>Sent: Monday, September 17, 2007 2:50 PM
>To: Pgadmin-Support (E
As recommended, I downloaded and installed pgAdmin v1.8.0-beta5
and ran into some problems:
1) The update.bat script failed to update the v1.6.3 release that came
integrated with the postgreSQL v1.8.2 release. Failing that, I proceeded
to install the complete program into a seperate dire
Jeff Buhrt wrote:
> Dave,
>
> I am happy to test. [Having been an open source (PD) maintainer, and
> currently contributing to projects, I know the effort it takes.]
Thanks - there's an updated .exe at
http://developer.pgadmin.org/~dpage/pgAdmin3.zip
Regards, Dave.
---(e
Jason Best wrote:
> It seems to be fixed in 1.8b5. Thanks.
Great, thanks for testing.
Regards, Dave.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's
It seems to be fixed in 1.8b5. Thanks.
Regards,
Jason Aaron Best
Lead Development Engineer
602.393.8987 [M]
212.202.4288 [F]
866.297.2841 [TF]
-Original Message-
From: Dave Page [mailto:[EMAIL PROTECTED]
Sent: Monday, September 17, 2007 12:42 PM
To: Jason Best
Cc: pgadmin-support@pos
Dave,
I am happy to test. [Having been an open source (PD) maintainer, and
currently contributing to projects, I know the effort it takes.]
-Jeff
Dave Page wrote:
Jeff Buhrt wrote:
Thanks for the great work! [#1 new feature: I love the fact column
widths don't keep resizing.]
:-)
1.6.3
Regards,
Jason Aaron Best
Lead Development Engineer
602.393.8987 [M]
212.202.4288 [F]
866.297.2841 [TF]
-Original Message-
From: Dave Page [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 15, 2007 1:48 AM
To: Jason Best
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmi
Daniel B. Thurman wrote:
> Thanks Dave.
>
> But I am having some trouble trying to get replication to work.
>
> Here is what I did:
>
> 1) On master server:
>a) I registered: lib/slevent.dll
>b) I register as a service: slon -regservice
>c) slon -listengines
> 2 engine(s) regis
Am 17.09.2007 um 19:40 schrieb Charlie Clark:
There I was just editing a table definition, adding a new column
and making it a primary key and suddenly pgAdmin went up in smoke.
Does it log such crashes anywhere? Hasn't been picked up by the Mac
OS crash detector. Happened twice in success
Thanks Dave.
But I am having some trouble trying to get replication to work.
Here is what I did:
1) On master server:
a) I registered: lib/slevent.dll
b) I register as a service: slon -regservice
c) slon -listengines
2 engine(s) registered for service 'Slony-I'
Engine 1: E:
> --- Original Message ---
> From: Erwin Brandstetter <[EMAIL PROTECTED]>
> To: Dave Page <[EMAIL PROTECTED]>
> Sent: 17/09/07, 17:29:37
> Subject: Re: [pgadmin-support] Query tool greyed out
>
>
> Of course, the maintenance DB!
> I am afraid you won't be seeing C++ patches from me any t
Right click on a table-> go to properties-> create pk constraint and add
column click ok. A unhandled exception occurs on my machine and pgadmin
exits.
There I was just editing a table definition, adding a new column and
making it a primary key and suddenly pgAdmin went up in smoke. Does
it log such crashes anywhere? Hasn't been picked up by the Mac OS
crash detector. Happened twice in succession so I hope it's
reproducible elswhere.
CRE
This bug has been around a while, sorry its taken me so long to report it.
In the sql editor do the following :-
1. Open Find and replace
2. Check regular expressions
3. In Find what enter $
4. In Replace with enter anything
5. Click Replace All
pgadmin seems to go into a loop where pgadmin stop
Dave Page wrote:
Erwin Brandstetter wrote:
In a future release we could default to database "postgres" for global
objects, which is there for purposes like this one, isn't it?
It would be convenient to to open the SQL window directly from a role.
As long as we work on global objects like roles, t
Erwin Brandstetter wrote:
> On Sep 15, 10:28 am, [EMAIL PROTECTED] (Dave Page) wrote:
>> Rob McDonell wrote:
>>> In both version 1.6 and 1.8 (can't remember earlier) the SQL button and
>>> Query Tool menu item are inactive/greyed out when a Role is selected in
>>> the Object Browser. This tool shou
On Sep 15, 10:28 am, [EMAIL PROTECTED] (Dave Page) wrote:
> Rob McDonell wrote:
> > In both version 1.6 and 1.8 (can't remember earlier) the SQL button and
> > Query Tool menu item are inactive/greyed out when a Role is selected in
> > the Object Browser. This tool should always be available: regar
Daniel B. Thurman wrote:
> I have tried to follow the pgAdmin slony support in the help sections
> of pgAdmin and it seems to be inconsistent. For example, it is not
> intuitively clear from the help sections how exactly to setup the master
> and slave configurations. From a windows client perspe
I have tried to follow the pgAdmin slony support in the help sections
of pgAdmin and it seems to be inconsistent. For example, it is not
intuitively clear from the help sections how exactly to setup the master
and slave configurations. From a windows client perspective, it seems
that one must us
On Sep 17, 2:59 pm, [EMAIL PROTECTED] (Dave Page) wrote:
> Hmm, works for me in SVN-Trunk (1.8 beta5 + a few minor unrelated tweaks):
> (...)
> Anyone else able to reproduce this?
I cannot reproduce it either.
Testing pgAdmin III 1.8.0 Beta 5 (Sep 10 2007, rev: 6631). Client Win
XP, host: Debian
Bintsarovsky Dima home wrote:
> I have two functions:
>
> CREATE OR REPLACE FUNCTION tests.func1() RETURNS integer AS $BODY$
> DECLARE BEGIN RAISE NOTICE 'notice'; PERFORM tests.func2(); RETURN 1;
> END;$BODY$ LANGUAGE 'plpgsql' VOLATILE;
>
>
> CREATE OR REPLACE FUNCTION tests.func2() RETURNS
Vladimir Kokovic wrote:
> Hi,
>
> I've tried to edit BOOL NOT NULL field which have value TRUE within
> 'Edit Data' window,
> but error dialog appeared with text
> "ERROR: null value in column "vazeci" violates not-null constraint"
> even field has DEFAULT TRUE clause !
The boolean editor in the
Hi,
I've tried to edit BOOL NOT NULL field which have value TRUE within
'Edit Data' window,
but error dialog appeared with text
"ERROR: null value in column "vazeci" violates not-null constraint"
even field has DEFAULT TRUE clause !
My OS is kubuntu 7.10 (gutsy)
Jeff Buhrt wrote:
> Thanks for the great work! [#1 new feature: I love the fact column
> widths don't keep resizing.]
:-) you're welcome!
> pgAdmin 1.8.0 Beta 5 (Sep 10 2007, rev: 6631)
> WinXP Pro, SP2
>
> Postgres server: postgresql-8.1.9-1.fc6
>
> Using either an existing table or a new (ex:
Harald Armin Massa wrote:
> So my suggestion: make tablespace default blank in the wizards.
I've made it so it's obvious what it is, and added
it to all the create dialogs.
Regards, Dave
---(end of broadcast)---
TIP 7: You can help support the Pos
Jason L. Buberel wrote:
> Something to consider for the 2.0 series, if it has not already been
> suggested:
>
> "Bookmark View"
>
> A user has selected 'View Data -> View All Rows' or 'View Data -> View
> Filtered Rows' from the context menu for a view or table. They
> eventually are presented wi
Harald Armin Massa wrote:
> Hello,
>
> I am using a 2 screen configuration. Moving pgadmin to the secodary
> screen gives me ample space on the main screen to do other stuff.
>
> Now dialog windows of pgadmin pop up in the middle of the main screen.
> Not in the middle of pgadmin.
>
> Is it poss
Hello,
I am using a 2 screen configuration. Moving pgadmin to the secodary screen
gives me ample space on the main screen to do other stuff.
Now dialog windows of pgadmin pop up in the middle of the main screen. Not
in the middle of pgadmin.
Is it possible in the long run to change the positioni
I have two functions:
CREATE OR REPLACE FUNCTION tests.func1()
RETURNS integer AS
$BODY$
DECLARE
BEGIN
RAISE NOTICE 'notice';
PERFORM tests.func2();
RETURN 1;
END;$BODY$
LANGUAGE 'plpgsql' VOLATILE;
CREATE OR REPLACE FUNCTION tests.func2()
RETURNS integer AS
$BODY$
DECLARE
BEGIN
RAISE NOTI
Something to consider for the 2.0 series, if it has not already been
suggested:
"Bookmark View"
A user has selected 'View Data -> View All Rows' or 'View Data -> View
Filtered Rows' from the context menu for a view or table. They
eventually are presented with the 'Edit Data' tabular display w
34 matches
Mail list logo
