2007/2/15, Cory Horner <[EMAIL PROTECTED]>:
Sorry for missing the message -- haven't been watching the lists very
closely.
I thought we did a decent job on schema support, but it hasn't been
tested on _every_ configuration yet. My inkling is that it could be a
permissions problem, but the easiest way to figure this out would be to
step through with the debugger.
Yes I was thinking about permissions but changing the user to "postgres" for
the DB connection in GeoServer didn't solve anything..
What version of postgresql are you running?
PostgreSQL 8.1 (and PostGIS 1.1.3)
Please try executing that
SQL snippet from within the psql shell:
SELECT "id", "key", "userId", "layerId", "sessionId", "label", "mode",
"style", encode(AsBinary(force_2d("geom"), 'XDR'),'base64') FROM
"esig"."esig_points" WHERE '1' = '0';
In fact my DB schema is different now: all my tables are in the "public"
schema and I don't have anymore upper case in my field names (avoiding extra
potential issue, altough double quotes should force PG to interpret names in
a case sensitive way).
(using the same user credentials). Note that if your table or schema
has uppercase characters, it won't match.
You should get 0 rows back, but you might also get the error reproduced.
Let us know how that goes. I just tried a similar snippet with
postgres 8.1.1 without trouble.
Another thing to try is setting log_statement = 'all' in your
postgresql.conf file, restarting, and then hitting the database again
with your code (this will allow you to see ALL the sql sent to the
server in your pgsql.log, rather than just errors) -- this will shed
some light on what is leading up to this point.
Ok I will try to go back to my original design (ie. putting all my tables
into a seperate schema) and test it. But I can only do that on the next
week. I'll keep you informed on the ML.
PS: there's still something weird with my posts on this ML. Even with my new
mail account @gmail, I can't receive my own post! Maybe the SourceForge
mailing list server has new policy: no send to the original poster? That
would be the first time I see that on a ML.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
