Re: [ADMIN] postgres 6.5 and krb5-1.0.6

1999-06-29 Thread Tom Ivar Helbekkmo
"Morris, Joel A." <[EMAIL PROTECTED]> writes: > I'm trying to build 6.5 w/ krb5 support. The Kerberos 5 support in PostgreSQL has not been updated for the API changes between whatever beta version it was written for and the final release. I have no idea how much work it will be to fix it. As a

Re: [ADMIN] 6.4.2 and 6.5 date usertype difference

1999-06-29 Thread Oleg Bartunov
Try this (6.5): test=> show DATESTYLE; NOTICE: DateStyle is Postgres with European conventions SHOW VARIABLE test=> select * from JUNK_QWERTY; id|mydate --+-- 1|01-02-1999 2|24-03-1999 3|24-11-1999 You can select which DATESTYLE to use SET DATESTYLE TO 'ISO'|'SQL'|'Postgres'|'Eu

[ADMIN] 6.4.2 and 6.5 date usertype difference

1999-06-29 Thread Colin Price (EML)
I have just replicated a db in 6.5 from 6.4.2. The table selects the date differently from the identical table. I obviously set a parameter in 6.4.2 which I now cannot find (from mail list archive and doc as well). Please aid someone who is tearing his hair out. Thank you in advance, Colin. Th

Re: [ADMIN] Re: vacum, locks, indicies and whatnot

1999-06-29 Thread Todd R. Eigenschink
Mark Dalphin writes: >I am very pleased to see the program written and think it may be >useful for others. I wonder if it might be written "more elegantly", >somehow accessing the Postgresql meta-data directly, but that is by >way of musing rather than critisism, for I don't know how to do it. I

[ADMIN] Re: vacum, locks, indicies and whatnot

1999-06-29 Thread Mark Dalphin
On Monday, Jun 28, Todd R. Eisenschink wrote: ... a program called AutoVac which loops over all the databases controlled by Postgresql, drops each index, VACUUM ANALYZE each table and then re-creates the index. An interesting mixture of shell, Perl and psql (no complaint, mind you; it is more th

[ADMIN] postgres 6.5 and krb5-1.0.6

1999-06-29 Thread Morris, Joel A.
I'm trying to build 6.5 w/ krb5 support. I have made the service principal and made the necessary changes to Makefile.global. When I try to build I get an error about not finding krb5.h in auth.c. This is easily fixed by editing auth.c to specify the correct location for krb5.h. After I fix tha

No Subject

1999-06-29 Thread owner-pgsql-admin