"Robert Haas" wrote:
> > * (seq_page_cost/(random_page_cost))
> > * EXCLUDE constraints has no tags to be linked.
> > * "EXCLUDE constraints" is not indexed from the Index page.
> CREATE TABLE ... CONSTRAINT ... EXCLUDE rather than CREATE TABLE
> CONSTRAINT ... EXCLUDE.
Here is a patch to fix
> From: z-sa...@guitar.ocn.ne.jp
> To: anaeem...@hotmail.com; dp...@postgresql.org
> CC: pgsql-hackers@postgresql.org
> Subject: Re: UUIDs generated using ossp-uuid on windows not unique
> Date: Wed, 31 Mar 2010 01:52:50 +0900
>
> Hi MUHAMMAD-san.
>
> Sorry late reaction...
> unfortunately, M
> To: anaeem...@hotmail.com
> CC: dp...@postgresql.org; z-sa...@guitar.ocn.ne.jp;
> pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] UUIDs generated using ossp-uuid on windows not unique
> Date: Tue, 30 Mar 2010 10:01:50 -0400
> From: t...@sss.pgh.pa.us
>
> MUHAMMAD ASIF writes:
> > I
Josh Berkus wrote:
On 3/29/10 5:04 PM, Magnus Hagander wrote:
Last i heard from Dave on that topic is that there's no chance of that
happening that quickly. He's on a plane now but I'm sure he'll confirm
that when he lands.
That means that we'll be doing the test-fest using Alpha4, materially.
For now Postgres able to create deferrable uniques with following syntax:
...
and table_constraint is:
[ CONSTRAINT constraint_name ]
{ UNIQUE ( column_name [, ... ] ) index_parameters |
PRIMARY KEY ( column_name [, ... ] ) index_parameters |
CHECK ( expression ) |
FOREIGN KEY ( column_name
On Wed, Mar 31, 2010 at 12:21 PM, Robert Haas wrote:
> I just tested this and it seems to just sit there doing this over and
> over again:
>
> LOG: record with zero length at 0/3006B28
>
> I'm not sure that we should forbid this configuration, but the current
> behavior doesn't seem right either.
On Wed, Mar 31, 2010 at 12:06 PM, Robert Haas wrote:
> After snapshotting my master using hot backup to create a workable
> slave instance, I created recovery.conf on the slave and tried to get
> it to connect to the master and stream WAL.
>
> This led to the message "sorry, too many standbys alre
On Tue, Mar 30, 2010 at 12:26 AM, Fujii Masao wrote:
> On Wed, Mar 3, 2010 at 9:41 PM, Fujii Masao wrote:
>> On Wed, Feb 24, 2010 at 2:18 PM, Fujii Masao wrote:
>>> If standby_mode is enabled, and neither primary_conninfo nor restore_command
>>> are set, the standby would get stuck. How about fo
On Tue, Mar 30, 2010 at 9:48 PM, Fujii Masao wrote:
> On Wed, Mar 31, 2010 at 9:47 AM, Robert Haas wrote:
>> On Tue, Mar 30, 2010 at 5:09 AM, Fujii Masao wrote:
>>> I rebased the patch to HEAD. Is the patch still required for 9.0?
>>> If not, I'd remove the open item of the smart shutdown during
After snapshotting my master using hot backup to create a workable
slave instance, I created recovery.conf on the slave and tried to get
it to connect to the master and stream WAL.
This led to the message "sorry, too many standbys already", which did
not immediately clue me in as to what I needed
I discovered tonight that if you shut down a server, create
recovery.conf with standby_mode = 'on', and start it back up again,
you get this:
LOG: database system was shut down at 2010-03-30 22:34:09 EDT
LOG: entering standby mode
FATAL: recovery connections cannot start because the
recovery_co
On Wed, Mar 31, 2010 at 7:01 AM, Robert Haas wrote:
> At the risk of being blunt, AFAICT, the delay in getting to beta has
> little or nothing to do with testing and everything to do with the
> fact that streaming replication got committed with a long list of open
> items two months ago, and many
On Wed, Mar 31, 2010 at 1:28 AM, Heikki Linnakangas
wrote:
> Fujii Masao wrote:
>>> * Small code changes to handling of failedSources, inspired by your
>>> comment. No change in functionality.
>>>
>>> This is also available in my git repository at
>>> git://git.postgresql.org/git/users/heikki/post
Robert Haas wrote:
While it might be interesting to have/find/write a tool that puts an
HTTP/JSON layer around the DB connection, it's pretty much entirely
unrelated to the proposed project of creating a json type with
PostgreSQL analagous to the xml type we already have, which is what
the OP i
On Wed, Mar 31, 2010 at 9:47 AM, Robert Haas wrote:
> On Tue, Mar 30, 2010 at 5:09 AM, Fujii Masao wrote:
>> I rebased the patch to HEAD. Is the patch still required for 9.0?
>> If not, I'd remove the open item of the smart shutdown during
>> recovery.
>
> I am by no means an expert on this area
On Tue, Mar 30, 2010 at 8:58 PM, Josh Berkus wrote:
>> I'd think that you could get quite a long ways on this, at least doing
>> something like dbslayer without *necessarily* needing to do terribly
>> much work inside the DB engine.
>
> There's actually an HTTP framework tool for Postgres which al
> I'd think that you could get quite a long ways on this, at least doing
> something like dbslayer without *necessarily* needing to do terribly
> much work inside the DB engine.
There's actually an HTTP framework tool for Postgres which already does
something of the sort. It was introduced at pg
On Tue, Mar 30, 2010 at 5:09 AM, Fujii Masao wrote:
> I rebased the patch to HEAD. Is the patch still required for 9.0?
> If not, I'd remove the open item of the smart shutdown during
> recovery.
I am by no means an expert on this area of the code, but in the
interest of moving things along I rev
On Tue, Mar 30, 2010 at 9:36 AM, Dimitri Fontaine
wrote:
> Robert Haas writes:
>
>> On Tue, Mar 30, 2010 at 12:56 AM, Anindya Jyoti Roy
>> wrote:
>>> As Jeff Davis pointed out, I followed the modification he suggested and now
>>> I want to have a basic matching only. I think atleast the fingerp
joeyadams3.14...@gmail.com (Joseph Adams) writes:
> I introduced myself in the thread "Proposal: access control jails (and
> introduction as aspiring GSoC student)", and we discussed jails and
> session-local variables. But, as Robert Haas suggested, implementing
> variable support in the backend
On Tue, Mar 30, 2010 at 4:43 PM, Josh Berkus wrote:
> On 3/29/10 5:04 PM, Magnus Hagander wrote:
>> Last i heard from Dave on that topic is that there's no chance of that
>> happening that quickly. He's on a plane now but I'm sure he'll confirm
>> that when he lands.
>
> That means that we'll be d
On 3/29/10 5:04 PM, Magnus Hagander wrote:
> Last i heard from Dave on that topic is that there's no chance of that
> happening that quickly. He's on a plane now but I'm sure he'll confirm
> that when he lands.
That means that we'll be doing the test-fest using Alpha4, materially.
Which is annoyin
Heikki Linnakangas writes:
> Seems OK to me. It's worth noting though that if a module does do
> palloc+memcpy of PlannerInfo, and it's compiled against the new sources
> with the extra field, but used on an old server version, it will
> memcpy() from beyond the end of the struct. If you're seriou
Hi MUHAMMAD-san.
Sorry late reaction...
unfortunately, My machine crashed and was not revitalized.:-(
However, There is a thing of now a few.
http://winpg.jp/~saito/pg_work/OSSP_win32/msvc/
I have a comment from Ralf S. Engelschall.
==
Sorry for being late with the release of OSSP uuid 2.0.0.
Ye
Tom Lane wrote:
> Marc Cousins pointed out here
> http://archives.postgresql.org/pgsql-general/2010-03/msg01123.php
> that the "constraint_exclusion = partition" feature added in 8.4
> does not do what you'd expect for the target relation of an UPDATE
> or DELETE. That's because expansion of an in
Fujii Masao wrote:
>> * Small code changes to handling of failedSources, inspired by your
>> comment. No change in functionality.
>>
>> This is also available in my git repository at
>> git://git.postgresql.org/git/users/heikki/postgres.git, branch "xlogchanges"
>
> I looked the patch and was not
Marc Cousins pointed out here
http://archives.postgresql.org/pgsql-general/2010-03/msg01123.php
that the "constraint_exclusion = partition" feature added in 8.4
does not do what you'd expect for the target relation of an UPDATE
or DELETE. That's because expansion of an inheritance set is managed
d
> The interpretation of the standard in the above way (DECLARE is declarative,
> ...
It's not just interpretation, but also a regression if we were to change this.
> The uniqueness problem can only be solved with modifying
> the runtime library to keep track of the cursor names in the client.
> I
Robert Haas writes:
> On Tue, Mar 30, 2010 at 12:56 AM, Anindya Jyoti Roy
> wrote:
>> As Jeff Davis pointed out, I followed the modification he suggested and now
>> I want to have a basic matching only. I think atleast the fingerprint
>> processing can be done in summer (if not the image proces
2010/3/30 Tom Lane :
> Ian Barwick writes:
>> 2010/3/30 Pavel Stehule :
>>> we can use a non existing column "name". What does mean?
>
>> FYI this has caused me (and presumably a few other people) a bit of
>> head-scratching, e.g.:
>> http://archives.postgresql.org/pgsql-general/2010-03/msg00362
Ian Barwick writes:
> 2010/3/30 Pavel Stehule :
>> we can use a non existing column "name". What does mean?
> FYI this has caused me (and presumably a few other people) a bit of
> head-scratching, e.g.:
> http://archives.postgresql.org/pgsql-general/2010-03/msg00362.php
We could make that stop
2010/3/30 Pavel Stehule :
> Hello,
>
> I was noticed on little bit strange feature of PostgreSQL 8.4 and 9.0
>
> we can use a non existing column "name". What does mean?
>
>
> postgres=# create table h(a int, b int);
> CREATE TABLE
> Time: 2,604 ms
> postgres=# insert into h values(199,22);
> INSER
MUHAMMAD ASIF writes:
> I have downloaded uuid-1.6.2.tar.gz from http://www.ossp.org/pkg/lib/uuid/ .
> It successfully built with MinGW gcc and made libuuid.a, I renamed it to
> uuid.lib to build uuid-ossp contrib module with visual studio 2005. uuid-ossp
> give the following linker error with
On Tue, Mar 30, 2010 at 12:56 AM, Anindya Jyoti Roy wrote:
> As Jeff Davis pointed out, I followed the modification he suggested and now
> I want to have a basic matching only. I think atleast the fingerprint
> processing can be done in summer (if not the image processing). Is it a good
> GSoC pro
Also, where are we on using full names rather than first names only? I
don't see the point in omitting the last names. Are we trying to
obscure to outsiders who is really working on our code?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company
Hello,
I was noticed on little bit strange feature of PostgreSQL 8.4 and 9.0
we can use a non existing column "name". What does mean?
postgres=# create table h(a int, b int);
CREATE TABLE
Time: 2,604 ms
postgres=# insert into h values(199,22);
INSERT 0 1
Time: 0,970 ms
postgres=# explain verbos
As Jeff Davis pointed out, I followed the modification he suggested and
now I want to have a basic matching only. I think atleast the
fingerprint processing can be done in summer (if not the image
processing). Is it a good GSoC project now?
Waiting for a reply eagerly
Thanks and regards,
Anin
As Jeff Davis pointed out, I followed the modification he suggested and
now I want to have a basic matching only. I think atleast the
fingerprint processing can be done in summer (if not the image
processing). Is it a good GSoC project now?
Waiting for a reply eagerly
Thanks and regards,
Anin
On Tue, Mar 30, 2010 at 1:37 AM, Takahiro Itagaki
wrote:
> Hi, I have some questions about 9.0 release note.
> I'd like to work for some of them if required. Comments welcome.
>
> * Allow per-tablespace sequential and random page cost variables
> (seq_page_cost/(random_page_cost)) via ALTER TABLE
Some recent off-list discussion has suggested that we should keep
plperl's copy of ppport.h in sync on all branches, just as we do with
timezone data files. So when we update it on HEAD we should
simultaneously update the back branches. It's a derived file, produced
by the perl module Devel::
Peter Eisentraut wrote:
On tis, 2010-03-30 at 08:39 +0200, Stefan Kaltenbrunner wrote:
on fast systems pg_dump is completely CPU bottlenecked
Might be useful to profile why that is. I don't think pg_dump has
historically been developed with CPU efficiency in mind.
It's not pg_dump that is t
On Tue, 30 Mar 2010 13:01:54 +0200, Peter Eisentraut
wrote:
On tis, 2010-03-30 at 08:39 +0200, Stefan Kaltenbrunner wrote:
on fast systems pg_dump is completely CPU bottlenecked
Might be useful to profile why that is. I don't think pg_dump has
historically been developed with CPU efficien
On mån, 2010-03-29 at 17:03 -0700, Josh Berkus wrote:
> > The idea crudely is the following:
> >
> > I want to implement a image database system: This will have the
> > following quality:
>
> This seems fine, but I believe it's been done before. You might want to
> search for existing projects,
On tis, 2010-03-30 at 08:39 +0200, Stefan Kaltenbrunner wrote:
> on fast systems pg_dump is completely CPU bottlenecked
Might be useful to profile why that is. I don't think pg_dump has
historically been developed with CPU efficiency in mind.
--
Sent via pgsql-hackers mailing list (pgsql-hack
>On Tue, Jun 17, 2008 at 11:17 AM, Hiroshi Saito
> wrote:
>> Hi.
>>
>> Please this.
>> http://winpg.jp/~saito/pg_work/OSSP_win32/msvc/
>
>Ahh, a makefile - that makes things somewhat clearer :-)
>
>Thanks - I've updated the build machine so future releases will
>include this fix.
>
>--
>Dave Page
On Wed, Mar 3, 2010 at 11:03 PM, Fujii Masao wrote:
> On Tue, Mar 2, 2010 at 10:52 PM, Fujii Masao wrote:
>>> It's not clear what it should return, a TLI corresponding the filename
>>> of the WAL segment the record was replayed from, so that you can use
>>> pg_xlogfile_name() to find out the file
On Mon, Feb 1, 2010 at 11:49 AM, Fujii Masao wrote:
> On Sat, Jan 30, 2010 at 12:54 PM, Fujii Masao wrote:
>>> HOWEVER, I do believe this is an issue we could live with for 9.0 if
>>> it's going to lead to a whole lot of additional debugging of SR. But if
>>> it's an easy fix, it'll avoid a lot
Hi,
The attached patch improves the documents about SR as follows:
* Improve the description about the setup procedure of SR.
o Add the link to the recovery.conf parameter if needed.
o Add the example of recovery.conf setting.
* Document what should be monitored for avoiding the disk full
f
On 30 March 2010 08:26, Zhai Boxuan wrote:
>
> I have read some infor about the MERGE command, which has not been
> implemented yet in Postgres 8. I considered the problem and have a brief plan
> for the jobs.
>
You may find these to be some help if you haven't already read them:
http://archive
To whom may concern,
My name is Zhai Boxuan, a student from China.
I am now a Master Student of National University of Singapore. And, before I
came to Singapore, I have got another master degree in Wuhan University. In
that period, I focus mainly on implementing a novel Object-oriented database
50 matches
Mail list logo
