Creating serial ID on Windows.

Поиск
Список
Период
Сортировка
От Ardian Xharra (Boxxo)
Тема Creating serial ID on Windows.
Дата
Msg-id 013501c651b0$0b2a66e0$6a01a8c0@BOXXO.ARDIAN
обсуждение исходный текст
Ответы Re: Creating serial ID on Windows.  (Chris <dmagick@gmail.com>)
Список pgsql-general
I'm having some troubles restoring a database on Windows and I found this difference between PostgreSQL running on Linux and Windows.
When I create a table like this:
CREATE TABLE fee_payment1(id_fee_payment1 serial NOT NULL) WITH OIDS;
On Linux platform it will be:
CREATE TABLE fee_payment1 (  id_fee_payment1 serial NOT NULL) WITH OIDS;
And on Windows platform is:
CREATE TABLE fee_payment1
(  id_fee_payment1 int4 NOT NULL DEFAULT nextval('fee_payment1_id_fee_payment1_seq'::regclass) ) WITH OIDS;
So, I would like to know if this would have an impact throught restoring database.

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

Предыдущее
От: Tony Caduto
Дата:
Сообщение: ACL question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bug? was: Re: ERROR: could not convert UTF8 character to ISO8859-1