Обсуждение: "Use replication set" widget

Поиск
Список
Период
Сортировка

"Use replication set" widget

От
Guillaume Lelarge
Дата:
Hi,

I'm working to get all dialogs available in a 800x600 pixels screen.
While doing this, I found that not all properties dialog had a "Use
replication" widget. Which seems a great idea to me, because you can put
only tables and sequences in a Slony replication set. So I wonder why
there are so many dialogs that have this widget even if it's of no use
to many of them.

Quick list:

dlgAggregate.xrc dlgCast.xrc dlgCheck.xrc dlgColumn.xrc
dlgConversion.xrc dlgDomain.xrc dlgExtension.xrc dlgExtTable.xrc
dlgForeignDataWrapper.xrc dlgForeignKey.xrc dlgForeignServer.xrc
dlgForeignTable.xrc dlgFunction.xrc dlgGroup.xrc dlgIndexConstraint.xrc
dlgIndex.xrc dlgLanguage.xrc dlgOperator.xrc dlgPackage.xrc
dlgRole.xrc dlgRule.xrc dlgSchema.xrc dlgSequence.xrc dlgSynonym.xrc
dlgTable.xrc dlgTextSearchConfiguration.xrc dlgTextSearchDictionary.xrc
dlgTextSearchParser.xrc dlgTextSearchTemplate.xrc dlgTrigger.xrc
dlgType.xrc dlgUserMapping.xrc dlgUser.xrc dlgView.xrc

Can I drop them in all dialogs but table's and sequence's ones? or did I
misunderstand the use of this widget?


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

Re: "Use replication set" widget

От
Dave Page
Дата:
On Mon, Apr 4, 2011 at 10:43 AM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
> Hi,
>
> I'm working to get all dialogs available in a 800x600 pixels screen.
> While doing this, I found that not all properties dialog had a "Use
> replication" widget. Which seems a great idea to me, because you can put
> only tables and sequences in a Slony replication set. So I wonder why
> there are so many dialogs that have this widget even if it's of no use
> to many of them.
>
> Quick list:
>
> dlgAggregate.xrc dlgCast.xrc dlgCheck.xrc dlgColumn.xrc
> dlgConversion.xrc dlgDomain.xrc dlgExtension.xrc dlgExtTable.xrc
> dlgForeignDataWrapper.xrc dlgForeignKey.xrc dlgForeignServer.xrc
> dlgForeignTable.xrc dlgFunction.xrc dlgGroup.xrc dlgIndexConstraint.xrc
> dlgIndex.xrc dlgLanguage.xrc dlgOperator.xrc dlgPackage.xrc
> dlgRole.xrc dlgRule.xrc dlgSchema.xrc dlgSequence.xrc dlgSynonym.xrc
> dlgTable.xrc dlgTextSearchConfiguration.xrc dlgTextSearchDictionary.xrc
> dlgTextSearchParser.xrc dlgTextSearchTemplate.xrc dlgTrigger.xrc
> dlgType.xrc dlgUserMapping.xrc dlgUser.xrc dlgView.xrc
>
> Can I drop them in all dialogs but table's and sequence's ones? or did I
> misunderstand the use of this widget?

You misunderstood :-). What that is supposed to do is execute the
query using Slony's EXECUTE DDL functionality, which allows the change
to be pushed out across the entire cluster - so (for example), you can
push a new role out to all of your servers.


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: "Use replication set" widget

От
Guillaume Lelarge
Дата:
Le 04/04/2011 11:58, Dave Page a écrit :
> On Mon, Apr 4, 2011 at 10:43 AM, Guillaume Lelarge
> <guillaume@lelarge.info> wrote:
>> Hi,
>>
>> I'm working to get all dialogs available in a 800x600 pixels screen.
>> While doing this, I found that not all properties dialog had a "Use
>> replication" widget. Which seems a great idea to me, because you can put
>> only tables and sequences in a Slony replication set. So I wonder why
>> there are so many dialogs that have this widget even if it's of no use
>> to many of them.
>>
>> Quick list:
>>
>> dlgAggregate.xrc dlgCast.xrc dlgCheck.xrc dlgColumn.xrc
>> dlgConversion.xrc dlgDomain.xrc dlgExtension.xrc dlgExtTable.xrc
>> dlgForeignDataWrapper.xrc dlgForeignKey.xrc dlgForeignServer.xrc
>> dlgForeignTable.xrc dlgFunction.xrc dlgGroup.xrc dlgIndexConstraint.xrc
>> dlgIndex.xrc dlgLanguage.xrc dlgOperator.xrc dlgPackage.xrc
>> dlgRole.xrc dlgRule.xrc dlgSchema.xrc dlgSequence.xrc dlgSynonym.xrc
>> dlgTable.xrc dlgTextSearchConfiguration.xrc dlgTextSearchDictionary.xrc
>> dlgTextSearchParser.xrc dlgTextSearchTemplate.xrc dlgTrigger.xrc
>> dlgType.xrc dlgUserMapping.xrc dlgUser.xrc dlgView.xrc
>>
>> Can I drop them in all dialogs but table's and sequence's ones? or did I
>> misunderstand the use of this widget?
>
> You misunderstood :-). What that is supposed to do is execute the
> query using Slony's EXECUTE DDL functionality, which allows the change
> to be pushed out across the entire cluster - so (for example), you can
> push a new role out to all of your servers.
>
>

Oh OK, thanks for the explanation. So, it should be on all properties'
dialogs?


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

Re: "Use replication set" widget

От
Dave Page
Дата:
On Mon, Apr 4, 2011 at 11:20 AM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
> Le 04/04/2011 11:58, Dave Page a écrit :
>> On Mon, Apr 4, 2011 at 10:43 AM, Guillaume Lelarge
>> <guillaume@lelarge.info> wrote:
>>> Hi,
>>>
>>> I'm working to get all dialogs available in a 800x600 pixels screen.
>>> While doing this, I found that not all properties dialog had a "Use
>>> replication" widget. Which seems a great idea to me, because you can put
>>> only tables and sequences in a Slony replication set. So I wonder why
>>> there are so many dialogs that have this widget even if it's of no use
>>> to many of them.
>>>
>>> Quick list:
>>>
>>> dlgAggregate.xrc dlgCast.xrc dlgCheck.xrc dlgColumn.xrc
>>> dlgConversion.xrc dlgDomain.xrc dlgExtension.xrc dlgExtTable.xrc
>>> dlgForeignDataWrapper.xrc dlgForeignKey.xrc dlgForeignServer.xrc
>>> dlgForeignTable.xrc dlgFunction.xrc dlgGroup.xrc dlgIndexConstraint.xrc
>>> dlgIndex.xrc dlgLanguage.xrc dlgOperator.xrc dlgPackage.xrc
>>> dlgRole.xrc dlgRule.xrc dlgSchema.xrc dlgSequence.xrc dlgSynonym.xrc
>>> dlgTable.xrc dlgTextSearchConfiguration.xrc dlgTextSearchDictionary.xrc
>>> dlgTextSearchParser.xrc dlgTextSearchTemplate.xrc dlgTrigger.xrc
>>> dlgType.xrc dlgUserMapping.xrc dlgUser.xrc dlgView.xrc
>>>
>>> Can I drop them in all dialogs but table's and sequence's ones? or did I
>>> misunderstand the use of this widget?
>>
>> You misunderstood :-). What that is supposed to do is execute the
>> query using Slony's EXECUTE DDL functionality, which allows the change
>> to be pushed out across the entire cluster - so (for example), you can
>> push a new role out to all of your servers.
>>
>>
>
> Oh OK, thanks for the explanation. So, it should be on all properties'
> dialogs?

Yup.


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company