On Wed, Sep 26, 2012 at 10:59 AM, Christopher Browne wrote:
> A different place where I wound up having to jump through considerable
> hoops when doing schema analytics was vis-a-vis identifying functions.
> I need to be able to compare schemas across databases, so oid-based
> identification of f
On 27/09/12 02:59, Christopher Browne wrote:
On Wed, Sep 26, 2012 at 10:02 AM, Tom Lane wrote:
Daniel Farina writes:
On Tue, Sep 25, 2012 at 10:55 PM, Jaime Casanova wrote:
The definition of information_schema.triggers contains this:
-- TRIGGER_TYPE_UPDATE; we intentionally omit TRIGGER_TYP
On 26-09-2012 11:08, Simon Riggs wrote:
> I suggest we implement that with some kind of switch/case in the view
> definition.
>
-- parameter can be set in a session and defaults to on
SET compliance_information_schema TO off;
--
Euler Taveira de Oliveira - Timbira http://www.timbira.co
On Wed, Sep 26, 2012 at 10:02 AM, Tom Lane wrote:
> Daniel Farina writes:
>> On Tue, Sep 25, 2012 at 10:55 PM, Jaime Casanova
>> wrote:
>>> The definition of information_schema.triggers contains this:
>>> -- TRIGGER_TYPE_UPDATE; we intentionally omit TRIGGER_TYPE_TRUNCATE
>>> so it seems that w
On 26 September 2012 15:02, Tom Lane wrote:
> Daniel Farina writes:
>> On Tue, Sep 25, 2012 at 10:55 PM, Jaime Casanova
>> wrote:
>>> The definition of information_schema.triggers contains this:
>>> -- TRIGGER_TYPE_UPDATE; we intentionally omit TRIGGER_TYPE_TRUNCATE
>>> so it seems that we are
Daniel Farina writes:
> On Tue, Sep 25, 2012 at 10:55 PM, Jaime Casanova
> wrote:
>> The definition of information_schema.triggers contains this:
>> -- TRIGGER_TYPE_UPDATE; we intentionally omit TRIGGER_TYPE_TRUNCATE
>> so it seems that we are not showing TRUNCATE triggers intentionally,
>> but
On 09/26/2012 03:08 AM, Daniel Farina wrote:
On Tue, Sep 25, 2012 at 10:55 PM, Jaime Casanova wrote:
On Wed, Sep 26, 2012 at 12:17 AM, Daymel Bonne Solís wrote:
Hello hackers:
I need a list of all triggers created in my database, but the view
system_information.triggers does not show truncat
On Tue, Sep 25, 2012 at 10:55 PM, Jaime Casanova wrote:
> On Wed, Sep 26, 2012 at 12:17 AM, Daymel Bonne Solís wrote:
>> Hello hackers:
>>
>> I need a list of all triggers created in my database, but the view
>> system_information.triggers does not show truncate triggers, but it does for
>> inser
On Wed, Sep 26, 2012 at 12:17 AM, Daymel Bonne Solís wrote:
> Hello hackers:
>
> I need a list of all triggers created in my database, but the view
> system_information.triggers does not show truncate triggers, but it does for
> insert, update and delete triggers.
>
> The same problem is found in
Hello hackers:
I need a list of all triggers created in my database, but the view
system_information.triggers does not show truncate triggers, but it does
for insert, update and delete triggers.
The same problem is found in versions 9.1 and 9.2.
Regards.
10mo. ANIVERSARIO DE LA CREACION DE
10 matches
Mail list logo
