blob: 151081176a557aac0a1c3774171ff5f68b7792d0 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
<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>
<p>
( I've personally been unable to get PostgreSQL working with larger column names,
though the process does look like it should be straightforward. If anyone is
interested in assisting me with this, please get in touch.
-Ivan <a href="mailto:ivan@sisd.com"><ivan@sisd.com</a>> )
</p>
</body>
|
