Re: Per-database/schema settings

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Per-database/schema settings
Date: 2000-07-07 13:40:20
Message-ID: 3965DDC4.CBBA8074@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> This solution can forever stop all discussion about styles that PG
> must/can support.

This is one thing I'm *not* certain about. The problems with a fully
general, templated formatting function for the backend include

1) It is easy to make a date/time template which *cannot* be used to
read data back in. So, for example, pg_dump could be fundamentally
broken just be this setting. Currently, input and output are always
compatible (more or less ;)

2) There may be a performance hit to *always* use a fully general
template for formatting.

3) If the template is used for output, it should probably be used for
input (to minimize the possibility of (1)). But then we would be able to
accept fewer date/time variations than we do now.

- Thomas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2000-07-07 14:05:21 Re: DateStyle (was Re: Per-database/schema settings)
Previous Message Karel Zak 2000-07-07 13:33:50 Re: DateStyle (was Re: Per-database/schema settings)