Announcement Announcement Module
Collapse
No announcement yet.
creating temporary table PostgreSql 8.1 and iBatis 2.3 Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • creating temporary table PostgreSql 8.1 and iBatis 2.3

    Greetings!

    I've build a script in pgAdmin 3 ( os x 10.4 on ppc) that does a select, some left outer joins and puts the results into a temporary table. Works great when I run in pgAdmin.

    Then I try to use in an iBatis sqlmap as a 'select' and get this when trying to execute it:

    org.postgresql.util.PSQLException: ERROR: must be member of role "postgres"

    Other than that queries run fine.
    I'm thinking the problem is on the db admin side of things, but I'm at a loss as to how to start fixing it.

    I'll greatly appreciate any feedback.

    Thank you in advance.

  • #2
    I would presume you might be running the tests under a user account which doesn't have the required permissions to do what you want.
    Last edited by karldmoore; Aug 29th, 2007, 11:21 AM.

    Comment


    • #3
      ... correct. Cut & Paste in this case just didn't cut it
      Thanks for the tip!

      Comment


      • #4
        Hehe . Not a problem, glad to help!
        Last edited by karldmoore; Aug 29th, 2007, 11:21 AM.

        Comment

        Working...
        X