summaryrefslogtreecommitdiff
path: root/httemplate/docs/postgresql.html
blob: 1356739d6027ea00452f1fc779d5abbaa93762f1 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<head>
  <title>PostgreSQL notes</title>
</head>
<body>
  <h1>PostgreSQL notes</h1>
<p>
PostgreSQL ships by default with a maximum of 31 character column names.  If
you use arbitrary RADIUS attributes longer than 9 characters, fs-setup will
fail with `duplicate column' errors (in the part_svc table).
Solution: use a different database
engine, or recompile PostgreSQL with 64 character column names.
</p>
Future versions of Freeside will keep all column names under 31 characters to
avoid this problem.
</p>
</body>