Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column
Дата
Msg-id 87lgf7l6sj.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identitycolumn  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column
Список pgsql-bugs
>>>>> "Michael" == Michael Paquier <michael@paquier.xyz> writes:

 > On Sat, Mar 03, 2018 at 07:55:41PM +0000, Andrew Gierth wrote:
 >> sequence_options thinks it can put all the sequence parameters
 >> through makeInteger and have them come out intact.

 Michael> Yeah, on 32b machines "long" is 4 bytes...

And on 64-bit Windows, too.

 Michael> Perhaps it would be the occasion to introduce a T_Integer64
 Michael> type for Value which gets stored as a string? And as far as I
 Michael> can see defGetInt64 is only used by sequences.

The slightly misnamed T_Float is what's currently used for Value nodes
which contain numeric values as strings. So there'd be no point in a new
type tag if you're still going to store the value as a string.

-- 
Andrew (irc:RhodiumToad)


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identitycolumn
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column