Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nloZA-0002kJ-9K for pgsql-bugs@arkaria.postgresql.org; Tue, 03 May 2022 09:11:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nloZ9-0000RQ-6D for pgsql-bugs@arkaria.postgresql.org; Tue, 03 May 2022 09:11:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nlo5o-0005aS-6D for pgsql-bugs@lists.postgresql.org; Tue, 03 May 2022 08:41:12 +0000 Received: from sonic303-20.consmr.mail.ne1.yahoo.com ([66.163.188.146]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nlo5k-0007f4-GD for pgsql-bugs@lists.postgresql.org; Tue, 03 May 2022 08:41:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1651567265; bh=iCW42YoYAZUTUNZl8j2VzLGOyGy01yTS9HBDDU3JZQI=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=kIHZI4JQdD5TQVxpX+259e37IPeSzpi0mOhQ08w/lm9UNrEpE4Rt+KHatmkVB4CJuukzu0S0a361TIjsn5PWk+ZNlx5/M2lyT9eROkWB2dSp7/lMp348WuMaFPZu5hg08EAb5byQxvI4VtoIwtl6I+J1eyBGv7qxm/r2Q23+9kiCAHsfNIIlBpOo/HrGHj9sas05z+tFcWBEtkR4pursq/MpvSz4/sVM7ZXe0criqiwdtwP4TamJX/lUhUA8x1OUYsbCp36qNoyOnn/MCN54Pj/gs2+zwLg7iftWARYAMHh7stWb/aIpvBR+XhxIJDEfMjRLaj7XmZburFMSAoRS9w== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1651567265; bh=tuh/ixOVAPtMKHQe6XvpM4TRBRJKdUaRIydPmRKqRfq=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=j29i5XsHsWaBb4/suk2dGtqErYnyLcswJ223/GVNIE/IU7z3rbFFDH8NTwfdqqBH9s5zqwiDEfeu10KQ95Yz3q38hjosw/iG7cO4U9cGoxJbTfgAnFOjOgtdrQTCLJm+yxNwrpiSjzObVFyCbVS34+gv+UbbVd6MlysuIm6hzrG89+I8ItxhM61BSQtf0fVrHGkOvng+8Mv/7ppNscn5oWWyEX9UjnIMTvoWSGqNa6lboihqWL9cTPDss6Mvz3MgJ3VOkKhnfV0W9zoZwMaZMxVUkbL5ht3Mh3dxEq1oF3T2PXTUl346Q6aTAi2YIQ3MkdE/i6YK3fFq7aGgsHzsKg== X-YMail-OSG: ma7m_jMVM1lc8EoPHV60zI9IJn2UC5xE.qaZ7QXxm3ETUERbHsoLQCW2cfW1fRt xTT3M2y6HLQufAuUeJ2tjO.onGwNX0YDrgiNUlFIEi4QgrtSBl9ZkCI22KotVekQ0RXFdWB2lUQ9 xCXjTiVXMg6odpPtEZosKUeOXvL0W6Xem_AndK5fdGq4LTjind1OE3eAmhhlC.kuFmm4gNO1gQlE xOHDiKTuRZLDGpv3l0QZCy6DoqOnLyHRdMLadVWDZLzc5u83iKiu0.WXyK1mB6rbBX7srffyd6rN ZcttdLawg2O.60q2ORQdj1EaQmqb0awRqVjc8bMkyyRMkz_B6m5IyMYfME.53DlGA.Rr.bgn6m_3 lQKCE4SU31ZbdoiwOCpRjbW1NbSpj.N61z8tAxLShk6IRi8YQcaa8jQjsRvQiu5ok7gJ9S7sVUcA jC2bL5a2HHNRTOz90fuNLH1g6ZTfYNKEDSeHD7gADFlvA83oPtXqMcr1P4KsOVB2wsrbRZDZAsO_ etKzbZd71PNK14.fiFTWbsrVKWbUVU8cIqVu23H2gOz3SKjmQfBKf.toYLwTB0VHakcCQ3HjkBbQ ErtNw1RG51rimMQybGeOWhOdIjQG0T.Sy0RvTMcPcZcsh8RXNWWxbkh2Vz9.lip2b.tx8OCFZIea oESHOjqu4ef_KjNk5yoMF36osoTGCK_Q28D9SW7DfFP07B.WsRW_4tkcYHdEHgxx3RQBZKwrkl2Q Iowrq9NBUGouaaKxNONmyH13xDIRzofCtgZKf31fhQz.5gJF7.VQZZA8Cjka4db3rfJmmIkj3eT. g4n5tkPkRhpSJ0Nh7mDmH7vS1RNE_YYw.3x_aHgIgzXOC_9m3bSNLR3dzvcQlbNnFcs13_PHclUk F1xwvT0FquSW5dggHb0T.YwegrYWEXm.q7Dze4KMrtYzuFtZIcadQ.mFQpUYQydz_1e0BVAsbO7r o0dSI47mttYu4UMpWSoL6wzH8w3KNkQelynN1IRV8fSSxjQp44Tq3JTmndxJz6c2vjXumwhW60H2 vLC1FfP3PF1jPX4144DeeKNkrg57LwKrQKnViMSiV_I4q1nnZWx0cd1SLdVlwHHyO0bnVOu.5wdg E7BY7GClvicVeDhz8sj9b4LIxs.oDx8mAwe4Zzj3QtYuAlxhS6G9NVcCoppGNWgsxgjCoVdUd.ro hNCvolPeBXdWsHmDYuJA.akekVAYvdQyc.z0rv9bLFfcuKcBjvMtSYVm2U5fUlblmRVn6KfEQCzH ythiyvQv_a2kDHA9znf_6sOr0bwpCLPa.x13uwkqrilwqLyc7WKrlejwte5ZKPBIYJZRujZ1M.EN Hoq1AsixQ6lk2iLc5akFb8ZtkJMGThFASoSEXLd4ZmiRs1RyLz9WKFtknxStjPcf4Uegp3.hZMOb mHM77nfF5TeO0ajbAK9VRcCzjBoifKCQT.znA3SXcu8AlWZ4iue7dSynabUXxGEJJ8gw98TJ70Mv ntCHDhfzm4OIXjSOxsniRezwKxIt8humjq4BdCbhWgR5sNKZXblifN0t9KBkCZ6GCV2YBhWm2FKY 1kkewNgE5lDpeYVqzHmmScZYys339msBlpRd6WCUlm7OssjVAhQPqcaek4lCzS7xrqydhyzNJ55Q e4Slc3Hnmlz6nO2lKhtlc3.MDK_s5BKub0V1YNG6GcGS9EzWAOxNcNixWWcNLz1tuXmU_V1J5ToK QYH_8N8JHpg_YDBB3hZKBDwSO2454UElCNhdBKJeCkJtDFQ9ZyQao7bEcdzWO0hRkP_3hyosFolN 9PwdYHiseZ1j6F_DqiMO4KBskEZPkWpE2o3MZvXFRxwokTTvQV8OjMlSh81.yBbeojx47OFvkC8G ZCV8pIK.CvaM4DlUi.Y2EMFN5aUyrRwTSS06XcWKs8PpWkpD6zDwwhU8BuZqlQanUM.akpMmxkTt MDafZ_U2VSC1aK9IgufwiAWmXgfUWwvu_s8vBrJgl.vcmEgu64EuZ9OIcxaADMzQoXB_n31kPdBq QDQb1v5J2qIPKlAAXNSszxfen7X8wsyV3AOv9gHSJB8HvnLX6ZPVtHczrErMFWmVUcDlmtulKmgi izK9J6JPV9KsAj2kMqGRYejcmmDa6t1RThhMHe_MmaIZLPpasnAlIbMG0CnDIpMrC109nMyuDc6I 0DOz1m138yLv7Yd_SizL3ZHgbge7otipIX8va44V_dhBwR7Ma70sroi7Cc3yL0A1422IwsjDamCZ hic1ohHGnx9z48sqNNy2et6kf5nqV66LCpUPp X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic303.consmr.mail.ne1.yahoo.com with HTTP; Tue, 3 May 2022 08:41:05 +0000 Date: Tue, 3 May 2022 08:41:01 +0000 (UTC) From: Van Droogenbroeck David To: "pgsql-bugs@lists.postgresql.org" Message-ID: <1060239572.3847959.1651567261680@mail.yahoo.com> In-Reply-To: <1519274001.3839906.1651567094742@mail.yahoo.com> References: <661039975.3830107.1651565848436.ref@mail.yahoo.com> <661039975.3830107.1651565848436@mail.yahoo.com> <1519274001.3839906.1651567094742@mail.yahoo.com> Subject: Fw: bug in postgres 14.2 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3847958_3909931.1651567261675" X-Mailer: WebService/1.1.20118 YMailNorrin Content-Length: 20297 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_3847958_3909931.1651567261675 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Dear Here an update of our problem. I have try some other things and it is still stranger: select count(*) from bin.ggr =3D> no problem (still it had the mulipolygon) CREATE TABLE bin.ggr (=C2=A0=C2=A0 =C2=A0gid serial NOT NULL, =C2=A0=C2=A0 =C2=A0objectid int4 NULL, =C2=A0=C2=A0 =C2=A0naam varchar(64) NULL, =C2=A0=C2=A0 =C2=A0"__gid" int2 NULL, =C2=A0=C2=A0 =C2=A0ggrnaa varchar(50) NULL, =C2=A0=C2=A0 =C2=A0niscode int4 NULL, =C2=A0=C2=A0 =C2=A0geom gis.geometry(multipolygon, 31370) NULL, =C2=A0=C2=A0 =C2=A0vmm_gem_id int4 NULL, =C2=A0=C2=A0 =C2=A0CONSTRAINT ggr_pkey PRIMARY KEY (gid) ); CREATE INDEX ggr_geom_idx ON bin.ggr USING gist (geom); CREATE INDEX ggr_vmm_gem_id ON bin.ggr USING btree (vmm_gem_id); but=20 select count(*) from trn.parkings =3D> SQL Error [XX000]: ERROR: variable n= ot found in subplan target list CREATE TABLE trn.parkings ( =C2=A0=C2=A0 =C2=A0gid serial NOT NULL, =C2=A0=C2=A0 =C2=A0"__gid" numeric(10) NULL, =C2=A0=C2=A0 =C2=A0omschrijvi varchar(254) NULL, =C2=A0=C2=A0 =C2=A0bron varchar(20) NULL, =C2=A0=C2=A0 =C2=A0edit_wijz varchar(20) NULL, =C2=A0=C2=A0 =C2=A0datum_dig varchar(24) NULL, =C2=A0=C2=A0 =C2=A0locatieid numeric(10) NULL, =C2=A0=C2=A0 =C2=A0opmerking varchar(30) NULL, =C2=A0=C2=A0 =C2=A0park_id int4 NULL, =C2=A0=C2=A0 =C2=A0geom gis.geometry(multipolygon, 31370) NULL, =C2=A0=C2=A0 =C2=A0CONSTRAINT parkings_pkey PRIMARY KEY (gid) ); CREATE INDEX parkings_geom_idx ON trn.parkings USING gist (geom); The workaround can't we implement (to much work and to complex to change) Met vriendelijke groetenDavid Van D=20 ----- Forwarded Message ----- From: Van Droogenbroeck David To: pgsql-bugs@lists.postgresql.org Sent: Tuesday, May 3, 2022, 10:17:28 AM GMT+2Subject: bug in postgres = 14.2 Dear we have found a bug in postgres 14.2. select count(*) from wat.owl_v ov;the error is: org.jkiss.dbeaver.model.sql= .DBSQLException: SQL Error [XX000]: ERROR: variable not found in subplan ta= rget list at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execu= teStatement(JDBCStatementImpl.java:133) at org.jkiss.dbeaver.ui.editors.sql= .execute.SQLQueryJob.executeStatement(SQLQueryJob.java:513) at org.jkiss.db= eaver.ui.editors.sql.execute.SQLQueryJob.lambda$0(SQLQueryJob.java:444) at = org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java= :171) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingle= Query(SQLQueryJob.java:431) at org.jkiss.dbeaver.ui.editors.sql.execute.SQL= QueryJob.extractData(SQLQueryJob.java:816) at org.jkiss.dbeaver.ui.editors.= sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3435) at org.jk= iss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJo= bDataRead.java:118) at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteR= ecover(DBExecUtils.java:171) at org.jkiss.dbeaver.ui.controls.resultset.Res= ultSetJobDataRead.run(ResultSetJobDataRead.java:116) at org.jkiss.dbeaver.u= i.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetView= er.java:4711) at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJo= b.java:105) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) Ca= used by: org.postgresql.util.PSQLException: ERROR: variable not found in su= bplan target list at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorR= esponse(QueryExecutorImpl.java:2552) at org.postgresql.core.v3.QueryExecuto= rImpl.processResults(QueryExecutorImpl.java:2284) at org.postgresql.core.v3= .QueryExecutorImpl.execute(QueryExecutorImpl.java:322) at org.postgresql.jd= bc.PgStatement.executeInternal(PgStatement.java:481) at org.postgresql.jdbc= .PgStatement.execute(PgStatement.java:401) at org.postgresql.jdbc.PgStateme= nt.executeWithFlags(PgStatement.java:322) at org.postgresql.jdbc.PgStatemen= t.executeCachedSql(PgStatement.java:308) at org.postgresql.jdbc.PgStatement= .executeWithFlags(PgStatement.java:284) at org.postgresql.jdbc.PgStatement.= execute(PgStatement.java:279) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDB= CStatementImpl.execute(JDBCStatementImpl.java:330) at org.jkiss.dbeaver.mod= el.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java= :130) ... 12 more the DDL of the table is: CREATE TABLE wat.owl_v ( gid serial NOT NULL, wate= rlicha varchar(254) NULL, owl_naam varchar(254) NULL, orde varchar(254) NUL= L, gsd varchar(50) NULL, bekken_nr numeric(10) NULL, bekken_naa varchar(254= ) NULL, cat_code numeric(10) NULL, cat_naam varchar(254) NULL, typ_code var= char(254) NULL, type_naam varchar(254) NULL, statuut_co varchar(10) NULL, s= tatuut_na varchar(254) NULL, asz varchar(20) NULL, lengte numeric NULL, gel= dig_van date NULL, geldig_tot date NULL, geom gis.geometry(multipolygon, 31= 370) NULL, vmm_vhaw_id int4 NULL, CONSTRAINT owl_v_pkey PRIMARY KEY (gid) )= ; CREATE INDEX owl_v_geom_idx ON wat.owl_v USING gist (geom); CREATE INDEX = owl_v_vmm_vhaw_id ON wat.owl_v USING btree (vmm_vhaw_id); the most strange = on the thing is, when we change the * into any of the fields of the table, = We don't get an error. I think the problem is something with multipolygon, because we have another= table quite the same but with multilinestring and the query works without = any problem CREATE TABLE wat.owl_l ( gid serial NOT NULL, waterlicha varcha= r(254) NULL, owl_naam varchar(254) NULL, orde varchar(254) NULL, sgd varcha= r(50) NULL, bekken_nr numeric(10) NULL, bekken_naa varchar(254) NULL, cat_c= ode numeric(10) NULL, cat_naam varchar(254) NULL, type_code varchar(254) NU= LL, type_naam varchar(254) NULL, statuut_co varchar(10) NULL, statuut_na va= rchar(254) NULL, asz varchar(20) NULL, geldig_van date NULL, geldig_tot dat= e NULL, lengte numeric NULL, geom gis.geometry(multilinestring, 31370) NULL= , vmm_vhaw_id int4 NULL, CONSTRAINT owl_l_pkey PRIMARY KEY (gid) ); CREATE = INDEX owl_l_geom_idx ON wat.owl_l USING gist (geom); CREATE INDEX owl_l_vmm= _vhaw_id ON wat.owl_l USING btree (vmm_vhaw_id); Kind regardsDavid Van D =20 ------=_Part_3847958_3909931.1651567261675 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Dear<= /div>

Here an update of our problem.
I = have try some other things and it is still stranger:
=

select count(= *) from bin.ggr =3D> no problem (still it had the mulipolygon)
CREATE TABLE bin.ggr (
    gid = serial NOT NULL,
    objectid int4 NULL,    naam varchar(64) NULL,
    "__gid" int2 NULL,
   &nbs= p;ggrnaa varchar(50) NULL,
    niscode int= 4 NULL,
    geom gis.geometry(multipoly= gon, 31370) NULL,
    vmm_gem_id int4 = NULL,
    CONSTRAINT ggr_pkey PRIMARY KEY = (gid)
);
CREATE INDEX ggr_geom_idx ON b= in.ggr USING gist (geom);
CREATE INDEX ggr_vmm_gem_i= d ON bin.ggr USING btree (vmm_gem_id);

<= div dir=3D"ltr">but
select cou= nt(*) from trn.parkings =3D> SQL Error [XX000]: ERROR: variabl= e not found in subplan target list

CREATE TABLE trn.parkings (
    gid serial NOT NULL,
   =  "__gid" numeric(10) NULL,
    omschr= ijvi varchar(254) NULL,
    bron varchar(2= 0) NULL,
    edit_wijz varchar(20) NULL,    datum_dig varchar(24) NULL,
    locatieid numeric(10) NULL,
&nb= sp;   opmerking varchar(30) NULL,
   =  park_id int4 NULL,
    geom gis.geom= etry(multipolygon, 31370) NULL,
    = ;CONSTRAINT parkings_pkey PRIMARY KEY (gid)
);
CREATE INDEX parkings_geom_idx ON trn.parkings USING gist (geom);=


The workaround can't we implement (to much work and to = complex to change)

Met vriendelijke groeten
David Van D
<= /div>


=20
----- Forwarded Message -----
From: Van Droogenbroeck David <david_van_d@y= ahoo.com>
To: pgsql-bugs@lists.postgresql.org <pgsql= -bugs@lists.postgresql.org>
Sent: Tuesday, May 3, 2022,= 10:17:28 AM GMT+2
Subject: bug in postgres 14.2

Dear

we have found a bug in postgres 14.2.

select count(*) from wat.owl_v ov;
the error is:
=09o= rg.jkiss.dbeaver.model.sql.DBSQLException: SQL Error [XX000]: ERROR: variab= le not found in subplan target list
=09=09at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStateme= ntImpl.executeStatement(JDBCStatementImpl.java:133)
=09=09at org.jkiss.dbeaver.ui.editors.sql= .execute.SQLQueryJob.executeStatement(SQLQueryJob.java:513)
=09=09at org.jkiss.dbeaver.ui.edito= rs.sql.execute.SQLQueryJob.lambda$0(SQLQueryJob.java:444)
=09=09at org.jkiss.dbeaver.model.exec= .DBExecUtils.tryExecuteRecover(DBExecUtils.java:171)
=09=09at org.jkiss.dbeaver.ui.editors.sql= .execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:431)
=09=09at org.jkiss.dbeaver.ui.edi= tors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:816)
=09=09at org.jkiss.dbeaver.ui.ed= itors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3435)
=09=09at org.jkiss.dbea= ver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRea= d.java:118)
=09=09at= org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.jav= a:171)
=09=09at org.= jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDa= taRead.java:116)
=09=09at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetData= PumpJob.run(ResultSetViewer.java:4711)
=09=09at org.jkiss.dbeaver.model.runtime.AbstractJob.run= (AbstractJob.java:105)
=09= =09at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
=09Caused by: org.postgr= esql.util.PSQLException: ERROR: variable not found in subplan target list
=09=09at org.postgres= ql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:25= 52)
=09=09at org.pos= tgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:228= 4)
=09=09at org.post= gresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:322)
<= div>=09=09at org.postgresql.jd= bc.PgStatement.executeInternal(PgStatement.java:481)
=09=09at org.postgresql.jdbc.PgStatement.= execute(PgStatement.java:401)
=09=09at org.postgresql.jdbc.PgStatement.executeWithFlags(PgState= ment.java:322)
=09=09at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308)<= /div>
=09=09at org.postgre= sql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284)
=09=09at org.postgresql.jdbc.PgStat= ement.execute(PgStatement.java:279)
=09=09at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStateme= ntImpl.execute(JDBCStatementImpl.java:330)
=09=09at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBC= StatementImpl.executeStatement(JDBCStatementImpl.java:130)
=09=09... 12 more

the DDL of the table is:
=09CREATE TABLE wat.owl_v (
=09=09gid serial NOT NULL,
=09=09waterlicha varchar(254) NUL= L,
=09=09owl_naam va= rchar(254) NULL,
=09=09orde varchar(254) NULL,
= =09=09gsd varchar(50) NULL,
=09=09bekken_nr numeric(10) NULL,
=09=09bekken_naa varchar(254) NULL,
= =09=09cat_code numeric(10) NUL= L,
=09=09cat_naam va= rchar(254) NULL,
=09=09typ_code varchar(254) NULL,
=09=09type_naam varchar(254) NULL,
=09=09statuut_co varchar(10) NULL,
=09=09statuut_na varchar(254) NULL= ,
=09=09asz varchar(= 20) NULL,
=09=09leng= te numeric NULL,
=09=09geldig_van date NULL,
= =09=09geldig_tot date NULL,
=09=09geom gis.geometry(multipolygon, 31370) NULL,
=09=09vmm_vhaw_id int4= NULL,
=09=09CONSTRA= INT owl_v_pkey PRIMARY KEY (gid)
=09);
=09CREATE INDEX owl_v_geom_idx ON wat.owl_v USING gist (geom);
=09CREATE INDEX owl_v_vmm_vhaw_id= ON wat.owl_v USING btree (vmm_vhaw_id);
=09
the most strange on the thing is, when w= e change the * into any of the fields of the table, We don't get an error.<= /div>

