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
