From: | Michael Moore <michaeljmoore(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Need more info on PL/pgSQL compile listing |
Date: | 2015-11-16 23:29:56 |
Message-ID: | CACpWLjNR-0T3w55i34eqK3z9BrVu2ojxoXPp3aUZWUFYF_M60A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I am doing like:
*mydb-# \i pxportal2_mod.sql*
which gives an error like:
*CREATE FUNCTION*
*psql:pxportal2_mod.sql:309: NOTICE: type reference
tx_portal.portal_name%TYPE converted to character varying*
*psql:pxportal2_mod.sql:309: NOTICE: type reference
tx_service_catalog.service_code%TYPE converted to character varying*
*psql:pxportal2_mod.sql:309: ERROR: syntax error at or near "pxportal2"*
*LINE 61: pxportal2.dlogerror (v_program_name, v_program_loca...*
* ^*
The problem is that there are lots of directives and comments in my input
file so that neither line 309 (above) or 61 is actually meaningful.
I would simply like to echo the input lines to the output or get a more
verbose message. I spent over an hour googling this but no luck.
This is the beginning of my input file if that helps:
*-- Generated by Ora2Pg, the Oracle database Schema converter, version 16.0*
*-- Copyright 2000-2015 Gilles DAROLD. All rights reserved.*
*-- DATASOURCE: dbi:Oracle:LCD1_DEV*
*SET client_encoding TO 'UTF8';*
*\set ON_ERROR_STOP OFF*
*-- Oracle package 'PXPORTAL2' declaration, please edit to match PostgreSQL
syntax.*
*-- PostgreSQL does not recognize PACKAGES, using SCHEMA instead.*
*DROP SCHEMA IF EXISTS pxportal2 CASCADE;*
*CREATE SCHEMA pxportal2;*
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-11-17 00:02:30 | Re: Need more info on PL/pgSQL compile listing |
Previous Message | david.paulo | 2015-11-15 02:17:19 | Re: How would I get rid of trailing blank line? |