Thread: bootstrap table with TimestampTz type
Hello I have a problem with creating bootstrap table with TimestampTz type. Initdb finish with bug unrecognized type "TimestampTz", because pg_type knows "timestamptz". But I can't to use timestamptz, because the identifier is "TimestampTz". What is good solution? Thank You Pavel
Pavel Stehule escribió: > Hello > > I have a problem with creating bootstrap table with TimestampTz type. > > Initdb finish with bug unrecognized type "TimestampTz", because > pg_type knows "timestamptz". But I can't to use timestamptz, because > the identifier is "TimestampTz". > > What is good solution? See pg_authid.h ... is that not enough? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
2009/5/20 Alvaro Herrera <alvherre@commandprompt.com>: > Pavel Stehule escribió: >> Hello >> >> I have a problem with creating bootstrap table with TimestampTz type. >> >> Initdb finish with bug unrecognized type "TimestampTz", because >> pg_type knows "timestamptz". But I can't to use timestamptz, because >> the identifier is "TimestampTz". >> >> What is good solution? > > See pg_authid.h ... is that not enough? thank you, it'is it regards Pavel > > -- > Alvaro Herrera http://www.CommandPrompt.com/ > The PostgreSQL Company - Command Prompt, Inc. >
Alvaro Herrera <alvherre@commandprompt.com> writes: > Pavel Stehule escribi�: >> Initdb finish with bug unrecognized type "TimestampTz", because >> pg_type knows "timestamptz". But I can't to use timestamptz, because >> the identifier is "TimestampTz". > See pg_authid.h ... is that not enough? That was okay for a one-off hack, but if we're going to have timestamptz in multiple catalogs, it might be nice to have a cleaner solution. Should we make it work like aclitem does (cf genbki.h)? regards, tom lane
2009/5/20 Tom Lane <tgl@sss.pgh.pa.us>: > Alvaro Herrera <alvherre@commandprompt.com> writes: >> Pavel Stehule escribió: >>> Initdb finish with bug unrecognized type "TimestampTz", because >>> pg_type knows "timestamptz". But I can't to use timestamptz, because >>> the identifier is "TimestampTz". > >> See pg_authid.h ... is that not enough? > > That was okay for a one-off hack, but if we're going to have timestamptz > in multiple catalogs, it might be nice to have a cleaner solution. > Should we make it work like aclitem does (cf genbki.h)? > I found, so it was bad shot - In my case is timestamp field not null I'll look on genbki thank you Pavel > regards, tom lane >
Tom Lane escribió: > Alvaro Herrera <alvherre@commandprompt.com> writes: > > Pavel Stehule escribi�: > >> Initdb finish with bug unrecognized type "TimestampTz", because > >> pg_type knows "timestamptz". But I can't to use timestamptz, because > >> the identifier is "TimestampTz". > > > See pg_authid.h ... is that not enough? > > That was okay for a one-off hack, but if we're going to have timestamptz > in multiple catalogs, it might be nice to have a cleaner solution. > Should we make it work like aclitem does (cf genbki.h)? Yeah, eventually we're going to need timestamps in autovacuum scheduler catalogs too, so if it's solved for good, all the better. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
so solution is simple as two lines to genbki.sh - there is similar jobs - NameData => name, ... regards Pavel Stehule 2009/5/20 Alvaro Herrera <alvherre@commandprompt.com>: > Tom Lane escribió: >> Alvaro Herrera <alvherre@commandprompt.com> writes: >> > Pavel Stehule escribió: >> >> Initdb finish with bug unrecognized type "TimestampTz", because >> >> pg_type knows "timestamptz". But I can't to use timestamptz, because >> >> the identifier is "TimestampTz". >> >> > See pg_authid.h ... is that not enough? >> >> That was okay for a one-off hack, but if we're going to have timestamptz >> in multiple catalogs, it might be nice to have a cleaner solution. >> Should we make it work like aclitem does (cf genbki.h)? > > Yeah, eventually we're going to need timestamps in autovacuum scheduler > catalogs too, so if it's solved for good, all the better. > > -- > Alvaro Herrera http://www.CommandPrompt.com/ > The PostgreSQL Company - Command Prompt, Inc. >