#include <stdlib.h>
#include <string.h>
#include <stdio.h>
#include <unistd.h>


int
main(void)
{
    EXEC SQL CONNECT TO postgres USER postgres;

    EXEC SQL BEGIN;
    EXEC SQL CREATE SCHEMA IF NOT EXISTS hollywood;
    EXEC SQL CREATE SCHEMA IF NOT EXISTS hollywood2 AUTHORIZATION postgres;
    EXEC SQL CREATE RECURSIVE VIEW view_test(c0) AS SELECT c0 from test;
    EXEC SQL CREATE OR REPLACE RECURSIVE VIEW view_test(c0) AS SELECT c0 from test;
    EXEC SQL CREATE AGGREGATE sumdouble (float8) ( stype = float8, sfunc = float8pl, mstype = float8, msfunc = float8pl, minvfunc = float8mi);
    EXEC SQL ROLLBACK;

    EXEC SQL DISCONNECT ALL;
    return 0;
}