On Thu, Jul 3, 2008 at 3:47 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Andrew Hammond" <[EMAIL PROTECTED]> writes:
>> On Thu, Jul 3, 2008 at 2:35 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
>>> The whole thing is pretty mystifying, especially the ENOSPC write
>>> failure on what seems like it couldn't
Dave Witt wrote:
> ..but Postgres only shows the first ~1000 chars from each queued/running
> query. I know this is a long-standing issue (from reading other
> posts/sites), but I'd like to throw in my vote for showing the entire
> query, in some future version (easier said than done, I kno
Hi Everyone,
My first posting to the group..
I came from a mysql background (~7 years, small/mid database, about
55gig), where I could do "SHOW FULL PROCESSLIST;" to see all the queries
currently queued/running on the system. I found it a very useful feature.
The Postgres equivalent is (rou
Bruce Momjian wrote:
> We have come to agreement that there is no longer a need for a separate
> 'patches' email list --- the size of patches isn't a significant issue
> anymore, and tracking threads between the patches and hackers lists is
> confusing.
>
> I propose we close the patches list and t
I just had this same problem.
Perhaps the wiki and http://git.postgresql.org/static/serviceinfo.html
should also be updated with the working (i.e. http) URL?
...Robert
On Thu, Jul 3, 2008 at 12:56 AM, Yoshiyuki Asaba <[EMAIL PROTECTED]> wrote:
> Hi,
>
> From: Abhijit Menon-Sen <[EMAIL PROTECTED]
"Andrew Hammond" <[EMAIL PROTECTED]> writes:
> On Thu, Jul 3, 2008 at 2:35 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
>> The whole thing is pretty mystifying, especially the ENOSPC write
>> failure on what seems like it couldn't have been a full disk.
> Yes, I've passed along the task of explaining w
On Thu, Jul 3, 2008 at 10:37 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Merlin Moncure" <[EMAIL PROTECTED]> writes:
>> Are you suggesting that omission of a patch on the 'fest' page means
>> that you are bumped from the fest?
>
> No, if you had submitted the patch on time then the correct next step
On Thu, Jul 3, 2008 at 2:35 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Andrew Hammond" <[EMAIL PROTECTED]> writes:
>> Does anyone else have any suggestions about what I can do to diagnose this?
>
> The whole thing is pretty mystifying, especially the ENOSPC write
> failure on what seems like it cou
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> Are you suggesting that omission of a patch on the 'fest' page means
> that you are bumped from the fest?
No, if you had submitted the patch on time then the correct next step
is to get it added to the fest page; I don't think that should be
controver
"Andrew Hammond" <[EMAIL PROTECTED]> writes:
> Does anyone else have any suggestions about what I can do to diagnose this?
The whole thing is pretty mystifying, especially the ENOSPC write
failure on what seems like it couldn't have been a full disk.
> Jun 27 15:54:31 qadb2 postgres[92519]: [44-1
On Thu, Jul 3, 2008 at 3:45 PM, Dave Page <[EMAIL PROTECTED]> wrote:
> On Thu, Jul 3, 2008 at 8:34 PM, Alex Hunsaker <[EMAIL PROTECTED]> wrote:
>
>> The one I advised be added (the Auto Explain patch) was posted on Mar
>> 29, 2008 (http://archives.postgresql.org/pgsql-hackers/2008-03/msg01214.php),
Does anyone else have any suggestions about what I can do to diagnose this?
Do I need to re-initdb or can I reasonably keep running with the existing db?
A
On Mon, Jun 30, 2008 at 7:20 PM, Andrew Hammond
<[EMAIL PROTECTED]> wrote:
> On Fri, Jun 27, 2008 at 8:14 PM, Tom Lane <[EMAIL PROTECTED]> w
On Thu, Jul 3, 2008 at 8:34 PM, Alex Hunsaker <[EMAIL PROTECTED]> wrote:
> The one I advised be added (the Auto Explain patch) was posted on Mar
> 29, 2008 (http://archives.postgresql.org/pgsql-hackers/2008-03/msg01214.php),
> re-posted the Jun 30th and then an updated patch today... It only
> bei
On Thu, Jul 3, 2008 at 12:44 PM, Dave Page <[EMAIL PROTECTED]> wrote:
> it concerns me that despite it being day 3 of the July commit fest,
> people are still being advised to add new items to the wiki page.
>
> To make the idea work, we need to stick to the rules we defined when
> we came up with
=?UTF-8?B?SmFuIFVyYmHFhHNraQ==?= <[EMAIL PROTECTED]> writes:
> attached are two patches against HEAD. The smaller one is meant to be
> commited - it adds some functions that manipulate double-linked lists,
> namely inserting a new cell after or before another cell and swapping
> two adjacent cel
On Thu, Jul 3, 2008 at 2:44 PM, Dave Page <[EMAIL PROTECTED]> wrote:
> it concerns me that despite it being day 3 of the July commit fest,
> people are still being advised to add new items to the wiki page.
>
> To make the idea work, we need to stick to the rules we defined when
> we came up with t
On Thu, 2008-07-03 at 20:06 +0100, Dave Page wrote:
> On Thu, Jul 3, 2008 at 8:02 PM, Marko Kreen <[EMAIL PROTECTED]> wrote:
> > On 7/3/08, Dave Page <[EMAIL PROTECTED]> wrote:
> >> it concerns me that despite it being day 3 of the July commit fest,
> >> people are still being advised to add new
On Thu, Jul 3, 2008 at 8:02 PM, Marko Kreen <[EMAIL PROTECTED]> wrote:
> On 7/3/08, Dave Page <[EMAIL PROTECTED]> wrote:
>> it concerns me that despite it being day 3 of the July commit fest,
>> people are still being advised to add new items to the wiki page.
>>
>> To make the idea work, we need
On 7/3/08, Dave Page <[EMAIL PROTECTED]> wrote:
> it concerns me that despite it being day 3 of the July commit fest,
> people are still being advised to add new items to the wiki page.
>
> To make the idea work, we need to stick to the rules we defined when
> we came up with the concept - speci
On Thu, Jul 03, 2008 at 02:01:22PM -0400, Tom Lane wrote:
> Garick Hamlin <[EMAIL PROTECTED]> writes:
> > I have a patch that I have been using to support postgresql's
> > notion of ident authentication when using unix domain sockets on
> > Solaris. This patch basically just adds support for
it concerns me that despite it being day 3 of the July commit fest,
people are still being advised to add new items to the wiki page.
To make the idea work, we need to stick to the rules we defined when
we came up with the concept - specifically, no new patches once the
fest begins!
So please - n
Garick Hamlin <[EMAIL PROTECTED]> writes:
> I have a patch that I have been using to support postgresql's
> notion of ident authentication when using unix domain sockets on
> Solaris. This patch basically just adds support for using
> getupeercred() on Solaris so unix sockets and ident auth
On Thu, Jul 3, 2008 at 10:58 AM, Dean Rasheed <[EMAIL PROTECTED]> wrote:
>
> Here is an updated version of the patch, with a debug_explain_min_duration
> parameter to allow explaining of just slow-running queries. I've also
> incorporated
> a couple of Simon Riggs' suggestions for formatting the o
>
> What I'd be inclined to think about is making
> check_generic_type_consistency and related functions allow the
> arguments matched to ANYELEMENT to be of different actual types
> so long as select_common_type could determine a unique type to
> coerce them all to. It'd take some refactoring (no
Hi,
I have a patch that I have been using to support postgresql's
notion of ident authentication when using unix domain sockets on
Solaris. This patch basically just adds support for using
getupeercred() on Solaris so unix sockets and ident auth works just
like it does on Linux and elsewh
Tom Lane wrote:
To get a working WIN64 port it'd be necessary to go around and replace
long with size_t/ssize_t in the places where it matters --- but there
are not 450 of them, I don't think. And I'd advise not touching the
places that use int; that will just bloat the patch and make it harder
Here is an updated version of the patch, with a debug_explain_min_duration
parameter to allow explaining of just slow-running queries. I've also
incorporated
a couple of Simon Riggs' suggestions for formatting the output better.
Do I need to post this to -patches, or is that now obsolete?
Regar
David E. Wheeler wrote:
> On Jul 3, 2008, at 00:19, Teodor Sigaev wrote:
>
>>> Hash opclass is 5-times simpler that btree one :)
>>
>> CREATE FUNCTION citext_hash(mchar)
>> RETURNS int4
>> AS 'MODULE_PATHNAME'
>> LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
>>
>> CREATE OPERATOR CLASS citext_op
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Present us the actual problems as you discover them, and we will find a
> solution. Right now we are just guessing.
>> There seems to be two problems that affect 64-bit POSIX systems too:
> Well, 64-bit POSIX works just fine, so unless you can pres
On Jul 3, 2008, at 00:19, Teodor Sigaev wrote:
Hash opclass is 5-times simpler that btree one :)
CREATE FUNCTION citext_hash(mchar)
RETURNS int4
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
CREATE OPERATOR CLASS citext_ops
DEFAULT FOR TYPE mchar USING hash AS
Gregory Stark <[EMAIL PROTECTED]> writes:
> I think what you're suggesting is making integer and floating point constants
> like 0 and 0.1 be treated as "unknown" or perhaps a different kind of unknown,
> "unknown integral type" and "unknown numeric type".
No, that would be a pretty dangerous way
On Jul 2, 2008, at 22:14, Tom Lane wrote:
Note that this sort of stuff will mostly be fixed by pg_indent,
whether or not David does anything about it. But certainly
conforming to the project style to begin with will cause less
pain to reviewers' eyeballs.
Yeah, I'll change it. I'm JAPH, so ki
daveg <[EMAIL PROTECTED]> writes:
> On Thu, Jul 03, 2008 at 11:15:10AM +0300, Marko Kreen wrote:
>> - The statement_timeout is set back with "statement_timeout = default"
>> Maybe it would be better to do "= 0" here? Although such decision
>> would go outside the scope of the patch, I see no sense
"cinu" <[EMAIL PROTECTED]> writes:
Could anyone please tell me where I am going wrong and if there is a way I can
get the same behaviour that I am getting while I am executing the through psql
prompt.
a) you might try hitting return occasionally in your email :)
b) you maybe need to put a SEL
On Thu, 2008-07-03 at 19:56 +0530, cinu wrote:
> Could anyone please tell me where I am going wrong and if there is a
> way I can get the same behaviour that I am getting while I am
> executing the through psql prompt.
You're mistake is that you think a transaction is related to your
terminal, but
Hi All, I am having an issue with a deadlock scenario in PostgreSQL 8.3.1I have
the following database postgres, what I do is create two tables t1 and t2 in
this database and I have the following fileds t1(a_id smallint, fn
character(20), ln character(20), rt smallint)t2( c_id smallint, c_name
--On Montag, Juni 30, 2008 18:47:33 -0400 Bruce Momjian <[EMAIL PROTECTED]>
wrote:
I'd like to implement them if we agree on them
Bernd, have you made any progress on this?
Here's a patch for this. I'll add it to the commit fest wiki page if it's
okay for you.
--
Thanks
Thanks for pointers, that has cleared a few things up for me.
On 03/07/2008, at 11:27 PM, Csaba Nagy wrote:
On Thu, 2008-07-03 at 23:15 +1000, Aaron Spiteri wrote:
Inside foo there was a INSERT and UPDATE, and the INSERT failed but
the UPDATE succeeded would the UPDATE be rolled back?
Just t
On Thu, 2008-07-03 at 23:15 +1000, Aaron Spiteri wrote:
> Inside foo there was a INSERT and UPDATE, and the INSERT failed but
> the UPDATE succeeded would the UPDATE be rolled back?
Just to add to the other answers, if the INSERT is before the UPDATE in
the function, the function execution stops
am Thu, dem 03.07.2008, um 23:15:33 +1000 mailte Aaron Spiteri folgendes:
> Hi guys,
>
> I have been following the mailing list and reading the source code
> for a little while, and was wandering if someone could fill in the
> gaps for me. Does PostgresQL view updates and inserts performed
On Thu, 2008-07-03 at 13:54 +0100, Gregory Stark wrote:
> "Simon Riggs" <[EMAIL PROTECTED]> writes:
>
> > On Thu, 2008-07-03 at 14:11 +0300, Heikki Linnakangas wrote:
> >
> >> > What I'd like it to do is to recognise that the 0 should be cast
> >> > implicitly to another datatype within the same
Hi guys,
I have been following the mailing list and reading the source code
for a little while, and was wandering if someone could fill in the
gaps for me. Does PostgresQL view updates and inserts performed in a
function as part of the same transaction or are they considered
separate tr
On Thu, Jul 03, 2008 at 11:15:10AM +0300, Marko Kreen wrote:
> On 5/11/08, daveg <[EMAIL PROTECTED]> wrote:
> > Attached is a patch to add a commandline option to pg_dump to limit how
> > long
> > pg_dump will wait for locks during startup.
>
> My quick review:
>
> - It does not seem important
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> On Thu, 2008-07-03 at 14:11 +0300, Heikki Linnakangas wrote:
>
>> > What I'd like it to do is to recognise that the 0 should be cast
>> > implicitly to another datatype within the same family. I want and expect
>> > nvl(char_column, 0)
>> > to fail, but
Am Donnerstag, 3. Juli 2008 schrieb Ken Camann:
> > Anyway, back to the immediate problem. What would probably make sense
> > to try as a first step is something like
> >
> > #ifndef WIN64
> > typedef unsigned long Datum;/* XXX sizeof(long) >= sizeof(void *) */
> > #else
> > typedef unsigned l
On Thu, 2008-07-03 at 14:11 +0300, Heikki Linnakangas wrote:
> > What I'd like it to do is to recognise that the 0 should be cast
> > implicitly to another datatype within the same family. I want and expect
> > nvl(char_column, 0)
> > to fail, but I expect the various numeric/integer types we ha
Paul van den Bogaard wrote:
Since these data structures are for collecting information I was able to
create a new function that retrieves its information from these data
structures and returns them as a result from a query.
However this is too intrusive. Since everything is in shared memory it
Simon Riggs wrote:
I'm using the nvl() function from the orafce package. It is defined as a
polymorphic function so its function signature is
nvl(anyelement, anyelement)
Now if I try to use the function in this very typical way
nvl(numeric_col, 0)
we get
ERROR: function nvl(numeric, int
Tom Lane napsal(a):
Gregory Stark <[EMAIL PROTECTED]> writes:
Out of curiosity, what is a "user-defined collation"? Are there SQL statements
to go around declaring what order code points should be sorted in? That seems
like it would be... quite tedious!
Hm, that's a good point. SQL99 has
On Thu, 2008-07-03 at 12:22 +0200, Pavel Stehule wrote:
> 2008/7/3 Simon Riggs <[EMAIL PROTECTED]>:
> > I'm using the nvl() function from the orafce package. It is defined as a
> > polymorphic function so its function signature is
> > nvl(anyelement, anyelement)
> >
> > Now if I try to use the fu
2008/7/3 Simon Riggs <[EMAIL PROTECTED]>:
> I'm using the nvl() function from the orafce package. It is defined as a
> polymorphic function so its function signature is
> nvl(anyelement, anyelement)
>
> Now if I try to use the function in this very typical way
> nvl(numeric_col, 0)
>
> we get
>
>
to look into an idea I currently have I need (and implemented) a new
piece of memory that resides in (Postgres) shared memory. My data
structures are in place an the new database seems running fine. Even
under high load :-)
Since these data structures are for collecting information I was
Gregory Stark wrote:
> Well at least it caught the bug that Mark was performance testing with a
> --enable-cassert build :/
True ;) I appreciated that there would be some overhead, but I didn't
think it would be that much. This was mainly since I seem to remember
there was talk a while back o
I'm using the nvl() function from the orafce package. It is defined as a
polymorphic function so its function signature is
nvl(anyelement, anyelement)
Now if I try to use the function in this very typical way
nvl(numeric_col, 0)
we get
ERROR: function nvl(numeric, integer) does not exist
>> I'm inclined to think that we'd better turn that off by default,
>> since it's not looking like it's catching anything new.
Well at least it caught the bug that Mark was performance testing with a
--enable-cassert build :/
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.c
Tom Lane wrote:
> OK, I've reproduced the test case locally. I believe that when you
> say "worse", you mean "worse than 8.3", right? And you did tell me
> offlist that you were testing with --enable-cassert. CVS HEAD has
> very substantially greater cassert overhead because of the
> randomize
On 5/11/08, daveg <[EMAIL PROTECTED]> wrote:
> Attached is a patch to add a commandline option to pg_dump to limit how long
> pg_dump will wait for locks during startup.
My quick review:
- It does not seem important enough to waste a short option on.
Having only long option should be enough.
Hi,
[I've searched archives for the subject, but couldn't find a related
discussion. If there is any, sorry for duplication.]
We're migrating nearly a dozen of MSSQL servers of size ~100GiB per
cluster. For this purpose, we dump MSSQL data to COPY files using a Java
program. We have database sche
CREATE FUNCTION citext_hash(*citext*)
DEFAULT FOR TYPE *citext* USING hash AS
Oops, citext of course.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing
A bit long - the summary is that "intptr_t" should probably be used,
assuming I understand the problem this thread is talking about:
Ken Camann wrote:
1. An object in memory can have size "Size" (= size_t). So its big
(maybe 8 bytes).
2. An index into the buffer containing that object has inde
Douglass book, though I probably missed it. Anyone got a link for me to
read to make it happen?
Hash opclass is 5-times simpler that btree one :)
CREATE FUNCTION citext_hash(mchar)
RETURNS int4
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;
CREATE OPERATOR CLASS citext_o
61 matches
Mail list logo