"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 information I
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
columns.
I
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
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
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
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 extend the
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
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.conf
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
my DB. But I saw that
Hello !
My ODBC driver in MS Visual Basic 6 refers also to
"Stored procedures" asRecord 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 fetch routines to
14 matches
Mail list logo