[ZOPE] ZBabel translation to Postgres

Andrew Kenneth Milton akm@mail.theinternet.com.au
Fri, 5 Jan 2001 19:09:14 +1000


+-------[ Olaf Zanger ]----------------------
| hi Andrew and others,
| 
| > I get errors:
| > when i first want to view a page with the <dtml-babel src=uk dst=de>
| > test</dtml-babel>
| > 
| > pg.error
| > error value: error: attribute 'phrases_phrase_id_seq' not found
| 
| i changed the column name of the id from "phrase_id" to "id" and get
| still the same error message as above. 
| so i figured that my bug is not in my changes but somewhere in the
| python code. 

you need to make sure you create a table with a SERIAL type, which
automatically create phrases_phrase_id_seq table (which is why it should
be called phrase_id in your case).

These are normally created for you, but, if you drop the table, it
doesn't automatically drop the sequence table. You might have to drop
the table and the sequence and re-create your table so you get the
correct table setup. Postgres can be a complete pain at times.

-- 
Totally Holistic Enterprises Internet|  P:+61 7 3870 0066   | Andrew Milton
The Internet (Aust) Pty Ltd          |  F:+61 7 3870 4477   | 
ACN: 082 081 472 ABN: 83 082 081 472 |  M:+61 416 022 411   | Carpe Daemon
PO Box 837 Indooroopilly QLD 4068    |akm@theinternet.com.au|