===========================================================
.___ __ __
_________________ __ __ __| _/|__|/ |_
/ ___\_` __ \__ \ | | \/ __ | | \\_ __\
/ /_/ > | \// __ \| | / /_/ | | || |
\___ /|__| (____ /____/\____ | |__||__|
/_____/ \/ \/
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);