Phil wrote:
> I want to develop an app which uses libpq, built with mingw.
> Is there a download package which contains just the include files/dlls?
> If not, what package do I download? I don't need the server, just the client
> libraries.
You can use the regular binary installer for Windows,
it
Hello
2009/6/10 Tom Lane :
> "Atul Chojar" writes:
>> So in 8.3.7, the incrementing of the for-loop variable "idx" is being
>> ignored; that is not the case in 8.2.7. Is this a new feature of 8.3.7 or a
>> bug?
>
> It's the new implementation. Depending on unspecified implementation
> details is
Josh Berkus wrote:
On 6/10/09 7:20 PM, Christophe wrote:
On Jun 10, 2009, at 6:27 PM, Chris wrote:
Can you list the filesizes on http://media.postgresql.org/sfpug/ please?
Oh, good idea. Didn't think of it.
Thanks :D
--
Postgresql & php tutorials
http://www.designmagick.com/
--
Sent vi
On 6/10/09 7:20 PM, Christophe wrote:
On Jun 10, 2009, at 6:27 PM, Chris wrote:
Can you list the filesizes on http://media.postgresql.org/sfpug/ please?
Oh, good idea. Didn't think of it.
--Josh
--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com
--
Sent via pgsql-general mailing lis
On Jun 10, 2009, at 6:27 PM, Chris wrote:
Can you list the filesizes on http://media.postgresql.org/sfpug/
please?
Josh Berkus handles that page, but I think that's a splendid idea.
This particular video file is about 403MB.
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
Phil Longstaff wrote:
I want to develop an app which uses libpq, built with mingw. Is there a
download package which contains just the include files/dlls? If not,
what package do I download? I don't need the server, just the client
libraries.
Phil
If you dont mind all the ssl stuff (5 or 6 d
Christophe wrote:
Greetings,
The video from the June 9, 2009 SFPUG meeting, "PostgreSQL as a secret
weapon for high-performance Ruby on Rails applications," is now
available for viewing or download from the media.postgresql.org server:
http://media.postgresql.org/sfpug/sfpug-rails-20090609.
Greetings,
The video from the June 9, 2009 SFPUG meeting, "PostgreSQL as a secret
weapon for high-performance Ruby on Rails applications," is now
available for viewing or download from the media.postgresql.org server:
http://media.postgresql.org/sfpug/sfpug-rails-20090609.mov
Thanks,
-- X
I want to develop an app which uses libpq, built with mingw. Is there a
download package which contains just the include files/dlls? If not, what
package do I download? I don't need the server, just the client libraries.
Phil
Gus Gutoski writes:
> Naturally then, *every* record in the database has its "foreign_id"
> field set to 2 and its "coin" field set to 50. I *really* need to
> recover that "foreign_id" field. (As its name suggests, that field is
> a foreign key into a different table.)
Well, in principle you c
Hi,
I'm a noob who failed to properly sanitize incoming data from the
front end. As a result, a poor hapless user managed to smuggle in a
malicious UPDATE statement that corrupted every single record in a
7+ table. Only 3 fields were corrupted and of those only one is
vital. But it's REALLY
"Atul Chojar" writes:
> So in 8.3.7, the incrementing of the for-loop variable "idx" is being
> ignored; that is not the case in 8.2.7. Is this a new feature of 8.3.7 or a
> bug?
It's the new implementation. Depending on unspecified implementation
details is a good way to have broken code.
We recently upgraded from postgres version 8.2.7 to 8.3.7. The below
pl/pgsql test function behaves differently in the 2 versions.
The code of the function is :-
CREATE OR REPLACE FUNCTION "public"."testloop" () RETURNS varchar AS
$body$
BEGIN
FOR idx IN 1..10 LOOP
raise not
Tom Lane wrote:
Andreas Wenk writes:
EXECUTE 'INSERT INTO produkte
(art_nr,bezeichnung,beschreibung,preis,steuersatz,aktionspreis,stichworte,vector)
VALUES
('''||art_nr||''','''||bezeichnung||''','''||beschreibung||''','||preis||',
'||steuersatz|
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
First of all thank you very much to everyone that shared their views
on the task at hand!
I've actually accomplished it using MRTG :)
BR,
Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam
Bill Moran wrote:
> In response to Pedr
Andreas Wenk writes:
> EXECUTE 'INSERT INTO produkte
> (art_nr,bezeichnung,beschreibung,preis,steuersatz,aktionspreis,stichworte,vector)
> VALUES
> ('''||art_nr||''','''||bezeichnung||''','''||beschreibung||''','||preis||',
>
> '||steuersatz||','||a
Hi everybody,
altough I know that the way over a Trigger is preferred, I can't see what is wrong in my
function. It must be an escaping error:
CREATE OR REPLACE FUNCTION
user_insert_vector_data(text,text,text,numeric,numeric,numeric,text)
RETURNS void AS
$$
DECLARE
art_nr ALI
In response to Pedro Doria Meunier :
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Thank you Bill for your tip.
>
> As far as the table's name is concerned the only one I can find is
> 'pg_statistic' (under pg_catalog). I'm using PGSQL 8.2.9 on x86_64.
Can't imagine why you're not seein
On Wed, 2009-06-10 at 15:29 +0100, Pedro Doria Meunier wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Thank you Bill for your tip.
>
> As far as the table's name is concerned the only one I can find is
> 'pg_statistic' (under pg_catalog). I'm using PGSQL 8.2.9 on x86_64.
>
> BR,
h
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thank you Bill for your tip.
As far as the table's name is concerned the only one I can find is
'pg_statistic' (under pg_catalog). I'm using PGSQL 8.2.9 on x86_64.
BR,
Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam
Bill Moran wrote:
"Nykolyn, Andrew P (AS)" writes:
>> Sounds like you are trying to use an 8.3 client program with an 8.2
>> version of libpq.so.
> Why would the new install of 8.3.5 be using an 8.2 version of libpq.so
It's the same major version number, ie libpq.so.5, so if you'd failed to
replace 8.2 with 8.3 t
In response to Pedro Doria Meunier :
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi all
>
> I've googled for an answer but couldn't find one.
> Is there anyway to monitor the average connections to a database?
>
> Thank you in advance for any insights.
The pg_stat_activity table hold
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all
I've googled for an answer but couldn't find one.
Is there anyway to monitor the average connections to a database?
Thank you in advance for any insights.
BR,
- --
Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam
-BEGIN PGP SI
"Nykolyn, Andrew P (AS)" writes:
> I have successfully installed 8.3.5 as a fresh install on a Redhat 4.5
> machine. Now I try to upgrade another Redhat 4.5 machine with an
> existing 8.2.4 install and the "make check" fails all tests. When I
> look at the results file for each type being tes
On 2009-06-09, Grzegorz Jaśkiewicz wrote:
> 2009/6/9 Brandon Metcalf :
>
>
>> I'm not sure I follow how this solves the problem.
>
> Well, surely if you just need one row, you need single value per key.
> And that's the, imo , better solution to that problem, than limiting
> number of rows.
not r
In response to "Preeti Khurana" :
> I checked the release notes till 8.1.17, but could not come across any such
> issue which leads to db performance degradation after doing heavy db
> operations.
I don't think that was his point. I expect it was something more along the
lines of crashing bugs
2009/6/10 Preeti Khurana :
> I checked the release notes till 8.1.17, but could not come across any such
> issue which leads to db performance degradation after doing heavy db
> operations. AutoVacuum is also enabled parallel.
Note that you might be much better served moving to 8.3 if HOT can
he
I checked the release notes till 8.1.17, but could not come across any such
issue which leads to db performance degradation after doing heavy db
operations. AutoVacuum is also enabled parallel.
-Original Message-
From: Grzegorz Jaśkiewicz [mailto:gryz...@gmail.com]
Sent: Monday, June
28 matches
Mail list logo