| 48 | } |
| 49 | |
| 50 | int |
| 51 | main(int argc, char **argv) |
| 52 | { |
| 53 | const char *conninfo; |
| 54 | PGconn *conn; |
| 55 | PGresult *res; |
| 56 | PGnotify *notify; |
| 57 | int nnotifies; |
| 58 | |
| 59 | /* |
| 60 | * If the user supplies a parameter on the command line, use it as the |
| 61 | * conninfo string; otherwise default to setting dbname=postgres and using |
| 62 | * environment variables or defaults for all other connection parameters. |
| 63 | */ |
| 64 | if (argc > 1) |
| 65 | conninfo = argv[1]; |
| 66 | else |
| 67 | conninfo = "dbname = postgres"; |
| 68 | |
| 69 | /* Make a connection to the database */ |
| 70 | conn = PQconnectdb(conninfo); |
| 71 | |
| 72 | /* Check to see that the backend connection was successfully made */ |
| 73 | if (PQstatus(conn) != CONNECTION_OK) |
| 74 | { |
| 75 | fprintf(stderr, "%s", PQerrorMessage(conn)); |
| 76 | exit_nicely(conn); |
| 77 | } |
| 78 | |
| 79 | /* Set always-secure search path, so malicious users can't take control. */ |
| 80 | res = PQexec(conn, |
| 81 | "SELECT pg_catalog.set_config('search_path', '', false)"); |
| 82 | if (PQresultStatus(res) != PGRES_TUPLES_OK) |
| 83 | { |
| 84 | fprintf(stderr, "SET failed: %s", PQerrorMessage(conn)); |
| 85 | PQclear(res); |
| 86 | exit_nicely(conn); |
| 87 | } |
| 88 | |
| 89 | /* |
| 90 | * Should PQclear PGresult whenever it is no longer needed to avoid memory |
| 91 | * leaks |
| 92 | */ |
| 93 | PQclear(res); |
| 94 | |
| 95 | /* |
| 96 | * Issue LISTEN command to enable notifications from the rule's NOTIFY. |
| 97 | */ |
| 98 | res = PQexec(conn, "LISTEN TBL2"); |
| 99 | if (PQresultStatus(res) != PGRES_COMMAND_OK) |
| 100 | { |
| 101 | fprintf(stderr, "LISTEN command failed: %s", PQerrorMessage(conn)); |
| 102 | PQclear(res); |
| 103 | exit_nicely(conn); |
| 104 | } |
| 105 | PQclear(res); |
| 106 | |
| 107 | /* Quit after four notifies are received. */ |
nothing calls this directly
no test coverage detected