| 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: | Whole Thread | Raw Message | 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 |