[GENERAL] system date != now()

2004-04-10 Thread CSN
How do I update pg's date? It doesn't appear to have been updated with DST. I was under the impression that changing the system's date/time (date -s "...") would cause pg to use that. [EMAIL PROTECTED] data]# date Sun Apr 11 00:39:07 MDT 2004 [EMAIL PROTECTED] data]# [EMAIL PROTECTED] data]# psql

Re: [GENERAL] running postgresql database from loopback filesystem?

2004-04-10 Thread Greg Stark
Jeff Davis <[EMAIL PROTECTED]> writes: > I have virtual hosted users on a server and some of them have a > postgresql database. I'm concerned about the outside possibility that a > user could create an infinite loop and fill up the partition on which > everyone's database resides. It seems like

[GENERAL] Postmaster won't shut down

2004-04-10 Thread wespvp
I've got a 2 hour index build that has been running for 9 hours. With 'ps -efl' I see that there is a VACUUM ANALYZE running that started 24 hours ago and my index build is 'wating'. I sent a SIGINT to postmaster and it kicked all sessions out, but the VACUUM is still running so postmaster won't

Re: [GENERAL] COPY TO order

2004-04-10 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Clodoaldo Pinto Neto) would write: > How to make sure COPY TO writes the table lines to the file in the same order > they were inserted? You probably want to rewrite PostgreSQL then. > I'm producing html pages in pl/pgsql and using COPY

[GENERAL] Access Conversion

2004-04-10 Thread Mark Lubratt
Hello, I'm trying to convert an Access application to have its backend be PostgreSQL. I've created the schema and imported the data without a problem. My problem is that the Access application wasn't written by me and has numerous queries and table relationships that I want to replace in pl

Re: [GENERAL] help needed regarding Query processing in postgres

2004-04-10 Thread Bruce Momjian
[EMAIL PROTECTED] wrote: > hi all, > > I am an M.Tech student of IITBombay,india. > We are doing a project on access control in postgres. > > Is there any way in which, i can add a extra predicate to the sql query > given to the postgres database table. > > please if any body could help me in th

[GENERAL] COPY TO order

2004-04-10 Thread Clodoaldo Pinto Neto
Hello, How to make sure COPY TO writes the table lines to the file in the same order they were inserted? I'm producing html pages in pl/pgsql and using COPY TO to write then to file. Occasionaly, about once in 7 or 9, the lines are copied to the file out of the order they were inserted in the tab

[GENERAL] help needed regarding Query processing in postgres

2004-04-10 Thread kirang
hi all, I am an M.Tech student of IITBombay,india. We are doing a project on access control in postgres. Is there any way in which, i can add a extra predicate to the sql query given to the postgres database table. please if any body could help me in this regard. Reply as soon as posible. thank

Re: [GENERAL] Sorting in Unicode not working

2004-04-10 Thread Tom Lane
Holger Klawitter <[EMAIL PROTECTED]> writes: > So in other words, all databases inside postgres must have the same (or at > least a compatible) encoding+locale Yup. strcoll()'s locale setting implicitly assumes a particular encoding (at least on the platforms I'm familiar with), and so selecting

Re: [GENERAL] Sorting in Unicode not working

2004-04-10 Thread Tom Lane
Hitesh Bagadiya <[EMAIL PROTECTED]> writes: > We did set the locate to hi_IN at initdb but sorting is not > working. You should check that you have selected a database encoding that matches what the locale expects. Also double-check that you really do have that locale selected (use pg_controldata

Re: [GENERAL] Errors in transactions

2004-04-10 Thread Bruno Wolff III
On Sat, Apr 10, 2004 at 12:55:46 +0100, Phil Endecott <[EMAIL PROTECTED]> wrote: > Dear PostgresQL experts, > > I thought I understood transactions until I found this problem. I'm > sure it must be a common situation. Can someone point me in the right > direction? > > I have a simple table th

[GENERAL] Errors in transactions

2004-04-10 Thread Phil Endecott
Dear PostgresQL experts, I thought I understood transactions until I found this problem. I'm sure it must be a common situation. Can someone point me in the right direction? I have a simple table that records which flags are set for various objects: create table obj_flags ( obj_id in

Re: [GENERAL] Sorting in Unicode not working

2004-04-10 Thread Holger Klawitter
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > You need to make sure you initdb with the right locale, not only > the right encoding. So in other words, all databases inside postgres must have the same (or at least a compatible) encoding+locale in order to allow proper sorting or other locale d

Re: [GENERAL] Sorting in Unicode not working

2004-04-10 Thread Hitesh Bagadiya
We did set the locate to hi_IN at initdb but sorting is not working. One thing is that linux system is running on en_US locale. Does this makes any difference? hitesh --- Tom Lane <[EMAIL PROTECTED]> wrote: > Hitesh Bagadiya <[EMAIL PROTECTED]> writes: > > Our database contains Hindi as well as

Re: [GENERAL] Accented chars in several apps

2004-04-10 Thread Janning Vygen
Am Freitag, 9. April 2004 22:32 schrieb G. Brannon Smith: > Answering my own post. I went ahead and bit the bullent and dumped the > whole thing over to ENCODING = 'UNICODE'. Wasn't nearly as painful as I > thought it would be... although I guess the DB has now effectively > doubled in size. Isn't