Re: postgresql system column errors

Поиск
Список
Период
Сортировка
От Mark Gibson
Тема Re: postgresql system column errors
Дата
Msg-id 4030CB90.6070204@cromwell.co.uk
обсуждение исходный текст
Ответ на postgresql system column errors  (Ashish Mahabal <aam@astro.caltech.edu>)
Ответы PGSQL C API()  (Karam Chand <karam_chand03@yahoo.com>)
Re: postgresql system column errors  (Ashish Mahabal <aam@astro.caltech.edu>)
Список pgsql-general
Ashish Mahabal wrote:

>Hello Hiroshi,
>
>When I try to use the column name xmin in one of my tables I get
>ERROR:  column name "xmin" conflicts with a system column name
>
>You seem to have been affected by these errors in the past too. Had you
>found a solution?
>
>Anybody else have any solutions?
>
>

The only thing you can do is change your column name.

The manual tells you about the system columns here:
http://www.postgresql.org/docs/7.4/static/ddl-system-columns.html

--
Mark Gibson <gibsonm |AT| cromwell |DOT| co |DOT| uk>
Web Developer & Database Admin
Cromwell Tools Ltd.
Leicester, England.


В списке pgsql-general по дате отправления:

Предыдущее
От: Robert Creager
Дата:
Сообщение: Re: Dazed and Confused
Следующее
От: Fischer Ulrich
Дата:
Сообщение: tsearch2: restoring problem