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

Re: Invalid input for integer on VIEW

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mike <mike(at)bristolreccc(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Invalid input for integer on VIEW
Date: 2004-08-24 16:30:57
Message-ID: 4752.1093365057@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
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

In response to

Responses

pgsql-general by date

Next:From: Silvio MatthesDate: 2004-08-24 16:33:50
Subject: WG: Re: Re: select ... where <column>='' does a seqscan [auf Viren geprueft]
Previous:From: Ron St-PierreDate: 2004-08-24 16:28:15
Subject: Re: Dump and Restore

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