On Mon, Feb 21, 2005 at 12:47:58PM +0530, Surabhi Ahuja wrote:
> cc -I/usr/local/pgsql/includesample.c -L/usr/local/pgsql/lib -lpq -o
> sample
> I then run itand it gives and error
> [indra:/homes/surabi] ./sample
> ./sample: error while loading shared libraries: libpq.so.3: cannot open
i have
written a program sample.cit is as folllows:
#include#include
int
main(){ PGconn *myconnection =
PQconnectdb("");
printf("Hi"); return
0;}
I then compile this program using
makefile
make samplecc
-I/usr/local/pgsql/include sample.c
-L/usr/local/pgsql/lib -l
Hello!
Finally the time has come for us to upgrade our PostgreSQL 7.4.5-servers to
8.0.1 - and though I'm very much looking forward to some of the new features,
the dump&reload process is worrying me a bit this time. I've got one cluster in
particular which is roughly 9GB in size and features s
I made the same experience now with PG 8.01, FC3 and 512MB memory. The previous
was PG 7.4.6, FC2 and 1GB.
The difference in performance between kernels 2.6.9-1.724 and 2.6.10-1.766 is
still huge.
I notice that in 2.6.10 the function accesses the disk much more.
Does anyone know what changes fro
PostGresQL 8 beta1.
PGAdmin III beta 1.21
Is there a way to see what error code or error message occured when an error
happens?
I am trying to perform exception handling and a create view that included
another view that did not exist occured in a plpgsql function.
I finally figured out that the er
[EMAIL PROTECTED] ("Ed L.") writes:
>
> Workin' on gdb/strace build, but having trouble with both. Gdb
> just doesn't build from source, not sure why yet, and no depots
> found at porting center. It doesn't appear that strace is
> supported for 11.23 itanium based on strace README/PORTING fi
Hello everyone.
I am a recent convert from quite an old version of MySQL. I have an ancient
business app/database that I dump into MySQL overnight, then run a whole set of
queries on to form tables that users then query using Excel DSN.
Up to now, because MySQL didn't have subqueries, these routi
Even if the function did a select from d, it could still have plenty of
duplicates. To remove that possibility you would have to use the distinct
clause which is also generally less efficient then a group by.
"Bruno Wolff III" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Sat, F
The core part of the code was posted by Tom Lane. It would have taken me a
lot longer without that push.
One of the most frustrating things, IMHO, about PostGreSQL is the fact that
when I wanted to change a view, even slightly by adding a new column, I
would have to first drop it along with all th
hi, is it possible to change the user's password from a stored
procedure or a funcion? I mean , is there a system function/stored
procedure that can do it? like the dbo.sp_password found in Adaptive
server anywhare?
thanks in advance
Hugo
---(end of broadcast)---
There is a program called pgdiff.. but I could not really make it work and it
seems to be quiet old and unmaintained: http://pgdiff.sourceforge.net/
Martin
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://w
You can always do an insert and add a trigger that checks the key for
existence. If it exists do the update instead.
That way you have one line of code doing both inserts and updates.
The only problem with it is that it looks confusing from an outsiders
perspective, so it would have to be document
On Wed, Feb 16, 2005 at 06:16:36PM -0700, Pritesh Shah wrote:
> hi,
>
> I would like to thank everybody for their responses to my question. I
> tried a couple of things and the best thing for me was to use
> utils/postgis_restore.pl script.
>
> I ran this script on some sample databases and they
Thanks Tom,
It took me the better part of the day but I banged out a fully working
function.
Sim
"Tom Lane" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Sim Zacks" <[EMAIL PROTECTED]> writes:
> > I am trying to write a query on the pg_depend table and it is confusing
the
> > he
Bruce,
On another note, is there plans to improve the type checking of stored
functions during the save/compile?
Currently I can pretty much make tons of mistakes (on purpose of course
:-) and they are not flagged as errors until runtime.
The biggest complaint I see from other DBAs (MS SQL, Oracl
Ragnar Hafstað wrote:
On Sun, 2005-02-20 at 18:18 -0500, phil campaigne wrote:
Yes Gnari it works now!
all I had to do in addition to your advice was alias the sub select:
hardwoodthunder=# select
player_number,player_name,cum_score,sum(a),sum(c),sum(t) from ( select
player_number, player_na
On Sun, 2005-02-20 at 18:18 -0500, phil campaigne wrote:
> Yes Gnari it works now!
> all I had to do in addition to your advice was alias the sub select:
>
> hardwoodthunder=# select
> player_number,player_name,cum_score,sum(a),sum(c),sum(t) from ( select
> player_number, player_name, cum_scor
Yes Gnari it works now!
all I had to do in addition to your advice was alias the sub select:
hardwoodthunder=# select
player_number,player_name,cum_score,sum(a),sum(c),sum(t) from ( select
player_number, player_name, cum_score, (select player_points where
aspect='A') as A ,(select player_points
Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
> In postgresql.conf, we have such a sentence:
> "Some settings, such as listen_address, require a postmaster shutdown and
> restart to take effect."
> Which other parameter changes requires a restart? Do we have a doc on
> this?
http://www.postgresql.o
Good thinking, it works :)
Thanks.
On Sat, 19 Feb 2005 16:53:52 -0800 (PST), Stephan Szabo
<[EMAIL PROTECTED]> wrote:
> On Sun, 20 Feb 2005, Vitaly Belman wrote:
>
> > I have the following plpgsql function:
> >
> > CREATE OR REPLACE FUNCTION public."temp"(int4)
> > RETURNS public.books AS
> >
On Sun, 2005-02-20 at 16:32 -0500, phil campaigne wrote:
> hardwoodthunder=# select player_number, player_name, cum_score, (select
> player_points where aspect='A') as A ,(select player_points where
> aspect='C') as C, (select player_points where aspect='T') as T from
> (select * from player as
I see that I need another qualifier, cum_score in the select statement,
but I still need to consolidate the rows:
hardwoodthunder=# select player_number, player_name, cum_score, (select
player_points where aspect='A') as A ,(select player_points where
aspect='C') as C, (select player_points whe
Hi myself,
On Sun, 20 Feb 2005, Devrim GUNDUZ wrote:
In postgresql.conf, we have such a sentence:
"Some settings, such as listen_address, require a postmaster shutdown and
restart to take effect."
Which other parameter changes requires a restart? Do we have a doc on
this?
I think I've found it:
htt
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
In postgresql.conf, we have such a sentence:
"Some settings, such as listen_address, require a postmaster shutdown and
restart to take effect."
Which other parameter changes requires a restart? Do we have a doc on
this?
Regards,
- --
Devrim GUND
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I don't use PostgreSQL in Windows, I was just merely verifying that
this guy isn't the only one having this kind of problem, and yes this
is a Mac. I run my PostgreSQL db in Solaris, Linux and Mac OS X :-)
- -
Jonel Rienton
http://blogs.road14.c
On Sun, 2005-02-20 at 10:45, Lincoln Yeoh wrote:
> I'm not an expert.
>
> Turn off tab completion? It's probably scanning through all the possible
> table names and the algorithm used is probably not designed for that
> number. And with 42000 tables, tab completion may not be that helpful.
>
>
Hi all,
I'm haveing trouble writing a select statement that gives me a resulting
row like this:
player_number, player name,a,c,t, (total of a+c+t).
here's what I have so far but it puts the a,c,t in separate rows.
hardwoodthunder=# select (select player_points where aspect='A') as
A,(select play
Greg wrote:
> is "DROP TRIGGER" transaction safe?... I mean, could I do:
>
> BEGIN
> DROP TRIGGER category_mv_ut;
> ... insert rows
> ... update materialized view table
> CREATE TRIGGER category_mv_ut AFTER UPDATE ON items
> FOR EACH ROW EXECUTE PROCEDURE update_ut();
> COMMIT;
>
> .. without oth
Lincoln Yeoh wrote:
> I'm not an expert.
>
> Turn off tab completion? It's probably scanning through all the
> possible table names and the algorithm used is probably not designed
> for that number. And with 42000 tables, tab completion may not be
> that helpful.
>
> Don't use ext2/ext3? There
On Sat, 19 Feb 2005 12:01:07 -0600, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
On Sat, Feb 19, 2005 at 18:04:32 +0100,
charlie clark <[EMAIL PROTECTED]> wrote:
Dear list,
is there a simple way to change the way ORDER BY works on columns with
NULLs? I can understand the need for default behaviour
I'm not an expert.
Turn off tab completion? It's probably scanning through all the possible
table names and the algorithm used is probably not designed for that
number. And with 42000 tables, tab completion may not be that helpful.
Don't use ext2/ext3? There are other filesystems on Linux which
I assume this is also VirtuaL PC on the mac, right? I've been using
VirtualPC on the PC for a lot of th dev work on the intaller, and it
should certaily work there..
Does this only occur with win2k, or does it also occur with
XP/2003/whatever?
In the end I doubt there is much we can do, it seems
Dear Postgresql experts,
I have a single database with one schema per user. Each user has a
handful of tables, but there are lots of users, so in total the database
has thousands of tables.
I'm a bit concerned about scalability as this continues to grow. For
example I find that tab-completion
33 matches
Mail list logo
