Re: [HACKERS] 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 Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] bootstrap table with TimestampTz type
2009/5/20 Alvaro Herrera alvhe...@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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] bootstrap table with TimestampTz type
Alvaro Herrera alvhe...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] bootstrap table with TimestampTz type
2009/5/20 Tom Lane t...@sss.pgh.pa.us: Alvaro Herrera alvhe...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] bootstrap table with TimestampTz type
Tom Lane escribió: Alvaro Herrera alvhe...@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 Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] bootstrap table with TimestampTz type
so solution is simple as two lines to genbki.sh - there is similar jobs - NameData = name, ... regards Pavel Stehule 2009/5/20 Alvaro Herrera alvhe...@commandprompt.com: Tom Lane escribió: Alvaro Herrera alvhe...@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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers