Thanks that did itPatrick Hatcher-Martin Marques <[EMAIL PROTECTED]> wrote: -To: "Patrick Hatcher" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]From: Martin Marques <[EMAIL PROTECTED]>Date: 2003-11-22 03:08PMSubject: Re: [GENERAL] error loading shared libraries: libpq.so.3El Sáb 22 Nov 2003 17:20,
I did initdb -D /var/lib/pgsql/data. I downloaded the
attached script from this message -
http://archives.postgresql.org/pgsql-general/2003-11/msg01258.php
- and will give that a try. (I was getting the same
"old version" errors as well.)
CSN
--- Lamar Owen <[EMAIL PROTECTED]> wrote:
> On Satur
On Saturday 22 November 2003 06:07 pm, CSN wrote:
> Is there an updated version of Lamar Owen's linux
> startup script available? It initializes the database
> on first invocation after initdb has been done
> manually (even after changing all 7.3's to 7.4's in
> the script), then gives an error on
El Sáb 22 Nov 2003 20:07, CSN escribió:
> Is there an updated version of Lamar Owen's linux
> startup script available? It initializes the database
> on first invocation after initdb has been done
> manually (even after changing all 7.3's to 7.4's in
> the script), then gives an error on subsequent
Is there an updated version of Lamar Owen's linux
startup script available? It initializes the database
on first invocation after initdb has been done
manually (even after changing all 7.3's to 7.4's in
the script), then gives an error on subsequent startups.
__
Do
On Thu, Nov 20, 2003 at 09:33:48PM +0530, Durai wrote:
> How to test the "Multiuser testing" in PostgreSQL?. I used
> the apache bench "ab" tool for this one.
For a real world test you would need several scripts doing different
things: updates to different rows, in
El Sáb 22 Nov 2003 17:20, Patrick Hatcher escribió:
> Doing an upgrade on RH 8 box from 7.3.4 to 7.4 from source. The
> installation appeared go smoothly. I tried to reinstall my database using
> psql -d someda -f data.file and I get the error message:
> error while loading shared libraries: libp
Yep.
http://archives.postgresql.org/pgsql-general/2003-11/msg00852.php
On Sat, 2003-11-22 at 12:44, CSN wrote:
> Is it possible to iterate over an array in plpgsql?
> Something like:
>
> function insert_stuff (rel_ids int[])
> ...
>
> foreach rel_ids as id
> insert into table (rel_id, val)
>
Is it possible to iterate over an array in plpgsql?
Something like:
function insert_stuff (rel_ids int[])
...
foreach rel_ids as id
insert into table (rel_id, val)
values (id, 5);
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
Doing an upgrade on RH 8 box from 7.3.4 to 7.4 from source. The
installation appeared go smoothly. I tried to reinstall my database using
psql -d someda -f data.file and I get the error message:
error while loading shared libraries: libpq.so.3: cannot open shared
object file: No such file or dir
On Sat, 22 Nov 2003, Rajesh Kumar Mallah wrote:
> How come numeric(10,2) accepting value 10.011 and truncating the .001
> part ? Shudnt' it be complaining , i am not sure.
AFAICS, the spec says that implementation-defined rounding or truncation
occurs if least significant digits would be lost.
On Tue, 18 Nov 2003, Rick Gigger wrote:
> I will search the archives but does anyone know off the top of their head
> which performs better?
lo_* but then I forgot to turn off compression on the bytea column.
--
Nigel Andrews
>
> - Original Message -
> From: "Keith C. Perry" <[EMAIL
[EMAIL PROTECTED] writes:
> I think the original driving thought technically has something to do with
> system backup, and restore or system re-install in the case of
> catastrophic failure, as well as what I've alluded to in regards to
> original server setup planning and how intended usage imp
Hello:
I am a new user of postgresql. I am using postgresql 7.3.4 and I had
inserted about 1.7 million records to a table. When I vacuum / select * from
table, it gets a error message of : Invalid page header in block xxx of
TableA. I check that I still can insert records to the table. But I am
Hi,
How come numeric(10,2) accepting value 10.011 and truncating the .001
part ? Shudnt' it be complaining , i am not sure.
Regds
Mallah.
tradein_clients=# CREATE TABLE t_a ( a numeric (10,2) );
CREATE TABLE
tradein_clients=#
tradein_clients=#
tradein_clients=# \d t_a
Table "publ
Hi,
I am looking for an open source (free) data modeling tool for PostgreSQL.
It should - if possible - support:
- E-R-Modelling
- relational data model / modeling
- (GUI SQL interface to the database)
- platform independence (Win32, Mac, Unix/Linux)
Does anybody know some tools that match my cr
Thanks Tom. I don't mind having to start it again and again at server
reboots, as I only intend to use it for testing for now.
So how can I execute it inside my own folder? Do I need to give any
special commands? Is there any FAQ for this?
Thanks,
Erick
__
Do
17 matches
Mail list logo
