SQL command bug

[Timmehhh]

is it working beta 11?

[Timmehhh]

Still not working, when do you expect to fix this?

Regards,
Tim

[bugsbunny]

You can work around this:

Login using pgadmin3 using the postgres account. (Or else login in with the existing account and create a new, temporary, superuser account with full abilities).

Go down to the Login Roles section and select the Timmehhh role. Right click and choose properties. Modify the name to all lower case (you shouldn't be logged in to the account that you're modifying).

Next go to the database itself, select it and right click, choose properties, and change the owner to the new, modified, name. You'll also need to go and change all the tables. It's probably easier to script this part but you can easily go through all the tables in the public schema and change the owner (if there's no current owner leave it alone).

Once done and verified you can go and delete the new,temporary, account you created. Or leave it for future emergency maintenance issues.

[bugsbunny]

You can work around this:

Login using pgadmin3 using the postgres account. (Or else login in with the existing account and create a new, temporary, superuser account with full abilities).

Go down to the Login Roles section and select the Timmehhh role. Right click and choose properties. Modify the name to all lower case (you shouldn't be logged in to the account that you're modifying).
EDIT: When you do this you also have to re-enter the password otherwise when it modifies the entry you'll lose the associated password.

Next go to the database itself, select it and right click, choose properties, and change the owner to the new, modified, name. You'll also need to go and change all the tables. It's probably easier to script this part but you can easily go through all the tables in the public schema and change the owner (if there's no current owner leave it alone).

Once done and verified you can go and delete the new,temporary, account you created. Or leave it for future emergency maintenance issues.

[Timmehhh]

Thanks for the help !
I have created a new superuseraccount. I tried to log out the "Timmehhh" account but I couldn't now I can't get in my database at all. What to do?
http://i29.tinypic.com/2rynd51.png

[Timmehhh]

Can anyone help me? I have lost my entire pokerdatabase this way, I need it back

[zophio]

HI,

Facing the same problem. Hope this will be fixed soon as this seems essential to even open PT3 database. We need this bug fixed to even open PT3.

Best regards,

Thomas

[bugsbunny]

Thanks for the help !
I have created a new superuseraccount. I tried to log out the "Timmehhh" account but I couldn't now I can't get in my database at all. What to do?
http://i29.tinypic.com/2rynd51.png

1) You should be able to get in via pgadmin using the new superuser account.
2) If you already modified the old Timmehhh account and made it lower case then the problem is simply (based on the message in the image) that you're now trying to login with the old user name and you have to change it and log in with all lower case. This would apply to anyplace that you're using that name.

If you didn't modify the Timemehhh account in any way then you should still be able to get in, since you didn't change anything (which means that you did change something).

[Timmehhh]

I did something I accidently deactivated the Timmehhh role. And now I can't get in the database to activate it again.

[Timmehhh]

I did something I accidently deactivated the Timmehhh role. And now I can't get in the database to activate it again.

Also see this thread.
viewtopic.php?f=17&t=4465&start=10