Ron Peterson wrote: > Single quotes appear to behave > differently in diffent contexts. > > CREATE USER > :v_dbadmin > WITH PASSWORD > ':v_dbpass';
This sets your password to ":v_dbpass", which is probably not what you wanted. Your next message contains the correct solution: include the quotes in the variable value. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
