Mark Forums Read

\d mytable should display if trigger is enabled

Go Back

comp.databases.postgresql comp.databases.postgresql

Reply

Page 1 of 2

1

#1

Old

Thomas Guettler

Posts: n/a

\d mytable should display if trigger is enabled - 10-21-2008 , 10:00 AM

Hi,

I have a feature request:

\d mytable should display if a trigger is enabled or disabled.

Do others think this would be useful, too?

Thomas

--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de

Reply With Quote

#2

Old

Andreas Kretschmer

Posts: n/a

Re: \d mytable should display if trigger is enabled - 10-22-2008 , 02:18 AM

begin Thomas Guettler schrieb:

Quote:

Hi,

I have a feature request:

\d mytable should display if a trigger is enabled or disabled.

Do others think this would be useful, too?

Works for me:

test=# alter table foo disable trigger all;
ALTER TABLE
test=# \d foo
Table "public.foo"
Column | Type | Modifiers
--------+---------+-----------
a | integer |
Disabled triggers:
trg1 BEFORE INSERT ON foo FOR EACH ROW EXECUTE PROCEDURE trg_foo()

Okay, okay, this is:

test=# select version();
version
---------------------------------------------------------------------------------------------------
PostgreSQL 8.4devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.3 (Ubuntu 4.2.3-2ubuntu7)
(1 row)

end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net

Reply With Quote

#3

Old

Andreas Kretschmer

Posts: n/a

Re: \d mytable should display if trigger is enabled - 10-22-2008 , 02:18 AM

begin Thomas Guettler schrieb:

Quote:

Hi,

I have a feature request:

\d mytable should display if a trigger is enabled or disabled.

Do others think this would be useful, too?

Works for me:

test=# alter table foo disable trigger all;
ALTER TABLE
test=# \d foo
Table "public.foo"
Column | Type | Modifiers
--------+---------+-----------
a | integer |
Disabled triggers:
trg1 BEFORE INSERT ON foo FOR EACH ROW EXECUTE PROCEDURE trg_foo()

Okay, okay, this is:

test=# select version();
version
---------------------------------------------------------------------------------------------------
PostgreSQL 8.4devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.3 (Ubuntu 4.2.3-2ubuntu7)
(1 row)

end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net

Reply With Quote

#4

Old

Andreas Kretschmer

Posts: n/a

Re: \d mytable should display if trigger is enabled - 10-22-2008 , 02:18 AM

begin Thomas Guettler schrieb:

Quote:

Hi,

I have a feature request:

\d mytable should display if a trigger is enabled or disabled.

Do others think this would be useful, too?

Works for me:

test=# alter table foo disable trigger all;
ALTER TABLE
test=# \d foo
Table "public.foo"
Column | Type | Modifiers
--------+---------+-----------
a | integer |
Disabled triggers:
trg1 BEFORE INSERT ON foo FOR EACH ROW EXECUTE PROCEDURE trg_foo()

Okay, okay, this is:

test=# select version();
version
---------------------------------------------------------------------------------------------------
PostgreSQL 8.4devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.3 (Ubuntu 4.2.3-2ubuntu7)
(1 row)

end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net

Reply With Quote

#5

Old

Andreas Kretschmer

Posts: n/a

Re: \d mytable should display if trigger is enabled - 10-22-2008 , 02:18 AM

begin Thomas Guettler schrieb:

Quote:

Hi,

I have a feature request:

\d mytable should display if a trigger is enabled or disabled.

Do others think this would be useful, too?

Works for me:

test=# alter table foo disable trigger all;
ALTER TABLE
test=# \d foo
Table "public.foo"
Column | Type | Modifiers
--------+---------+-----------
a | integer |
Disabled triggers:
trg1 BEFORE INSERT ON foo FOR EACH ROW EXECUTE PROCEDURE trg_foo()

Okay, okay, this is:

test=# select version();
version
---------------------------------------------------------------------------------------------------
PostgreSQL 8.4devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.3 (Ubuntu 4.2.3-2ubuntu7)
(1 row)

end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net

Reply With Quote

#6

Old

Andreas Kretschmer

Posts: n/a

Re: \d mytable should display if trigger is enabled - 10-22-2008 , 02:18 AM

begin Thomas Guettler schrieb:

Quote:

Hi,

I have a feature request:

\d mytable should display if a trigger is enabled or disabled.

Do others think this would be useful, too?

Works for me:

