Major psql overhaul by Peter Eisentraut.
But I didn't found any other references to that "quote" and, after
removing that line,
the code still compiles without any error/warning.
Did I overlook something?
Best regards,
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - sky
e existing psql's behavior, propose it
> yourself.
It could be interesting, maybe using a \pset quote_columns_char, I'll
think about, thank you.
Best regards.
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://github.com/guedes - http://guede
text);
CREATE TABLE
postgres=# \d x
Tabela "public.x"
Coluna | Tipo | Modificadores
--+--+---
aí | text |
This will break copy&paste user actions and scripts that parses that output.
Maybe the patch should consider left/right non-printable chars to
cho
2016-01-26 5:29 GMT-02:00 Tatsuo Ishii :
>
> I assume you used UTF-8 encoding database.
Yes, I do.
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://github.com/guedes - http://guedesoft.net
http://www.postgresql.org.br
--
Sent via pgsql-hackers mailing list
, 'título e');
format
"título e"
(1 row)
Time: 0,051 ms
postgres=# select format('%I', 'título_e');
format
------
título_e
(1 row)
Time: 0,051 ms
postgres=# select format('%I', '_título');
format
--
timizer/plan/planner.c;h=147c4deef3bb708ebb32b6781330f6ed980fc90c;hb=HEAD#l245
[]s
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://github.com/guedes - http://guedesoft.net
http://www.postgresql.org.br
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to
7;halfyear', date '2015-08-15');
rather than trying to overloading `date_part` with a UDF or
calculating half like:
select ceil(date_part('quarter', date '2015-08-15') / 2);
BTW, I feel that I have enough feedback to set patch as rejected.
Thank y
2015-08-14 21:40 GMT-03:00 David G. Johnston :
> On Friday, August 14, 2015, Dickson S. Guedes wrote:
>>
>>
>> The term is used in a school or college to represent a half-year.
>> Actually it could be evaluated from a date using some math with
>> 'quarter
r', current_date);
date_trunc
2015-07-01 00:00:00-03
(1 row)
Thanks!
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://github.com/guedes - http://guedesoft.net
http://www.postgresql.org.br
--
Sent via pgsql-hackers mailing list (pgsql-hacker
2015-08-14 20:58 GMT-03:00 Dickson S. Guedes :
> Hello hackers,
>
> * Description
>
> This patch is a proposal
Now patch attached, sorry.
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://github.com/guedes - http://guedesoft.net
http://www.po
ot; for EXTRACT is in the core, rather than in SQL.
* Syntax
I'm using the word 'semester' since it is common in college and school
but I wondering if it should be other word (like 'halfyear', for
example)
Is this a feature that worth?
BTW, I'll put this in the commi
dability?
If by one side this feature does not covers a more generalized case,
by other is a nice start, IMHO.
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://github.com/guedes - http://guedesoft.net
http://www.postgresql.org.br
--
Sent via pgsql-hackers mailing lis
Em Seg, 2013-05-20 às 14:35 +0200, Andres Freund escreveu:
> On 2013-05-20 09:31:15 -0300, Dickson S. Guedes wrote:
> > Hum, I was supposing that I was doing something wrong but I'm getting
> > the same result as before even using your test case and my results is
> >
Em Dom, 2013-05-19 às 09:29 +0300, Heikki Linnakangas escreveu:
> On 18.05.2013 03:52, Dickson S. Guedes wrote:
> >> pgbench -S is such a workload. With 9.3beta1, I'm seeing this
> >> profile, when I run "pgbench -S -c64 -j64 -T60 -M prepared" on a
> >&
t.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/executor/README;h=8afa1e3e4a7596475cbf19a76c88d48a04aeef02;hb=HEAD
>
There
>
>
is a cool flowchart too:
http://www.postgresql.org/developer/backend/
[]s
- --
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: gued
);
BTOH, we could provide a pg_cancel_backend(pid, boolean)
so when that boolean is true it will do that job. Particularly
I'm not a fan of this kind of boolean flag and appreciate
the two function above, so +1.
BTW, if somebody wants an explain-and-cancel behavior
he could creat
] [k]
> arch_local_irq_enable + 1.18% postgres postgres [.]
> AllocSetAlloc ...
I'd like to test this here but I couldn't reproduce that perf output
here in a 64-core or 24-core machines, could you post the changes to
postgresql.conf and the perf arguments
gt; expression.
In my tests, after ANALYZE _bug_header and _bug_line, the query plan
changes and query results returns as expected. Is this a chance that
things isn't too bad?
[]s
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.po
t
> "ledger_balance_key"
> DETAIL: Key (balance)=(1.00) already exists.
> -->
>
> What am I missing?
Isn't it on log output?
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
http://www.rnp.br/keyserver/pks/lookup?search=0x8F3E3C06D428D10A
signature.asc
Description: This is a digitally signed message part
5f7efa5deddbb388
[]s
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://github.com/guedes - http://guedesoft.net
http://www.postgresql.org.br
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgres
evelopers chatting.
[1] http://wiki.postgresql.org/wiki/Development_information
[2] http://wiki.postgresql.org/wiki/Todo
[3] http://wiki.postgresql.org/wiki/Reviewing_a_Patch
Best regards,
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://github.com/guedes - h
assign
/* reset error state */
Do I am missing something or the last one is unnecessary?
Best regards.
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://github.com/guedes - http://guedesoft.net
http://www.postgresql.org.br
--
Sent via pgsql-hackers mailing list
well on both linux and OS X.
I don't have access to an OSX box ATM but term_clear_screen(), in
libedit, didn't help?
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://github.com/guedes - http://guedesoft.net
http://www.postgresql.org.br
--
Sent via
Hi,
This patch fix the wrong examples in funcs.sgml introduced by the commit:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a570c98d7fa0841f17bbf51d62d02d9e493c7fcc
regards
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://github.com/guedes - http
2013/1/22 Tom Lane :
> Why should \s, and \s alone,
> need to remind you where you're cd'd to?
Why not just get rid of that prefixed cd'd path in \s?
[]s
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://github.com/guedes - http
; PG::Error: ERROR: relation "xxx" does not exist
Isn't that something with search_path?
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://github.com/guedes - http://guedesoft.net
http://www.postgresql.org.br
--
Sent via pgsql-hackers mailing list (pgsql
to not bear mentioning, I
> don't know, but the thought crossed my mind that someone might fail to
> realize it.
I think that should be a mention about that in docs, someone could
expect that ddl_command_end be reached even when
ddl_command_start erros out, and try to use it in some way.
Regards
op? Obviously we should
test #if we have readline enabled to use it, but when we have it a
nice output will bring to us.
BTW, I don't know how this will behaves on OSX or Windows.
[]s
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://github.com/guedes - http
2013/1/20 Xi Wang :
> The correct NULL check should use `*newval'; `newval' must be non-null.
[... cutting code ...]
Please see [1] to know how is our submit patch process.
[1] http://wiki.postgresql.org/wiki/Submitting_a_Patch
regards,
--
Dickson S. Guedes
mail/xmpp: gue...@
2013/1/20 Amit kapila :
> On Sunday, January 20, 2013 4:04 AM Dickson S. Guedes wrote:
> 2013/1/18 Amit kapila :
>>> Please find the rebased Patch for Compute MAX LSN.
>
>>The function 'remove_parent_refernces' couldn't be called
>>'remove_parent
2013/1/18 Amit kapila :
> Please find the rebased Patch for Compute MAX LSN.
The function 'remove_parent_refernces' couldn't be called
'remove_parent_references' ?
Why not an extension in PGXN instead of a contrib?
Regards,
--
Dickson S. Guedes
mail/xmpp: gue...@g
2013/1/16 Bruce Momjian :
> Wiki updated:
>
> https://wiki.postgresql.org/wiki/Parallel_Query_Execution
Could we add CTE to that opportunities list? I think that some kind of
queries in CTE queries could be easilly parallelized.
[]s
--
Dickson S. Guedes
mail/xmpp: gue...@gued
ok-if-stopped. But that's not very workable,
> if only because both would want the same single-letter abbreviation.
--ignore-status
--ignore-status-start
--ignore-status-stop
?
Regards
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - htt
ly simpler that way.
Yes, agreed. Other implementations should be in their own distinct
patches. BTW, it could be interesting search the archive for past
discussions about CINE.
I changed the status of this patch to "Ready for Committer".
Regards,
--
Dickson S. Guedes
mail/xmpp: gue
nd got the
expected results when try to create it if not exists.
Two questions:
- Should this patch implements others INEs like ADD COLUMN IF NOT EXISTS?
- Should pg_dump or pg_restore support some kind of flag to use a
CREATE SCHEMA IF NOT EXISTS ... instead CREATE SCHEMA ...?
Regards,
--
27;re missing support in copyfuncs.c and equalfuncs.c for the
>> new field in the node.
>
> You're completely right, thanks...
>
> The attached patch add support for the new field in the node in
> "copyfuncs.c" and "equalfuncs.c".
Maybe I'
t; Now, PostgreSQL don't trow an error if we use "IF NOT EXISTS" in "CREATE
> SCHEMA" statement.
I started testing this, but I didn't see regression tests for it.
Could you write them?.
Best.
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: g
ing in the documentation. At least the search box doesn't
> find it.
Try in the search box of postgres doxygen documentation [1]..
[1] http://doxygen.postgresql.org/
[]s
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
2012/6/21 Magnus Hagander :
> On Wed, Jun 20, 2012 at 1:35 PM, Dickson S. Guedes
> wrote:
>> 2012/6/20 Magnus Hagander :
>>> On Wed, Jun 20, 2012 at 11:23 AM, Marti Raudsepp wrote:
>>>> On Wed, Jun 20, 2012 at 12:18 PM, Magnus Hagander
>>>> wrote:
o and keeps the actual links (for beta) working.
I'm using the same pattern in `pgvm` [1] and it is failing to fetch
beta versions :(
[1] https://github.com/guedes/pgvm/blob/master/include/sites
regards
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedeso
tabase server, rather than
just to a file, and it seems like pgsql_fdw is the obvious choice".
We have dblink as contrib, why not pgsql_fdw too?
Other FDWs could be available at PGXN, pgFoundry, Github, etc.
[]s
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http:
would only happen when a backend's demand for a new stats
> file is generated before the collector starts to write a new stats file
> but not received till afterwards.
>
> Comments? Anyone see a flaw in this design? Or want to argue that
> we shouldn't do anything about such
tryed in a MS SQL Server 2012 via SQLFiddle [1]. I could only create
'cmssn' and 'cmssd' tables because as I can see in [2] MS SQL Server
2012 doesn't supports MATCH syntax.
The result was:
select * from cmssn;
F1 | F2
(null) | (null)
select * from cmss
2012/5/30 Robert Haas :
> I tested the effect of this by setting up a series of 5-minute
> read-only pgbench run at scale factor 300 with 8GB of shared buffers
> on the IBM POWER7 machine.
I know it doesn't matter, but out of curiosity what OS you used?
best regards,
--
Dickson
I'm not convinced yet, because a single comment in only one column is
enough to show the "Description"'s column again.
IMHO it seems to me that the only gain of this new proposed behaviour
only happens when there is no especial information about the columns,
like comments or stat ta
= -a;
> ERROR: new row for relation "tbl" violates check constraint "tbl_a_check"
> DETAIL: New row with data (x, -10) violates check constraint "tbl_a_check".
>
> The last line, the detailed error message, is added by the patch.
The patch uses 'N
en I'll wait
for more opinions about the original Josh's proposal to avoid
duplicate work.
> Nice to see you in PGBR by the way.
Nice to see you too! :)
Best regards.
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgre
Isn't that what pagers like 'less' and 'more' do already? May be we
could provide a pager more specific to psql output as a contrib or
extension.
[]s
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - htt
+-+-
> a | integer | plain
> b | integer | plain
> Has OIDs: no
Using your example, what if column 'b' has a comment and 'a' not? How
the above output will be displayed?
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype:
ers could be in the errmsg only
instead errhint, then errhint could be omited from patch if there
isn't a good hint to report.
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
--
Sent via pgsql-hackers mailing list (pgsq
catalog even if
> it breaks the compatibility?
Splitting pg_stat_bgwriter into pg_stat_bgwriter and
pg_stat_checkpointer will break something internal?
With this modification we'll see applications like monitoring tools
breaking, but they could use a view to put data back together in a
compatibl
2011/10/18 Simon Riggs :
> On Wed, Oct 5, 2011 at 8:02 AM, Simon Riggs wrote:
>> On Wed, Oct 5, 2011 at 5:10 AM, Dickson S. Guedes
>> wrote:
>>
>>> Ah ok! I started reviewing the v4 patch version, this is my comments:
>>
>> ...
>>
>
Hello all,
This is a little patch to fix a typo in docs. In the length function
should be a space between "string" and "bytea".
Best regards,
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
diff
perly.
Well, all the tests was running with the default postgresql.conf in my
laptop but I'll setup a more "real world" environment to test for
performance regression. Until now I couldn't notice any significant
difference in TPS before and after patch in a small environment.
2011/10/3 Simon Riggs :
> On Sun, Oct 2, 2011 at 11:45 PM, Dickson S. Guedes
> wrote:
>> I'm trying your patch, it was applied cleanly to master and compiled
>> ok. But since I started postgres I'm seeing a 99% of CPU usage:
>
> Oh, thanks. I see what happe
881 14878 99 19:37 ?00:03:07 postgres: checkpointer
process
guedes 14882 14878 0 19:37 ?00:00:00 postgres: wal writer
process
guedes 14883 14878 0 19:37 ?00:00:00 postgres: autovacuum
launcher process
guedes 14884 14878 0 19:37 ? 00:00:00 postgres: stats
co
es
(like this kind of "cache" between calls) provided by www_fdw, for
that WWW API based FDWs.
Regards.
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
--
Sent via pgsql-hackers mailing list (pgsql-hackers@p
s work fine, caching the Auth value.
How WWW_FDW could play with behaviors like that, since other Web APIs
has the a authorization system like this [2]?
[1] http://code.google.com/apis/contacts/docs/3.0/developers_guide.html
[2] http://code.google.com/apis/gdata/articles/using_cURL.html
.html
[2] http://www.postgresonline.com/journal/archives/201-returns-table.html
Best regards,
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.
o $?
overwrite y? n
0
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
tart operations with the saved
>> buffer cache as the same condition as just before the last shutdown.
>
> Offhand this seems pretty handy for benchmarks where it would help get
> reproducible results.
It could have an option to force it or not at start of postgres. This
could helps
[... cut ...]
It's very good Josh.
For filter purpose, could have the form a 32bits/64bits choice?
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.or
Sorry, wrong list.. apologizes.
Em 2 de maio de 2011 13:56, Dickson S. Guedes escreveu:
> Olá povo, tudo bem?
>
> Que tal ajudarmos a testar esta versão candidata?
>
> Visite [1] e [2] para mais informações
>
> [1] http://www.postgresql.org/developer/beta
> [2] http://
Olá povo, tudo bem?
Que tal ajudarmos a testar esta versão candidata?
Visite [1] e [2] para mais informações
[1] http://www.postgresql.org/developer/beta
[2] http://wiki.postgresql.org/wiki/HowToBetaTest
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net
Was the tcpip_socket variable changed on
caracara's host?
[]s
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Em Tue, 21 Jul 2009 16:52:48 -0300, Peter Eisentraut
escreveu:
On Friday 17 July 2009 23:24:16 Dickson S. Guedes wrote:
An use case that i can figure out is an user that connects in multiples
instances in a lot of remote sites (like home-officer for example) and
needs this information in the
Takahiro!
Hum, for key names ok, but for values, wouldn't this worse the output when
it is greater than 512 bytes?
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
http://www.rnp.br/keyserver/pks/lookup?search=0x8F3E3
Em Thu, 16 Jul 2009 17:40:45 -0300, Peter Eisentraut
escreveu:
On Thursday 07 May 2009 05:23:41 Dickson S. Guedes wrote:
This is a WIP patch (for the TODO item in the subject) that I'm putting
in the Commit Fest queue for 8.5.
More generally, does anyone actually need this feature?
s not btree-specific, but could be used by other index AMs", so could
be better trying to think about this in a way to find another alternative,
if it is possible.
[1] http://archives.postgresql.org/pgsql-hackers/2009-04/msg00234.php
Thanks for your patch!
[]s
Dickson S. Guedes
http://p
Em Thu, 09 Jul 2009 19:58:01 -0300, Josh Berkus
escreveu:
The real question is slow-to-upgrade OSes like HP-UX, AIX, OpenBSD and
Solaris. What version of Bison are they shipping with?
In AIX 5.3: bison (GNU Bison) 1.875
[]s
Dickson S. Guedes
http://pgcon.postgresql.org.br
http
e log with some
important columns like "who" do "what" on "where" and "when".
This could help, maybe with a RSS in that (like in git).
[]s
Dickson S. Guedes
http://pgcon.postgresql.org.br
http://www.postgresql.org.br
--
Sent via pgsql-hackers mailin
comments of patches thath have one.
Would be nice if a theres is a way to order by some column like Patch Name,
Topic, Status, Author and Last Activity for example. Some descriptions was
truncated because de maxsize of textbox.
regards,
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: gu
ased on
pgcommitfest tables sctructure [1]?
[1]
http://git.postgresql.org/gitweb?p=pgcommitfest.git;a=blob;f=etc/table.sql;h=c60a298c863ef3e88dcfd16572781d2b435ca629;hb=HEAD
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.b
servers.
I agree with you that this feature should be postponed.
Best Regards,
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
http://www.rnp.br/keyserver/pks/lookup?search=0x8F3E3C06D428D10A
signature.asc
Description: Esta é uma parte de mensagem assinada digitalmente
Where can I find a more recent version of syncrep patch. The last one
that I've here is synch_rep_0428 and I'm getting segfault with it ":(.
In Wiki [1] the last is syncrep_0305
[1] http://wiki.postgresql.org/wiki/NTT%27s_Development_Projects
[]s
--
Dickson S. Guedes
Em Dom, 2009-05-17 às 19:22 +0200, hubert depesz lubaczewski escreveu:
> it doesn't for this query:
>
> SELECT i from generate_series(now(), CAST('infinity'::date AS
> timestamp), interval '1 hour') as x (i) limit 3;
>
> which (as far as i understand it) should be the same.
>
> why is it not lim
Em Sáb, 2009-05-16 às 23:40 -0400, Tom Lane escreveu:
> "Dickson S. Guedes" writes:
> > Is a simple "SELECT generate_series(now(), CAST('infinity'::date AS
> > timestamp), interval '1 hour');" working forever, an expected
> > behavior
Hi all
Is a simple "SELECT generate_series(now(), CAST('infinity'::date AS
timestamp), interval '1 hour');" working forever, an expected
behavior?
regards...
--
Dickson S. Guedes
-
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.p
Em Qui, 2009-05-14 às 09:35 +0300, Heikki Linnakangas escreveu:
> Dickson S. Guedes wrote:
> > Hi all,
> >
> > Attached is a patch to fix a command line example in charset.sgml.
>
> No, the options really are called LC_COLLATE and LC_CTYPE now. They were
> rename
Hi all,
Attached is a patch to fix a command line example in charset.sgml.
I hope it is correct.
[]s
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
fix_typo_lc_collatein_charset_sgml.patch.bz2
Description
Em Qui, 2009-05-07 às 10:11 +0300, Peter Eisentraut escreveu:
> On Thursday 07 May 2009 05:23:41 Dickson S. Guedes wrote:
> > This is a WIP patch (for the TODO item in the subject) that I'm putting
> > in the Commit Fest queue for 8.5.
>
> How about you just put the va
This is a WIP patch (for the TODO item in the subject) that I'm putting
in the Commit Fest queue for 8.5.
regards...
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
psql_escape_client_server_version.patch.bz2
Descri
Em Qua, 2009-05-06 às 13:49 -0700, Joshua D. Drake escreveu:
> On Wed, 2009-05-06 at 17:42 -0300, Dickson S. Guedes wrote:
> > Em Qua, 2009-05-06 às 16:27 -0400, Tom Lane escreveu:
> > > Alvaro Herrera writes:
> > > > I think it would be better that the sche
you'd have to remember to give the switch both for the
> -i run and the normal test runs.
So, in my opinion, the Joshua alternative is a good little change that
let "pgbench" runs in a more flexible way.
But, there is the possibility that someone are using an automated script
uot;.
A text warning about this could be shown at start of pgbench if the
target database isn't named "pgbench", for examplo, or just some text
could be added to the docs.
regards.
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - ht
E? I'm thinking in the scenario that this is allowed we can
do a update that don't satisfies the actual partition rule but another
in other partition, so the data will be moved?
This make senses?
[]s
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://gued
emp_xxx,
> CASE WHEN THEN emp_yyy,
> CASE WHEN emp_zzz,
> ELSE emp_default
> END CASE;
> );
>
> Original-Nachricht
> > Datum: Tue, 21 Apr 2009 10:46:41 -0300
> > Von: "Dickson S. Guedes"
> > An: Kedar Potdar , pgsql-hackers
gt; (
> emp_500 (START 1 END 500),
> emp_1500 (START 500 END 1500),
> emp_4000 (START 1520 END 4000)
> );
What if I need more columns to set the partitions?
[]s
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://planeta.postgresql.or
abled when track_activities is off.
> I'll fix it in the next patch. Also, I'd better measure overheads
> by the patch.
Will be very nice if I could on/off it. When done, please send us. I'd
like to test it in some stress scenarios, enabling and disabling it on
som
here:
1) How will be this behavior in a syncrep environment? I don't have one
here to test this, yet.
2) I couldn't find a clear way to disable it. There is one in this patch
or are you planning this to future?
Regards,
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skyp
to JOIN
vw_that_works - an example view that works without grouping some columns
vw_that_not_works -> an example view that throws an error
thanks.
--
Dickson S. Guedes
-
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://planeta.postgresql.org.br
test_error_failed_t
Em Sáb, 2009-03-07 às 19:38 -0500, Tom Lane escreveu:
> "Dickson S. Guedes" writes:
> > And bellow is the select that returns: "ERROR: failed to locate grouping
> > columns"
> > when no rows is returned by the View above, but it runs well when one or
&
e to use JOINs then all works fine... meaning the
problem is something in SUBSELECTs and VARCHAR used in that way.
Is this a bug or a expected behavior?
best regards.
--
Dickson S. Guedes
-
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://planeta.postgresql.org.br
--
Thomas pointed out, I think my AIX is missing libm.
>
> I will try to install it and post again when I have some news.
Please, install the linuxtoolbox for AIX, try compile again and tell
us. It means that somethings is missing in your box.
[]s
Dickson S. Guedes
-
mail/xmpp: gue...@guede
tg...@db01 $ export AR="ar -X64"
postg...@db01 $ ./configure --enable-integer-datetimes
--prefix=/srv/postgresql/8.3.6
postg...@db01 $ make
...
...
And all is done fine. Course, all above is for 64 bits compilling.
How you are trying that?
[]s
Dickson S. Guedes
-
mail/
resql/work/postgresql-8.3.6/src/test/regress'
gmake[1]: *** [installcheck] Error 2
gmake[1]: Leaving directory `/srv/postgresql/work/postgresql-8.3.6/src/test'
gmake: *** [installcheck] Error 2
make: 1254-004 The error code from the last command is 2.
Stop.
---
I'm wrong in anything?
Thank
is more suitable, I also think.
Any other ideas?
'walsender' should be a schema in the 'replication' database. Other
modules, in replication feature, could be placed there too.
[]s
--
Dickson S. Guedes
Administrador de Banco de Dados
Confesol - Projeto Colmeia
Florianopo
py.
You could have it in two parts - an agent running on the server, started
over ssh and GUI interface running on users workstation which talk to
said agent.
And I'd suggest you use wxPython for GUI part if you want a relatively
modern look.
Or the GUI could be a part of pgAdmin.
er_id)
SELECT level, lpad(' ', level*4) || last_name FROM employee_rec;" ?
In my opnion, it will be more simple to understand too.
--
[]s
Dickson S. Guedes
Administrador de Banco de Dados
Projeto Colmeia - Florianópolis, SC
(48) 3322-1185, ramal: 26
--
Sent via pgsql-hackers mailin
Hi all,
While i'm testing the HEAD version of CVS with this new feature, i
found a possible bug and like that more persons could try it in you
own box.
The attached file is a log of my test and I'm using a unprivileged
user to do it.
Thanks.
--
[]s
Dickson
1 - 100 of 107 matches
Mail list logo
