Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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?

Attachment: test.sql
Description: text/x-sql (2.8 KB)

In response to


pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group