pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Carol Walter <walterc@indiana.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: type unknown?
Date: Thu, 18 Sep 2008 19:03:11 -0400
Message-ID: <6906.1221778991@sss.pgh.pa.us> (raw)
In-Reply-To: <295F7A7F-901C-49F8-9627-61922BD33F6C@indiana.edu>
References: <ECE4FB45-9CD3-429F-9743-1BDA1D771942@indiana.edu>
	<2235.1221771693@sss.pgh.pa.us>
	<295F7A7F-901C-49F8-9627-61922BD33F6C@indiana.edu>

Carol Walter <walterc@indiana.edu> writes:
> Well, it''s a guess.  A "CREATE VIEW" follows the line that specifies  
> the warning.  (An "ALTER TABLE" immediately precedes it.)  This made  
> me think that is was on a view; then I went through the views till I  
> found one with a column called "collection".  Is there another way I  
> can isolate what's happening?

Try doing the restore with log_min_error_statement set to WARNING;
that would at least confirm whether you're looking at the right view
definition.

BTW, what PG version is this?

			regards, tom lane

view thread (4+ messages)

Message-ID: <6906.1221778991@sss.pgh.pa.us>
Permalink:  ../6906.1221778991@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/6906.1221778991@sss.pgh.pa.us

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, walterc@indiana.edu
  Subject: Re: type unknown?
  In-Reply-To: <6906.1221778991@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox