Hi,
On Wed, 2012-09-12 at 20:51 -0700, Mike Christensen wrote:
> In file included from ../pgadmin/include/pgAdmin3.h:24:0,
> from ./pgAdmin3.cpp:13:
> ../pgadmin/include/ctl/ctlSQLBox.h:17:24: fatal error: wx/stc/stc.h:
> No such file or directory
> compilation terminated.
Here
Hello.
I'm pleased to annouce that multicorn 0.9.2 has been released, which is
compatible with PostgreSQL 9.2 (but not 9.1 anymore).
The last release compatible with PG 9.1 is 0.9.1.
Version 0.9.2 major feature is the ability to declare columns which can be
used as parameterized paths.
This m
I had same problem too.
My laptop : Windows 7 Pro 64bit and postgresql-9.2.0-1-windows-x64.exe.
But it ok when I install postgresql-9.2.0-1-windows.exe on my server
windows 2003 Ent 32 bit.
On Thu, Sep 13, 2012 at 12:59 PM, John R Pierce wrote:
> On 09/12/12 10:42 PM, Dann Corbit wrote:
>
>>
>
Hi Devrim,
Thank you for pointing these facts out. Very helpful and I now have my
installations working without issue.
Changing the scripts as you have done is very useful for parallel
installations. It will make my work easier.
Regards,
Jeremy
On 12/09/12 16:57, Devrim GUNDUZ wrote:
> Hi Jerem
maintenance_work_mem is already 4GB. How large should it be during load
then ?
Sébastien
On Thu, Sep 13, 2012 at 1:29 AM, John R Pierce wrote:
> On 09/12/12 10:01 PM, Sébastien Lorion wrote:
>
>> pgbench initialization has been going on for almost 5 hours now and still
>> stuck before vacuum st
Alex Lai writes:
>"EXPLAIN insert into alex1 (fileid, archiveset) select 35352974, 10003;"
> [vs]
>"EXPLAIN insert into alex1 (fileid, archiveset) select '35352974',
> '10003';"
You might be happier using INSERT ... VALUES instead of INSERT
... SELECT for this. In the former, the parser
On Thu, Sep 13, 2012 at 12:15 AM, Devrim GÜNDÜZ wrote:
>
> Hi,
>
> On Wed, 2012-09-12 at 20:51 -0700, Mike Christensen wrote:
>> In file included from ../pgadmin/include/pgAdmin3.h:24:0,
>> from ./pgAdmin3.cpp:13:
>> ../pgadmin/include/ctl/ctlSQLBox.h:17:24: fatal error: wx/stc/st
Good Morning everyone,
We have a interesting thing happening on one of our DB's that when
autovacuum runs against the pg_catalog tables (or we run a manual vacuum)
we get a large delay in opening new connections. If this happens during a
busy period on our system we end up getting 200-300 con
Greetings!
I would like to begin learning to use LINQ with PostgreSQL. Ideally, it would
be good to have free tools to do it, since I probably won't be finished playing
with it before 30 days are up and I'd have to pay for something. It would also
be good if whatever I use has a good set of t
I need to determine relationships between several tables. Is there a free tool
to extract these from catalog tables? Is there an SQL that also does this?
Thanks
Alex
Sent from my smartphone
Mike Roest writes:
>We have a interesting thing happening on one of our DB's that when
> autovacuum runs against the pg_catalog tables (or we run a manual vacuum)
> we get a large delay in opening new connections.
I think you're hitting the problem that was fixed here:
Author: Tom Lane
Bran
> I would like to begin learning to use LINQ with PostgreSQL. Ideally, it
> would be good to have free tools to do it, since I probably won’t be
> finished playing with it before 30 days are up and I’d have to pay for
> something. It would also be good if whatever I use has a good set of
> tutori
Replying partially to my own question:
I downloaded the Express provider from DevArt. I then set them an E-mail as
scornfully as I possibly could write suggesting that if they are going to
provide samples with their code, the samples should probably be tested at least
once.
We'll see if their
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Tom Lane replied:
> My recollection is that they're intentionally excluded because they
> would otherwise be security holes --- there are some format codes that
> allow direct access to memory, or something like that.
They are not part of th
BTW, they'll probably take a day to respond since they're all in the Ukraine :)
They also seem to respond to questions fairly quickly on
StackOverflow, if you use the DevArt tag.
On Thu, Sep 13, 2012 at 10:26 AM, Rob Richardson
wrote:
> Replying partially to my own question:
>
>
>
> I downloaded
Hi Tom,
On the test box this seems to have completely resolved our problem.
I'll be scheduling an upgrade on the production cluster to verify it.
Thanks
On Thu, Sep 13, 2012 at 11:08 AM, Tom Lane wrote:
> Mike Roest writes:
> >We have a interesting thing happening on one of our DB's t
After switching to PostgreSql 9.1 serializable transaction level for all
transactions during posting single document errors
40001:ERROR: could not serialize access due to read/write dependencies among
transactions
Reason code: Canceled on identification as a pivot, during write.;
started to app
Em 12/09/2012 21:50, Edson Richter escreveu:
Em 12/09/2012 15:09, Kevin Grittner escreveu:
VACUUM FREEZE VERBOSE ANALYZE
Sorry, most of the messages are in portuguese, but I guess numbers are
more important, right?
INFO: índice "pk_notafiscalarq" agora contém 715084 versões de
registros em
Edson Richter wrote:
> Anything else I can do from here?
Did that result in more accurate numbers for pg_class.reltuples?
-Kevin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
Sent: Wednesday, September 12, 2012 11:00 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] how long to wait on 9.2 bitrock installer?
On 09/12/12 10
I downloaded the LinqConnect demo, which is what I really need, and which seems
to work well. I'm unsure whether their Entity Developer tool is required with
it, or if I can get the context class I need for inclusion in a C# project some
other way, such as with something provided inside Visual
I use Devart dotconnect for Postgresql at work and love it. I use it for
inserting into and querying a database of regression test results. I also use
it for managing a database of crash reports. I can't say anything bad about it.
One of the cool features
I like a lot is the amount of Get functi
On 9/12/12 2:31 PM, Tom Lane wrote:
> "C" is the official name of that locale. Not sure how you got it to say
> "POSIX" ... maybe we didn't have normalization of the locale name back
> then?
Says who? I think C and POSIX are distinct locales that just happen to
behave the same way.
--
Sent v
AG> I need to determine relationships between several tables. Is there a
AG> free tool to extract these from catalog tables? Is there an SQL that
AG> also does this?
https://metacpan.org/module/DBIx::Class
It can't figure out m2m's though, for obvious reasons.
--
tetris is so unre
From: Alexander Gataric [mailto:gata...@usa.net]
Sent: Thursday, September 13, 2012 12:52 PM
To: pgsql-general@postgresql.org
Subject: Best free tool for relationship extraction
I need to determine relationships between several tables. Is there a free tool
to extract these from catalog tables? I
It looks to me like you're misusing git..
You should only git init once, and always use that directory.
Then pg_dump, which should create one file per database
with the file name you've specified.
Not sure of the flags but I'd recommend plain text format.
I'm also unsure what you mean by networ
I started db creation over, this time with 16GB maintenance_work_mem and
fsync=off and it does not seem to have a great effect. After again 5 hours,
during index creation, disk and cpu are barely used: 95% idle and 2-3 MB/s
writes (150 reads/s, 90 writes/s).
Sébastien
On Thu, Sep 13, 2012 at 1:29
On Thu, 13 Sep 2012 11:51:42 -0500 "Alexander Gataric" wrote:
> I need to determine relationships between several tables. Is there a free
> tool to extract these from catalog tables? Is there an SQL that also does
> this?
I've gotten good results with schemaspy.
--
Bill Moran
--
Sent via
On 09/13/12 2:08 PM, Sébastien Lorion wrote:
I started db creation over, this time with 16GB maintenance_work_mem
and fsync=off and it does not seem to have a great effect. After again
5 hours, during index creation, disk and cpu are barely used: 95% idle
and 2-3 MB/s writes (150 reads/s, 90 wr
On 09/13/2012 09:59 AM, Tom Lane wrote:
Alex Lai writes:
"EXPLAIN insert into alex1 (fileid, archiveset) select 35352974, 10003;"
[vs]
"EXPLAIN insert into alex1 (fileid, archiveset) select '35352974', '10003';"
You might be happier using INSERT ... VALUES instead of INSERT
... SELECT
Peter Eisentraut writes:
> On 9/12/12 2:31 PM, Tom Lane wrote:
>> "C" is the official name of that locale. Not sure how you got it to say
>> "POSIX" ... maybe we didn't have normalization of the locale name back
>> then?
> Says who?
Says setlocale(), at least on the Fedora machine I just checke
Hi All,
I am a beginner in Postgresql and Databases. I have a requirement that
reclaiming disk space by deleting the rows in a selected time span. I went
through the documents and articles to know how to get the table size
(http://wiki.postgresql.org/wiki/Disk_Usage)
But before let the user d
"Andrus" wrote:
> After switching to PostgreSql 9.1 serializable transaction level
> for all transactions during posting single document errors
>
> 40001:ERROR: could not serialize access due to read/write
> dependencies among transactions
> Reason code: Canceled on identification as a pivot, dur
Em 13/09/2012 16:12, Kevin Grittner escreveu:
Edson Richter wrote:
Anything else I can do from here?
Did that result in more accurate numbers for pg_class.reltuples?
-Kevin
I don't how number were not accurate - for me they always seemed
consistent with what I knew about it...
Let's
On 09/13/2012 06:33 AM, Yelai, Ramkumar IN BLR STS wrote:
Hi All,
I am a beginner in Postgresql and Databases. I have a requirement that
reclaiming disk space by deleting the rows in a selected time span. I
went through the documents and articles to know how to get the table
size (_http://wiki
I usually just forget her birthday, eye color, or name. Then she extracts
herself from the relationship.
QED.
Le 2012-09-13 à 16:51, David Salisbury a écrit :
>
> It looks to me like you're misusing git..
>
> You should only git init once, and always use that directory.
> Then pg_dump, which should create one file per database
> with the file name you've specified.
> Not sure of the flags but I'd recom
Do these tend to perform well? I have some simple formulas in functions
like so:
CREATE OR REPLACE FUNCTION public.stat_foo(a integer, b integer, c integer)
RETURNS numeric AS
$BODY$
declare ret numeric;
begin
select (a+b) / c::numeric into ret;
return round(ret, 3);
end
$BODY$
LANGUAGE plpgs
2012/9/14 Wells Oliver :
> Do these tend to perform well? I have some simple formulas in functions like
> so:
>
> CREATE OR REPLACE FUNCTION public.stat_foo(a integer, b integer, c integer)
> RETURNS numeric AS
> $BODY$
>
> declare ret numeric;
>
> begin
> select (a+b) / c::numeric into ret;
> re
On Thursday, 13 September 2012 18:51:48 UTC+2, "Alexander Gataric" wrote:
> I need to determine relationships between several tables. Is there a free
> tool to extract these from catalog tables? Is there an SQL that also does
> this?
>
> Thanks
> Alex
>
> Sent from my smartphone
You can try D
On 09/13/12 10:17 PM, Wells Oliver wrote:
Do these tend to perform well? I have some simple formulas in
functions like so:
if you code your function in SQL instead of plpgsql, and mark it
immutable, it can be inlined by the planner.
--
john r pierceN 37, W 122
s
2012/9/14 John R Pierce :
> On 09/13/12 10:17 PM, Wells Oliver wrote:
>>
>> Do these tend to perform well? I have some simple formulas in functions
>> like so:
>
>
> if you code your function in SQL instead of plpgsql, and mark it immutable,
> it can be inlined by the planner.
you don't need to ma
42 matches
Mail list logo
