Hi, while trying to use SAPDB as OTRS database I ran into some problems: If you use VARCHAR without value, how long can it be? SAPDB only knows about VARCHAR with a defined value, otherwise its length is 1. The other problem is: CREATE TABLE session ( id serial, session_id VARCHAR (120) NOT NULL, value VARCHAR (1000) NOT NULL, PRIMARY KEY(id), UNIQUE (session_id) ) the name "value" is a reserved identifier in SAPDB. So would it be possible to change this sometime? CU, Wolfgang
Hi Wolfgang, On Mon, Feb 17, 2003 at 12:40:39PM +0100, Wolfgang Rosenauer wrote:
while trying to use SAPDB as OTRS database I ran into some problems:
If you use VARCHAR without value, how long can it be? SAPDB only knows about VARCHAR with a defined value, otherwise its length is 1.
This is special for PostgrSQL. "varchar" (without value) is the same as "text" and "text" is "variable unlimited length". See ( http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=datatype-cha... )
The other problem is: CREATE TABLE session [...] the name "value" is a reserved identifier in SAPDB. So would it be possible to change this sometime?
Yes it would be possible. But for testing drop this table. This table is just used for the database session backend (which isn't default). The IPC (RAM) database session backend is default. -=> Then the "session" table isn't in use.
Wolfgang
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Noch 209 Tage bis zum Gäubodenvolksfest! ;-)
participants (2)
-
Martin Edenhofer -
Wolfgang Rosenauer