agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedInstalling postgres
5+ messages / 4 participants
[nested] [flat]
* Installing postgres
@ 1994-09-19 16:19 Raj Vadakkencherry <raj@CS.UCLA.EDU>
1994-09-19 20:31 ` Re: Installing postgres Paul M. Aoki <aoki@cs.berkeley.edu>
0 siblings, 1 reply; 5+ messages in thread
From: Raj Vadakkencherry @ 1994-09-19 16:19 UTC (permalink / raw)
To: legacy
Hi,
I'd like to install the latest version of postgres on my linux machine.
Could you tell me where I can get the code and installation instructions ?
Raj.
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Installing postgres
1994-09-19 16:19 Installing postgres Raj Vadakkencherry <raj@CS.UCLA.EDU>
@ 1994-09-19 20:31 ` Paul M. Aoki <aoki@cs.berkeley.edu>
1994-09-20 06:34 ` Query returning more than one group Kacper Nowicki <Kacper.Nowicki@fuw.edu.pl>
0 siblings, 1 reply; 5+ messages in thread
From: Paul M. Aoki @ 1994-09-19 20:31 UTC (permalink / raw)
To: Raj Vadakkencherry <raj@CS.UCLA.EDU>; +Cc: legacy
raj@CS.UCLA.EDU (Raj Vadakkencherry) writes:
> I'd like to install the latest version of postgres on my linux machine.
> Could you tell me where I can get the code and installation instructions ?
try looking in
ftp://s2k-ftp.CS.Berkeley.EDU/pub/postgres/unofficial-ports/linux
that may not be the latest and greatest, strictly speaking. you
should probably try the standard linux ftp sites to see if there have
been any recent updates.
--
Paul M. Aoki | University of California at Berkeley
aoki@CS.Berkeley.EDU | Dept. of EECS, Computer Science Division (#1776)
| Berkeley, CA 94720-1776
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
^ permalink raw reply [nested|flat] 5+ messages in thread
* Query returning more than one group
1994-09-19 16:19 Installing postgres Raj Vadakkencherry <raj@CS.UCLA.EDU>
1994-09-19 20:31 ` Re: Installing postgres Paul M. Aoki <aoki@cs.berkeley.edu>
@ 1994-09-20 06:34 ` Kacper Nowicki <Kacper.Nowicki@fuw.edu.pl>
1994-09-20 20:01 ` Text string w/ a '\n' character??? Robert.Patrick@cs.cmu.edu
0 siblings, 1 reply; 5+ messages in thread
From: Kacper Nowicki @ 1994-09-20 06:34 UTC (permalink / raw)
To: legacy
Hi,
I would like to test POSTGRES interface I'm writing.
The problem is I don't know how I can generate portal
with more than one group of instances.
Thanks in advance,
Kacper
------------------------------------------------------------------------
Kacper Nowicki e-mail: Kacper.Nowicki@fuw.edu.pl
Warsaw University =================================
Physics Department Computer Center
Hoza 69, 00-681 Warszawa, Poland fax: (48) 39121805
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
^ permalink raw reply [nested|flat] 5+ messages in thread
* Text string w/ a '\n' character???
1994-09-19 16:19 Installing postgres Raj Vadakkencherry <raj@CS.UCLA.EDU>
1994-09-19 20:31 ` Re: Installing postgres Paul M. Aoki <aoki@cs.berkeley.edu>
1994-09-20 06:34 ` Query returning more than one group Kacper Nowicki <Kacper.Nowicki@fuw.edu.pl>
@ 1994-09-20 20:01 ` Robert.Patrick@cs.cmu.edu
1994-09-21 20:56 ` Re: Text string w/ a '\n' character??? Paul M. Aoki <aoki@cs.berkeley.edu>
0 siblings, 1 reply; 5+ messages in thread
From: Robert.Patrick@cs.cmu.edu @ 1994-09-20 20:01 UTC (permalink / raw)
To: legacy
We are developing an application which uses Postgres to store it's data.
The problem is that I need to be able to store text strings with
carriage return characters in them.
First, I tried just passing the raw '\n' character embedded in the
string to libpq. This causes me to receive a "scanner error"(something
about unterminated char or string) and nothing is stored in the text
field. Next, I tried inserting a '\' before the '\n' (since this
appears to work properly if done from the monitor). However, when
executed via libpq, Postgres just drops the carriage return entirely!
So I figured it was just a problem with the text data type and converted
everything to octal and tried to store it as a bytea data type.
Unfortunately, Postgres seems to treat the bytea data type exactly like
text (at least in this respect).
Is it possible to store a piece of text in Postgres without losing the
formatting (i.e., carriage returns)?
Robert
--
+------------------------------------------------------------------------+
| Robert Patrick _/_/_/_/ _/ _/ _/_/_/_/ |
| n-dim Group _/ _/ _/ _/ _/ _/ |
| Engineering Design Research Center _/ _/ _/ _/ _/ _/ |
| Department of Chemical Engineering _/ _/ _/ _/ _/ _/ |
| Carnegie Mellon University _/_/_/_/ _/_/_/_/_/ _/_/_/_/ |
| Pittsburgh, PA 15213 _/ _/ _/ _/ _/ |
| Phone: (412)268-5215 _/ _/ _/ _/ _/ |
| Fax: (412)268-5229 _/ _/ _/ _/ _/ |
| rp2y+@eiger.edrc.cmu.edu _/ _/ _/ _/ _/ |
| rp2y+@andrew.cmu.edu |
| World Wide Web: http://paneer.ndim.edrc.cmu.edu:8888/~rp2y/Home.html |
+------------------------------------------------------------------------+
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Text string w/ a '\n' character???
1994-09-19 16:19 Installing postgres Raj Vadakkencherry <raj@CS.UCLA.EDU>
1994-09-19 20:31 ` Re: Installing postgres Paul M. Aoki <aoki@cs.berkeley.edu>
1994-09-20 06:34 ` Query returning more than one group Kacper Nowicki <Kacper.Nowicki@fuw.edu.pl>
1994-09-20 20:01 ` Text string w/ a '\n' character??? Robert.Patrick@cs.cmu.edu
@ 1994-09-21 20:56 ` Paul M. Aoki <aoki@cs.berkeley.edu>
0 siblings, 0 replies; 5+ messages in thread
From: Paul M. Aoki @ 1994-09-21 20:56 UTC (permalink / raw)
To: Robert.Patrick@cs.cmu.edu; +Cc: legacy
Robert.Patrick@cs.cmu.edu writes:
> Is it possible to store a piece of text in Postgres without losing the
> formatting (i.e., carriage returns)?
i couldn't quite tell if you had already tried this, but:
heliotrope:postgres (22)> cat foo.c
main()
{
(void) PQsetdb("mumble");
(void) PQexec("create foo (x=text)");
(void) PQexec("append foo (x=\"new\\nline\")");
(void) PQfinish();
}
heliotrope:postgres (23)> cc foo.c /private/devel/postgres/lib/libpq.a
heliotrope:postgres (24)> createdb mumble
heliotrope:postgres (25)> a.out
heliotrope:postgres (26)> monitor -c 'retrieve (foo.all)' mumble
---------------
| x |
---------------
| new
line |
---------------
heliotrope:postgres (27)>
--
Paul M. Aoki | University of California at Berkeley
aoki@CS.Berkeley.EDU | Dept. of EECS, Computer Science Division (#1776)
| Berkeley, CA 94720-1776
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1994-09-21 20:56 UTC | newest]
Thread overview: 5+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1994-09-19 16:19 Installing postgres Raj Vadakkencherry <raj@CS.UCLA.EDU>
1994-09-19 20:31 ` Paul M. Aoki <aoki@cs.berkeley.edu>
1994-09-20 06:34 ` Query returning more than one group Kacper Nowicki <Kacper.Nowicki@fuw.edu.pl>
1994-09-20 20:01 ` Text string w/ a '\n' character??? Robert.Patrick@cs.cmu.edu
1994-09-21 20:56 ` Re: Text string w/ a '\n' character??? Paul M. Aoki <aoki@cs.berkeley.edu>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox