On Sat, Jan 21, 2012 at 1:45 AM, Bruce Duncan wrote:
> Just wanted to give a heads up to anyone who might be having a similar
> problem. We had an installation on a customer machine that had the AV
> product "ESET NOD32" installed. We quickly started having problems when
> there were two or more
On 21 January 2012 00:45, Bruce Duncan wrote:
> Thought this might be of help to anyone else out there who comes across this
> AV software during deployment and starts encountering strange behavior.
Thanks for the report, but shouldn't you really be complaining to the
anti-virus vendor?
--
Pete
Just wanted to give a heads up to anyone who might be having a similar
problem. We had an installation on a customer machine that had the AV
product "ESET NOD32" installed. We quickly started having problems when
there were two or more concurrent queries against the same tables in
PostgreSQL
Brar Piening wrote
>
> Just a guess: You don't have something like "host all all 127.0.0.1/32
> sspi" in your pg_hba.conf do you?
>
> Regards,
>
> Brar
>
I don't have that set. Here's a sample from my pg_hba (slightly redacted to
obfuscate our internal network address scheme).
# TYPE DATAB
G_Hosa_Phat wrote:
I've been trying to develop a new application in VB.NET (VS2008) against a
PostgreSQL 9.1.1 database server running on Windows Server 2008 using SSPI
authentication, and I'm running into this same error. I've tried both
specifying the username and not specifying it in my
Npgsq
On 19/01/2012 12:57 AM, David Salisbury wrote:
Think I'll answer myself on this. I'll join in whatever rows I get from
the self referential query above to the base table, and include the
rank column,
and then figure out some sort of post processing on the resultant view
( I hope ).
Usually r
Hi Adrian,
>> II) Having PostgreSQL issuing a NOTICE that "comments get stripped" if you
>> use comments somewhere where PostgreSQL accepts them, but discards them
>> silently?
>
> I think that is covered by this:
> http://www.postgresql.org/docs/9.0/interactive/sql-syntax-lexical.html#SQL-SYNTAX
I wonder if the issue is in client encoding. How do these characters
in various Windows codepages relate to UTF characters?
Best Wishes,
Chris Travers
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/p
On 20 January 2012 21:53, Jerry Richards wrote:
> I noticed there are several synchronous implementations (Postgre-XC,
> PGCluster, pgpool, rubyrep, built-in streaming, etc.). When you say, " you
> can dynamically change that right down to the transaction level...", are you
> referring specifi
Ahmed wrote
>
> I tested the latest Npgsql driver (2.0.12.0), the issue has been fixed. I
> was able to connect Npgsql test application from my Windows XP client
> machine with the PostgreSQL server running on Windows 2003 Server.
>
> Thank you for applying the patch.
>
I've been trying to deve
Peter,
I noticed there are several synchronous implementations (Postgre-XC, PGCluster,
pgpool, rubyrep, built-in streaming, etc.). When you say, " you can
dynamically change that right down to the transaction level...", are you
referring specifically to one of these implementations?
By the w
On 20 January 2012 21:17, John R Pierce wrote:
> On 01/20/12 12:31 PM, Jerry Richards wrote:
>>
>> Is synchronous postgresql replication slower than asynchronous? If so,
>> how much? I am looking into database replication for a phone system, so the
>> response time is of concern.
>
>
> when a cl
On Friday, January 20, 2012 12:24:26 pm Ralph Graulich wrote:
> Hi David,
>
> II) Having PostgreSQL issuing a NOTICE that "comments get stripped" if you
> use comments somewhere where PostgreSQL accepts them, but discards them
> silently?
I think that is covered by this:
http://www.postgresql.o
On 01/20/12 12:31 PM, Jerry Richards wrote:
Is synchronous postgresql replication slower than asynchronous? If
so, how much? I am looking into database replication for a phone
system, so the response time is of concern.
when a client issues a COMMIT on the master, synchronous by definition
[[[ My response embedded ]]]
-Original Message-
From: Ralph Graulich [mailto:maill...@shauny.de]
Sent: Friday, January 20, 2012 3:24 PM
To: David Johnston
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] comments in argument list of plpgsql get stripped?
Hi David,
> The fact that
On 2012-01-03, Frank Lanitz wrote:
> Am 02.01.2012 20:13, schrieb Hagen Finley:
>> I am using psql (8.2.15) and I would like to input German characters
>> (e.g. ä,ß,ö) into char fields I have in a database
>
> I see that you are using Outlook which leads me to assume you are
> running Windows as h
On 2011-12-22, Jacques Lamothe wrote:
[..]
> While everything is ok with local connections, I cannot connect remotely
> using any of my tools to the second database with port 5436,
[...]
> I have attached the posgresql.conf file.
It fell off.
The line you want is "listen_addresses"
--
⚂⚃ 1
Is synchronous postgresql replication slower than asynchronous? If so, how
much? I am looking into database replication for a phone system, so the
response time is of concern.
Thanks,
Jerry
Hi David,
> The fact that you can write comments in the middle of the arguments in an
> artifact of the parser and likely there is not reasonable way to get them to
> persist.
"Artifact" as in "something not normally used"?
> You either want to use "COMMENT ON" like Raymond said or you can
> sim
Hi Brice,
I think You are right, problem is just in php prepare/bindvalue
So it should be avoided...
I guess the reason you like to use bindvalue is safety in SQL injection
problem...
what should be handled on some way what depends on concrete case...
But far as I am aware string as input par
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ralph Graulich
Sent: Friday, January 20, 2012 12:28 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] comments in argument list of plpgsql get stripped?
Hi,
How can I
On 01/13/2012 02:49 PM, Tomas Vondra wrote:
On 13.1.2012 22:20, Tom Lane wrote:
Matt Dew writes:
An interesting sidenote we realized. the nice system shutdown script
/etc/init.d/postgres doesn't actually wait for the db to be down, it
just waits for pg_ctl to return.
By default, "pg_ctl sto
Hello Ray,
> You could use COMMENT ON instead:
>
> COMMENT ON function func_test(text, text)
> IS 'loads of documentation here';
>
> Would this do the job?
Thank you for your input.
I know about the COMMENT ON function, as I use it for all other purposes, like
documenting columns an
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Brice Maron
Sent: Friday, January 20, 2012 1:26 PM
To: David Johnston
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Immutable function with bind value
On Fri, Jan
On 20/01/2012 17:28, Ralph Graulich wrote:
> Hi,
>
> How can I store inline comments in the argument list of a plpgsql
> function to document complex overloaded functions with lots of
> arguments? It seems that PostgreSQL accepts the comments, but strips
> them as the function gets stored.
You co
On Fri, Jan 20, 2012 at 16:00, David Johnston wrote:
> On Jan 20, 2012, at 6:15, Brice Maron wrote:
>
>> Hi,
>>
>> i've discovered something kind of weird while developing my app...
>> I was trying to fetch some records in a table using a function immutable.
>> In my interface it was really slow
Hi,
How can I store inline comments in the argument list of a plpgsql function to
document complex overloaded functions with lots of arguments? It seems that
PostgreSQL accepts the comments, but strips them as the function gets stored.
I am using PostgreSQL 9.1.2.
+++
CREATE FUNCTION func_test
Hello,
Can anyone please tell me where I can find the PGbouncer executable and
tutorial for Windows 2008? I found one but need to recompile on Windows. I
also need intuitive instructions to configure it too.
Thanks in advance.
--
Edison
"Prodan, Andrei" writes:
> I have a DB in which items which are 'always valid' have a from_date of
> 19000101 00+1 (Europe/Berlin)
> When i try to restore the same DB to (Europe/Bucharest), instead of
> 19000101 00+2, the timestamp becomes "1900-01-01 00:44:24+01:44:24"
> which is ... stra
On Jan 20, 2012, at 6:15, Brice Maron wrote:
> Hi,
>
> i've discovered something kind of weird while developing my app...
> I was trying to fetch some records in a table using a function immutable.
> In my interface it was really slow and while i was in a psql it was
> really fast ...
>
> Afte
Thanks Matteo for your answer...
but.. this is only a usecase... i'm currently using thing like this in
a php app,
so i'm doing kind of a as
select * from test where a = test_immutable(?);
then
execute('var');
unfortunately there, i can't to an execute(test_immutable('var'))
for now i've a
On 20/01/2012 12:43, Brice Maron wrote:
> Hi,
>
> i've discovered something kind of weird while developing my app...
> I was trying to fetch some records in a table using a function immutable.
> In my interface it was really slow and while i was in a psql it was
> really fast ...
>
> After some
I am a new user, and, as some people already highlighted before me,
after having installed Postgres 9.1, the stackbuider is not able to
connect to the URL www.postgresql.org/applications-v2.xml. I can reach
that page by the browser, however.
My PC is running windows XP SP2 and it connects to int
Hi,
i've discovered something kind of weird while developing my app...
I was trying to fetch some records in a table using a function immutable.
In my interface it was really slow and while i was in a psql it was
really fast ...
After some research i've found out that it was caused by the bind
p
Hi,
currently we are trying to integrate Postgres with ODBC and have problems with
blobs.
We tried to use bytea and were under the impression that bytea would act like
a blob in other databases when used through ODBC.
So far we could not make it work properly. It seems we still have to do the
en
Hi.
I think that in specific statement with many constants:
CASE x
WHEN const1 THEN action1
WHEN const2 THEN action2
WHEN const3 THEN action3
WHEN const4 THEN action4
END CASE;
constants may be sorted at compile time, and when executed ,
it will be possible internally to use fast search:
Hi,
i've discovered something kind of weird while developing my app...
I was trying to fetch some records in a table using a function immutable.
In my interface it was really slow and while i was in a psql it was
really fast ...
After some research i've found out that it was caused by the bind
p
* Lincoln Yeoh:
> Is there a simple way to get postgresql to retry a transaction, or
> does the application have to actually reissue all the necessary
> statements again?
The application has to re-run the transaction, which might result in the
execution of different statements. In the INSERT-or-
At 04:27 PM 1/20/2012, Florian Weimer wrote:
* Lincoln Yeoh:
>>If you use serializable transactions in PostgreSQL 9.1, you can
>>implement such constraints in the application without additional
>>locking. However, with concurrent writes and without an index, the rate
>>of detected serialization
Hi,
Is it viable to have very many prepared transactions? As in tens of
thousands or even more?
The idea is so that a web application can do _persistent_
transactional stuff over multiple pages/accesses/sessions and have it
rolled back easily, or committed if desired. I'm thinking that it
m
Hello,
I have a DB in which items which are 'always valid' have a from_date of
19000101 00+1 (Europe/Berlin)
When i try to restore the same DB to (Europe/Bucharest), instead of
19000101 00+2, the timestamp becomes "1900-01-01 00:44:24+01:44:24"
which is ... strange.
My software then compl
On 01/20/12 12:20 AM, P. Broennimann wrote:
I need now to insert a record in that remote table and get back the
new primary field (autoincrement sequence).
Since "bdlink_exec" can not give back rows I tried to use "dblink",
but I can not figure out how to format that INSERT... RETURNING quer
* Lincoln Yeoh:
>>If you use serializable transactions in PostgreSQL 9.1, you can
>>implement such constraints in the application without additional
>>locking. However, with concurrent writes and without an index, the rate
>>of detected serialization violations and resulting transactions aborts
>
Hi there
I have a remote table that I access over dblink.
The table has a primary field set to "autoincrement".
I need now to insert a record in that remote table and get back the new
primary field (autoincrement sequence).
Since "bdlink_exec" can not give back rows I tried to use "dblink", but
44 matches
Mail list logo
