Maybe try getting postgresql-7.0.tar.gz. from www.postgresql.org. Then do
something like the following commands:
su -
groupadd postgres
adduser postgres
Note: make postgres user with default group postgres
cd /usr/local/src
tar -xvzf postgresql-7.0.tar.gz
cd postgresql-7.0
less INSTALL
Thank you for your answer.
I am developing WWW site that is serviced in 4 difference language,
english, chinese, japanese, korean. I allocated one database for one
language. each DB will have same tables that have same kind of
information in different language. But I want to keep member's
Janet wrote:
Hello!
I don't know if there is the right place to ask my question. If not,
please accept my apology.
I'm totally new to Linux. And I have troubles using the PostgreSQL.
I installed Redhat 6.0 and find there is postgresql already installed
on my computer.
Running the
Sungchul Park [EMAIL PROTECTED] writes in [EMAIL PROTECTED]:
I am developing WWW site that is serviced in 4 difference language,
english, chinese, japanese, korean. I allocated one database for one
language. each DB will have same tables that have same kind of
information in different
How mature is the plperl language for writing functions and triggers?
Is it fast? (ie: does the interpreter pre-compiles functions and
persists?)
I couldn't find any plperl package in the PG-7.0beta5 (the latest)
debian packages, should I roll my own PG to get it?
Thanks in advance for your
I am developing WWW site that is serviced in 4 difference language,
english, chinese, japanese, korean.
I allocated one database for one language.
Why?
Because I want to use same table name. I mean... For example, I have a
BBS code. That code store data into 'pubbbs' table. As you know I need
4 tables for one service.
Yes, I can use 4 different table name. As 'pubbbs_en', 'pubbbs_jp',
'pubbbs_kr', 'pubbbs_cn'. But I will make much more
Sungchul Park wrote:
Because I want to use same table name. I mean... For example, I have a
BBS code. That code store data into 'pubbbs' table. As you know I need
4 tables for one service.
Yes, I can use 4 different table name. As 'pubbbs_en', 'pubbbs_jp',
'pubbbs_kr', 'pubbbs_cn'. But I
'set time zone 'GMT';', or any other 'set time zone' (even with numeric time
zones), is completely ignored on my Tru64 machine (I always get dates in local
time, UT+2). On Debian, everything is fine.
Did I forget something when compiling PostgreSQL? Is there
Hi,
I am trying to figure out how to restrict user access to a database to
a few defined functions, so that users could use the database (and update
it) but only through a set of procedures, written for exemple in C and
using the Server Programming
interface.
I am new to PostgreSQL so sorry if
Emmanuel Motchane wrote:
Hi,
I am trying to figure out how to restrict user access to a database to
a few defined functions, so that users could use the database (and update
it) but only through a set of procedures, written for exemple in C and
using the Server Programming
interface.
"Voitenko, Denis" wrote:
So I am almost there, except my data is formated as follows:
"chunk1","chunk2","chunk3"
how would I tell COPY that my data is encapsulated in " and separated
by , ? Furthermore, I did not find a manual on the COPY command.
Anyone?
In /usr/local/pgsql/doc
On Tuesday 23 May 2000, at 14 h 17, the keyboard of Stephane Bortzmeyer
[EMAIL PROTECTED] wrote:
PostgreSQL 6.5.
And for those who wonder why I don't use 6.5.3, it's because, unlike 6.5, it doesn't
compile on Tru64:
cc -I../../../include -I../../../backend -DNOFIXADE -std -O4 -Olimit
Hello all,
I just finished my very first postgresql installation (Version 7). I
already like it much better than oracle 8, which took me the better part
of a day to install. Anyway, I have a red-hat based VA Linux box, so I
followed the red-hat startup instructions, putting a file in
ozric wrote:
I got help from one of our DBA's today here is what I was missing. This
in not in Bruce's Book.
INSERT INTO address (per_id,street_num,city,state,zip)
SELECT per_id,'$3','$4','$5','$6' FROM from person
WHERE last = '$1'
AND first = '$2';
$1-6 will be supplied by user input
Hi -
I'm new to postgres and have some questions regarding the
authentication and access systems. I've got postgres installed and can
connect from remote machines, but have some questions:
- I cannot connect as the postgres user 'postgres' from remote machines?
Why?
- How is pg_shadow
Aha!
I have had this thing about trying to figure out how to program
trees/hierarchies/graphs in SQL for awhile now. Something I've
complained about in this list an others, including a Byte newsgroup.
Well whaddya know, but I read Jon Udell's Byte column today, and it
begins by quoting my
does postgresql compile and run on macosx server?
if so, does anyone know if binaries for it exist?
thanks..
the tree. If you do a "SELECT * FROM supertable*" (for example, if you were to
redefine table* to mean select heterogeneous rows), what row will you get for a
row that exists in a leaf? The same row is in all tables between supertable
and the leaf. I suppose it would be necessary to have
[EMAIL PROTECTED] (Philip Hallstrom) writes:
I'm new to postgres and have some questions regarding the
authentication and access systems. I've got postgres installed and can
connect from remote machines, but have some questions:
- I cannot connect as the postgres user 'postgres' from
"Bryan White" [EMAIL PROTECTED] writes:
I get the output:
ERROR: ExecutePlan: (junk) `ctid' is NULL!
I get the same error if I try to update the null row.
At this point I figured I would outsmart it and use the oid. However it
appears the oid is null as well.
Wow, that's bizarre. It
21 matches
Mail list logo