Hi.
I am newbie of POSTGRESQL. Please, share your knowledge with me.
I have 2 diffrent databases. There is table that has member's
information in the first database and bbs table is in another database.
I'd like to join these two tables. But I can not found related information.
Is it impossible w
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
inf
I'm pgsql newbie. I try to install the pgsql 7.0 on my Solaris 8 x86 server
but fail. The following is the error message:
stringinfo.c: In function `appendStringInfo':
stringinfo.c:104: `va_list' undeclared (first use in this function)
stringinfo.c:104: (Each undeclared identifier is reported o
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.
> Ru
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 differen
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 hel
> 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 servic
Thank you.
I already decide to use Mule-Internal encoding. In fact, there is no
other choice. But I'm still not sure that I can solve my problem with
mule -internal encoding.
1. How can I copy(or backup) mule-internal encoded data. Mule-Internal
is for just back-end. If there is a table that h
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'. Bu
'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 som
> 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
> information in one ta
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 t
When trying to build a trigger function in C I get a missing include:
fmgr.h
Should I simply comment out that include?
[using the latest CVS image]
--
Louis-David Mitterrand - [EMAIL PROTECTED] - http://www.apartia.fr
Hoare's Law of Large Problems:
Inside every large problem is a smal
Title: RE: [GENERAL] loading data from flat text file
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?
On Tue, 23 May 2000, Louis-David Mitterrand wrote:
> How mature is the plperl language for writing functions and triggers?
You cannot write triggers in plperl yet.
> Is it fast? (ie: does the interpreter pre-compiles functions and
> persists?)
Yes.
-alex
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
> interf
> "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/
> 1. How can I copy(or backup) mule-internal encoded data. Mule-Internal
> is for just back-end. If there is a table that have rows in many
> different kind of language. I think, I could not back it up. Am I wrong?
Just do it. You can use copy, pg_dump etc as ordinary encodings. The
result woul
On Tue, May 23, 2000 at 10:10:41AM -0400, Ron Peterson wrote:
> > "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
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 2
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
/etc/rc.d/i
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 us
Stephane Bortzmeyer <[EMAIL PROTECTED]> writes:
> 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:
So have you tried 7.0 ?
Reports of porting problems for 7.0 will be gladly accepted, but you
are a few months too late to attract much intere
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 ma
I have a very simple table defined as
CREATE TABLE custlist (
listid int4 NOT NULL,
custid int4 NOT NULL);
Somehow a record has gotten into the table with both values null. When I
try to delete using
delete from custlist where custid is null;
or
delete from custlist where
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 compl
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 hav
[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' fro
"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
32 matches
Mail list logo
