Hi,
I am trying install the postgresql-7.4.3 simple
installation. I did ./configure command at the postgresql directory source.
While the configuring proccess I receiving the follow message:
checking for tar... /bin/tarchecking for
strip... stripchecking whether it is possible to strip li
Ð ÐÑÐ, 20.06.2004, Ð 17:44, kumar mcmillan ÐÐÑÐÑ:
> hi.
> I am using a pseudo "pivot table" SQL query to generate a report butI
> am totally stumped on why the COUNT() function isn't getting me
> theexpected results and was wondering if anyone has some ideas...
>
> it is for a statistical report s
hi.
I am using a pseudo "pivot table" SQL query to generate a report but I am totally stumped on why the COUNT() function isn't getting me the expected results and was wondering if anyone has some ideas...
it is for a statistical report showing which lead source a member followed when creating a p
> -Original Message-
> From: Peter Eisentraut [mailto:[EMAIL PROTECTED]
> Sent: 20 June 2004 14:07
> To: Tim Robinson; [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Help please - completely baffled by quoting
>
>
> Tim Robinson wrote:
> > select * from temp where a like 'a\\\'%'
> >
>
"NTPT" <[EMAIL PROTECTED]> writes:
> I recently compile Postgresql 7.4.3 with gcc 3.4.0 on RH 7.3 . Regression t=
> ests work well All passed, but
> Some binaries report a relocation error: :pg_dumpall undefined symbol get_p=
> rogname .=20
> This error occures in most of the binaries. What is wron
It means you have an old version of the PostgreSQL libraries in your
library search path.
---
NTPT wrote:
> Regardi
>
> I recently compile Postgresql 7.4.3 with gcc 3.4.0 on RH 7.3 . Regression tests work
> well All passed
"Tim Penhey" <[EMAIL PROTECTED]> writes:
> This has been a bit of a point of confusion for me.
>
> When do you use pg_restore vs. psql -f dumped.sql?
If you used the 'custom' or 'tar' formats of pg_dump, you need to use
pg_restore. If you dumped as straight SQL (the default), just feed
the dump
Tommy Gildseth <[EMAIL PROTECTED]> writes:
> ERROR: could not read block 6 of relation
> "pg_proc_proname_args_nsp_index": Input/output error
> I'm not really sure what's going on here, and how serious this is.
It's not good --- it means your disk has developed an unreadable block.
You can get
Tim Robinson wrote:
> select * from temp where a like 'a\\\'%'
>
> this should return all strings starting with a\' but it returns
> nothing!!!
\ is also the quoting character of LIKE, in addition to being a quoting
character on the string literal level. If you want all strings
starting w
Hi,
I generally consider myself competent with the complexities of quoting but I
can't figure out postgres at all. I've read the manual and it looks very
straightforward but that doesn't accord with my experiences. Here's an
example:
create table temp (a varchar(50));
insert into
Regardi
I recently compile Postgresql 7.4.3 with gcc
3.4.0 on RH 7.3 . Regression tests work well All passed, but
Some binaries report a relocation error:
:pg_dumpall undefined symbol get_progname .
This error occures in most of the binaries. What is
wrong ?
Installation of 7.4.2, even with just ./configure : gmake step ==>
_
gmake[4]: Leaving directory
`/usr/home/smith/Temp_holding/staging-area/postgresql/postgresql-7.4.2/src/backend/parser'
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmi
The first thing I made was vacuum/analyze them. Then I deleted and rebuilt the
indicies but the problem remained. So I created a new table (e_catalogo2) with new
indicies, I copied all data from the old table to the new one, weirdly the problem was
solved. In my opinion there is something wrong
I am moving my database from a machine running 7.4 to a machine running 7.2. My
sequences are not out of wack, is there a way to set the current value of a
sequence? I though ALTER SEQUENCE would work but it does not exist in version 7.2.
Thanks,
~S
---(end of broadcast)
dear groups,
how to view the trigger definition (i.e create trigger ) which
has already been created in the postgres. (iam working in linux terminal).
yours sincerely,
SathishKumar.S
---(end of broadcast)---
TIP 3: if posting/reading through
I need to limit the connection number per each user.
How can I do this?
Stanislaw Tristan
Kyiv, Ukraine
E-mail: [EMAIL PROTECTED]
I've got a standard setup on Debian woody, with postgreSQL backports
from http://people.debian.org/~elphick
Last night, I started getting mails from the cron daemon that this command:
/usr/bin/test -x /usr/lib/postgresql/bin/do.maintenance &&
/usr/lib/postgresql/bin/do.maintenance -a -F
was spit
Shea Martin wrote:
I am moving my database from a machine running 7.4 to a machine running
7.2. My sequences are not out of wack, is there a way to set the
current value of a sequence? I though ALTER SEQUENCE would work but it
does not exist in version 7.2.
Thanks,
~S
I honestly did to google
Scot L. Harris wrote:
>
> I just recently upgraded from 7.2.4 to 7.4.2 postgresql. What I did was
> a pg_dumpall to save my databases. Then after the upgrade I did a
> pg_restore using the saved dump file. Worked perfectly for me.
>
> After I installed the new version of postgresql I did a ini
19 matches
Mail list logo
