Hi,
I'm using Large Object to store images and displayed them on the fly. I never found
any problems and it
is very quiet. "When Postgre starts using large objects it is going to make a lot
of noise." ???
You can also generate XML on the fly or what you want with Perl or other CGI stuff,
simply
On Wed, 5 May 1999, Chris Bitmead wrote:
// > # 1. Tuples are limited to 8KB. I assume even the "text" type is limited
// > # that way. But my documents may be longer than that.
// >
// > This isn't a problem, I store all of my photographs
// > in postgres.
//
// How?
I pla
On Tue, 4 May 1999, Mark Fleming wrote:
// That a good solution, but now that XML is starting to break off it
// kinda puts PostgreSQL users at a disadvantage. We have to have
// static XML documents on on disk in order to use the format and have
// external search engines to search for content
Dustin Sallings wrote:
>
> On Tue, 4 May 1999, Raphael Finkel wrote:
>
> # Is PostgreSQL appropriate for a database of documents? I see several
> # potential problems.
> #
> # 1. Tuples are limited to 8KB. I assume even the "text" type is limited
> # that way. But my documents may be longer
There was a brief period of time during 6.5 where the ODBC and JDBC
interfaces were broken. It could very well have existed when beta 1 was
created. This is fixed in the current code. Hopefully beta2 will be
available soon.
-Original Message-
From: Bogus User [SMTP:[E
Ari Halberstadt wrote:
> Raphael Finkel <[EMAIL PROTECTED]> wrote:
> >Is PostgreSQL appropriate for a database of documents? I see several
> >potential problems.
> >
> >1. Tuples are limited to 8KB. I assume even the "text" type is limited that
> >way. But my documents may be longer than th
Can I do a select joining tables of one database with tables in another
database? Both
databases would be managed by the same postmaster.
Thanks,
Sarah Officer
[EMAIL PROTECTED]
> Bruce Momjian wrote:
>
> > There is. Linux/*BSD use only a big kernel lock, or
> > several big kernel locks.
>
> I think you're talking silly. BSD has one big lock, but my count there
> are around 60 locks in Linux 2.2. Solaris has thousands of locks.
>
>
OK, *BSD has one, Linux has 60,
> drop table mytemp; (just to be sure)
> check for existence of file "mytemp" in database directory; if you
> found it - remove
> recreate table.
It did work. Now I'm suprised because I know I did those steps yesterday
in that order. Obviously I must be mistaken or there is some other
unknown, bu
Hi,
Has anyone successfully used ODBC with PostgreSQL 6.5beta1? I've been
trying to for a few days now and can't seem to get it to work. I've tried
compiling on Debian 2.1 and RedHat 5.2 and have the same results. When I
try to connect to the database, I get an error on the server about an
I have a table with a column of type int8. When I try to create an
index on it, the
database protests and gives the following error message:
ERROR: Can't find a default operator class for type 20.
Is there an easy fix for this? I assumed builtin numeric types would
have
default comparison
> Bruce Tong writes:
>> PostgreSQL wants to create a file for each table.
BT> /var/lib/pgsql/base/zztong/*
BT> There is a file there named "mytemp" but it is empty.
I've run into this situation before -- it appears to be a Postgres bug.
You start a command that creates a table, and cancel
12 matches
Mail list logo
