Re: [GENERAL] Where are all the users?

2004-08-02 Thread Kay-Uwe Genz
"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

Re: [GENERAL] Fwd: [NOVICE] contrib/xml make error on Mac OS X 10.3.4

2004-08-02 Thread Joel Rodrigues
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/ ---

[GENERAL] pg_proc.proacl documentation

2004-08-02 Thread Jonathan Scott
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

Re: [GENERAL] How to use as Functional Index to be used as Primary KEY

2004-08-02 Thread Janning Vygen
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

[GENERAL] I have some questions...

2004-08-02 Thread Prabu Subroto
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

Re: [GENERAL] I have some questions...

2004-08-02 Thread Csaba Nagy
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

[GENERAL] exclusion in distributing binary-only postgresql to client

2004-08-02 Thread David Garamond
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:

Re: [GENERAL] PostgreSQL, GnuCash

2004-08-02 Thread Aaron Burghardt
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

Re: [GENERAL] How to use as Functional Index to be used as Primary KEY

2004-08-02 Thread Jim Seymour
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

Re: [GENERAL] I have some questions...

2004-08-02 Thread Michal Taborsky
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

Re: [GENERAL] pg_hba.conf changes without restarting postmaster

2004-08-02 Thread Secrétariat
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

Re: [GENERAL] Where are all the users?

2004-08-02 Thread gnari
"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

[GENERAL] Stored procedures

2004-08-02 Thread Secrétariat
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

[GENERAL] Information about the type of elements in an array from libpq

2004-08-02 Thread Markus Bertheau
Ð ÐÐÐ, 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