Following up on my compile problem, I've read the list archives for great
clues and had a good reply from Bruce to last night's query. (I hope
someone turns these hints into an FAQ for BSDi users.)
I've overcome the flex problem by renaming lex and then making a link lex
-> flex.
I also installed
Unfortunately tuples cannot be bigger than 8k. Many of us I think look
forward to the day when this restriction doesn't apply (it is on the
to-do list), but at this point in time 8k is the limit.
Large objects will work, but they have other problems that make them
fairly impractical.
John Browni
I'm trying to add large text items to a table (field declared as type
text). PQSendQuery can't take more than 8192 bytes.That's OK. But COPY
also complains that tuples of 29896 bytes are too big (trying to copy
from a file). So how do I get big text fields into a table? Do I have to
make them larg
On Tue, 25 May 1999, Chris Bitmead wrote:
What does this have to do with pl/pgsql?
# It's extremely straight-forward..
# $q = $dbh->prepare("SELECT x,y,z from b where c = ?");
# $q->execute("foo");
# while (($x, $y, $z) = $q->fetchrow())) {
# #stuff
# }
#
# $q = $dbh->prepare("INSERT I
On Mon, 24 May 1999, Simon Drabble wrote:
# char query[LOTS_OF_ROOM];
# sprintf(query, "INSERT INTO octects VALUES(%d)", a);
#
# PQexec(conn, query);
snprintf would probably be a better choice.
# -or- download my libpq wrapper, which allows you to perform queries without
# using a temp
Using pg_dump with 6.5b1 on solaris sparc, crashes with a core dump.
This means I can't keep backups and I can't upgrade my data model without
being able to export the old data.
If one of the developers wants debug info let me know what you need (e.g.,
what commands to run in gdb--though I'll ha
That's an example of performing procedural tasks using Perl as the
procedural language with access to the database.
I think what Mike is looking for are examples of using PL/pgSQL. Which, as
it where, is a procedural language 'internal' to postgreSQL (well that a
very bad way of putting it but I
Hey, found the module. Looks pretty interesting -- even has the
capability of ignoring stopwords. This is just what I am looking for!
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
--
Hi,
I am afraid I am a newbie. Forgive me if this is a silly question-
I'm trying to create a large database using JDBC to load the tables by
calling executeUpdate with the statement "SQL INSERT INTO" + tableName +
" VALUES (" etc...
After 14 and a half thousand rows the java virtual machine cras
Going through the documentation I can only find little about outer
joins. One statement is in the Changes doc about including syntax for
outer joins, but there doesn't seem to be implemented any code after
that.
Is it true that there's no outer joins yet? Any plans? Btw. what is the
syntax for ou
On Mon, 24 May 1999, Bruce Momjian wrote:
> Sorry, I meant in the distribution's contrib directory, not the ftp
> site. I didn't even know we had a contrib directory on the ftp site.
Wel, you do now! Thanks! I'll check it out!
Brett W. McCoy
It's extremely straight-forward..
$q = $dbh->prepare("SELECT x,y,z from b where c = ?");
$q->execute("foo");
while (($x, $y, $z) = $q->fetchrow())) {
#stuff
}
$q = $dbh->prepare("INSERT INTO a(x,y,z) values(?,?,?);
$q->execute($x,$y,$z);
Mike Haberman wrote:
>
> I too need more info on PL/pgS
> On Mon, 24 May 1999, Bruce Momjian wrote:
>
> > > What's it called? I only see some tcl frontend stuff. Despite my
> > > pessimism form the prior message, I am interested in a full text retrieval
> > > engine.
> >
> > It is called contrib/fulltextindex. Does someone want to suggest a
> > be
> On Mon, 24 May 1999, Bruce Momjian wrote:
>
> > > What's it called? I only see some tcl frontend stuff. Despite my
> > > pessimism form the prior message, I am interested in a full text retrieval
> > > engine.
> >
> > It is called contrib/fulltextindex. Does someone want to suggest a
> > be
I too need more info on PL/pgSQL than the docs supply.
Is it possible for people to mail me any examples of PL/pgSQL. I
just need to see examples of the syntax of the various control
sturctures, variable assignment, and the like.
>From simple to very complex, send anything that might be helpf
On Mon, 24 May 1999, Bruce Momjian wrote:
> > What's it called? I only see some tcl frontend stuff. Despite my
> > pessimism form the prior message, I am interested in a full text retrieval
> > engine.
>
> It is called contrib/fulltextindex. Does someone want to suggest a
> better name?
I di
> On Sun, 23 May 1999, Bruce Momjian wrote:
>
> > We have a fulltext stuff in the contrib directory.
>
> What's it called? I only see some tcl frontend stuff. Despite my
> pessimism form the prior message, I am interested in a full text retrieval
> engine.
It is called contrib/fulltextindex.
On Mon, 24 May 1999, Simon Drabble wrote:
> On Mon, 24 May 1999, Anna Langer wrote:
>
> > When we created the table in the database we set the attribut to int4.
> > We get the problem when we trying to move the interger to the database.
> >
> > int a=500;
> >
> > PQexec(conn, "INSERT INTO octe
On Mon, 24 May 1999, Anna Langer wrote:
> Hi!
> We are not really sure if this question is right for this mailinglist.
> We have some problem with INSERT INTO and we dont know how to solve it.We
> are writing it in a C-program. We are trying to get an integer from a file
> and put it into a dat
Its not really, really explanitory.
On Mon, 24 May 1999, Brett W. McCoy wrote:
> On Sun, 23 May 1999, Bruce Momjian wrote:
>
> > We have a fulltext stuff in the contrib directory.
>
> What's it called? I only see some tcl frontend stuff. Despite my
> pessimism form the prior message, I a
On Sun, 23 May 1999, Bruce Momjian wrote:
> We have a fulltext stuff in the contrib directory.
What's it called? I only see some tcl frontend stuff. Despite my
pessimism form the prior message, I am interested in a full text retrieval
engine.
Brett W. McCoy
The only thing that I know is whats in the docs and whats in the src
directory. I'd like to see/read more. I was going to pick up a Oracle book
on it but, I'm afraid that PL/pgSQL and PL/SQL aren't the same.
Thanks
Andy
On Sat, 22 May 1999, dustin sallings wrote:
> On Sat, 22 May 1999, Andy Le
22 matches
Mail list logo
