Re: [HACKERS] Date/time types: big changeu - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] Date/time types: big changeu
Date
Msg-id Pine.GSO.4.02A.10002181524230.4777-100000@Krokodil.DoCS.UU.SE
Whole thread Raw
In response to Re: [HACKERS] Date/time types: big changeu  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
Responses Re: [HACKERS] Date/time types: big changeu
List pgsql-hackers
On Thu, 17 Feb 2000, Thomas Lockhart wrote:

> However, istm that we could/should have more "default settings"
> traveling in the pg_database table. We've got the encoding, which if
> set for template1 will be set for every db. We've got the database
> location, which can point to an alternate location.

I don't think this should be a per database setting. Why not use an
environment variable PGDATESTYLE for it. That's easy enough for now.
Before we throw all kinds of per database defaults around, I'd like to see
some sort of a concept where exactly a "database" stands versus "schema",
etc. What happens if one day queries across databases are allowed?

> For v7.1, I'm hoping to work with Tatsuo and others to get closer to
> the general character sets and collation sequences allowed by SQL92.

Excellent.

-- 
Peter Eisentraut                  Sernanders vaeg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] psql and Control-C
Next
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] Date/time types: big change