Re: Problems with column names in dot-notation - Mailing list pgsql-jdbc

At 14.08.2002 08:55 -0400, Dave Cramer wrote:
>Can you get access to the server logs? I do these types of queries all
>the time?

The tomcat log gives me only the already mentioned error ("SQL-Error: The
column name sometable.somefield not found.")

Here are two snippets from the postgresql log:

/usr/local/pgsql/bin/postmaster: PostmasterMain: initial environ dump:
-----------------------------------------
         ANT_HOME=/usr/local/ant
         APACHE_HOME=/usr/local/apache
         CATALINA_HOME=/usr/local/tomcat4
         CC=gcc

CLASSPATH=:/usr/local/pgsql/share/java/postgresql.jar:/opt/classes:/opt/classes/postgis.jar:/opt/classes/DDConnectionBroker.jar:/usr/local/tomcat4/common/lib/servlet.jar:/usr/local/tomcat4/common/lib/xerces.jar:/data/www1/WEB-INF/classes:.
         HOME=/
         HZ=100
         JAVA_HOME=/usr/java
         LANG=de_DE
         LC_ALL=en_US.ISO8859-15@euro
         LOGNAME=root
         MAIL=/var/mail/root

PATH=/usr/local/pgsql/bin:/usr/local/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/local/ant/bin:/usr/ccs/bin:/usr/local/apache/bin:/export/home/ak3cvogt/bin
         PGDATA=/data/db/db1
         PGHOME=/usr/local/pgsql
         PGLIB=/usr/local/pgsql/lib
         SHELL=/sbin/sh
         TERM=vt100
         TOMCAT_HOME=/usr/local/tomcat3
         TZ=MET
         _INIT_NET_STRATEGY=none
         _INIT_PREV_LEVEL=S
         _INIT_RUN_LEVEL=3
         _INIT_RUN_NPREV=0
         _INIT_UTS_ISA=sparc
         _INIT_UTS_MACHINE=sun4u
         _INIT_UTS_NODENAME=nokis
         _INIT_UTS_PLATFORM=SUNW,Sun-Blade-100
         _INIT_UTS_RELEASE=5.8
         _INIT_UTS_SYSNAME=SunOS
         _INIT_UTS_VERSION=Generic_108528-15
-----------------------------------------
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
invoking IpcMemoryCreate(size=917504)
FindExec: found "/usr/local/pgsql/bin/postmaster" using argv[0]
DEBUG:  database system was shut down at 2002-08-14 15:24:44 MEST
DEBUG:  checkpoint record is at 0/309868
DEBUG:  redo record is at 0/309868; undo record is at 0/0; shutdown TRUE
DEBUG:  next transaction id: 11987; next oid: 16992
DEBUG:  database system is ready
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
DEBUG:  reaping dead processes
DEBUG:  BackendStartup: forked pid=5084 socket=8

[--snip--]

DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand
DEBUG:  BackendStartup: forked pid=5090 socket=8
/usr/local/pgsql/bin/postmaster child[5090]: starting with (postgres -d4
-v131072 -p nokis_contacts )
DEBUG:  InitPostgres
DEBUG:  StartTransactionCommand
DEBUG:  query: set datestyle to 'ISO'; select version(), case when
pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else
getdatabaseencoding() end;
DEBUG:  parse tree: { QUERY :command 5  :utility ?  :resultRelation 0 :into
<> :isPortal false :isBinary false :isTemp false :hasAggs false
:hasSubLinks false :rtable <> :jointree <> :rowMarks () :targetList <>
:groupClause <> :havingQual <> :distinctClause <> :sortClause <>
:limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  ProcessUtility: set datestyle to 'ISO'; select version(), case when
pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else
getdatabaseencoding() end;
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into
<> :isPortal false :isBinary false :isTemp false :hasAggs false
:hasSubLinks false :rtable <> :jointree { FROMEXPR :fromlist <> :quals <>}
:rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype
25 :restypmod -1 :resname version :reskey 0 :reskeyop 0 :ressortgroupref 0
:resjunk false } :expr { EXPR :typeOid 25  :opType func :oper { FUNC
:funcid 89 :functype 25 } :args <>}} { TARGETENTRY :resdom { RESDOM :resno
2 :restype 19 :restypmod -1 :resname getdatabaseencoding :reskey 0
:reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CASE :casetype 19
:arg <> :args ({ WHEN { EXPR :typeOid 16  :opType op :oper { OPER :opno 93
:opid 0 :opresulttype 16 } :args ({ EXPR :typeOid 19  :opType func :oper {
FUNC :funcid 1597 :functype 19 } :args ({ CONST :consttype 23 :constlen 4
:constbyval true :constisnull false :constvalue  4 [ 0 0 0 1 ] })} { CONST
:consttype 19 :constlen 32 :constbyval false :constisnull false
:constvalue  32 [ 83 81 76 95 65 83 67 73 73 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 ] })} :then { CONST :consttype 19 :constlen 32 :constbyval
false :constisnull false :constvalue  32 [ 85 78 75 78 79 87 78 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ] }}) :defresult { EXPR :typeOid
19  :opType func :oper { FUNC :funcid 1039 :functype 19 } :args <>}}})
:groupClause <> :havingQual <> :distinctClause <> :sortClause <>
:limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  plan: { RESULT :startup_cost 0.00 :total_cost 0.01 :rows 1 :width 0
:qptargetlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 25
:restypmod -1 :resname version :reskey 0 :reskeyop 0 :ressortgroupref 0
:resjunk false } :expr { EXPR :typeOid 25  :opType func :oper { FUNC
:funcid 89 :functype 25 } :args <>}} { TARGETENTRY :resdom { RESDOM :resno
2 :restype 19 :restypmod -1 :resname getdatabaseencoding :reskey 0
:reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CASE :casetype 19
:arg <> :args ({ WHEN { EXPR :typeOid 16  :opType op :oper { OPER :opno 93
:opid 62 :opresulttype 16 } :args ({ EXPR :typeOid 19  :opType func :oper {
FUNC :funcid 1597 :functype 19 } :args ({ CONST :consttype 23 :constlen 4
:constbyval true :constisnull false :constvalue  4 [ 0 0 0 1 ] })} { CONST
:consttype 19 :constlen 32 :constbyval false :constisnull false
:constvalue  32 [ 83 81 76 95 65 83 67 73 73 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 ] })} :then { CONST :consttype 19 :constlen 32 :constbyval
false :constisnull false :constvalue  32 [ 85 78 75 78 79 87 78 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ] }}) :defresult { EXPR :typeOid
19  :opType func :oper { FUNC :funcid 1039 :functype 19 } :args <>}}})
:qpqual <> :lefttree <> :righttree <> :extprm () :locprm () :initplan <>
:nprm 0  :resconstantqual <>}
DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: select contact.url from person, department, company,
contact, country where person.person_id = 4 and person.department_id =
department.department_id and department.company_id = company.company_id and
contact.country_id = country.country_id and person.contact_id =
contact.contact_id
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into
<> :isPortal false :isBinary false :isTemp false :hasAggs false
:hasSubLinks false :rtable ({ RTE :relname person :relid 16965  :subquery
<> :alias <> :eref { ATTR :relname person :attrs (
"person_id"   "is_nokis_contact"   "first_name"   "last_name"   "title"
"position"   "contact_id"   "phone"   "private_phone"   "cellphone"   "fax"
   "department_id"   "email" )} :inh true :inFromCl true :checkForRead true
:checkForWrite false :checkAsUser 0} { RTE :relname department :relid
16945  :subquery <> :alias <> :eref { ATTR :relname department :attrs (
"department_id"   "name_de"   "contact_id"   "name_en"   "company_id" )}
:inh true :inFromCl true :checkForRead true :checkForWrite false
:checkAsUser 0} { RTE :relname company :relid 16900  :subquery <> :alias <>
:eref { ATTR :relname company :attrs (
"company_id"   "name_1_de"   "name_2_de"   "acronym_de"   "contact_id"
"name_1_en"   "name_2_en"   "acronym_en" )} :inh true :inFromCl true
:checkForRead true :checkForWrite false :checkAsUser 0} { RTE :relname
contact :relid 16918  :subquery <> :alias <> :eref { ATTR :relname contact
:attrs (
"contact_id"   "street_1"   "street_2"   "plz_street"   "city_street"
"postbox"   "plz_postbox"   "city_postbox"   "country_id"   "url"   "email"
   "phone"   "fax"   "cellphone" )} :inh true :inFromCl true :checkForRead
true :checkForWrite false :checkAsUser 0} { RTE :relname country :relid
16938  :subquery <> :alias <> :eref { ATTR :relname country :attrs (
"country_id"   "iso_acronym"   "name_de"   "name_en" )} :inh true :inFromCl
true :checkForRead true :checkForWrite false :checkAsUser 0}) :jointree {
FROMEXPR :fromlist ({ RANGETBLREF 1 } { RANGETBLREF 2 } { RANGETBLREF 3 } {
RANGETBLREF 4 } { RANGETBLREF 5 }) :quals { EXPR :typeOid 16  :opType and
:oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR
:typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and
:oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid
0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23
:vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype
23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 0 4
] })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 0
:opresulttype 16 } :args ({ VAR :varno 1 :varattno 12 :vartype 23
:vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 12} { VAR :varno 2
:varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 2
:varoattno 1})})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 96
:opid 0 :opresulttype 16 } :args ({ VAR :varno 2 :varattno 5 :vartype 23
:vartypmod -1  :varlevelsup 0 :varnoold 2 :varoattno 5} { VAR :varno 3
:varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 3
:varoattno 1})})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 96
:opid 0 :opresulttype 16 } :args ({ VAR :varno 4 :varattno 9 :vartype 23
:vartypmod -1  :varlevelsup 0 :varnoold 4 :varoattno 9} { VAR :varno 5
:varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 5
:varoattno 1})})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 96
:opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 7 :vartype 23
:vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 7} { VAR :varno 4
:varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 4
:varoattno 1})})}} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM
:resno 1 :restype 1043 :restypmod 84 :resname url :reskey 0 :reskeyop 0
:ressortgroupref 0 :resjunk false } :expr { VAR :varno 4 :varattno 10
:vartype 1043 :vartypmod 84  :varlevelsup 0 :varnoold 4 :varoattno 10}})
:groupClause <> :havingQual <> :distinctClause <> :sortClause <>
:limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  plan: { NESTLOOP :startup_cost 0.00 :total_cost 24.17 :rows 1
:width 90 :qptargetlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype
1043 :restypmod 84 :resname url :reskey 0 :reskeyop 0 :ressortgroupref 0
:resjunk false } :expr { VAR :varno 65001 :varattno 3 :vartype 1043
:vartypmod 84  :varlevelsup 0 :varnoold 4 :varoattno 10}}) :qpqual <>
:lefttree { NESTLOOP :startup_cost 0.00 :total_cost 19.33 :rows 1 :width 86
:qptargetlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23
:restypmod -1 :resname <> :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk
false } :expr { VAR :varno 65001 :varattno 1 :vartype 23 :vartypmod
-1  :varlevelsup 0 :varnoold 1 :varoattno 12}} { TARGETENTRY :resdom {
RESDOM :resno 2 :restype 23 :restypmod -1 :resname <> :reskey 0 :reskeyop 0
:ressortgroupref 0 :resjunk false } :expr { VAR :varno 65001 :varattno 2
:vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 7}} {
TARGETENTRY :resdom { RESDOM :resno 3 :restype 1043 :restypmod 84 :resname
<> :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR
:varno 65001 :varattno 3 :vartype 1043 :vartypmod 84  :varlevelsup 0
:varnoold 4 :varoattno 10}} { TARGETENTRY :resdom { RESDOM :resno 4
:restype 23 :restypmod -1 :resname <> :reskey 0 :reskeyop 0
:ressortgroupref 0 :resjunk false } :expr { VAR :varno 65001 :varattno 4
:vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 4 :varoattno 9}} {
TARGETENTRY :resdom { RESDOM :resno 5 :restype 23 :restypmod -1 :resname <>
:reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR
:varno 65001 :varattno 5 :vartype 23 :vartypmod -1  :varlevelsup 0
:varnoold 4 :varoattno 1}} { TARGETENTRY :resdom { RESDOM :resno 6 :restype
23 :restypmod -1 :resname <> :reskey 0 :reskeyop 0 :ressortgroupref 0
:resjunk false } :expr { VAR :varno 65001 :varattno 6 :vartype 23
:vartypmod -1  :varlevelsup 0 :varnoold 2 :varoattno 1}} { TARGETENTRY
:resdom { RESDOM :resno 7 :restype 23 :restypmod -1 :resname <> :reskey 0
:reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 65001
:varattno 7 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 2
:varoattno 5}} { TARGETENTRY :resdom { RESDOM :resno 8 :restype 23
:restypmod -1 :resname <> :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk
false } :expr { VAR :varno 65000 :varattno 1 :vartype 23 :vartypmod
-1  :varlevelsup 0 :varnoold 3 :varoattno 1}}) :qpqual <> :lefttree {
NESTLOOP :startup_cost 0.00 :total_cost 14.49 :rows 1 :width 82
:qptargetlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23
:restypmod -1 :resname <> :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk
false } :expr { VAR :varno 65001 :varattno 1 :vartype 23 :vartypmod
-1  :varlevelsup 0 :varnoold 1 :varoattno 12}} { TARGETENTRY :resdom {
RESDOM :resno 2 :restype 23 :restypmod -1 :resname <> :reskey 0 :reskeyop 0
:ressortgroupref 0 :resjunk false } :expr { VAR :varno 65001 :varattno 2
:vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 7}} {
TARGETENTRY :resdom { RESDOM :resno 3 :restype 1043 :restypmod 84 :resname
<> :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR
:varno 65001 :varattno 3 :vartype 1043 :vartypmod 84  :varlevelsup 0
:varnoold 4 :varoattno 10}} { TARGETENTRY :resdom { RESDOM :resno 4
:restype 23 :restypmod -1 :resname <> :reskey 0 :reskeyop 0
:ressortgroupref 0 :resjunk false } :expr { VAR :varno 65001 :varattno 4
:vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 4 :varoattno 9}} {
TARGETENTRY :resdom { RESDOM :resno 5 :restype 23 :restypmod -1 :resname <>
:reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR
:varno 65001 :varattno 5 :vartype 23 :vartypmod -1  :varlevelsup 0
:varnoold 4 :varoattno 1}} { TARGETENTRY :resdom { RESDOM :resno 6 :restype
23 :restypmod -1 :resname <> :reskey 0 :reskeyop 0 :ressortgroupref 0
:resjunk false } :expr { VAR :varno 65000 :varattno 1 :vartype 23
:vartypmod -1  :varlevelsup 0 :varnoold 2 :varoattno 1}} { TARGETENTRY
:resdom { RESDOM :resno 7 :restype 23 :restypmod -1 :resname <> :reskey 0
:reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 65000
:varattno 2 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 2
:varoattno 5}}) :qpqual <> :lefttree { NESTLOOP :startup_cost 0.00
:total_cost 9.66 :rows 1 :width 74 :qptargetlist ({ TARGETENTRY :resdom {
RESDOM :resno 1 :restype 23 :restypmod -1 :resname <> :reskey 0 :reskeyop 0
:ressortgroupref 0 :resjunk false } :expr { VAR :varno 65001 :varattno 1
:vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 12}} {
TARGETENTRY :resdom { RESDOM :resno 2 :restype 23 :restypmod -1 :resname <>
:reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR
:varno 65001 :varattno 2 :vartype 23 :vartypmod -1  :varlevelsup 0
:varnoold 1 :varoattno 7}} { TARGETENTRY :resdom { RESDOM :resno 3 :restype
1043 :restypmod 84 :resname <> :reskey 0 :reskeyop 0 :ressortgroupref 0
:resjunk false } :expr { VAR :varno 65000 :varattno 1 :vartype 1043
:vartypmod 84  :varlevelsup 0 :varnoold 4 :varoattno 10}} { TARGETENTRY
:resdom { RESDOM :resno 4 :restype 23 :restypmod -1 :resname <> :reskey 0
:reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 65000
:varattno 2 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 4
:varoattno 9}} { TARGETENTRY :resdom { RESDOM :resno 5 :restype 23
:restypmod -1 :resname <> :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk
false } :expr { VAR :varno 65000 :varattno 3 :vartype 23 :vartypmod
-1  :varlevelsup 0 :varnoold 4 :varoattno 1}}) :qpqual <> :lefttree {
INDEXSCAN :startup_cost 0.00 :total_cost 4.82 :rows 1 :width 8
:qptargetlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23
:restypmod -1 :resname <> :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk
false } :expr { VAR :varno 1 :varattno 12 :vartype 23 :vartypmod
-1  :varlevelsup 0 :varnoold 1 :varoattno 12}} { TARGETENTRY :resdom {
RESDOM :resno 2 :restype 23 :restypmod -1 :resname <> :reskey 0 :reskeyop 0
:ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 7
:vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 7}})
:qpqual <> :lefttree <> :righttree <> :extprm () :locprm () :initplan <>
:nprm 0  :scanrelid 1 :indxid ( 16970) :indxqual (({ EXPR :typeOid
16  :opType op :oper { OPER :opno 96 :opid 65 :opresulttype 16 } :args ({
VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0
:varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval
true :constisnull false :constvalue  4 [ 0 0 0 4 ] })})) :indxqualorig (({
EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 65 :opresulttype
16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod
-1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 23
:constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 0 4 ]
})})) :indxorderdir 1 } :righttree { INDEXSCAN :startup_cost 0.00
:total_cost 4.82 :rows 1 :width 66 :qptargetlist ({ TARGETENTRY :resdom {
RESDOM :resno 1 :restype 1043 :restypmod 84 :resname <> :reskey 0 :reskeyop
0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 4 :varattno 10
:vartype 1043 :vartypmod 84  :varlevelsup 0 :varnoold 4 :varoattno 10}} {
TARGETENTRY :resdom { RESDOM :resno 2 :restype 23 :restypmod -1 :resname <>
:reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR
:varno 4 :varattno 9 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 4
:varoattno 9}} { TARGETENTRY :resdom { RESDOM :resno 3 :restype 23
:restypmod -1 :resname <> :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk
false } :expr { VAR :varno 4 :varattno 1 :vartype 23 :vartypmod
-1  :varlevelsup 0 :varnoold 4 :varoattno 1}}) :qpqual <> :lefttree <>
:righttree <> :extprm () :locprm () :initplan <> :nprm 0  :scanrelid 4
:indxid ( 16920) :indxqual (({ EXPR :typeOid 16  :opType op :oper { OPER
:opno 96 :opid 65 :opresulttype 16 } :args ({ VAR :varno 4 :varattno 1
:vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 4 :varoattno 1} { VAR
:varno 65001 :varattno 2 :vartype 23 :vartypmod -1  :varlevelsup 0
:varnoold 1 :varoattno 7})})) :indxqualorig (({ EXPR :typeOid 16  :opType
op :oper { OPER :opno 96 :opid 65 :opresulttype 16 } :args ({ VAR :varno
65001 :varattno 2 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno 7} { VAR :varno 4 :varattno 1 :vartype 23 :vartypmod
-1  :varlevelsup 0 :varnoold 4 :varoattno 1})})) :indxorderdir 0 } :extprm
() :locprm () :initplan <> :nprm 0  :jointype 0 :joinqual <>} :righttree {
INDEXSCAN :startup_cost 0.00 :total_cost 4.82 :rows 1 :width 8
:qptargetlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23
:restypmod -1 :resname <> :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk
false } :expr { VAR :varno 2 :varattno 1 :vartype 23 :vartypmod
-1  :varlevelsup 0 :varnoold 2 :varoattno 1}} { TARGETENTRY :resdom {
RESDOM :resno 2 :restype 23 :restypmod -1 :resname <> :reskey 0 :reskeyop 0
:ressortgroupref 0 :resjunk false } :expr { VAR :varno 2 :varattno 5
:vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 2 :varoattno 5}})
:qpqual <> :lefttree <> :righttree <> :extprm () :locprm () :initplan <>
:nprm 0  :scanrelid 2 :indxid ( 16947) :indxqual (({ EXPR :typeOid
16  :opType op :oper { OPER :opno 96 :opid 65 :opresulttype 16 } :args ({
VAR :varno 2 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0
:varnoold 2 :varoattno 1} { VAR :varno 65001 :varattno 1 :vartype 23
:vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 12})})) :indxqualorig
(({ EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 65
:opresulttype 16 } :args ({ VAR :varno 65001 :varattno 1 :vartype 23
:vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 12} { VAR :varno 2
:varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 2
:varoattno 1})})) :indxorderdir 0 } :extprm () :locprm () :initplan <>
:nprm 0  :jointype 0 :joinqual <>} :righttree { INDEXSCAN :startup_cost
0.00 :total_cost 4.82 :rows 1 :width 4 :qptargetlist ({ TARGETENTRY :resdom
{ RESDOM :resno 1 :restype 23 :restypmod -1 :resname <> :reskey 0 :reskeyop
0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 3 :varattno 1
:vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 3 :varoattno 1}})
:qpqual <> :lefttree <> :righttree <> :extprm () :locprm () :initplan <>
:nprm 0  :scanrelid 3 :indxid ( 16903) :indxqual (({ EXPR :typeOid
16  :opType op :oper { OPER :opno 96 :opid 65 :opresulttype 16 } :args ({
VAR :varno 3 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0
:varnoold 3 :varoattno 1} { VAR :varno 65001 :varattno 7 :vartype 23
:vartypmod -1  :varlevelsup 0 :varnoold 2 :varoattno 5})})) :indxqualorig
(({ EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 65
:opresulttype 16 } :args ({ VAR :varno 65001 :varattno 7 :vartype 23
:vartypmod -1  :varlevelsup 0 :varnoold 2 :varoattno 5} { VAR :varno 3
:varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 3
:varoattno 1})})) :indxorderdir 0 } :extprm () :locprm () :initplan <>
:nprm 0  :jointype 0 :joinqual <>} :righttree { INDEXSCAN :startup_cost
0.00 :total_cost 4.82 :rows 1 :width 4 :qptargetlist ({ TARGETENTRY :resdom
{ RESDOM :resno 1 :restype 23 :restypmod -1 :resname <> :reskey 0 :reskeyop
0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 5 :varattno 1
:vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 5 :varoattno 1}})
:qpqual <> :lefttree <> :righttree <> :extprm () :locprm () :initplan <>
:nprm 0  :scanrelid 5 :indxid ( 16940) :indxqual (({ EXPR :typeOid
16  :opType op :oper { OPER :opno 96 :opid 65 :opresulttype 16 } :args ({
VAR :varno 5 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0
:varnoold 5 :varoattno 1} { VAR :varno 65001 :varattno 4 :vartype 23
:vartypmod -1  :varlevelsup 0 :varnoold 4 :varoattno 9})})) :indxqualorig
(({ EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 65
:opresulttype 16 } :args ({ VAR :varno 65001 :varattno 4 :vartype 23
:vartypmod -1  :varlevelsup 0 :varnoold 4 :varoattno 9} { VAR :varno 5
:varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 5
:varoattno 1})})) :indxorderdir 0 } :extprm () :locprm () :initplan <>
:nprm 0  :jointype 0 :joinqual <>}
-----------------------------------------------------------
Dipl. Geogr. Carsten Heidmann
Tel.: 040.81908.345
Fax: 040.81908.373
heidmann@hamburg.baw.de
http://nokis.baw.de/

Bundesanstalt fuer Wasserbau
- Aussenstelle Kueste -
Wedeler Landstrasse 157
DE - 22559 Hamburg
-----------------------------------------------------------