Re: [GENERAL] column names in select don't exists in insert to

2006-09-27 Thread Johan
Michael Fuhr schreef: > On Thu, Sep 21, 2006 at 01:32:47AM -0700, Johan wrote: > > Someone executed the query in psql for me and the problem seems to be > > in a stored procedure triggered after update. This procedure complains > > about the field. > > Were you able to fix the problem or are you

Re: [GENERAL] column names in select don't exists in insert to

2006-09-24 Thread Michael Fuhr
On Thu, Sep 21, 2006 at 01:32:47AM -0700, Johan wrote: > Someone executed the query in psql for me and the problem seems to be > in a stored procedure triggered after update. This procedure complains > about the field. Were you able to fix the problem or are you still uncertain what the problem is

Re: [GENERAL] column names in select don't exists in insert to

2006-09-24 Thread Johan
Michael Fuhr schreef: > On Wed, Sep 20, 2006 at 02:29:16PM -0700, Johan wrote: > > I encountered a strange problem while trying to solve a bug. I use a > > postgresql 8.x database and a jdbc driver from > > postgresql-8.1dev-400.jdbc3.jar. The following is happening > > Any reason you're not usin

Re: [GENERAL] column names in select don't exists in insert to

2006-09-21 Thread Scott Marlowe
On Wed, 2006-09-20 at 16:29, Johan wrote: > Hi, > I encountered a strange problem while trying to solve a bug. I use a > postgresql 8.x database and a jdbc driver from > postgresql-8.1dev-400.jdbc3.jar. The following is happening > > The table is created like > create table test ( > field1 int8

Re: [GENERAL] column names in select don't exists in insert to

2006-09-20 Thread Michael Fuhr
On Wed, Sep 20, 2006 at 02:29:16PM -0700, Johan wrote: > I encountered a strange problem while trying to solve a bug. I use a > postgresql 8.x database and a jdbc driver from > postgresql-8.1dev-400.jdbc3.jar. The following is happening Any reason you're not using the latest, postgresql-8.1-407.jd

[GENERAL] column names in select don't exists in insert to

2006-09-20 Thread Johan
Hi, I encountered a strange problem while trying to solve a bug. I use a postgresql 8.x database and a jdbc driver from postgresql-8.1dev-400.jdbc3.jar. The following is happening The table is created like create table test ( field1 int8 not null, field2 int8 not null); if I do a select fiel