高健 wrote:
> I have one question about prepared statement.
> I use Java via JDBC, then send prepared statement to execute.
> I thought that the pg_prepared_statments view will have one record after my
> execution.
> But I can't find.
>
> Is the JDBC's prepared statement differ from SQL execut
On Sat, Jun 15, 2013 at 11:04:28PM +0400, Yuriy Rusinov wrote:
> Postgres 9.1
>
> utf-8
Is this the system locale or the pgcluster encoding? What is the output of the
pg_lsclusters?
Consider the utf8 convertion of those initial scripts if this is not an
option, then just create new cluster with
Hi.
I currently have a number of servers using both streaming replication
and WAL shipping in the standard setup.
Occasionally, the primaries get large load spikes. Load climbs up,
things slow down. So much so that streaming replication starts lagging
because the WAL sender is being starved for r
Hello,
I have time columns, whereas the time ist stored as houroffset in epoch.
e.g 36089 =>
select '19700101 00:01:00 GMT'::timestamptz + interval '360089' hours'
=> 2011-01-29 18:01:00+01
Now I want an aggregation that sum my values on the day start in a given time
zone.
The function below work
I have a problem granting permissions. The end result I'm looking for is:
Dustin and Pablo are data analysts. When either creates a table, the table must
be created outside of public, and both must be able to delete the table when
their work is finished. I would prefer that the tables they creat
I observed the following behaviour (I tested the following statements in
9.0.4, 9.0.5 and 9.3beta1):
$ psql template1
template1=# SELECT CASE WHEN 0=0 THEN 0 ELSE 1/0 END;
case
--
0
(1 row)
template1=# SELECT CASE WHEN 1=0 THEN 0 ELSE 1/0 END;
ERROR: division by zero
In this case the C
On Fri, Jun 7, 2013 at 5:51 AM, Joshua D. Drake wrote:
>
> On 06/06/2013 03:48 PM, Scott Marlowe wrote:
>>
>>
>> On Thu, Jun 6, 2013 at 4:35 PM, Joshua D. Drake
>> wrote:
>>>
>>> I had the distinct displeasure of staying up entirely too late with a
>>> customer this week because they upgraded to
On 06/17/2013 01:34 PM, Stuart Bishop wrote:
I've since heard that 3.4 also fixes this issue as well.
What are you using for your IO on these boxes?
I was able to demonstrate it over iSCSI to a Nimble Storage SAN as well as
DAS with 2 drive RAID 1 for xlogs and 8 drive RAID 10 for data (DL38
On 2013-06-17 22:17 +02:00, Andrea Lombardoni wrote:
I observed the following behaviour (I tested the following statements in
9.0.4, 9.0.5 and 9.3beta1):
$ psql template1
template1=# SELECT CASE WHEN 0=0 THEN 0 ELSE 1/0 END;
case
--
0
(1 row)
template1=# SELECT CASE WHEN 1=0 THEN 0 E
hello i'm having just a similiar problem, could you tell me what part of the
instructions you were missing?
im trying to upgrade from 8.3 to 9.2.4 but i get this error:
"this utility can only upgrade to postgresql version 9.2."
--
View this message in context:
http://postgresql.1045698.n5.na
On Mon, Jun 17, 2013 at 10:44:44AM -0700, jmfox180 wrote:
> hello i'm having just a similiar problem, could you tell me what part of the
> instructions you were missing?
>
> im trying to upgrade from 8.3 to 9.2.4 but i get this error:
>
> "this utility can only upgrade to postgresql version 9.2."
El 17/06/13 17:08, François Beausoleil escribió:
I have a problem granting permissions. The end result I'm looking for is:
Dustin and Pablo are data analysts. When either creates a table, the table must
be created outside of public, and both must be able to delete the table when
their work is
Hello:
Thanks to Laurenz. Your information is very helpful for me.
I change my Java program by adding the following:
org.postgresql.PGStatement pgt = (org.postgresql.PGStatement)pst;
pgt.setPrepareThreshold(1);
I can see an entry is in pg_prepared_statements now.
But the hyperlink's docu
13 matches
Mail list logo
