I am trying to compile postgresql 7.4.1 for sco 5.0.5 and get the following error:
"thread.c", line 269: error: undefined symbol: h_errno
Any ideas?
./configure --with-libs=/usr/local/lib --with-includes=/usr/local/include
herbie!/tmp/postgresql-7.4.1 # gmake
gmake -C doc all
gmake[1]: Entering
Up too late. This works fine. At least it works for some simpler test
functions under the just-downloaded 7.4.1 release.
-- Ezra Epstein
"ezra epstein" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I'm been banging my head over this for a little while now.
>
> Here's a simple fu
It's rumoured that Brian Hirt once said:
> What type bandwidth can you
> expect to use if you become a mirror (1meg/sec? more less?)
I honestly couldn't say, but I would suspect it would be a *lot* less than
that. Whilst PostgreSQL is popular, the type of application that it is
means that it will
I doubt there is a general rule as to which is better, it will depend
upon the individual circumstances (including budget).
It is my experience that 0+1 is a bit faster that RAID 5.
Sincerely,
Joshua D. Drake
Were you told why that was the wrong choice?
--
Mike Nolan
Dave,
I can go about setting up a web mirror, but i cannot offer a download
mirror if we have to use ftp. Our security policies are not to allow
ftp access. It's just one more thing to worry about if we open up our
firewall. I hope you understand. Will it be a problem only offer the
web
> > Use RAID 5 or 0+1...
> I have had the Mirroring vs RAID 5 debate before.
> You would go with RAID 5 to obtain the fault tolerance.
>
> That was my first choice but I was told I was wrong.
I doubt there is a general rule as to which is better, it will depend
upon the individual circumstances (
On Tue, 23 Dec 2003 [EMAIL PROTECTED] wrote:
> I just installed RH9 on a new machine and installed postgres in the
> installation process. I got the following error when trying to
> start the postmaster so... I tried removing the postgres software
> then reinstalling. rpm first said the softwa
On Tue, Dec 23, 2003 at 02:06:14AM -0500, George Gensure wrote:
> EXEC SQL SELECT * FROM foo() AS TBL( c int, i int );
>
> or any other query with multiple columns to a TBL description causes a
> segfault in ecpg. It also concerns me that all other symbols are
I just fixed this. The reason was a
kbd wrote:
Use RAID 5 or 0+1...
I have had the Mirroring vs RAID 5 debate before.
You would go with RAID 5 to obtain the fault tolerance.
That was my first choice but I was told I was wrong.
0+1 is RAID + STRIPE, it is (theoretically) faster than RAID 5 but
requires 4 disks where RAID 5 o
On Sun, 2003-12-21 at 18:49, Paul Ganainm wrote:
> [EMAIL PROTECTED] says...
> > > What then is a derived table, or is a derived table just a synonym for
> > > inline view?
>
> > I'm not sure what the "official" name for this is. I have heard both. So
> > from my point of view a derived table
Dear ezra epstein ;
Using Postgres 7.4,
the function "test" gets this: psql:temp3.sql:10: ERROR: syntax error
at or near "%" at character 135
the function "test2" gets this: psql:temp3.sql:10: ERROR: syntax error
at or near "ROWTYPE" at character 141
Very odd. The first doesn't even like t
ezra epstein wrote:
Aother head banger for me.
Below is a complete example of the code
Using Postgres 7.4,
the function "test" gets this: psql:temp3.sql:10: ERROR: syntax error
at or near "%" at character 135
the function "test2" gets this: psql:temp3.sql:10: ERROR: syntax error
at or nea
Aother head banger for me.
Below is a complete example of the code
Using Postgres 7.4,
the function "test" gets this: psql:temp3.sql:10: ERROR: syntax error
at or near "%" at character 135
the function "test2" gets this: psql:temp3.sql:10: ERROR: syntax error
at or near "ROWTYPE" at char
This is a fine approach. The FK will work fine. You'll probably want CatID
to be NOT NULL and CatParent to allow nulls. Having a Null parent
indicating root is easier for traversals.
Common other features to add include:
a "path" column that is maintaned by insert/update triggers. Quite
e
> Use RAID 5 or 0+1...
I have had the Mirroring vs RAID 5 debate before.
You would go with RAID 5 to obtain the fault tolerance.
That was my first choice but I was told I was wrong.
kd
[EMAIL PROTECTED] ("Joshua D. Drake") wrote in message news:<[EMAIL PROTECTED]>...
> >
> >
> >I am co
> -Original Message-
> From: Marc G. Fournier [mailto:[EMAIL PROTECTED]
> Sent: 23 December 2003 21:09
> To: Oliver Elphick
> Cc: Marc G. Fournier; Robert Treat; Dan Vande More;
> [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [webmaster] [GENERAL] Mirrors that don't suck.
>
> >
I'm been banging my head over this for a little while now.
Here's a simple function to return a record:
CREATE OR REPLACE FUNCTION create_item_record_for_override(INTEGER,
VARCHAR )
RETURNS RECORD AS '
DECLARE
recRECORD;
BEGIN
/* Normally we would not have a separ
http://mirror.ehpg.net/postgresql/ doesn't suck ;-) But I'm partial.
http://mirror.ehpg.net/postgresql/source/v7.4.1/ is a direct URL.
Gavin
Robert Treat wrote:
On Tue, 2003-12-23 at 13:39, Dan Vande More wrote:
Hey list, I'm just wondering if anyone can point me in the direction of a mirr
Hi Jan,
Thanks for the reply. I did come across the CREATE CONSTRAINT TRIGGER
doc page after my posting. It's not too well documented and seems to want
various parameters yet it's not clear what they'd be, so any pointers are
appreciated. My other two approaches were:
(a) Update the
> -Original Message-
> From: Marc G. Fournier [mailto:[EMAIL PROTECTED]
> Sent: 23 December 2003 20:48
> To: Joshua D. Drake
> Cc: Marc G. Fournier; Brian Hirt; Robert Treat;
> [EMAIL PROTECTED]; [EMAIL PROTECTED]; Dan Vande More
> Subject: Re: [webmaster] [GENERAL] Mirrors that don't
I just installed RH9 on a new machine and installed postgres in the
installation process. I got the following error when trying to
start the postmaster so... I tried removing the postgres software
then reinstalling. rpm first said the software was not installed
then when I tried to reinstall r
> See the "Client Interfaces" and possibly the "Server Programming"
> sections in the PostgreSQL manual:
> http://www.postgresql.org/docs/current/static/client-interfaces.html
> http://www.postgresql.org/docs/current/static/server-programming.html
> The examples in the contrib directory of the sour
Sorry about the cross posting ...
I am curently import data into rt 3 (3.0.7_01) and I have the following
message repeated in the logs for each binary Attachments:
+
[warning]: DBD::Pg::st execute failed: ERROR: invalid byte sequence for
encoding "UNICODE": 0xe0 at
/usr/li
ftp://ftp.au.postgresql.org/pub/postgresql/ is still only displaying
7.4.0 right now...
Marc G. Fournier wrote:
Send the details to webmaster@ so that the guys can add it to the database
... but, how are you mirroring? All official mirrors use rsync, and they
are auto-added to the list of mirro
Why don't you download the user's tutorial (pdf
format) from www.postgresql.org . It has quite
comprehensive discussion on joins
N Banerjee
--- Sai Hertz And Control Systems
<[EMAIL PROTECTED]> wrote: > Dear All,
>
> I was just looking for a nice in depth tutorial for
> JOINS
> would be greate
25 matches
Mail list logo
