diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2004-12-30 00:30:40 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2004-12-30 00:30:40 +0000 |
| commit | 1ade4b33f6357a1491bd95b3a8340c2b3bded31f (patch) | |
| tree | 58667f32c8263fb0422def3d0c08b51adf24b6f6 /contrib/oracle | |
| parent | 96ecf9d5aa1b0a0da72a223460545750d06ceb89 (diff) | |
| download | postgresql-1ade4b33f6357a1491bd95b3a8340c2b3bded31f.tar.gz postgresql-1ade4b33f6357a1491bd95b3a8340c2b3bded31f.zip | |
Triggers should return TRIGGER not OPAQUE. Looks like this script got
overlooked in 7.3 updates. Not a critical fix but avoids a notice when
the resulting SQL script is executed.
Diffstat (limited to 'contrib/oracle')
| -rw-r--r-- | contrib/oracle/Ora2Pg.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/contrib/oracle/Ora2Pg.pm b/contrib/oracle/Ora2Pg.pm index fd6656f8b85..0fbecba007b 100644 --- a/contrib/oracle/Ora2Pg.pm +++ b/contrib/oracle/Ora2Pg.pm @@ -881,7 +881,7 @@ print STDERR "Add triggers definition...\n" if ($self->{debug}); if ($self->{export_schema}) { $sql_output .= "SET search_path = $self->{schema}, pg_catalog;\n\n"; } - $sql_output .= "CREATE FUNCTION pg_fct_\L$trig->[0]\E () RETURNS OPAQUE AS '\n$trig->[4]\n' LANGUAGE 'plpgsql'\n\n"; + $sql_output .= "CREATE FUNCTION pg_fct_\L$trig->[0]\E () RETURNS TRIGGER AS '\n$trig->[4]\n' LANGUAGE 'plpgsql'\n\n"; $sql_output .= "CREATE TRIGGER \L$trig->[0]\E\n\t$trig->[1] $trig->[2] ON \"\L$trig->[3]\E\" FOR EACH ROW\n\tEXECUTE PROCEDURE pg_fct_\L$trig->[0]\E();\n\n"; } } |