Thank you Thomas for looking into this issue.
One question I would like to be answered is:
If a session changes the mode will it change the mode for other sessions
as well?
This is problematic if I have clients accessing the database through
jdbc wanting to use the REGULAR mode and some php clients
connecting through PgServer forcing everybody to use |POSTGRESQL MODE.|
19.6.2011 15:16, Thomas Mueller kirjoitti:
Anyway, the first connection that opens a database using the
PostgreSQL server needs to be an administrator user (so the system
tables can be created).
This is understandable and can be handled simply by opening the db when
opening the server and keeping it open.
Do you mean that everytime the db is opened, the first PgServer user has
to be admin?
In other words are the system tables persistent?
Btw. your last sentence was cut in the middle.
- rami
19.6.2011 15:16, Thomas Mueller kirjoitti:
Hi,
Actually, it's a bit different:
So far, non-admin users can open a database using a mode (MODE=xxx),
but only if the database is not open already (even if the mode matched
the current mode). This is a bug and will be fixed. There was another
bug: non-admin users could not open a database over the PgServer,
because they didn't have enough access rights to read the pg_catalog
tables. This will be fixed as well.
Anyway, the first connection that opens a database using the
PostgreSQL server needs to be an administrator user (so the system
tables can be created). Subsequent connections don't need to be opened
by an administrator. The reason is that
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