test=# alter table foo disable trigger all;
ALTER TABLE
test=# \d foo
Table "public.foo"
Column | Type | Modifiers
--------+---------+-----------
a | integer |
Disabled triggers:
trg1 BEFORE INSERT ON foo FOR EACH ROW EXECUTE PROCEDURE trg_foo()

Okay, okay, this is:

test=# select version();
version
---------------------------------------------------------------------------------------------------
PostgreSQL 8.4devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.3 (Ubuntu 4.2.3-2ubuntu7)
(1 row)

end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net

Reply With Quote

#7

Old

Andreas Kretschmer

Posts: n/a

Re: \d mytable should display if trigger is enabled - 10-22-2008 , 02:18 AM

begin Thomas Guettler schrieb:

Quote:

Hi,

I have a feature request:

\d mytable should display if a trigger is enabled or disabled.

Do others think this would be useful, too?

Works for me:

test=# alter table foo disable trigger all;
ALTER TABLE
test=# \d foo
Table "public.foo"
Column | Type | Modifiers
--------+---------+-----------
a | integer |
Disabled triggers:
trg1 BEFORE INSERT ON foo FOR EACH ROW EXECUTE PROCEDURE trg_foo()

Okay, okay, this is:

test=# select version();
version
---------------------------------------------------------------------------------------------------
PostgreSQL 8.4devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.3 (Ubuntu 4.2.3-2ubuntu7)
(1 row)

end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net

Reply With Quote

#8

Old

Andreas Kretschmer

Posts: n/a

Re: \d mytable should display if trigger is enabled - 10-22-2008 , 02:18 AM

begin Thomas Guettler schrieb:

Quote:

Hi,

I have a feature request:

\d mytable should display if a trigger is enabled or disabled.

Do others think this would be useful, too?

Works for me:

test=# alter table foo disable trigger all;
ALTER TABLE
test=# \d foo
Table "public.foo"
Column | Type | Modifiers
--------+---------+-----------
a | integer |
Disabled triggers:
trg1 BEFORE INSERT ON foo FOR EACH ROW EXECUTE PROCEDURE trg_foo()

Okay, okay, this is:

test=# select version();
version
---------------------------------------------------------------------------------------------------
PostgreSQL 8.4devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.3 (Ubuntu 4.2.3-2ubuntu7)
(1 row)

end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net

Reply With Quote

#9

Old

Andreas Kretschmer

Posts: n/a

Re: \d mytable should display if trigger is enabled - 10-22-2008 , 02:18 AM

begin Thomas Guettler schrieb:

Quote:

Hi,

I have a feature request:

\d mytable should display if a trigger is enabled or disabled.

Do others think this would be useful, too?

Works for me:

test=# alter table foo disable trigger all;
ALTER TABLE
test=# \d foo
Table "public.foo"
Column | Type | Modifiers
--------+---------+-----------
a | integer |
Disabled triggers:
trg1 BEFORE INSERT ON foo FOR EACH ROW EXECUTE PROCEDURE trg_foo()

Okay, okay, this is:

test=# select version();
version
---------------------------------------------------------------------------------------------------
PostgreSQL 8.4devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.3 (Ubuntu 4.2.3-2ubuntu7)
(1 row)

end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net

Reply With Quote

#10

Old

Thomas Guettler

Posts: n/a

Re: \d mytable should display if trigger is enabled - 10-22-2008 , 05:35 AM

Hi Andreas,

I use 8.2.6. Good to know, that it will be included in the next release (8.4).

foo_esg_modw=# alter table foo_beleg disable trigger foo_beleg_tgr;
ALTER TABLE
foo_esg_modw=# \d foo_beleg
Tabelle »public.foo_beleg«
Spalte | Typ | Attribute
------------------+--------------------------+------------------------------------------------------------
id | integer | not null default nextval('foo_beleg_id_seq'::regclass)
...
Indexe:
...
Trigger:
foo_beleg_tgr AFTER INSERT OR DELETE OR UPDATE ON foo_beleg FOR EACH ROW EXECUTE PROCEDURE history_monitor()

foo_esg_modw=# select version();
version
--------------------------------------------------------------------------------------------
PostgreSQL 8.2.6 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.2.1 (SUSE Linux)
(1 Zeile)

Andreas Kretschmer schrieb:

Quote:

Works for me:
..
PostgreSQL 8.4devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.3 (Ubuntu 4.2.3-2ubuntu7)

--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de

Reply With Quote

Reply

Page 1 of 2

1

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.