bootstrap table with TimestampTz type

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 <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

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>: