Dave Page wrote:
> I get the above error message when creating a database in pgAdmin now:
> CREATE DATABASE demo
> WITH ENCODING='SQL_ASCII'
> COMMENT ON DATABASE demo IS 'This is the demo database';
> GRANT ALL ON DATABASE demo TO public;
> ALTER DATABASE demo SET search_path=demo;
> I understand what the message is telling me to do, but what is the
> reason for this change, and is it really *required*?
This is the commit that changed it:
It was in fact never supposed to work, but we failed to detect it. I had
to modify my test scripts that did something like psql -c "VACUUM foo;
SELECT ..." because of that as well. It's highly likely that it'll brake
other people's scripts as well, but I don't think there's much we can do
about it :(.
> The way pgAdmin is
> designed, a change to accomodate firing everything off in seperate
> queries would be a significant one which would most likely require us to
> effectively restart our whole beta process and may well mean we don't
> have a release ready for 8.3 in fact :-(
I'm surprised this hasn't been noticed before, the change was made back
in March. Are you sure there's more queries like that that need to be
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings