Re: [GENERAL] #include "executor/spi.h" throwing errors

Can you please email me your spi.h. Need to see the path of other header files that spi.h includes and compare it with what i have.~HarpreetOn 8/30/06, Harpreet Dhaliwal <[EMAIL PROTECTED]> wrote: Now i did something like this$ cat a.c#include $ gcc -I /usr/include/pgsql/server -c a.c$still gettin

Re: [GENERAL] #include "executor/spi.h" throwing errors

On Wed, Aug 30, 2006 at 02:59:45AM -0400, Harpreet Dhaliwal wrote: > Can you please email me your spi.h. > Need to see the path of other header files that spi.h includes and compare > it with what i have. Perhaps you should post some of the actual errors you're getting? http://developer.postgresq

Re: [GENERAL] #include "executor/spi.h" throwing errors

Also, Where should the directoriresexecutor, nodes, utils, access, catalog be? Over here, its searching it in /usr/includeHowever, these files are located at /usr/include/pgsql/server/When i copy these directories to /usr/include, it throws the error that I posted in the form of a file a minute ag

Re: [GENERAL] XPath and XML support

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of John Gray > Sent: 29 August 2006 22:49 > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] XPath and XML support > > On Thu, 24 Aug 2006 13:56:12 -0700, Frank Cohen wrote: > > > Thanks Niko

[GENERAL] PostgreSQL on system with root as only user

Hi! I am about to install PostgreSQL on a minimal Linux system, where root is the only user that is allowed to exist. I would prefer to use a binary installer. Is it possible to install PostgreSQL without the postgres user? /Fredrik ---(end of broadcast)---

Re: [GENERAL] PostgreSQL on system with root as only user

No, you can't.You need postgres user for sure.Postgresql database doesn't run on root account.~HarpreetOn 8/30/06, Fredrik Israelsson < [EMAIL PROTECTED]> wrote: Hi!I am about to install PostgreSQL on a minimal Linux system, where rootis the only user that is allowed to exist. I would prefer to use

Re: [GENERAL] #include "executor/spi.h" throwing errors

Also,a.c is at/usr/local/pgsql/hpsand sp.h is at/usr/include/pgsql/server/executorDoes that make a difference?Regards,~harpreetOn 8/30/06, Harpreet Dhaliwal <[EMAIL PROTECTED]> wrote: Also, Where should the directoriresexecutor, nodes, utils, access, catalog be? Over here, its searching it in /usr

Re: [GENERAL] #include "executor/spi.h" throwing errors

Also, Can you please email me ur directory structure, as in, absolute path of a.c and absolute path of spi.h.Thanks,~HarpreetOn 8/30/06, Harpreet Dhaliwal <[EMAIL PROTECTED]> wrote: Also,a.c is at/usr/local/pgsql/hpsand sp.h is at/usr/include/pgsql/server/executorDoes that make a difference?Regard

Re: [GENERAL] #include "executor/spi.h" throwing errors

On Wed, Aug 30, 2006 at 03:53:13AM -0400, Harpreet Dhaliwal wrote: > Also, > Can you please email me ur directory structure, as in, absolute path > of a.cand absolute path of > spi.h. The absolute path of a.c is the irrelevent, it's in the current directory. executor/spi.h is in /usr/include/postg

Re: [GENERAL] #include "executor/spi.h" throwing errors

Did not understand about capital L and small L. What should i be using, capital or small.I also tried gcc -I `pg_config --includedir-server` a.cand it still says executor/spi.h doesn't exist. On 8/30/06, Martijn van Oosterhout wrote: On Wed, Aug 30, 2006 at 03:53:13AM -0400, Har

Re: [GENERAL] #include "executor/spi.h" throwing errors

On Wed, Aug 30, 2006 at 04:14:20AM -0400, Harpreet Dhaliwal wrote: > Did not understand about capital L and small L. > What should i be using, capital or small. Please use a font that distinguishes between I and l. It's capital I like in INDIGO. Not an L at all... > I also tried > gcc -I `pg_conf

Re: [GENERAL] #include "executor/spi.h" throwing errors

Problem was that i was using -L as in LEAMON, not I as in Indigo.Its working now. Martijn, thanks alot for your patience. I realy don't know why was I doing -L, actually i was thinkin of linking something. HUH. Had to include. Thanks alot once again~HarpreetOn 8/30/06, Martijn van Oosterhout

Re: [GENERAL] Version 1 Calling convention

How does the SPI manager know which database to connect using SPI_CONNECT()As there can be more than one datbase in the postgres server, how does it make out which database to connect as we don't specify the datbase name we intend to connect. ~JasOn 8/30/06, Jasbinder Bali <[EMAIL PROTECTED]> wrote

Re: [GENERAL] Version 1 Calling convention

On Wed, Aug 30, 2006 at 04:34:17AM -0400, Jasbinder Bali wrote: > How does the SPI manager know which database to connect using SPI_CONNECT() > As there can be more than one datbase in the postgres server, how does it > make out which database to connect as we don't specify the datbase name we > in

[GENERAL] Status on Fedora Core Extras packaging

Hello, Yesterday night, I was approved (sponsored) for Fedora Core packaging (please note that this is not something financial). For the beginning, I officially submitted python-psycopg2 to FC6. More are on the way; like pgpool, Slony-I, pgadmin3-adminpacks, phpPgAdmin, postgresql_autodoc, pgfoui

Re: [GENERAL] Version 1 Calling convention

