Re: [HACKERS] default locale considered harmful? (was Re: [GENERAL]

2003-06-02 Thread Peter Eisentraut
Tom Lane writes: I think that a more general solution would be the ability to select a locale (and hence a sort order) per-column, as the SQL spec envisions. It is a general solution, but not for this problem. The problem was to make all locales equally suitable for certain optimizations, not

Re: [HACKERS] Question about simple function folding optimization

2003-06-02 Thread Peter Eisentraut
Tom Lane writes: (the documentation build at developer.postgresql.org doesn't seem to have updated since before the server move :-() The program called onsgmls (or maybe nsgmls) is missing. Marc, can you please install it? It should be in a package called opensp. -- Peter Eisentraut

Re: [HACKERS] Postgres config file: autocommit = off

2003-06-02 Thread Rasmus Resen Amossen
We have been there, done that, and decided it was a bad idea. I suggest you do a little reading in the mail list archives. I have searched the lists archives for the words commit, autocommit and transaction but couldn't find any discussion on wheter to give a database administrator the option

[HACKERS] Table-driven SHOW (was Re: Are we losing momentum?)

2003-06-02 Thread Tom Lane
[ moving this thread to a more appropriate place ] Sean Chittenden [EMAIL PROTECTED] writes: It would also be interesting to combine this with Rod's idea of driving describe-type queries by table instead of hardwired code. Imagine that the backend's show foo command first looks for foo as a

Re: [HACKERS] default locale considered harmful? (was Re: [GENERAL]

2003-06-02 Thread Peter Eisentraut
Bruce Momjian writes: Our default indexes will be able to do =, , , ORDER BY, and the special index will be able to do LIKE, ORDER BY, and maybe equals. Do I have that correct? The default operator class supports comparisons (=, , , etc.) and ORDER BY based on those operators. The other

Re: [HACKERS] compile error on cvs tip

2003-06-02 Thread Peter Eisentraut
Sean Chittenden writes: Keep krb4 in the tree for 7.4, but before 7.4 gets released, the documentation and release notes need to state that krb4 has been depreciated and that it will be removed before 7.5. I'll add submit a patch for the updated verbiage in a bit. -sc I object to treating

[HACKERS] initdb problems handling super username with spaces.

2003-06-02 Thread Francisco Figueiredo Jr.
Hi all, I just get postgresql from cvs and could compile perfectly on cygwin!! Great work guys!!! But when I run the initdb script, it fails with the following message: The database cluster will be initialized with locale C. Fixing permissions on existing directory /var/pgsqlcvs/... ok creating

Re: [HACKERS] default locale considered harmful? (was Re: [GENERAL]

2003-06-02 Thread Peter Eisentraut
Tom Lane writes: Are there any locales that claim that not-physically-identical strings are equal? In Unicode there are plenty such combinations. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our

Re: [HACKERS] XML and postgres

2003-06-02 Thread John Gray
On Fri, 2003-05-30 at 17:06, Oleg Bartunov wrote: Hello, Is there interest to storing and indexed access methods for xml in postgresql ? While I don't use xml in my applications but I see Yes. But my GiST skills were never up to it! possible directions to develop contrib module with

Re: [HACKERS] Table-driven SHOW (was Re: Are we losing momentum?)

2003-06-02 Thread Rod Taylor
One thing that is doable with psql's current hard-wired approach, but doesn't seem easy to do with this solution, is automatic localization of strings such as column headings. Rod had looked at that a little in his trial patch to convert psql's \d stuff to table-driven form, but AFAIR he

[HACKERS] pg_database encoding again

2003-06-02 Thread Christopher Kings-Lynne
Hi Guys, I really need a solution to this one :( What is the encoding of the database names in the pg_database table? As far as I can tell, each row is saved in the encoding of the database from which it is created? In my application, the actual names change from gobbledygook to proper

Re: [HACKERS] default locale considered harmful? (was Re: [GENERAL]

2003-06-02 Thread Bruce Momjian
Peter Eisentraut wrote: Bruce Momjian writes: Our default indexes will be able to do =, , , ORDER BY, and the special index will be able to do LIKE, ORDER BY, and maybe equals. Do I have that correct? The default operator class supports comparisons (=, , , etc.) and ORDER BY based on

Re: [HACKERS] compile error on cvs tip

2003-06-02 Thread Bruce Momjian
Peter Eisentraut wrote: Sean Chittenden writes: Keep krb4 in the tree for 7.4, but before 7.4 gets released, the documentation and release notes need to state that krb4 has been depreciated and that it will be removed before 7.5. I'll add submit a patch for the updated verbiage in a

Re: [HACKERS] Why are triggers semi-deferred?

2003-06-02 Thread Bruce Momjian
I am trying to figure out whether there is a TODO item in this thread. The basis of the discussion appeared to be whether we are honoring the spec by executing before/after statement/row/constraint triggers properly, and if we are not, is it desirable/significant if we break the spec. Which

Re: [HACKERS] pg_database encoding again

2003-06-02 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] writes: What is the encoding of the database names in the pg_database table? As far as I can tell, each row is saved in the encoding of the database from which it is created? That sounds about right. If you're using databases of different encodings

Re: [HACKERS] Dev FAQ emacs settings

2003-06-02 Thread Bruce Momjian
FAQ_DEV updated. Thanks. --- Andrew Dunstan wrote: The Developer FAQ is slightly awry for emacs settings, or at least it was for my setup. Here's what I ended up getting to work ;;- (c-add-style

Re: [HACKERS] pg_database encoding again

2003-06-02 Thread Christopher Kings-Lynne
That sounds about right. If you're using databases of different encodings in the same installation, it would probably be wise to restrict yourself to the intersection of those encodings when choosing database names. Bummer. So there's no one encoding I can set it to :( Actually, since the

Re: [HACKERS] pg_database encoding again

2003-06-02 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] writes: How do I get the encoding of the server? There is none. The per-database encodings are the only truth. We aren't likely to institute one in future, either; the trend seems to be more towards decentralization than the reverse. I would suggest

Re: [HACKERS] ECPG thread-safety

2003-06-02 Thread Shridhar Daithankar
On 1 Jun 2003 at 11:10, Manfred Spraul wrote: Shridhar Daithankar wrote: 2) Native freeBSD threads pthread.h in /usr/include and lc_r Do you know if FreeBSD supports pthread_rwlock with PTHREAD_PROCESS_SHARED? I'm trying to replace the LWLocks with pthread_rwlocks. What about