diff options
Diffstat (limited to 'httemplate/docs/postgresql.html')
| -rwxr-xr-x | httemplate/docs/postgresql.html | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/httemplate/docs/postgresql.html b/httemplate/docs/postgresql.html new file mode 100755 index 000000000..151081176 --- /dev/null +++ b/httemplate/docs/postgresql.html @@ -0,0 +1,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> + |