Nice to see some poker being discussed on this list. Much more
reputable than Stock Trading.
I was once on the LuckyBum side of this in a Casino Limit game.
Opponent: AT
Stuart the LuckyBum: 88
Flop: ATT
Myself and opponent checked that flop, I bet the turn 8 and was
raised, the river 8 saw
the
On 07/19/11 7:58 PM, Tom Lane wrote:
I'm keeping an eye on it internally to Red Hat, but not really
contributing any significant number of cycles ATM. My understanding of
the status is that the core stuff works but there are still a lot of
Oracle dependencies in lesser-used nooks and crannies
Hi all,
I have a problem on text escaping. In my application, I have a table
offlinemsg, which has one column id with long, and has another column
msg with text.
pgsql ODBC and dynamic SQL binding was used when I tried to insert
data into offlinemsg.
the sql is : insert into offlinemsg values(?,
On 07/20/2011 02:14 AM, Stuart Cooper wrote:
Nice to see some poker being discussed on this list. Much more
reputable than Stock Trading.
If the casinos did something like what traders call front-running,
they'd all be put in jail the next day for cheating their customers.
Just a day in
Hi,
what index is used (and according to what rules) when there are two (or
more) different indexes defined on one column? Assume:
CREATE TABLE example (
id SERIAL PRIMARY KEY,
...);
CREATE INDEX example_id_idx ON example USING hash (id);
By default there are btree index created and the
On Wed, Jul 20, 2011 at 2:39 PM, Vlastimil Krejcir krej...@ics.muni.czwrote:
Hi,
what index is used (and according to what rules) when there are two (or
more) different indexes defined on one column? Assume:
CREATE TABLE example (
id SERIAL PRIMARY KEY,
...);
CREATE INDEX
Hi
I'm doing a restore into Postgresql 8.4, postgis 1.5.1 and I'm getting the
following error when it creates the below function:
pg_restore: creating FUNCTION _get_buffer(geometry, double precision,
integer)
pg_restore: [archiver (db)] Error from TOC entry 966; 1255 49162661 FUNCTION
Hi:
After partitioning a big table, I am getting slower performance on queries
run on the non-partitioned table (llamadas) than the partitioned table
(llamadas_maestra).
Not partitioned table:
heos_prod=# explain analyze select * from llamadas where cod_empresa=1
and
Hi
I would like to build Postgres from source with the visual studio 2010 compiler
Is it supported? Is there any document which describes the process of the
implementation?
Thanks,
Yuval Sofer
BMC Software
CTMD Business Unit
DBA Team
972-52-4286-282
On 20/07/2011 11:56, Sofer, Yuval wrote:
Hi
I would like to build Postgres from source with the visual studio 2010
compiler
Is it supported? Is there any document which describes the process of
the implementation?
Yes, it's in the Fine Manual:
On Wed, Jul 20, 2011 at 12:09 PM, Ruben Blanco rubenb...@gmail.com wrote:
After partitioning a big table, I am getting slower performance on queries
run on the non-partitioned table (llamadas) than the partitioned table
(llamadas_maestra).
Not partitioned table:
heos_prod=# explain
Have you tried one of the newer ODBC drivers? Also, you may want to look
into enabling standard_conforming_strings or disabling the warning
messages with escape_string_warning.
Jon
From: Zhidong She zhidong@gmail.com
To: pgsql-o...@postgresql.org, pgsql-general@postgresql.org,
Sofer, Yuval yuval_so...@bmc.com writes:
I would like to build Postgres from source with the visual studio 2010
compiler
Is it supported?
Not yet. You could test the pending patch for that:
https://commitfest.postgresql.org/action/patch_view?id=523
regards, tom lane
Rebecca Clarke rebe...@clarke.net.nz writes:
I'm doing a restore into Postgresql 8.4, postgis 1.5.1 and I'm getting the
following error when it creates the below function:
pg_restore: creating FUNCTION _get_buffer(geometry, double precision,
integer)
pg_restore: [archiver (db)] Error from
Thanks. But I am not looking for how to avoid the problem at this
moment,
I am more interested in why PostgreSQL is designed to work this way.
To make the problem more obvious,
drop table if exists t1;
create table t1 (f1 int);
create unique index uix_t1 on t1(f1) ;
insert into t1(f1) values (1),
Thanks for the reply.
You are right, the result is all or nothing, so it's still atomic. I
found my mistake and posted a clarification for my question.
I know in PostgreSQL 9.0 unique constraint can be set to deferrable.
However still no luck for unique indexes.
The real question is that why
Samuel Hwang sam...@replicon.com writes:
Thanks. But I am not looking for how to avoid the problem at this
moment,
I am more interested in why PostgreSQL is designed to work this way.
Performance --- it's significantly more expensive to do a deferred
uniqueness check, since you have to visit
On Wed, Jul 20, 2011 at 4:18 PM, Samuel Hwang sam...@replicon.com wrote:
The real question is that why PostgreSQL behaves differently than
other major DBMS. IMHO, doing checking at set operation boundary is
more appropriate than at row boundary.
The real question is why anyone would actually
It seems to me that it is inherently wrong to perform any operation on a
database that depends on the order in which records are retrieved,
without specifying that order in an ORDER BY clause. The update t1 set
f1 = f1 + 1 assumes that the operation will be performed in an order
that guarantees
On Wed, Jul 20, 2011 at 9:58 AM, Rob Richardson
rob.richard...@rad-con.comwrote:
It seems to me that it is inherently wrong to perform any operation on a
database that depends on the order in which records are retrieved,
without specifying that order in an ORDER BY clause. The update t1 set
From May 31, 2006; 12:03pm . . .
It struck me that we are missing a feature that's fairly common in Unix
programs.
Perhaps COPY ought to have the ability to pipe its output to a shell command,
or read input from a shell command.
Maybe something like:
COPY mytable TO '| gzip
On Jul 20, 2011, at 11:29 PM, david.sahag...@emc.com david.sahag...@emc.com
wrote:
From May 31, 2006; 12:03pm . . .
It struck me that we are missing a feature that's fairly common in Unix
programs.
Perhaps COPY ought to have the ability to pipe its output to a shell command,
or read
On Tue, Jul 19, 2011 at 12:44 PM, Scott Ribe
scott_r...@elevated-dev.com wrote:
My suggestion: all such announcements should include information about
supported platforms. Any announcement submitted without that info should be
rejected, and the vendor instructed to add it before
On 07/20/11 12:04 PM, Vick Khera wrote:
And describe*what* the product does. Not everyone knows what a
product is by its name, especially when the name is some marketing
term and not descriptive.
I love seeing literature and websites for product XYZ that make it sound
like it mills the
On Wed, Jul 20, 2011 at 12:17 PM, John R Pierce pie...@hogranch.com wrote:
On 07/20/11 12:04 PM, Vick Khera wrote:
And describe*what* the product does. Not everyone knows what a
product is by its name, especially when the name is some marketing
term and not descriptive.
I love seeing
Can anyone recommend PostgreSQL 9.0 High Performance by G. Smith?
Cheers,
Andrej
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.georgedillon.com/web/html_email_is_evil.shtml
--
Sent via pgsql-general mailing list
On Jul 20, 2011, at 18:11, Andrej andrej.gro...@gmail.com wrote:
Can anyone recommend PostgreSQL 9.0 High Performance by G. Smith?
Yes.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Jul 20, 2011, at 18:11, Andrej andrej.gro...@gmail.com wrote:
Can anyone recommend PostgreSQL 9.0 High Performance by G. Smith?
Yes.
+1.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Sent via pgsql-general
On Jul 21, 2011, at 3:59 AM, Tatsuo Ishii wrote:
On Jul 20, 2011, at 18:11, Andrej andrej.gro...@gmail.com wrote:
Can anyone recommend PostgreSQL 9.0 High Performance by G. Smith?
Yes.
+1.
+1.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
On 07/20/2011 03:29 PM, Tatsuo Ishii wrote:
On Jul 20, 2011, at 18:11, Andrejandrej.gro...@gmail.com wrote:
Can anyone recommend PostgreSQL 9.0 High Performance by G. Smith?
Yes.
+1.
--
+ (another) 1
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
Thanks all - book ordered :}
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 21/07/11 10:45, Andrej wrote:
Thanks all - book ordered :}
I wonder how much Greg has spent in bribes??? :-)
More seriously: I intend going through my copy in depth to get a better
unbderstanding of pg.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Simon Riggs wrote:
The real question is why anyone would actually perform that kind of
UPDATE. It doesn't really make much sense to increment a PK value.
PostgreSQL is good at supporting things people want and need, so
differences do exist in places that are fairly low priority.
I
Thanks. That's the best reason I can think of too.
Less expensive feels like taking shortcuts to speed up things and not a
good reason to make decision on.
Although maintain backward compatibility makes sense (to some extend), if
old PG doesn't behave properly, it should be fixed, shouldn't
Hello All,
I've faced with the following problem: I'm trying to implement the auto
start of postgres. My way is to use inittab:
pg:2345:respawn:/bin/su - postgres -c /usr/local/pgsql/bin/postmaster
-D/usr/local/pgsql/data /usr/local/pgsql/server.log 21 /dev/null
But this approach does not
Greg,
Thank you for the information. We are not aware about this. Please remove my
email.
We will follow the process in future.
Regards,
MS
M.S. Rao | Director
0: 608.661.7604 I ms@symphonycorp.commailto:ms@symphonycorp.com
Symphony Corporationhttp://www.symphonycorp.com/ A
* Gavin Flower (gavinflo...@archidevsys.co.nz) wrote:
On 21/07/11 10:45, Andrej wrote:
Thanks all - book ordered :}
+1
I wonder how much Greg has spent in bribes??? :-)
He's bought me a beer. :D Or maybe I him.. ;)
More seriously: I intend going through my copy in depth to get a
better
On 07/20/2011 04:31 PM, Gavin Flower wrote:
On 21/07/11 10:45, Andrej wrote:
Thanks all - book ordered :}
I wonder how much Greg has spent in bribes??? :-)
More seriously: I intend going through my copy in depth to get a
better unbderstanding of pg.
The funny thing is that at full list
On 07/20/11 4:02 AM, Gavrina, Irina wrote:
I’ve faced with the following problem: I’m trying to implement the auto start
of postgres. My way is to use inittab:
pg:2345:respawn:/bin/su - postgres -c /usr/local/pgsql/bin/postmaster
-D/usr/local/pgsql/data /usr/local/pgsql/server.log 21 /dev/null
On Wed, Jul 20, 2011 at 4:11 PM, Andrej andrej.gro...@gmail.com wrote:
Can anyone recommend PostgreSQL 9.0 High Performance by G. Smith?
Highly recommended. I was one of Greg's reviewers and therefore read
most of it ahead of time and I was still excited to get a hard copy of
it. :)
--
Sent
Hi,
How can one create a postgres build with custom system table names?
For example, instead of pg_class, I'd like to name the table as
foobar_class. Or instead of pg_catalog, foobar_catalog.
I don't care about compatiblity with pgadmin, jdbc drivers, etc. I'd
be happy just as long as I have a
On 20/07/11 18:56, Sofer, Yuval wrote:
I would like to build Postgres from source with the visual studio 2010
compiler
Unless you're willing to use the patch Tom linked to, you should compile
with Visual Studio 2008 or with the Microsoft Platform SDK 7.0 (Windows
Vista and .NET 3.5).
More
On 21/07/11 01:59, david.sahag...@emc.com wrote:
From May 31, 2006; 12:03pm . . .
It struck me that we are missing a feature that's fairly common in Unix
programs.
Perhaps COPY ought to have the ability to pipe its output to a shell command,
or read input from a shell command.
Maybe
On 21/07/11 07:31, Gavin Flower wrote:
On 21/07/11 10:45, Andrej wrote:
Thanks all - book ordered :}
I wonder how much Greg has spent in bribes??? :-)
Lots of time helping people out on this mailing list (for free),
contributing work to Pg, etc. That's enough bribe for me.
My copy is in the
On 21/07/11 10:49, maxxe...@gmail.com wrote:
Hi,
How can one create a postgres build with custom system table names?
For example, instead of pg_class, I'd like to name the table as
foobar_class. Or instead of pg_catalog, foobar_catalog.
I don't care about compatiblity with pgadmin, jdbc
On 20/07/11 19:02, Gavrina, Irina wrote:
Hello All,
I’ve faced with the following problem: I’m trying to implement the auto start
of postgres. My way is to use inittab:
pg:2345:respawn:/bin/su - postgres -c /usr/local/pgsql/bin/postmaster
Are you working on some kind of
46 matches
Mail list logo