I think the problem is something wi= th multipolygon, because we have another table quite the same but with mult= ilinestring and the query works without any problem
=09CREATE TABLE wat.owl_l (
=09=09gid serial NOT NULL,
<= div>=09=09waterlicha varchar(2= 54) NULL,
=09=09owl_= naam varchar(254) NULL,
=09= =09orde varchar(254) NULL,
=09=09sgd varchar(50) NULL,
=09=09bekken_nr numeric(10) NULL,
=09=09bekken_naa varchar(254) NULL,
=09=09cat_code numeric(= 10) NULL,
=09=09cat_= naam varchar(254) NULL,
=09= =09type_code varchar(254) NULL,
=09=09type_naam varchar(254) NULL,
=09=09statuut_co varchar(10) NULL,
<= div>=09=09statuut_na varchar(2= 54) NULL,
=09=09asz = varchar(20) NULL,
=09=09geldig_van date NULL,
= =09=09geldig_tot date NULL,
=09=09lengte numeric NULL,
=09=09geom gis.geometry(multilinestring, 31370= ) NULL,
=09=09vmm_vh= aw_id int4 NULL,
=09=09CONSTRAINT owl_l_pkey PRIMARY KEY (gid)
=09);
=09CREATE INDEX owl_l_geom_idx ON wat.owl_l USING gist (geom);
=09CREATE INDEX owl_l_v= mm_vhaw_id ON wat.owl_l USING btree (vmm_vhaw_id);

Kind regards
David = Van D

------=_Part_3847958_3909931.1651567261675--