Jeff Davis wrote:
Anyway, it occured to me that I could create a special file for each
database user of limited size, and make a filesystem on top of that
file. The file could be owned by the user. Then, each user could have a
seperate database and that database would be at the location of the
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
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
-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
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
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 that
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,
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
a
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.
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
[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 this
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
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 TO
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
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 the
15 matches
Mail list logo