PG_FUNCTION_INFO_V1 (test);Datumtest (PG_FUNCTION_ARGS){   int id = PG_GETARG_INT(0);    char *raw_rawemail1 = PG_GETARG_CHAR_P(1); //line 6 (warning thrown for this line)   char *rawemail1 = (char *)  palloc (VARSIZE(rawemail1));   VARATT_SIZEP ( rawemail1 ) = VARSI

[GENERAL] Query for order of tables

Hello;How can I query the pg catalogue to produce a list of tables in order of dependency?Cheers.

Re: [GENERAL] Version 1 Calling convention

On Wed, Aug 30, 2006 at 05:38:34AM -0400, Jasbinder Bali wrote: > PG_FUNCTION_INFO_V1 (test); > > char *raw_rawemail1 = PG_GETARG_CHAR_P(1); //line 6 (warning > thrown for this line) > Was trying to test the code given in the postgres manual. > The only diff being that i changed the

Re: [GENERAL] Version 1 Calling convention

Does that mean if I am passing a char value to the version 1 function from a function in the database then in the version 1 function it needs to be treated as text*??On 8/30/06, Martijn van Oosterhout wrote: On Wed, Aug 30, 2006 at 05:38:34AM -0400, Jasbinder Bali wrote:> PG_FU

Re: [GENERAL] Version 1 Calling convention

On Wed, Aug 30, 2006 at 06:05:18AM -0400, Jasbinder Bali wrote: > Does that mean if I am passing a char value to the version 1 function from a > function in the database then in the version 1 function it needs to be > treated as text*?? It depends on what type you're passing: char-> PG_GETARG

[GENERAL] Encoding problem

Hello,    I am really new to PostgreSQL and I seem to have an encoding problem. I come from Greece and I would like to make queries using greek characters too. I chose to write my database using encoding UTF8 and everything worked just fine creating it, until I tried to make a query using g

Re: [GENERAL] PostgreSQL on system with root as only user

> I am about to install PostgreSQL on a minimal Linux system, where root > is the only user that is allowed to exist. I would prefer to use a > binary installer. Is it possible to install PostgreSQL without the > postgres user? PostgreSQL refuses to start up as root user for security reasons (thi

Re: [GENERAL] PostgreSQL on system with root as only user

"Fredrik Israelsson" <[EMAIL PROTECTED]> writes: > I am about to install PostgreSQL on a minimal Linux system, where root > is the only user that is allowed to exist. You've *got* to be kidding. That's possibly the stupidest system design decision I've ever heard ... what is the point of disallow

Re: [GENERAL] PostgreSQL on system with root as only user

Well, no actual "design decision" is made yet. Just testing... ...actually, in embedded, minimalistic environments, I don't think it's unusual to have one and only one user. /Fredrik -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: den 30 augusti 2006 15:17 To: Fredrik

Re: [GENERAL] PostgreSQL on system with root as only user

On Wed, 2006-08-30 at 09:17 -0400, Tom Lane wrote: > "Fredrik Israelsson" <[EMAIL PROTECTED]> writes: > > I am about to install PostgreSQL on a minimal Linux system, where root > > is the only user that is allowed to exist. > > You've *got* to be kidding. That's possibly the stupidest system desi

Re: [GENERAL] Confused about locales

On 8/19/06, John Gunther <[EMAIL PROTECTED]> wrote: I've been reading about locales, encodings, sort orders, the to_ascii function and, embarrasingly, I'm more confused than enlightened.: What I want is very simple: 1) I want the database to correctly accept, store, and display alphabetic charac

Re: [GENERAL] PostgreSQL on system with root as only user

On Wed, Aug 30, 2006 at 03:34:22PM +0200, Fredrik Israelsson wrote: > Well, no actual "design decision" is made yet. Just testing... > > ...actually, in embedded, minimalistic environments, I don't think it's > unusual to have one and only one user. Yeah, but in embedded minimalisatic POSIX-compa

[GENERAL] PLPERL Function very Slow

Hi, i am having a problem with a plperl function i am trying to write. (using 8.1.4) the function does a select (ca 30,000 rows) using spi_query($query); while (my $row = spi_fetchrow($handle)) and within the while loop inserts the record into a table using spi_exec_query($query); The initia

Re: [GENERAL] PostgreSQL on system with root as only user

On Aug 30, 2006, at 9:01 , Chris Mair wrote: If you know what you're doing and you want to disable that feature you need to recompile from source and disable the uid checks in src/backend/main/main.c. Unless you're working in the embedded space or some such thing, I don't think it's a good id

[GENERAL] plz unsubscribe me

   please unsubscribe from this   thank u

Re: [GENERAL] plz unsubscribe me

In response to "rama krishna" <[EMAIL PROTECTED]>: >please unsubscribe from this > thank u > Instructions are in the mail headers of each message: List-Archive: List-Help: List-ID: List-Owner:

[GENERAL] Postgres

Prezado Suporte, Gostaria de saber se existe "upgrade"do BD Postgres 7.2.1 para BD Postgres 8.1? onde consigo obter? Desde já agradeço atenção dispensada Respeitosamente,                                                                   Bruno Lima Garcez                            Primeiro-

Re: [GENERAL] Deathly slow performance on SMP red-hat system

In article <[EMAIL PROTECTED]>, Joshua D. Drake <[EMAIL PROTECTED]> wrote: % Patrick TJ McPhee wrote: [...] [the query is "select 1"] % > But if I turn on duration logging, I get timings like % > LOG: duration: 91.480 ms [...] % Vacuum? Analyze? I had autovacuum on initially, but turned it off

[GENERAL] SQL Tuning

Hola, soy nuevo por acá, quisiera saber si me pueden ayudar para ver que modificaciones puedo hacerle a esta consulta para que funciones mas rápido ya que como esta ahora consume mucha cpu y memoria. desde ya muchas gracias. saludos query SELECT DISTINCT t.id, emp.descripcion as contratista,

Re: [GENERAL] PLPERL Function very Slow

Alex <[EMAIL PROTECTED]> writes: > The initial select is pretty fast and first inserts very fast, but after > a few thousand inserts the inserts start to slow down until it crawls. > Writing the same in a normal perl script takes less than 90 seconds > while the function is taking 10 minutes. Can

Re: [GENERAL] Postgres

Em 29/08/06, [EMAIL PROTECTED]<[EMAIL PROTECTED]> escreveu: Prezado Suporte, Gostaria de saber se existe "upgrade"do BD Postgres 7.2.1 para BD Postgres 8.1? onde consigo obter? Bruno, Esta lista é apenas em inglês. Para suporte em português procure: http://wiki.postgresql.org.br/ http://pg

Re: [GENERAL] PostgreSQL on system with root as only user

Unless it's a read-only database, I would never recommend using flash media for an RDBMS. Unless it's a small database, I would never recommend using USB as a storage interface for an RDBMS. -- Brandon Aiken CS/IT Systems Engineer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

[GENERAL] Fwd: How to convert a string to bytea?

-- Forwarded message --From: Chris Hoover <[EMAIL PROTECTED]>Date: Aug 30, 2006 12:22 PM Subject: How to convert a string to bytea?To: "pgsql-admin@postgresql.org" I am in need of some help.  I need to use the encode function against a text string in one

Re: [GENERAL] plz unsubscribe me

Bill Moran wrote: In response to "rama krishna" <[EMAIL PROTECTED]>: please unsubscribe from this thank u Instructions are in the mail headers of each message: List-Archive: List-Help: List-ID: List-

Re: [GENERAL] plz unsubscribe me

"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > Bill Moran wrote: >> Instructions are in the mail headers of each message: > Actually it is quite ridiculous that we expect someone to read the mail > headers. Those headers are really there for mail programs to read. On my MUA (a several-years-ol

Re: [GENERAL] Encoding problem

On Aug 30, 2006, at 6:29 AM, Pantelis Natsiavas wrote: In addition trying to make the same query through the query tool of pgadmin, I receive the same answer and of course null results. I don't know if it matters, but I am using Windows XP and PostgreSQL 8.1 with JDBC 3. I have checked ev

Re: [GENERAL] plz unsubscribe me

Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: Bill Moran wrote: Instructions are in the mail headers of each message: Actually it is quite ridiculous that we expect someone to read the mail headers. Those headers are really there for mail programs to read. On my MUA (a sev

Re: [GENERAL] PostgreSQL on system with root as only user

On Aug 30, 2006, at 12:03 , Brandon Aiken wrote: Unless it's a read-only database, I would never recommend using flash media for an RDBMS. Well, it's an embedded device, so you can pretty much be certain that it's not storing sales information. If the flash goes belly up, then the device

Re: [GENERAL] plz unsubscribe me

In response to "Joshua D. Drake" <[EMAIL PROTECTED]>: > Tom Lane wrote: > > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > >> Bill Moran wrote: > >>> Instructions are in the mail headers of each message: > > > >> Actually it is quite ridiculous that we expect someone to read the mail > >> heade

Re: [GENERAL] plz unsubscribe me

There are good reasons why that is not a feature found in many popular email clients. The biggest of which is that if it was people would use it all the time and spammers would abuse it as a way to cull current email addresses. As a matter of fact, most large esp's encourage their clients to

Re: [GENERAL] plz unsubscribe me

Bill Moran wrote: In response to "Joshua D. Drake" <[EMAIL PROTECTED]>: Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: Bill Moran wrote: Instructions are in the mail headers of each message: Actually it is quite ridiculous that we expect someone to read the mail headers. I

Re: [GENERAL] Postgresql mentioned on Newsforge MySQL article

On Monday 28 August 2006 17:04, Peter Eisentraut wrote: > Tony Caduto wrote: > > http://newsvac.newsforge.com/newsvac/06/08/28/1738259.shtml > > > > Don't know the validity of this dvd order test they did, but the > > article claims Postgresql only did 120 OPM. > > The contest evaluated the solutio

Re: [GENERAL] PostgreSQL on system with root as only user

I haven't got any numbers (or a USB stick I can test with at the moment) but USB is going to be a bottleneck for read and write performance. Unless you're accessing very small amounts of data or running small queries, I would expect performance to be pretty poor. If your data set is so small, why

Re: [GENERAL] plz unsubscribe me

Tom Lane wrote: > In any case, we also expend bandwidth on a couple of footer TIPs that > remind people how to unsubscribe. Maybe one of them should explicitly > say that mailing to the list is not the way. One of them talks about "unregister", because of which you'd think we're already covered.

[GENERAL] Tsearch2 & Hebrew

Hello all, I want to use Tsearch2 for a current project I have but I can't seem to find a way to implement it on hebrew content. I found that there is an hebrew Ispell project and apparently I can use it as a dictionary but I can't find any hebrew stemmer to work properly with it, or maybe I'

Re: [GENERAL] plz unsubscribe me

Alvaro Herrera <[EMAIL PROTECTED]> writes: > So I don't think we should do anything about it. It's not really a > serious problem. Actually, what I'd like to see done is to get majordomo to bounce list messages containing "unsubscribe" in the subject, with an explanatory message about the right w

Re: [GENERAL] PLPERL Function very Slow

1 -- Drop your indexes on the table to be inserted into. 2 -- Execute a BEGIN transaction 3 -- Execute your inserts. 4 -- Execute a commit or rollback and END transaction 5 -- Rebuild / recreate your indexes "Alex" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > i am havin

Re: [GENERAL] plz unsubscribe me

Tom Lane wrote: Alvaro Herrera <[EMAIL PROTECTED]> writes: So I don't think we should do anything about it. It's not really a serious problem. Actually, what I'd like to see done is to get majordomo to bounce list messages containing "unsubscribe" in the subject, with an explanatory message a

[GENERAL] Dblink and connections to MySQL?

Does anyone have any recommendations or experiences on connecting a postgres db to a mysql db possibly through dblink or another technology?  Does dblink just do postgres to postgres?  There is not a lot documentation on that contrib.   Thanks, Brian

Re: [GENERAL] PostgreSQL on system with root as only user

On Aug 30, 2006, at 13:58 , Brandon Aiken wrote: I haven't got any numbers (or a USB stick I can test with at the moment) but USB is going to be a bottleneck for read and write performance. Unless you're accessing very small amounts of data or running small queries, I would expect performance

[GENERAL] Listening on more than one port?

I need to be able to have postmaster (8.1.2) listen on more than one port, eg, 5432 and some other port, such as 5431.There does not appear to be a way to configure that. You can configure multiple IP addresses, but not multiple ports. If I set up a TCP port redirector like rinetd, to forward packe

Re: [GENERAL] Status on Fedora Core Extras packaging

On Wed, Aug 30, 2006 at 12:12:30 +0300, Devrim GUNDUZ <[EMAIL PROTECTED]> wrote: > > More will be in FC Extras. Please let me know that if you want to see > any PostgreSQL related software in the repository. I do have time to > package all related stuff. Do you think you could have a way to sto

Re: [GENERAL] Dblink and connections to MySQL?

Brian Maguire wrote: Does anyone have any recommendations or experiences on connecting a postgres db to a mysql db possibly through dblink or another technology? Does dblink just do postgres to postgres? There is not a lot documentation on that contrib. What brings you to that conclusion? d

Re: [GENERAL] Fwd: How to convert a string to bytea?

# [EMAIL PROTECTED] / 2006-08-30 12:22:47 -0400: > -- Forwarded message -- > From: Chris Hoover <[EMAIL PROTECTED]> > Date: Aug 30, 2006 12:22 PM > Subject: How to convert a string to bytea? > To: "pgsql-admin@postgresql.org" > > I am in need of some help. I need to use the encod

Re: [GENERAL] Dblink and connections to MySQL?

Hi Brian, Dblink is for postgresql to postgresql, you have to use DBI-Link for connections to other databases. http://pgfoundry.org/projects/dbi-link/ -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Adminis

Re: [GENERAL] Listening on more than one port?

On Wed, Aug 30, 2006 at 02:42:58PM -0500, Michael Nolan wrote: > I need to be able to have postmaster (8.1.2) listen on more than one port, > eg, 5432 and some other port, such as 5431. Why? > If I set up a TCP port redirector like rinetd, to forward packets from port > 5431 to port 5432 it appea

Re: [GENERAL] Postgresql mentioned on Newsforge MySQL article

On Wed, Aug 30, 2006 at 01:54:56PM -0400, Robert Treat wrote: > Seems they are fast where it counts... namely getting a team of developers on > top of the contest so they come out shining. Too bad people in this > community don't see the value of paying people to do advocacy related > developme

Re: [GENERAL] plz unsubscribe me

# [EMAIL PROTECTED] / 2006-08-30 14:11:11 -0400: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > So I don't think we should do anything about it. It's not really a > > serious problem. > > Actually, what I'd like to see done is to get majordomo to bounce list > messages containing "unsubscribe"

Re: [GENERAL] plz unsubscribe me

# [EMAIL PROTECTED] / 2006-08-30 12:32:21 -0500: > There are good reasons why that is not a feature found in many popular > email clients. The biggest of which is that if it was people would use > it all the time and spammers would abuse it as a way to cull current > email addresses. IOW g

Re: [GENERAL] Postgresql mentioned on Newsforge MySQL article

On Aug 30, 2006, at 16:11 , Martijn van Oosterhout wrote: On Wed, Aug 30, 2006 at 01:54:56PM -0400, Robert Treat wrote: Seems they are fast where it counts... namely getting a team of developers on top of the contest so they come out shining. Too bad people in this community don't see the v

Re: [GENERAL] Dblink and connections to MySQL?

On Wednesday 30 August 2006 15:41, Tony Caduto wrote: > Hi Brian, > Dblink is for postgresql to postgresql, you have to use DBI-Link for > connections to other databases. > http://pgfoundry.org/projects/dbi-link/ Note that you can use some of the pl functions themselves to accomplish this as well

Re: [GENERAL] plz unsubscribe me

Roman Neuhauser wrote: > # [EMAIL PROTECTED] / 2006-08-30 14:11:11 -0400: > > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > > So I don't think we should do anything about it. It's not really a > > > serious problem. > > > > Actually, what I'd like to see done is to get majordomo to bounce list >

Re: [GENERAL] plz unsubscribe me

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane opined: > Actually, what I'd like to see done is to get majordomo to bounce list > messages containing "unsubscribe" in the subject, with an explanatory > message about the right way to unsubscribe. There's no reason the rest > of us should

Re: [GENERAL] plz unsubscribe me

On Wednesday 30 August 2006 14:14, Joshua D. Drake wrote: > Tom Lane wrote: > > Alvaro Herrera <[EMAIL PROTECTED]> writes: > >> So I don't think we should do anything about it. It's not really a > >> serious problem. > > > > Actually, what I'd like to see done is to get majordomo to bounce list >

Re: [GENERAL] Dblink and connections to MySQL?

Brian Maguire wrote: Does anyone have any recommendations or experiences on connecting a postgres db to a mysql db possibly through dblink or another technology? Does dblink just do postgres to postgres? There is not a lot documentation on that contrib. You could probably use DBIlink for that.

Re: [GENERAL] Postgresql mentioned on Newsforge MySQL article

Martijn van Oosterhout wrote: On Wed, Aug 30, 2006 at 01:54:56PM -0400, Robert Treat wrote: Seems they are fast where it counts... namely getting a team of developers on top of the contest so they come out shining. Too bad people in this community don't see the value of paying people to do adv

Re: [GENERAL] Listening on more than one port?

On 8/30/06, Martijn van Oosterhout wrote: On Wed, Aug 30, 2006 at 02:42:58PM -0500, Michael Nolan wrote:> I need to be able to have postmaster (8.1.2) listen on more than one port,> eg, 5432 and some other port, such as 5431.Why? Situation in a nutshell:Production  and test data

Re: [GENERAL] Listening on more than one port?

If you need to run two separate databases on the same box, each with its own port, then having two clusters would be one way to go. Each cluster has its own postgresql.conf and so each cluster can be (must be, if I'm not mistaken) configured to listen on a separate port. -

Re: [GENERAL] Postgresql mentioned on Newsforge MySQL article

On Wednesday 30 August 2006 16:48, Joshua D. Drake wrote: > Martijn van Oosterhout wrote: > > On Wed, Aug 30, 2006 at 01:54:56PM -0400, Robert Treat wrote: > >> Seems they are fast where it counts... namely getting a team of > >> developers on top of the contest so they come out shining. Too bad >

[GENERAL] Installing on Redhat 7.2

Hello all!   I'm trying to install postgresql and I'm getting the following error;   error: failed dependencies:    libc.so.6(GLIBC_2.3)   is needed by postgresql-8.1.4-3PGDG    libcrypto.so.4   is needed by postgresql-8.1.4-3PGDG    libpq.so.4   is needed by postgresql-8.1.4-

Re: [GENERAL] Installing on Redhat 7.2

On Aug 30, 2006, at 2:49 PM, Dennis Reaves wrote: Hello all! I'm trying to install postgresql and I'm getting the following error; error: failed dependencies: libc.so.6(GLIBC_2.3) is needed by postgresql-8.1.4-3PGDG libcrypto.so.4 is needed by postgresql-8.1.4-3PGDG

Re: [GENERAL] Installing on Redhat 7.2

On Wednesday 30 August 2006 14:49, "Dennis Reaves" <[EMAIL PROTECTED]> wrote: > Any suggestion on trying to resolve this? I can't seem to find anything > that helps. a) install an operating system that isn't >5 years old. or b) try rebuilding packages from the source RPM. or c) install from sou

Re: [GENERAL] Installing on Redhat 7.2

"Dennis Reaves" <[EMAIL PROTECTED]> writes: > Hello all! > > I'm trying to install postgresql and I'm getting the following error; > > error: failed dependencies: > libc.so.6(GLIBC_2.3) is needed by postgresql-8.1.4-3PGDG > libcrypto.so.4 is needed by postgresql-8.1.4-3PGDG

Re: [GENERAL] Installing on Redhat 7.2

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Steve Atkins wrote: > > On Aug 30, 2006, at 2:49 PM, Dennis Reaves wrote: [snip] > I've no doubt that current Postgresql versions will compile from > source and run on 7.2, but you're fairly unlikely to find RPMs Really? Most system libraries have c

[GENERAL] Dependency graph of all tuples relied upon in a query answer

I'm storing facts about an entity (e.g., "company") in a normalized form with various repeating groups, link tables, etc. My workflow requires that after (or as part of) collecting these facts, I be able to "sign off" as having verified all of the facts that pertain to a given company. I understa

Re: [GENERAL] Installing on Redhat 7.2

On Aug 30, 2006, at 4:10 PM, Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Steve Atkins wrote: On Aug 30, 2006, at 2:49 PM, Dennis Reaves wrote: [snip] I've no doubt that current Postgresql versions will compile from source and run on 7.2, but you're fairly unlikely to f

Re: [GENERAL] Installing on Redhat 7.2

Alan Hodgson wrote: > On Wednesday 30 August 2006 14:49, "Dennis Reaves" <[EMAIL PROTECTED]> wrote: >> Any suggestion on trying to resolve this? I can't seem to find anything >> that helps. > > a) install an operating system that isn't >5 years old. > > or b) try rebuilding packages from the sou

