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 |
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 |