projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
global duplicate checking on svc_pbx.id, RT#9967
[freeside.git]
/
bin
/
pg-readonly
diff --git
a/bin/pg-readonly
b/bin/pg-readonly
index
4f6d7c3
..
ad69fbd
100644
(file)
--- a/
bin/pg-readonly
+++ b/
bin/pg-readonly
@@
-17,6
+17,8
@@
my $dbh = adminsuidsetup $user;
foreach my $table ( dbdef->tables ) {
$dbh->do("GRANT SELECT ON $table TO $rouser");
$dbh->commit();
foreach my $table ( dbdef->tables ) {
$dbh->do("GRANT SELECT ON $table TO $rouser");
$dbh->commit();
- $dbh->do("GRANT SELECT ON ${table}_seq TO $rouser");
- $dbh->commit();
+ if ( my $pkey = dbdef->table($table)->primary_key ) {
+ $dbh->do("GRANT SELECT ON ${table}_${pkey}_seq TO $rouser");
+ $dbh->commit();
+ }
}
}