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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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