Pg42703 column "iddatum" does not exist

Vragen
, ,
1

De volgende query op PostgreSQL van Metacom:

select * from public."fJournaalpost" e where ( iddatum > :w1idDatum )

geeft de volgende error:

pg42703: 42703: column "iddatum" does not exist

POSITION: 48
Perhaps you meant to reference the column "e.idDatum".

An unknown error occurred.

Message ID: 677a96f2-7811-458a-91d3-454c6c3273b6

Occurred (UTC): 30-4-2024 11:35:05

Npgsql.PostgresException
   at Npgsql.Internal.NpgsqlConnector.<<ReadMessage>g__ReadMessageLong|223_0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Npgsql.NpgsqlDataReader.<NextResult>d__47.MoveNext()
2

Dit is dezelfde error als ik ook zou krijgen in pgAdmin via:

select min(idDatum)
,      max(idDatum)
,      min(documentDatum)
,      max(documentDatum)
from   "fJournaalpost"

Dit werkt wel in pgAdmin:

select min("idDatum")
,      max("idDatum")
,      min("documentDatum")
,      max("documentDatum")
from   "fJournaalpost"