BLOb is OID
CREATE TABLE images (imagefield oid);
- Original Message -
From: David Lanier <[EMAIL PROTECTED]>
To: PGSQL-General <[EMAIL PROTECTED]>
Sent: 14 Îêòîìâðè 1999 ã. 18:15
Subject: [GENERAL] insert BLOB
> I'm relatively new to Postgres.
>
> I'd like some help setting up a BLOB
I'm relatively new to Postgres.
I'd like some help setting up a BLOB (binary large object) field to hold
images, and more importantly, inserting data (images) into it. We're using
version 6.5.1.
I tried this:
CREATE TABLE images (imagefield blob);
but I got an error, stating "Unable to locate
A lot of this has come up recently. Bruce, perhaps you can add a TODO like
this:
* Completely rethink authentication.
I have some ideas (think tcpd), but I have way too many ideas and too
little time these days :(
-Peter
On Thu, 14 Oct 1999, Mark Jewiss wrote:
> Hello,
>
> Similar to
Hello,
Similar to other questions I've seen posed in the last day or so,
apologies if this exact question has been asked, I don't think it has.
I want to restrict access to a set of databases to connections from a
specfic machine and a specific user.
Lines in my pg_hba.conf file are similar to
I am trying to figure out how to get access to my Postgress database
from Filemaker Pro 5.0 on a Windows 98 machine. I know I need ODBC
drivers but which ones and where do I get them?
--
Ted Florence
[EMAIL PROTECTED]
Take our survey at http://www.avenza.com/products.survey.html
MAPublisher - Th
No...we tried in the past, and more hated it then wanted it...
On Wed, 13 Oct 1999, Jim Cromie wrote:
>
> would it be possible to add a Reply-to header to all outgoing messages ?
>
>
>
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Ad
Hello, I'm a new into the postgres's world, and I was
seeing the User's Guide from V.6.4 and I saw that you
can write into a View. In the new versions can you? If
not, have any body any idea of when it would be
reality?
You can do so now. Just create a ON INSERT rule for the view.
Virtues of SP:
1) speed - no reparsing of queries, no multiple queries transmitted between
application and db (if SP not available, operation is a sequence of sql
operations).
2) Business Logic is enforced uniformly, not re-implemented in every app that
touches a table.
Drawbacks of SP:
1) S
On Wed, 13 Oct 1999, Lamar Owen wrote:
> Bruce Momjian wrote:
> > > There is a todo item for the postgres user to have a password by default.
> > > I'm not sure though how that would be done. Probably in initdb. (?)
> >
> > We could enabled it as part of initdb. Prompt them for it there, and
>
On Thu, 14 Oct 1999, Chairudin Sentosa Harjo wrote:
> Dear all,
>
> mydb=> create table rtext (rtext varchar(10));
> CREATE
> mydb=> insert into rtext values ('hello');
> INSERT 17681 1
>
> What do "17681" and "1" mean?
>
> Could someone help me to understand this please?
>
"17681": nu
On Thu, 14 Oct 1999, Chairudin Sentosa Harjo wrote:
> Simon Drabble wrote:
> >
> > On Thu, 14 Oct 1999, Chairudin Sentosa Harjo wrote:
> >
> > > Dear all,
> > >
> > > mydb=> create table rtext (rtext varchar(10));
> > > CREATE
> > > mydb=> insert into rtext values ('hello');
> > > INSERT 176
Hello,
I agree with this point of view : the granularity of the authentication is not small
enough to allow a good setup of access security to the PG databases.
I plan to setup a database backed web servers :
* the databases are stored on one Linux box,
* the Apache servers are on another,
* all
At 09:56 PM 13-10-1999 +0200, Peter Eisentraut wrote:
>There is a todo item for the postgres user to have a password by default.
>I'm not sure though how that would be done. Probably in initdb. (?)
Initdb sounds ok. Just have no password by default. \N is strange!
>> the clear and in a 666 permi
13 matches
Mail list logo
