===========================================================
                                      .___ __  __   
          _________________  __ __  __| _/|__|/  |_ 
         / ___\_` __ \__  \ |  |  \/ __ | | \\_  __\
        / /_/  >  | \// __ \|  |  / /_/ | |  ||  |  
        \___  /|__|  (____  /____/\____ | |__||__|  
       /_____/            \/           \/           
              grep rough audit - static analysis tool
                  v2.8 written by @Wireghoul
=================================[justanotherhacker.com]===
bucardo-5.6.0/t/customcode.exception.bucardotest.pl-148-        # Log the resolution.
bucardo-5.6.0/t/customcode.exception.bucardotest.pl:149:        $info->{message} .= qq{Unique conflict on $relation($expr) for value \`$keep->{ukey}\` resolved by deleting $pk_col \`$lose->{pkey}\` from database $lose->{db} and keeping $pk_col \`$keep->{pkey}\` from database $keep->{db}};
bucardo-5.6.0/t/customcode.exception.bucardotest.pl-150-
##############################################
bucardo-5.6.0/t/BucardoTesting.pm-1198-            ## Kick off all other people
bucardo-5.6.0/t/BucardoTesting.pm:1199:            $SQL = qq{SELECT $pidcol FROM pg_stat_activity WHERE datname = 'bucardo' and $pidcol <> pg_backend_pid()};
bucardo-5.6.0/t/BucardoTesting.pm-1200-            for my $row (@{$dbh->selectall_arrayref($SQL)}) {
##############################################
bucardo-5.6.0/t/BucardoTesting.pm-1206-            $dbh->commit();
bucardo-5.6.0/t/BucardoTesting.pm:1207:        } while ($dbh->selectrow_array(qq{SELECT count(*) FROM pg_stat_activity WHERE datname = 'bucardo' and $pidcol <> pg_backend_pid()}))[0] && $retries--;
bucardo-5.6.0/t/BucardoTesting.pm-1208-        debug(qq{Dropping database bucardo from cluster $clustername});
##############################################
bucardo-5.6.0/t/BucardoTesting.pm-1230-    ## Make some adjustments
bucardo-5.6.0/t/BucardoTesting.pm:1231:    $sth = $dbh->prepare('UPDATE bucardo.bucardo_config SET setting = $2 WHERE name = $1');
bucardo-5.6.0/t/BucardoTesting.pm-1232-    $count = $sth->execute('piddir' => $PIDDIR);
##############################################
bucardo-5.6.0/t/BucardoTesting.pm-1254-    system("date >> log.context");
bucardo-5.6.0/t/BucardoTesting.pm:1255:    system(sprintf "echo '%s' >> log.context", quotemeta($_[0])) if $_[0];
bucardo-5.6.0/t/BucardoTesting.pm-1256-    system("tail -n 100 log.bucardo bucardo_test_database_*/pg.log 2>/dev/null >> log.context");
##############################################
bucardo-5.6.0/t/BucardoTesting.pm-1514-
bucardo-5.6.0/t/BucardoTesting.pm:1515:    system("rm -fr $dirname");
bucardo-5.6.0/t/BucardoTesting.pm-1516-
##############################################
bucardo-5.6.0/scripts/slony_migrator.pl-816-    eval {
bucardo-5.6.0/scripts/slony_migrator.pl:817:        my $SQL = qq{SELECT sub_active FROM $schema.sl_subscribe WHERE sub_receiver = $slave }.
bucardo-5.6.0/scripts/slony_migrator.pl-818-            qq{AND sub_provider = $provider AND sub_set = $slony_set};
##############################################
bucardo-5.6.0/scripts/bucardo_rrd-76-FROM   bucardo.q
bucardo-5.6.0/scripts/bucardo_rrd:77:WHERE  cdate >= '$ARG->{TS}'
bucardo-5.6.0/scripts/bucardo_rrd-78-AND    aborted IS NOT NULL
##############################################
bucardo-5.6.0/scripts/bucardo_rrd-81-FROM   freezer.master_q
bucardo-5.6.0/scripts/bucardo_rrd:82:WHERE  cdate >= '$ARG->{TS}'
bucardo-5.6.0/scripts/bucardo_rrd-83-AND    aborted IS NOT NULL
##############################################
bucardo-5.6.0/scripts/bucardo-report-1029-$SQLSTART
bucardo-5.6.0/scripts/bucardo-report:1030:FROM (SELECT * FROM bucardo.q WHERE targetdb=\$1 UNION ALL SELECT * FROM bucardo.$old_q WHERE targetdb=\$1) q
bucardo-5.6.0/scripts/bucardo-report-1031-${WHERECLAUSE}ORDER BY $OCOL2 $ODIR, 1 ASC, started DESC
##############################################
bucardo-5.6.0/scripts/bucardo-report-1151-    my $earliest = $dbh->selectall_arrayref($SQL)->[0][0];
bucardo-5.6.0/scripts/bucardo-report:1152:    my $oldwhere = " WHERE sync=\$1 AND cdate >= '$earliest'";
bucardo-5.6.0/scripts/bucardo-report-1153-
##############################################
bucardo-5.6.0/scripts/bucardo-report-1157-$SQLSTART
bucardo-5.6.0/scripts/bucardo-report:1158:FROM (SELECT * FROM bucardo.q WHERE sync=\$1 UNION ALL SELECT * FROM bucardo.$old_q $oldwhere) q
bucardo-5.6.0/scripts/bucardo-report-1159-${WHERECLAUSE}ORDER BY $OCOL2 $ODIR, 1 ASC
##############################################
bucardo-5.6.0/scripts/bucardo-report-1163-$SQLSTART
bucardo-5.6.0/scripts/bucardo-report:1164:FROM (SELECT * FROM bucardo.q WHERE sync=\$1 UNION ALL SELECT * FROM bucardo.$old_q $oldwhere) q
bucardo-5.6.0/scripts/bucardo-report-1165-${WHERECLAUSE}ORDER BY $OCOL2 $ODIR, 1 ASC
##############################################
bucardo-5.6.0/scripts/check_bucardo_sync-76-
bucardo-5.6.0/scripts/check_bucardo_sync:77:  system($COM);
bucardo-5.6.0/scripts/check_bucardo_sync-78-
##############################################
bucardo-5.6.0/Bucardo.pm-5513-    if (! exists $table->{"db:$dbname"}{has_indexes}) {
bucardo-5.6.0/Bucardo.pm:5514:        $SQL = qq{SELECT relhasindex FROM pg_class WHERE oid = '$tablename'::regclass};
bucardo-5.6.0/Bucardo.pm-5515-        ## relhasindex is a boolean 't' or 'f', but DBD::Pg will return it as 1 or 0
##############################################
bucardo-5.6.0/Bucardo.pm-5523-    $self->glog("Disabling indexes for $dbname.$tablename", LOG_NORMAL);
bucardo-5.6.0/Bucardo.pm:5524:    $SQL = qq{UPDATE pg_class SET relhasindex = 'f' WHERE oid = '$tablename'::regclass};
bucardo-5.6.0/Bucardo.pm-5525-    $count = $db->{dbh}->do($SQL);
##############################################
bucardo-5.6.0/Bucardo.pm-5567-        ## We set this to 'f' earlier, so flip it back now
bucardo-5.6.0/Bucardo.pm:5568:        $SQL = qq{UPDATE pg_class SET relhasindex = 't' WHERE oid = '$tablename'::regclass};
bucardo-5.6.0/Bucardo.pm-5569-        $count = $db->{dbh}->do($SQL);
##############################################
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-690-$name =~ s/'/''/go;
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema:691:$SQL = "SELECT * FROM bucardo.db WHERE name = '$name'";
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-692-$rv = spi_exec_query($SQL);
##############################################
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1179-(my $safesyncname = $syncname) =~ s/'/''/go;
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema:1180:$SQL = "SELECT * FROM sync WHERE name = '$safesyncname'";
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1181-$rv = spi_exec_query($SQL);
##############################################
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1189-(my $herd = $info->{herd}) =~ s/'/''/go;
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema:1190:$SQL = qq{SELECT 1 FROM herd WHERE name = '$herd'};
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1191-$rv = spi_exec_query($SQL);
##############################################
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1239-        JOIN   db d ON (d.name = m.db)
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema:1240:        WHERE  dbgroup = '$dbs'
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1241-    };
##############################################
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1510-    SELECT * FROM bucardo.bucardo_delta_names
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema:1511:      WHERE sync = $1 
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1512-      ORDER BY tablename
##############################################
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1597-    c.oid FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema:1598:  WHERE nspname = $1 AND relname = $2;
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1599-
##############################################
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1663-  JOIN pg_namespace n ON n.oid = c.relnamespace
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema:1664:  WHERE relname = $1 AND pg_table_is_visible(c.oid);
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1665-}
##############################################
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1671-  JOIN pg_namespace n ON n.oid = c.relnamespace
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema:1672:  WHERE c.oid = $1;
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1673-}
##############################################
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1689-    FROM pg_class c JOIN pg_namespace n ON (n.oid = c.relnamespace)
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema:1690:    WHERE c.oid = $2;
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1691-
##############################################
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1695-    FROM bucardo.bucardo_delta_targets
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema:1696:    WHERE tablename = $2;
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1697-  RAISE DEBUG 'delta_targets rows found for %: %', dtablename, drows;
##############################################
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1783-BEGIN
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema:1784:  PERFORM 1 FROM bucardo.bucardo_delta_names WHERE sync = $1 LIMIT 1;
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1785-  IF NOT FOUND THEN
##############################################
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1789-  FOR myrec IN SELECT DISTINCT tablename, deltaname, trackname
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema:1790:    FROM bucardo.bucardo_delta_names WHERE sync = $1
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-1791-    ORDER BY tablename LOOP
##############################################
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-2450-            $SQL = qq{SELECT trigger_language,trigger_body FROM bucardo_custom_trigger 
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema:2451:              WHERE goat=$tinfo->{id} 
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-2452-              AND status='active' 
##############################################
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-2524-            $SQL = qq{SELECT trigger_language,trigger_body,trigger_level FROM bucardo_custom_trigger
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema:2525:              WHERE goat=$tinfo->{id}
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-2526-              AND status='active'
##############################################
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-2709-    ## Does this herd exist?
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema:2710:    $SQL = qq{SELECT 1 FROM herd WHERE name = '$herd'};
bucardo-5.6.0/.pc/02-schema-config.patch/bucardo.schema-2711-    $rv = spi_exec_query($SQL);
##############################################
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-2169-                $dbh->pg_rollback_to('try_remove_db');
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo:2170:                $dbh->do('DELETE FROM bucardo.goat WHERE db = ' . $dbh->quote($name));
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo:2171:                $dbh->do('DELETE FROM bucardo.dbmap WHERE db = ' . $dbh->quote($name));
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-2172-                ## Try the same query again
##############################################
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-2660-                    $dbh->rollback();
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo:2661:                    $dbh->do('DELETE FROM bucardo.sync WHERE dbs = ' . $dbh->quote($name));
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-2662-                    eval {
##############################################
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-3658-        $SQL = 'INSERT INTO bucardo.herdmap (herd,priority,goat) VALUES (?,?,'
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo:3659:            . qq{ (SELECT id FROM goat WHERE schemaname||'.'||tablename=? AND db=? AND reltype='$reltype'))};
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-3660-
##############################################
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-4237-    my $clause = generate_clause({col => 'name', items => \@nouns});
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo:4238:    my $WHERE = $clause ? "WHERE $clause" : '';
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-4239-    $SQL = "SELECT * FROM bucardo.herd $WHERE ORDER BY name";
##############################################
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-6579-    my $clause = generate_clause({col => 'name', items => \@nouns});
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo:6580:    my $WHERE = $clause ? "WHERE $clause" : '';
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-6581-    $SQL = "SELECT * FROM bucardo.customcode $WHERE ORDER BY name";
##############################################
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-6768-    my $clause = generate_clause({col => 'tablename', items => \@nouns});
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo:6769:    my $WHERE = $clause ? "AND $clause" : '';
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo:6770:    $SQL = "SELECT * FROM bucardo.goat WHERE reltype = 'sequence' $WHERE ORDER BY schemaname, tablename";
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-6771-    $sth = $dbh->prepare($SQL);
##############################################
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-7196-        . q{JOIN pg_catalog.pg_namespace n ON (n.oid = c.relnamespace) }
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo:7197:        . qq{WHERE relkind = '$kind' };
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-7198-
##############################################
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-7229-    ## Grab all current tables or sequences from the goat table.
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo:7230:    $SQL = qq{SELECT schemaname, tablename FROM bucardo.goat WHERE reltype= '$type' AND db = '$db->{name}'};
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-7231-    my %hastable;
##############################################
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-7702-
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo:7703:    my $SQL = qq{SELECT pg_get_constraintdef(oid,true) FROM pg_constraint WHERE conname = '$name'};
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-7704-    my $def = $dbh->selectall_arrayref($SQL)->[0][0];
##############################################
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-8347-        clog "Removed old bucardo_config name: $name";
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo:8348:        upgrade_and_log(qq{DELETE FROM bucardo.bucardo_config WHERE name = '$name'});
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-8349-        $changes++;
##############################################
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-8358-               SET name = '$names->[1]'
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo:8359:             WHERE name = '$names->[0]'
bucardo-5.6.0/.pc/03-interpreter.patch/bucardo-8360-        });
##############################################
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-690-$name =~ s/'/''/go;
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema:691:$SQL = "SELECT * FROM bucardo.db WHERE name = '$name'";
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-692-$rv = spi_exec_query($SQL);
##############################################
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1179-(my $safesyncname = $syncname) =~ s/'/''/go;
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema:1180:$SQL = "SELECT * FROM sync WHERE name = '$safesyncname'";
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1181-$rv = spi_exec_query($SQL);
##############################################
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1189-(my $herd = $info->{herd}) =~ s/'/''/go;
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema:1190:$SQL = qq{SELECT 1 FROM herd WHERE name = '$herd'};
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1191-$rv = spi_exec_query($SQL);
##############################################
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1239-        JOIN   db d ON (d.name = m.db)
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema:1240:        WHERE  dbgroup = '$dbs'
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1241-    };
##############################################
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1510-    SELECT * FROM bucardo.bucardo_delta_names
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema:1511:      WHERE sync = $1 
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1512-      ORDER BY tablename
##############################################
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1597-    c.oid FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema:1598:  WHERE nspname = $1 AND relname = $2;
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1599-
##############################################
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1663-  JOIN pg_namespace n ON n.oid = c.relnamespace
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema:1664:  WHERE relname = $1 AND pg_table_is_visible(c.oid);
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1665-}
##############################################
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1671-  JOIN pg_namespace n ON n.oid = c.relnamespace
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema:1672:  WHERE c.oid = $1;
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1673-}
##############################################
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1689-    FROM pg_class c JOIN pg_namespace n ON (n.oid = c.relnamespace)
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema:1690:    WHERE c.oid = $2;
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1691-
##############################################
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1695-    FROM bucardo.bucardo_delta_targets
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema:1696:    WHERE tablename = $2;
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1697-  RAISE DEBUG 'delta_targets rows found for %: %', dtablename, drows;
##############################################
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1783-BEGIN
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema:1784:  PERFORM 1 FROM bucardo.bucardo_delta_names WHERE sync = $1 LIMIT 1;
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1785-  IF NOT FOUND THEN
##############################################
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1789-  FOR myrec IN SELECT DISTINCT tablename, deltaname, trackname
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema:1790:    FROM bucardo.bucardo_delta_names WHERE sync = $1
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-1791-    ORDER BY tablename LOOP
##############################################
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-2450-            $SQL = qq{SELECT trigger_language,trigger_body FROM bucardo_custom_trigger 
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema:2451:              WHERE goat=$tinfo->{id} 
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-2452-              AND status='active' 
##############################################
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-2524-            $SQL = qq{SELECT trigger_language,trigger_body,trigger_level FROM bucardo_custom_trigger
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema:2525:              WHERE goat=$tinfo->{id}
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-2526-              AND status='active'
##############################################
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-2709-    ## Does this herd exist?
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema:2710:    $SQL = qq{SELECT 1 FROM herd WHERE name = '$herd'};
bucardo-5.6.0/.pc/04-session-authorization.patch/bucardo.schema-2711-    $rv = spi_exec_query($SQL);
##############################################
bucardo-5.6.0/bucardo-2169-                $dbh->pg_rollback_to('try_remove_db');
bucardo-5.6.0/bucardo:2170:                $dbh->do('DELETE FROM bucardo.goat WHERE db = ' . $dbh->quote($name));
bucardo-5.6.0/bucardo:2171:                $dbh->do('DELETE FROM bucardo.dbmap WHERE db = ' . $dbh->quote($name));
bucardo-5.6.0/bucardo-2172-                ## Try the same query again
##############################################
bucardo-5.6.0/bucardo-2660-                    $dbh->rollback();
bucardo-5.6.0/bucardo:2661:                    $dbh->do('DELETE FROM bucardo.sync WHERE dbs = ' . $dbh->quote($name));
bucardo-5.6.0/bucardo-2662-                    eval {
##############################################
bucardo-5.6.0/bucardo-3658-        $SQL = 'INSERT INTO bucardo.herdmap (herd,priority,goat) VALUES (?,?,'
bucardo-5.6.0/bucardo:3659:            . qq{ (SELECT id FROM goat WHERE schemaname||'.'||tablename=? AND db=? AND reltype='$reltype'))};
bucardo-5.6.0/bucardo-3660-
##############################################
bucardo-5.6.0/bucardo-4237-    my $clause = generate_clause({col => 'name', items => \@nouns});
bucardo-5.6.0/bucardo:4238:    my $WHERE = $clause ? "WHERE $clause" : '';
bucardo-5.6.0/bucardo-4239-    $SQL = "SELECT * FROM bucardo.herd $WHERE ORDER BY name";
##############################################
bucardo-5.6.0/bucardo-6579-    my $clause = generate_clause({col => 'name', items => \@nouns});
bucardo-5.6.0/bucardo:6580:    my $WHERE = $clause ? "WHERE $clause" : '';
bucardo-5.6.0/bucardo-6581-    $SQL = "SELECT * FROM bucardo.customcode $WHERE ORDER BY name";
##############################################
bucardo-5.6.0/bucardo-6768-    my $clause = generate_clause({col => 'tablename', items => \@nouns});
bucardo-5.6.0/bucardo:6769:    my $WHERE = $clause ? "AND $clause" : '';
bucardo-5.6.0/bucardo:6770:    $SQL = "SELECT * FROM bucardo.goat WHERE reltype = 'sequence' $WHERE ORDER BY schemaname, tablename";
bucardo-5.6.0/bucardo-6771-    $sth = $dbh->prepare($SQL);
##############################################
bucardo-5.6.0/bucardo-7196-        . q{JOIN pg_catalog.pg_namespace n ON (n.oid = c.relnamespace) }
bucardo-5.6.0/bucardo:7197:        . qq{WHERE relkind = '$kind' };
bucardo-5.6.0/bucardo-7198-
##############################################
bucardo-5.6.0/bucardo-7229-    ## Grab all current tables or sequences from the goat table.
bucardo-5.6.0/bucardo:7230:    $SQL = qq{SELECT schemaname, tablename FROM bucardo.goat WHERE reltype= '$type' AND db = '$db->{name}'};
bucardo-5.6.0/bucardo-7231-    my %hastable;
##############################################
bucardo-5.6.0/bucardo-7702-
bucardo-5.6.0/bucardo:7703:    my $SQL = qq{SELECT pg_get_constraintdef(oid,true) FROM pg_constraint WHERE conname = '$name'};
bucardo-5.6.0/bucardo-7704-    my $def = $dbh->selectall_arrayref($SQL)->[0][0];
##############################################
bucardo-5.6.0/bucardo-8347-        clog "Removed old bucardo_config name: $name";
bucardo-5.6.0/bucardo:8348:        upgrade_and_log(qq{DELETE FROM bucardo.bucardo_config WHERE name = '$name'});
bucardo-5.6.0/bucardo-8349-        $changes++;
##############################################
bucardo-5.6.0/bucardo-8358-               SET name = '$names->[1]'
bucardo-5.6.0/bucardo:8359:             WHERE name = '$names->[0]'
bucardo-5.6.0/bucardo-8360-        });
##############################################
bucardo-5.6.0/bucardo.schema-691-$name =~ s/'/''/go;
bucardo-5.6.0/bucardo.schema:692:$SQL = "SELECT * FROM bucardo.db WHERE name = '$name'";
bucardo-5.6.0/bucardo.schema-693-$rv = spi_exec_query($SQL);
##############################################
bucardo-5.6.0/bucardo.schema-1180-(my $safesyncname = $syncname) =~ s/'/''/go;
bucardo-5.6.0/bucardo.schema:1181:$SQL = "SELECT * FROM sync WHERE name = '$safesyncname'";
bucardo-5.6.0/bucardo.schema-1182-$rv = spi_exec_query($SQL);
##############################################
bucardo-5.6.0/bucardo.schema-1190-(my $herd = $info->{herd}) =~ s/'/''/go;
bucardo-5.6.0/bucardo.schema:1191:$SQL = qq{SELECT 1 FROM herd WHERE name = '$herd'};
bucardo-5.6.0/bucardo.schema-1192-$rv = spi_exec_query($SQL);
##############################################
bucardo-5.6.0/bucardo.schema-1240-        JOIN   db d ON (d.name = m.db)
bucardo-5.6.0/bucardo.schema:1241:        WHERE  dbgroup = '$dbs'
bucardo-5.6.0/bucardo.schema-1242-    };
##############################################
bucardo-5.6.0/bucardo.schema-1511-    SELECT * FROM bucardo.bucardo_delta_names
bucardo-5.6.0/bucardo.schema:1512:      WHERE sync = $1 
bucardo-5.6.0/bucardo.schema-1513-      ORDER BY tablename
##############################################
bucardo-5.6.0/bucardo.schema-1598-    c.oid FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace
bucardo-5.6.0/bucardo.schema:1599:  WHERE nspname = $1 AND relname = $2;
bucardo-5.6.0/bucardo.schema-1600-
##############################################
bucardo-5.6.0/bucardo.schema-1664-  JOIN pg_namespace n ON n.oid = c.relnamespace
bucardo-5.6.0/bucardo.schema:1665:  WHERE relname = $1 AND pg_table_is_visible(c.oid);
bucardo-5.6.0/bucardo.schema-1666-}
##############################################
bucardo-5.6.0/bucardo.schema-1672-  JOIN pg_namespace n ON n.oid = c.relnamespace
bucardo-5.6.0/bucardo.schema:1673:  WHERE c.oid = $1;
bucardo-5.6.0/bucardo.schema-1674-}
##############################################
bucardo-5.6.0/bucardo.schema-1690-    FROM pg_class c JOIN pg_namespace n ON (n.oid = c.relnamespace)
bucardo-5.6.0/bucardo.schema:1691:    WHERE c.oid = $2;
bucardo-5.6.0/bucardo.schema-1692-
##############################################
bucardo-5.6.0/bucardo.schema-1696-    FROM bucardo.bucardo_delta_targets
bucardo-5.6.0/bucardo.schema:1697:    WHERE tablename = $2;
bucardo-5.6.0/bucardo.schema-1698-  RAISE DEBUG 'delta_targets rows found for %: %', dtablename, drows;
##############################################
bucardo-5.6.0/bucardo.schema-1784-BEGIN
bucardo-5.6.0/bucardo.schema:1785:  PERFORM 1 FROM bucardo.bucardo_delta_names WHERE sync = $1 LIMIT 1;
bucardo-5.6.0/bucardo.schema-1786-  IF NOT FOUND THEN
##############################################
bucardo-5.6.0/bucardo.schema-1790-  FOR myrec IN SELECT DISTINCT tablename, deltaname, trackname
bucardo-5.6.0/bucardo.schema:1791:    FROM bucardo.bucardo_delta_names WHERE sync = $1
bucardo-5.6.0/bucardo.schema-1792-    ORDER BY tablename LOOP
##############################################
bucardo-5.6.0/bucardo.schema-2451-            $SQL = qq{SELECT trigger_language,trigger_body FROM bucardo_custom_trigger 
bucardo-5.6.0/bucardo.schema:2452:              WHERE goat=$tinfo->{id} 
bucardo-5.6.0/bucardo.schema-2453-              AND status='active' 
##############################################
bucardo-5.6.0/bucardo.schema-2525-            $SQL = qq{SELECT trigger_language,trigger_body,trigger_level FROM bucardo_custom_trigger
bucardo-5.6.0/bucardo.schema:2526:              WHERE goat=$tinfo->{id}
bucardo-5.6.0/bucardo.schema-2527-              AND status='active'
##############################################
bucardo-5.6.0/bucardo.schema-2710-    ## Does this herd exist?
bucardo-5.6.0/bucardo.schema:2711:    $SQL = qq{SELECT 1 FROM herd WHERE name = '$herd'};
bucardo-5.6.0/bucardo.schema-2712-    $rv = spi_exec_query($SQL);