"gnari" <[EMAIL PROTECTED]> schrieb am 01.08.04 19:11:26:From: "Kay-Uwe.Genz" <[EMAIL PROTECTED]>> > Am 01.08.2004 um 10:44 schrieb Kay-Uwe Genz:> > > Hi @ all,> >> > I want to reference the User-ID PG use as an FOREIGN KEY in a tabel of > > my DB. But I saw that pg_user is a view. Where are the in
Thank you ! that did it. - Joel
On Aug 1, 2004, at 11:15, Peter Eisentraut wrote:
Joel Rodrigues wrote:
The files do exist, for example:
/usr/include/libxml2/libxml/xpath.h
Try
make all CPPFLAGS=-I/usr/include/libxml2
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---
All,
I am looking for documentation on the pg_proc.proacl column. I am working on a
schemadiff and when I expect the acl to be the same, they come out slightly different.
I searched the PG 7.4 doc site, and didn't find anything except the one liner on the
pg_proc description page.
Any kind of
Am Samstag, 31. Juli 2004 17:13 schrieb Tom Lane:
> Janning Vygen <[EMAIL PROTECTED]> writes:
> > So here is my question: How can i define a functional index to be used
> > with a primary key (using postgreSQL 7.4.3)?
>
> You can't. The SQL spec says that primary keys are columns or lists of
> col
Dear my friends...
My boss requested that my application is equipped with
emoicon (smiley) in the sales report. That's why I
need to know, is it possible to save a small image
into the postgres? with which data type should I
define the column (field)?
I have a currently table, salesreport. Its fi
Prabu,
There are a number of approaches to do this:
1) Store your images on the file system of the server and in the data
base store only the path to it;
2) Create an icon table, and store your icons as BLOBs in it, then
reference them from your reports table.
I'm not an expert on BLOBs, so ple
When I distribute a binary-only distribution of Postgre to a client, can
I exclude some parts of Postgres (to make it smaller), e.g.
documentation (all of doc/), some PL's, or even psql, initdb, pg_dump,
etc.?
--
dave
---(end of broadcast)---
TIP 5:
On Aug 1, 2004, at 6:26 PM, Christopher Browne wrote:
Measuring it as binary installs:
- Installing PostgreSQL on Debian requires adding a 9.8MB package.
- Installing MySQL on Debian requires adding several packages adding
up to (+ 8.7 0.2 1.0 0.6), or roughly 10.3MB.
- Installing FireBird2 requi
Janning Vygen <[EMAIL PROTECTED]> wrote:
>
[snip]
>
> Thanks to Tom and Peter for your answers. I will design my table without a
> primary key and use my unique index instead of a primary key. As this unique
> key is the same as a primary key i dont see the reason why postgresql
> should't ext
Prabu Subroto wrote:
My boss requested that my application is equipped with
emoicon (smiley) in the sales report. That's why I
need to know, is it possible to save a small image
into the postgres? with which data type should I
define the column (field)?
What do you mean by "equipped with emoicon (s
If you launch your progress server at startup (in init.d),
you only have to type :
# service postgresql reload
It works fine.
Luc
- Original Message -
From: "Christopher Browne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 31, 2004 3:09 AM
Subject: Re: [GENERAL] pg_hba
"Kay-Uwe Genz" <[EMAIL PROTECTED]> :
> "gnari" <[EMAIL PROTECTED]> schrieb am 01.08.04 19:11:26:
>
> From: "Kay-Uwe.Genz" <[EMAIL PROTECTED]>
> >
> > Am 01.08.2004 um 10:44 schrieb Kay-Uwe Genz:
> >
> > > Hi @ all,
> > >
> > > I want to reference the User-ID PG use as an FOREIGN KEY in a tabel of
Hello !
My ODBC driver in MS Visual Basic 6 refers also to
"Stored procedures" as Record source.
What are these stored procedures, I don't find
anything in the 7.4 documentation,
Where can I find documentation ?
Many thanks.
Luc
Ð ÐÐÐ, 02.08.2004, Ð 14:49, Federico Di Gregorio ÐÐÑÐÑ:
> On lun, 2004-08-02 at 14:30 +0200, Markus Bertheau wrote:
> > Hi,
> >
> > I wonder if there is some kind of support for PostgreSQL's arrays in
> > psycopg? The fetch routines return the literal array syntax of
> > PostgreSQL. I'd want the f
14 matches
Mail list logo