"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
[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
> 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
does postgresql compile and run on macosx server?
if so, does anyone know if binaries for it exist?
thanks..
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
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
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
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
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
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
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
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
> 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
> "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/
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
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
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?
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
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
> 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
'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
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
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
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
> I am developing WWW site that is serviced in 4 difference language,
> english, chinese, japanese, korean.
> I allocated one database for one language.
Why?
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
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
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
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
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
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
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
32 matches
Mail list logo
