2
* this file tests all sorts of connecting to one single database.
10
/* do not include regression.h */
15
exec sql begin declare section;
18
char *user="connectuser";
19
exec sql end declare section;
23
exec sql connect to connectdb as main;
24
exec sql alter user connectuser ENCRYPTED PASSWORD 'connectpw';
25
exec sql disconnect; /* <-- "main" not specified */
27
strcpy(db, "connectdb");
29
exec sql connect to :db as :id;
30
exec sql disconnect :id;
32
exec sql connect to connectdb as main;
33
exec sql disconnect main;
35
exec sql connect to "connectdb" as main;
36
exec sql disconnect main;
38
exec sql connect to 'connectdb' as main;
39
exec sql disconnect main;
41
exec sql connect to as main user connectdb;
42
exec sql disconnect main;
44
exec sql connect to connectdb as main user connectuser/connectdb;
45
exec sql disconnect main;
47
exec sql connect to unix:postgresql://localhost/connectdb as main user connectuser;
48
exec sql disconnect main;
50
exec sql connect to "unix:postgresql://localhost/connectdb" as main user connectuser;
51
exec sql disconnect main;
53
exec sql connect to 'unix:postgresql://localhost/connectdb' as main user :user;
54
exec sql disconnect main;
56
exec sql connect to "unix:postgresql://200.46.204.71/connectdb" as main user connectuser;
57
exec sql disconnect main;
59
exec sql connect to unix:postgresql://localhost/ as main user connectdb;
60
exec sql disconnect main;
63
exec sql connect to connectdb as main;
64
exec sql connect to connectdb as main;
65
exec sql disconnect main;
68
exec sql disconnect nonexistant;