Re: [GENERAL] Postgresql mentioned on Newsforge MySQL article

Martijn van Oosterhout wrote: On Wed, Aug 30, 2006 at 01:54:56PM -0400, Robert Treat wrote: Seems they are fast where it counts... namely getting a team of developers on top of the contest so they come out shining. Too bad people in this community don't see the value of paying people to do ad

Re: [GENERAL] Installing on Redhat 7.2

Doug: Thanks a-lot; that worked perfectly! Thanks, -Dennis - Original Message - From: "Douglas McNaught" <[EMAIL PROTECTED]> To: "Dennis Reaves" <[EMAIL PROTECTED]> Cc: Sent: Wednesday, August 30, 2006 6:49 PM Subject: Re: [GENERAL] Installing on Redhat 7.2 "Dennis Reaves" <[EMAIL

Re: [GENERAL] Listening on more than one port?

On 8/30/06, Michael Nolan <[EMAIL PROTECTED]> wrote: Situation in a nutshell: Production and test databases are on two separate systems inside the firewall. The web server is at an ISP, outside the firewall. The firewall sends all data coming from the ISP, port 5432 to a specific IP address i

[GENERAL] pg_config --includedir is null

G'day After a successful make install of postgresql-8.1.3 with msys and mingw pg_config --includedir is null ... I want to to show the correct includedir to allow libpqxx to compile. Any clues on how to recompile postgres or pg_config to show the correct directories? Thanks in advance -- Keith