Re: Invalid input for integer on VIEW

From: mike <mike(at)bristolreccc(dot)co(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Invalid input for integer on VIEW
Date: 2004-08-24 17:42:52
Message-ID: 1093369372.11622.5.camel@datacc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2004-08-24 at 12:30 -0400, Tom Lane wrote:
> mike <mike(at)bristolreccc(dot)co(dot)uk> writes:
> > If I do the same query, except to create a new table, everything works,
> > so is this a view bug?
>
> Possibly, but you haven't given enough info to let someone else
> reproduce the problem. A SQL script that creates all the necessary
> tables and the view and then triggers the failure would make it much
> easier for us to investigate.
>
> regards, tom lane
>

Is this OK, or do you want some data as well?

> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>

Attachment Content-Type Size
test.sql text/x-sql 2.8 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shelby Cain 2004-08-24 18:00:00 Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming
Previous Message Jeff Amiel 2004-08-24 17:35:49 Re: SELECT to an external file