Michael Nolan wrote:
Earlier today I was working on a MySQL database (not by choice, I assure
you),
and I typed a statement like this:
Update tablexyz set field1 = '15' where field2 - 20;
The '-' was supposed to be an equal sign, but MySQL executed it anyway.
(Field2 is an integer.)
I was
Le dimanche 26 juin 2011 à 00:05 -0700, Darren Duncan a écrit :
> Michael Nolan wrote:
> Having real BOOLEAN is just one of the reasons I like Postgres the most.
>
Would you mind giving an example of where a boolean field would be a win
over an integer one?
I'm asking this because I frequently
Hi,
I came across a strange issue when caching prepared statement..
We are accessing postgres(9.0.3) via the jdbc driver (9.0b801) using a
prepared statement cache.
This works very good but in
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
hello
2011/6/26 Vincent Veyron :
> Le dimanche 26 juin 2011 à 00:05 -0700, Darren Duncan a écrit :
>> Michael Nolan wrote:
>
>> Having real BOOLEAN is just one of the reasons I like Postgres the most.
>>
>
> Would you mind giving an example of where a boolean field would be a win
> over an integer
Hi,
I came across a strange issue when caching prepared statement..
We are accessing postgres(9.0.3) via the jdbc driver (9.0b801) using a
prepared statement cache.
This works very good but in 1 case the 5th execution (and later ones)
suddenly takes 30 seconds as the first few just take less then
This is likely the case where the first few "prepared statements" are not truly
prepared. Once you hit five the cache kicks in and computes a generic query
plan to cache. Since this plan is generic, where the first five were specific,
it exhibits worse performance than queries where the where
David Johnston writes:
> This is likely the case where the first few "prepared statements" are
> not truly prepared. Once you hit five the cache kicks in and computes
> a generic query plan to cache.
Not so much that as that JDBC decides that it should tell the backend to
start using a prepared
* Vincent Veyron (vv.li...@wanadoo.fr) wrote:
> Would you mind giving an example of where a boolean field would be a win
> over an integer one?
Where you only ever want 2 (or perhaps 2+NULL) values allowed for the
column. It's about domain, consistency, etc, primairly. That said,
don't we implem
This message has been digitally signed by the sender.
Re___GENERAL__An_amusing_MySQL_weakness__not_.eml
Description: Binary data
Hi-Tech Gears Ltd, Gurgaon, India
Sent using "PostMaster" by QuantumLink Communications
Get your free
On 26/06/11 16:44, Michael Nolan wrote:
Earlier today I was working on a MySQL database (not by choice, I
assure you),
and I typed a statement like this:
Update tablexyz set field1 = '15' where field2 - 20;
The '-' was supposed to be an equal sign, but MySQL executed it
anyway. (Field2 is an
On 23/06/11 23:28, Tarlika Elisabeth Schmitz wrote:
Hello Gavin,
On Wed, 22 Jun 2011 20:53:19 +1200
Gavin Flower wrote:
[...]
This design ensures that: names of towns are unique within a given
country and>region.
Note you will still need business logic, in a trigger or some such, to
ensure
On 23 Jun 2011, at 19:48, Alexander Farber wrote:
> Sorry for the late reply - but I still haven't found a solution,
> for example I have a PHP script with 5 consecutive SELECT
> statements (source code + problem described again under:
>
> http://stackoverflow.com/questions/6458246/php-and-pgboun
I'm having huge problems with a Drupal install using Postgres 8.4.8.
I'm getting the following error:
PDOException: SQLSTATE[08006] [7] could not connect to server:
Connection refused Is the server running on host "localhost" and
accepting TCP/IP connections on port 5432? in lock_may_be_available
On Sunday, June 26, 2011 12:36:59 pm Dave Coventry wrote:
> I'm having huge problems with a Drupal install using Postgres 8.4.8.
>
> I'm getting the following error:
>
> PDOException: SQLSTATE[08006] [7] could not connect to server:
> Connection refused Is the server running on host "localhost" a
On Sun, Jun 26, 2011 at 09:36:59PM +0200, Dave Coventry wrote:
> I'm having huge problems with a Drupal install using Postgres 8.4.8.
>
> I'm getting the following error:
Do you get the error in the logs or do you see it while going to the
site manually and does it show this instead of rendering
On Sat, Jun 25, 2011 at 3:56 AM, David Johnston wrote:
> First: I would suggest your use of “Local Time” is incorrect and that you
> would be better off thinking of it as “Abstract Time”. My responses below
> go into more detail but in short you obtain a “Local” time by “Localizing”
> and “Abstr
On Friday, June 24, 2011 10:37:43 am hernan gonzalez wrote:
> > As I understand it, documentation patches are welcomed:)
>
> I'd indeed wish some radical changes to the documentation.
>
> To start with, the fundamental data type names are rather misleading; SQL
> standard sucks here, true, but Po
On Sunday, June 26, 2011 12:57:15 pm hernan gonzalez wrote:
>
> An instant is a point in the universal time, it's a physical concept,
> unrelated to world calendars. The time point at which the man first landed
> on the moon is an instant, as is the moment at which my server restarted.
> It is no
>
>
> You might want to review the Theories of Relativity, which pretty much blew
> away
> the notion of an absolute time and introduced the notion of frame of
> reference
> for time.
>
>
Well, I give up.
--
Hernán J. González
http://hjg.com.ar/
On Sunday, June 26, 2011 12:57:15 pm hernan gonzalez wrote:
>
> An instant is a point in the universal time, it's a physical concept,
> unrelated to world calendars. The time point at which the man first landed
> on the moon is an instant, as is the moment at which my server restarted.
> It is no
On Sunday, June 26, 2011 1:36:32 pm hernan gonzalez wrote:
> > You might want to review the Theories of Relativity, which pretty much
> > blew away
> > the notion of an absolute time and introduced the notion of frame of
> > reference
> > for time.
>
> Well, I give up.
As it happens I am currentl
Thank you very much for your responses.
On 26 June 2011 21:54, Peter Bex wrote:
> Do you get the error in the logs or do you see it while going to the
> site manually and does it show this instead of rendering a page?
The log don't really give much indication of anything untoward
happening. It's
On Fri, Jun 24, 2011 at 09:42, Rob Sargent wrote:
> Can't the service script be something like
> cd d:/me/data/PostgreSQL; ./pg_ctl.exe runservice -N "pgsql" -D
> "d:/me/etc/PostgreSQL"
Don't know about that, the service was installed by pg_ctl.
Still, if two relative paths are based on one fol
On Sun, Jun 26, 2011 at 11:23:30PM +0200, Dave Coventry wrote:
[snip]
> 2011-06-26 17:13:24 EDT DETAIL: Failed system call was
> shmget(key=5432001, size=29278208, 03600).
> 2011-06-26 17:13:24 EDT HINT: This error usually means that
> PostgreSQL's request for a shared memory segment exceeded ava
On 06/26/11 2:23 PM, Dave Coventry wrote:
While the server is a little challenged in the way of RAM, it is by no
means under any sort of load.
I didn't read the whole thread, but is this a Linux server? Linux has
a horrible feature, the "Out of Memory Killer", which kills off
processes when
Dne 25.6.2011 13:22, Alban Hertroys napsal(a):
> As another possible improvement, I'd probably not create a new connection in
> every function call, but use a global $db object instead. Creating
> DB-connections is relatively expensive, so you don't want to do that more
> often than strictly nec
Apologies, I didn't notice that I was replying off-list.
On 27 June 2011 00:29, Dave Coventry wrote:
> On 26 June 2011 23:37, John R Pierce wrote:
>> I didn't read the whole thread, but is this a Linux server? Linux has a
>> horrible feature, the "Out of Memory Killer", which kills off process
On 06/26/11 4:10 PM, Dave Coventry wrote:
work_mem: 64kB
shared_buffers: 128kB
maintenance_work_mem: 1MB
I'll see if that makes any difference.
I'd watch the systems' memory usage as shown by `top` or `free`... as
long as the 'cached' value (add in 'free' if its significant) stays
reasonab
Dave and John
drupal is built on php
php is a binary which plays by the memory limitations posted in php.ini
php.ini:
memory_limit=32M ; Maximum amount of memory a script may consume (32MB)
crank that down if Drupal is exhausting heapspace
Martin Gainty
GMT+5 (this week)
_
Hi,
I'm pretty new to postgres, but I'm currently working on a project to
extend some of the code. For what we're doing, we need to sometimes store
tuples from multiple tables into the same tuplestore.
The way I understand the code, tuples stored in tuplestores do not also
store the TupleDesc
Le dimanche 26 juin 2011 à 12:05 -0400, Stephen Frost a écrit :
> > (the driver converts t/f to 0/1), but I like to tune my fields properly.
>
> Yes, which is pretty horrible of it, imo.
>
There is an option to turn it off and get the characters t/f returned
(pg_bool_tf)
--
Vincent Veyron
htt
Le dimanche 26 juin 2011 à 16:41 +0200, Pavel Stehule a écrit :
> everywhere, where you require readability. For me a FALSE is more
> readable than 1 <> 0 or TRUE instead 1 = 1
>
Actually, in Perl it's just 0 for false and 1 for true, so it's very
readable if you're used to it.
> >
> > I'm ask
On Sunday, June 26, 2011 12:57:15 pm hernan gonzalez wrote:
>
> An instant is a point in the universal time, it's a physical concept,
> unrelated to world calendars. The time point at which the man first landed
> on the moon is an instant, as is the moment at which my server restarted.
> It i
Spencer Pearson writes:
> The way I understand the code, tuples stored in tuplestores do not also
> store the TupleDesc or a way to access the original table the tuple came
> from. This - again, as I understand the code - would make it impossible to
> know what types of attributes are stored in
I can confirm, when I call ps.setPrepareThreshold(1) the query is slow
immediately, so the plan must be different with the server prepared
statements.
Thanks,
Rob
On Sun, Jun 26, 2011 at 5:11 PM, Tom Lane wrote:
> David Johnston writes:
>> This is likely the case where the first few "prepared
35 matches
Mail list logo
