Parent Directory | Revision Log | Patch
revision 153 by dpavlin, Mon Oct 10 10:25:37 2005 UTC | revision 154 by dpavlin, Mon Oct 10 12:07:13 2005 UTC | |
---|---|---|
# | Line 78 EOF | Line 78 EOF |
78 | # link backups with archive | # link backups with archive |
79 | my $sth = $dbh->prepare(q{ | my $sth = $dbh->prepare(q{ |
80 | INSERT INTO archive_backup ( | INSERT INTO archive_backup ( |
81 | archive_id, backup_id, status | archive_id, backup_id |
82 | ) VALUES ( | ) VALUES ( |
83 | (SELECT last_value FROM archive_id_seq), ?, ? | (SELECT last_value FROM archive_id_seq), ? |
84 | ) | ) |
85 | }); | }); |
86 | ||
87 | $sth->execute($backup_id, 'ok'); | $sth->execute($backup_id); |
88 | ||
89 | $dbh->commit(); | $dbh->commit(); |
90 |
|
ViewVC Help | |
Powered by ViewVC 1.1.26 |