Re: [HACKERS] parallel restore

ne seems to be an optimization... maybe it's better to split in two incremental patches? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.o

Re: [HACKERS] parallel restore

On Tue, Jan 6, 2009 at 4:32 PM, Tom Lane wrote: > Andrew Dunstan writes: >> Jaime Casanova wrote: >>> i'm using: >>> pg_restore -f mic.backup -Fc -v -m5 > >> Strange. Maybe the server log will show activity? > > There's no connection info,

Re: [HACKERS] parallel restore

On Tue, Jan 6, 2009 at 4:04 PM, Jaime Casanova wrote: > On Mon, Dec 29, 2008 at 6:42 PM, Andrew Dunstan wrote: >> >> Attached is the latest parallel restore patch. I think this is getting >> fairly close. >> > > hi, i was making some tests in windows... > any

Re: [HACKERS] parallel restore

-Fc -v -m5 there is a way to know if it's really hanging or is simply too slow? i plan to let it run all night long just in case... -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsq

Re: [HACKERS] sum() over (partition by order) question

can be described better... don't know exactly if we can imitate this behaviour without window functions -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-

Re: [HACKERS] about truncate

late the child tables from the parent table, then you want to > remove all the rows from the parent table. > you're spying me? exactly that happen to me... ;) my first attempt was to execute TRUNCATE ONLY... and gives me an error and the thread begun... -- Atentamente, Jaime Casa

Re: [HACKERS] TODO items for window functions

a very laizy or novice definition) but if that is correct or near correct maybe we need to follow the same pattern: create function -- without any decoration create aggregate maybe with a decoration of being window o create window aggregate or something similar... -- Atentamente, Jaime C

Re: [HACKERS] WIP: Automatic view update rules

issueing a warning. > yes. if we didn't do that we will be against spec. syntax rule 12 (again in 11.19 ) says: """ 12)If WITH CHECK OPTION is specified, then the viewed table shall be updatable. """ -- Atentamente, Jaime Casanova Sopor

Re: [HACKERS] [idea] a copied relkind in pg_attribute

ld files is handled as a regular file suddenly, it can > make a confusion. It is a similar situation. > doesn't understand this... -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hack

Re: [HACKERS] WIP: Automatic view update rules

om foo where id < 10 with check option; NOTICE: CREATE VIEW will create implicit INSERT/UPDATE/DELETE rules CREATE VIEW 3) one final point: seems like you'll have to update the rules regression test (attached the regression.diffs) -- Atentamente, Jaime Casanova Soporte y capacitación d

[HACKERS] hot standby on mingw

icolon at end of struct or union ../../../../src/include/access/xact.h:184: warning: type defaults to `int' in declaration of `xl_xact_abort_prepared' ../../../../src/include/access/xact.h:184: warning: data definition has no type or storage class make[4]: *** [heapam.o] Error 1 i gues

Re: [HACKERS] parallel restore vs. windows

On Sun, Dec 14, 2008 at 12:13 PM, Andrew Dunstan wrote: > > This version completes properly on Windows with the regression database. > actually, this one doesn't apply cleanly on head -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrol

Re: [HACKERS] [idea] a copied relkind in pg_attribute

ature optimization and that AFAIR is the root of all evil :) -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To mak

Re: [HACKERS] reloptions and toast tables

against the first) -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] about truncate

Hi, just out of curiosity, why TRUNCATE doesn't support ONLY? audit=# TRUNCATE only postgres_log; ERROR: syntax error at or near "only" LINE 1: TRUNCATE only postgres_log; -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guay

Re: [HACKERS] rules regression test failed on mingw

gression-# select 'S2' union all select 's2' regression-# order by 1; ?column? -- s1 S1 s2 S2 (4 rows) -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador

Re: [HACKERS] Preventing index scans for non-recoverable index AMs

On Wed, Dec 17, 2008 at 5:47 PM, Kenneth Marshall wrote: > Rebuilding a hash index for the case > for which it is preferred (large, large tables) would be excrutiating. > there's such a situation? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y

Re: [HACKERS] Preventing index scans for non-recoverable index AMs

On Wed, Dec 17, 2008 at 5:54 PM, Simon Riggs wrote: > We don't yet have a mechanism for an > index AM to say "damn, this index is screwed up, don't use it". > mark pg_index.indisvalid and/or pg_index.indisready to false in the hot standby node? -- Atentame

Re: [HACKERS] Preventing index scans for non-recoverable index AMs

because makes those more slow without any benefit at all... now there will be one... -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresq

Re: [HACKERS] Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1

w partitions (inherit tables and modify the trigger)... and what i want to see is an automatic creation when it's needed... -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-ha

Re: [HACKERS] rules regression test failed on mingw

iour is correct in spain... we have a lot of spanish languages ;) administra...@casanova10 ~/pg.build/8.4dev $ bin/psql -a -f test.sql postgres select 'wieck'::text < 'wiech'::text; ?column? -- f (1 row) select 'wiech'::text < 'wieck'::

Re: [HACKERS] rules regression test failed on mingw

On Mon, Dec 15, 2008 at 10:26 AM, Alvaro Herrera wrote: > Tom Lane wrote: >> "Jaime Casanova" writes: >> > On Mon, Dec 15, 2008 at 8:59 AM, Tom Lane wrote: >> >> What locale is this running in? >> >> > Seems this is Spanish_Spain.1252 an

Re: [HACKERS] rules regression test failed on mingw

those rules? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] rules regression test failed on mingw

On Mon, Dec 15, 2008 at 8:59 AM, Tom Lane wrote: > "Jaime Casanova" writes: >> i'm seeing a fail in the rules regression, seems like it is not >> ordering the results right even when the regression has an explicit >> order by... > > What locale is this

[HACKERS] rules regression test failed on mingw

more info -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 regression.diffs Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscrip

Re: [HACKERS] Block-level CRC checks

On Thu, Nov 13, 2008 at 1:00 PM, Alvaro Herrera > This patch is also skipping pd_special and the unused area of the page. > v11 doesn't apply to cvs head anymore -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil -

Re: [HACKERS] Quick patch: Display sequence owner

y the table of course, but I'd > imagine to most people it'd just be noise. Could see it being shown in > the verbose version, \d+ foo.bar. > that's exactly why we want the aditional info... the idea of putting it on \d+ doesn't sounds too bad... to me at least... > For

Re: [HACKERS] Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1

On Thu, Nov 27, 2008 at 10:10 AM, Jaime Casanova <[EMAIL PROTECTED]> wrote: > On Thu, Nov 27, 2008 at 9:41 AM, Robert Haas <[EMAIL PROTECTED]> wrote: >> On Thu, Nov 27, 2008 at 8:31 AM, Gregory Stark <[EMAIL PROTECTED]> wrote: >>>> CREATE PARTITION t

Re: [HACKERS] Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1

using CREATE TABLE because we are inventing new syntax but it seems like using ALTER TABLE is a *lot* of work altough ISTM more usefull -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1

ce for a foreign key. > not directly, but you always can create a trigger instead of the foreign key constraint... mmm...the docs says that there is no good workaround, what about mention a trigger? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de

Re: [HACKERS] Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1

; i review it on nov 6, and there were open questions by me and by Emmanuel none of those has been answered: http://archives.postgresql.org/pgsql-hackers/2008-11/msg00362.php -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuado

[HACKERS] where is the last hot standby patch?

i get lost with this one... i thought there were two patches that get merged into one, but i don't find nor the merged version nor the actualized version of any of one... -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuado

Re: [HACKERS] Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1

On Wed, Nov 5, 2008 at 11:47 PM, Jaime Casanova <[EMAIL PROTECTED]> wrote: > On Fri, Oct 31, 2008 at 7:42 PM, Emmanuel Cecchet <[EMAIL PROTECTED]> wrote: >> Hi Nikhil, >> > > i'm looking at this one: > http://archives.postgresql.org/message-id/[EMAIL PRO

Re: [HACKERS] [PATCHES] Solve a problem of LC_TIME of windows.

t right, the patch should contain something like: if (len > dstlen) { return 0; } -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@po

Re: [HACKERS] HEAD build failure on win32 mingw

hing was good... i thouhgt it was a problem already solved... could be a problem in the nightly builds? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@

Re: [HACKERS] CVS can't be built on mingw

help. This is not a new requirement. > well, i haven't had perl on windows from several years and i have been building postgres for testing since last month and this is the first time i got this error. Maybe psql's sql_help.h is not mandatory to the building process? -- Atentamente, Jai

[HACKERS] CVS can't be built on mingw

having perl to build on mingw. That wasn't the case before, maybe we need a warning in the configure just as we do now with bison and flex? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via

Re: [HACKERS] failed test float8 on mingw

On Tue, Nov 11, 2008 at 4:48 PM, Jaime Casanova <[EMAIL PROTECTED]> wrote: > On Tue, Nov 11, 2008 at 4:32 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote: >> Jaime Casanova wrote: >>> On Tue, Nov 11, 2008 at 12:17 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote: &g

Re: [HACKERS] failed test float8 on mingw

On Tue, Nov 11, 2008 at 4:32 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote: > Jaime Casanova wrote: >> On Tue, Nov 11, 2008 at 12:17 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote: >>> Do earlier versions work if built on this machine? Like 8.3-latest? My guess >&

Re: [HACKERS] failed test float8 on mingw

declaration of 'gettimeofday' was here All of this, is with ./configure --prefix=/home/Administrador/pgsql-8.1 --enable-cassert --enable-debug --enable-depend --with-pgport=5434 --without-zlib Something i forgot to mention, because it doesn't seems related, is that i had to manually incl

[HACKERS] Hot standby v5d, fails to build on windows

s no type or storage class """ I was able to compile changing uint for uint32 but i'm not sure if that is the aproppiate type... -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 --

Re: [HACKERS] [PATCHES] Solve a problem of LC_TIME of windows.

s that (i honestly doesn't understand this patch very well ;)? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] failed test float8 on mingw

actual result output: SELECT '10e-400'::float8; ! float8 ! ! 0 ! (1 row) ! SELECT '-10e-400'::float8; ! float8 ! ! 0 ! (1 row) -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guaya

Re: [HACKERS] question for patch "Automatically update view"

AFAIR, this patch only supports SQL92 so only views based on single tables are supported... There isn't a message indicating that the view will not be updatable? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +5

Re: [HACKERS] another question i met during reviewing

yone give me a help? > actually that is intentional, there was a lot of problems in original implementation of CHECK OPTION :) http://archives.postgresql.org/message-id/[EMAIL PROTECTED] -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaqui

Re: [HACKERS] regression in analyze

On 11/6/08, Jaime Casanova <[EMAIL PROTECTED]> wrote: > On Thu, Nov 6, 2008 at 9:24 AM, Matteo Beccati <[EMAIL PROTECTED]> wrote: >> Hi, >> >>> Attached test shows a regression in analyze command. >>> Expected rows in an empty table is 2140 even after

Re: [HACKERS] regression in analyze

, as I've just checked that 8.0 did > behave the same. However the question also was raised a few days ago on > the italian mailing list and I couldn't find a reasonable explanation > for it. > mmm yeah! i'm seeing the same at 8.3 too :( -- Atentamente, Jaime Casanova

[HACKERS] regression in analyze

Hi all, Attached test shows a regression in analyze command. Expected rows in an empty table is 2140 even after an ANALYZE is executed -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 psql (8.4devel) You

Re: [HACKERS] Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1

rest, the patch passes all regression tests and seems to work as advertized -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

[HACKERS] can we create a record of more than one field?

r message ERROR: function result type must be integer because of OUT parameters i was expecting the result to be a record because of the SETOF record. it's a bug or intentional? this is in 8.3.4 -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo d

[HACKERS] Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1

just remembering that -patches is a dead list, so i'm sending this to -hackers where it will have more visibility... -- Forwarded message -- From: Jaime Casanova <[EMAIL PROTECTED]> Date: Oct 22, 2008 9:43 AM Subject: Re: [PATCHES] Auto Partitioning Patch - WIP v

Re: [HACKERS] avoid create a tablespace in pg_tblspc

On Thu, Oct 9, 2008 at 6:22 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Jaime Casanova" <[EMAIL PROTECTED]> writes: >> bug report http://archives.postgresql.org/pgsql-bugs/2008-10/msg00037.php >> seems like a reasonably request to me... and one that is simple to

[HACKERS] avoid create a tablespace in pg_tblspc

Hi, bug report http://archives.postgresql.org/pgsql-bugs/2008-10/msg00037.php seems like a reasonably request to me... and one that is simple to fulfill, just create a PG_VERSION in the pg_tblspc dir at initdb. if no one objects, here is a one linear patch for that -- regards, Jaime Casanova

Re: [HACKERS] trigger functions broken?

> > And? > > The function returns a TRIGGER, not a value. > actually, that means that you can return undefined values for NEW and OLD...and worse you can update other tables based on undefined NEW/OLD values? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesorí

Re: [HACKERS] Common Table Expressions applied; some issues remain

on what to do? One possibility is to flatten only > if the subquery doesn't contain any volatile functions. > maybe i'm missing something but AFAIR postgres will not try to optimize (push down/pull up) if it see any volatile function. -- Atentamente, Jaime Casanova Soporte y capa

Re: [HACKERS] [PATCH] allow has_table_privilege(..., 'usage') on sequences

er "SELECT * FROM sequence", which definitely needs to have > different privileges from nextval()/currval(). > can we tell there is consensus in create a new has_sequence_privilege()? Abhijit will you make it? if not i can make a try... -- regards, Jaime Casanova Soporte y capacitac

Re: Column level privileges was:(Re: [HACKERS] Extending grant insert on tables to sequences)

ce to work on this? It's next on my list and > I'll start working on it tonight unless you've had a chance to get to > it. Please let me know. > not really, i start to read the code... but was interrupted for a new task... (if we only could send kill -9 signals to work tas

Re: [HACKERS] Extending grant insert on tables to sequences

on tables to sequences" for this Commit Fest without being an updated patch -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. (593) 87171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make c

Re: [HACKERS] [PATCH] allow has_table_privilege(..., 'usage') on sequences

On Thu, Aug 7, 2008 at 3:08 AM, Abhijit Menon-Sen <[EMAIL PROTECTED]> wrote: > I just noticed, to my dismay, that has_table_privilege() does not allow > me to check for usage privileges on sequences. > Maybe we want a new function has_sequence_privilege() instead? -- regards,

Re: [HACKERS] Extending grant insert on tables to sequences

On Fri, Aug 22, 2008 at 10:19 PM, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > Added to September commit fest. > updating the patch with one that only extends inserts. though, i haven't look at the col level privs patch yet. -- regards, Jaime Casanova Soporte y capaci

Re: [HACKERS] Proposal: new border setting in psql

we are trying to make cosmetic magic instead of solve the real problem... what about the idea someone propose of having output formats hooks... seems more reasonable to me -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel

Re: [HACKERS] September Commit Fest coming soon!

On Tue, Aug 26, 2008 at 1:28 PM, Josh Berkus <[EMAIL PROTECTED]> wrote: > > Second, I need to know who's available for round-robin reviewing for this > commitfest (September 1-15). let's make a try... count with me for round-robin reviewing... -- regards, Jaime Casano

Re: [HACKERS] Extending grant insert on tables to sequences

On Fri, Aug 22, 2008 at 10:19 PM, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > Added to September commit fest. > why? there isn't a new patch yet... i haven't sent it because i want to see the column level privileges patch first because Tom's complaints -- reg

Re: [HACKERS] A smaller default postgresql.conf

uot; ones... i have seen to many people turning off fsync in OLTP systems 'cause someone tolds them that will improve speed... and work_mem setted at 256Mb because that improves a bad query that should be rewritten as something more sanely... -- regards, Jaime Casanova Soporte y capacitación de

Re: [HACKERS] Re: [COMMITTERS] pgsql: Make the pg_stat_activity view call a SRF

| i have done pg_lock_status and pg_show_all_settings the other three will do tomorrow -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. (593) 87171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@

Re: [HACKERS] benchmark farm

On 1/21/08, Andrew Dunstan <[EMAIL PROTECTED]> wrote: > > It's on my (very long) TODO list to add benchmarking as an option on the > buildfarm. If you're interested in working on it then contact me offline and > we will work on how to move forward. > any move in thi

Re: Column level privileges was:(Re: [HACKERS] Extending grant insert on tables to sequences)

On 7/25/08, Stephen Frost <[EMAIL PROTECTED]> wrote: > * Jaime Casanova ([EMAIL PROTECTED]) wrote: > > ok, seems this is the last one for column level patch > > http://archives.postgresql.org/pgsql-patches/2008-04/msg00417.php > > > > any one working it... > &g

Re: Column level privileges was:(Re: [HACKERS] Extending grant insert on tables to sequences)

On Fri, Jul 25, 2008 at 4:51 AM, Stephen Frost <[EMAIL PROTECTED]> wrote: > * Jaime Casanova ([EMAIL PROTECTED]) wrote: >> ok, seems this is the last one for column level patch >> http://archives.postgresql.org/pgsql-patches/2008-04/msg00417.php >> >> any one work

Column level privileges was:(Re: [HACKERS] Extending grant insert on tables to sequences)

On Thu, Jul 24, 2008 at 12:09 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Jaime Casanova" <[EMAIL PROTECTED]> writes: >>> Another issue is the interaction with the planned column-level GRANT >>> feature. > >> Although that is a feature we want,

Re: [HACKERS] Extending grant insert on tables to sequences

t; the problems mentioned above. However, it would mean that it'd be > impossible to grant INSERT without effectively granting sequence USAGE > --- revoking USAGE on the sequence wouldn't stop anything. Plus, \z on > the sequence would fail to tell you about those implicitly held rights. see

Re: [HACKERS] Extending grant insert on tables to sequences

leges & (ACL_INSERT | ACL_UPDATE | ACL_SELECT >> + { > > The parentheses around the first comparison can go away, and also the > ones around the ACL_* here: > ok -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL Guayaquil - Ecuador Cel. (593) 8717115

Re: [HACKERS] Extending grant insert on tables to sequences

complaint he just asked what is the use case... if people think it should be removed ok, but OTOH: why? i don't think that affects anything... -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL Guayaquil - Ecuador Cel. (593) 87171157 Index: doc/src/sgml/ref/grant.sgml =

Re: [HACKERS] [PATCHES] Extending grant insert on tables to sequences

On 7/8/08, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Jaime Casanova escribió: > > On Thu, May 22, 2008 at 1:18 PM, Jaime Casanova <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > > > The idea of this patch is to avoid the need to make explicit grants

Re: [HACKERS] CommitFest rules

age. Does that > sound right? > yeah! that was always the process... email to -hackers the proposal, design, discussion, etc... email to -patches the patch itself... the only change is that we are no longer using -patches for this but the commitfest page. -- regards, Jaime Casanova Soporte

Re: [HACKERS] proposal for smaller indexes on index-ordered tables

ot yet ensure that indexed tables remain indexed. > Just for the records. you mean *ordered* tables, don't you? Postgres does not yet ensure that ordered tables remain ordered. -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL Guayaquil - Ecuador Cel. (593) 87171157

Re: [HACKERS] Setting a pre-existing index as a primary key

T NULL constraints and a declared primary key ... so what > > did you really need it for? > > Agreed, functionally there's not much of a difference. It's more of a > matter of proper design identifying a primary key. > set right constraints it's good for documenting

Re: [HACKERS] column level privileges

On Tue, Apr 1, 2008 at 5:40 PM, Andrew Dunstan <[EMAIL PROTECTED]> wrote: > > Apologies if this gets duplicated - original seems to have been dropped due > to patch size - this time I am sending it gzipped. > just for the record, this patch doesn't apply cleanly to

Re: [HACKERS] [PATCHES] Updatable views

even if it doesn't apply... just to see what needs to be done... -- regards, Jaime Casanova -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] [PATCHES] 2WRS [WIP]

*/ > #ifdef TRACE_SORT > booltrace_sort = false; > #endif > - #ifdef DEBUG_BOUNDED_SORT > - booloptimize_bounded_sort = true; > - #endif it's seems you're removing something added in 8.3 -- regards, Jaime Casanova "Programming today is a race b

[HACKERS] -U option in psql

quot; ignored Password for user -U: psql: fe_sendauth: no password supplied -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the u

Re: [HACKERS] patch queue needs update was:(PostgreSQL 8.4 development plan)

"Add GUC temp_tablespaces toprovide a default location for" patch was actually committed in 8.3 and it's still on the patch queue http://momjian.us/mhonarc/patches_hold/msg0.html i think a depuration will be needed to keep the first "commit fests" simple... -- regards, Ja

Re: [HACKERS] NULL OR ZERO

On Feb 3, 2008 7:26 PM, Omar Bettin <[EMAIL PROTECTED]> wrote: > Probably I am on the wrong place but for me NULL on numbers means 0 or ZERO. > I know about standards... > NULL means unknown value, ZERO is a known value -- regards, Jaime Casanova "Programming today is a r

Re: [HACKERS] could not open relation: Invalid argument

On Jan 15, 2008 4:25 AM, Magnus Hagander <[EMAIL PROTECTED]> wrote: > On Mon, Jan 14, 2008 at 10:12:55PM -0500, Jaime Casanova wrote: > > On Jan 14, 2008 11:03 AM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > > > Roberts, Jon wrote: > > > > Ve

Re: [HACKERS] could not open relation: Invalid argument

f you want i can send it to you... if your mail server doesn't accept large files (the zip file is 5.6 mb) then maybe someone can share some space for temporarily store it... -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and

Re: [HACKERS] pgwin32_open returning EINVAL

On Dec 20, 2007 9:31 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Jaime Casanova escribió: > > > it doesn't compile on current head on mingw 5.1 and msys 1.0.10; of > > course, it doesn't compile on 8.2 neither in order to Alvaro's contact > > to tes

Re: [HACKERS] pgwin32_open returning EINVAL

ld returned 1 exit status d:\mingw\bin\dllwrap.exe: d:\mingw\bin\gcc exited with status 1 make[3]: *** [libpq.a] Error 1 make[3]: Leaving directory `/home/General/PG_RELEASES/pgsql-8.3/src/interfaces/libpq' make[2]: *** [all] Error 2 make[2]: Leaving directory `/home/General/PG_RELEASES/pg

[HACKERS] compiling postgres in winxp

all] Error 2 make[1]: Leaving directory `/home/General/postgresql-8.2.5/src' make: *** [install] Error 2 -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger

Re: [HACKERS] Time to update list of contributors

On Nov 27, 2007 7:08 PM, Josh Berkus <[EMAIL PROTECTED]> wrote: > Jaime Casanova, Venezuala Ecuador > Bernd Helmle and he's from germany http://www.oopsware.de/private/bernd.html -- regards, Jaime Casanova "Programming today is a race between software engineers strivi

Re: [HACKERS] Function structure in formatting.c

> each of the KeyWords. It makes the code simpler, more readable -- and > considerably shorter. > > A patch will be on the way shortly. > take your time, this seems like it will be for 8.4 anyway -- regards, Jaime Casanova "Programming today is a race between software engineers

Re: [HACKERS] 76AC-752C-3D91 : CONFIRM from pgsql-hackers (subscribe)

On 8/7/07, Bertram Scharpf <[EMAIL PROTECTED]> wrote: > accept 76AC-752C-3D91 > cool, good for you -- Atentamente, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to p

Re: [HACKERS] Possible feature request

8.2: http://www.postgresql.org/docs/8.2/static/sql-update.html -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idi

Re: [HACKERS] plpgsql FOR loop doesn't guard against strange step values

://archives.postgresql.org/pgsql-committers/2007-07/msg00142.php at least the part that prevents overflow and probably the one that reject zero in BY are clearly bugs and should be backpatched to 8.2, aren't they? -- regards, Jaime Casanova "Programming today is a race between softw

Re: [HACKERS] what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL

me relfilenode; there's no need for extra catalog entries. we recently make the path for temp files to be just base/pgsql_tmp or pg_tblspc//pgsql_tmp. do we want to complicate things again? while not just a new rekind indicating this is a template and not and actual table. and using th

Re: [HACKERS] month abreviation

On 6/22/07, Euler Taveira de Oliveira <[EMAIL PROTECTED]> wrote: Jaime Casanova wrote: > note the month abreviation (mons?) is this intentional? > This notation has been used since the code was written (~7 years ago) [1]. [1] http://developer.postgresql.org/cvsweb.cgi/pgsql/src/b

[HACKERS] month abreviation

(prerelease) (Debian 4.1.1-21) (1 row) note the month abreviation (mons?) is this intentional? sgerp=# select age(current_date, '1979-08-15'::date); age - 27 years 10 mons 5 days (1 row) -- Atentamente, Jaime Casanova "Programming today is a race b

Re: [HACKERS] wrong sql statement crashes backend

encoding: Use default text encoding for outgoing messages Use Unicode (UTF-8) encoding for outgoing messages probably pavel had UTF-8 encoding -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof p

Re: [HACKERS] [COMMITTERS] pgsql: Create a GUC parametertemp_tablespacesthat allows selection of

spaces *per file*, which is not the way it works now. ok. are you doing this? or can i prepare a patch that implements this? i guess we can allocate the memory for the list in TopTransactionContext. -- regards, Jaime Casanova "Programming today is a race between software engineers strivin

Re: [HACKERS] [COMMITTERS] pgsql: Create a GUC parametertemp_tablespacesthatallows selection of

parses the GUC on every GetTempTablespaces() call :( -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winni

Re: [HACKERS] Reviewing temp_tablespaces GUC patch

On 5/27/07, Robert Treat <[EMAIL PROTECTED]> wrote: On Friday 25 May 2007 12:39, Jaime Casanova wrote: > On 5/25/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > Bernd Helmle <[EMAIL PROTECTED]> writes: > > > --On Freitag, Mai 25, 2007 10:49:29 + Jaime Ca

Re: [HACKERS] Reviewing temp_tablespaces GUC patch

On 5/25/07, Bernd Helmle <[EMAIL PROTECTED]> wrote: --On Freitag, Mai 25, 2007 00:02:06 + Jaime Casanova <[EMAIL PROTECTED]> wrote: > sounds good. can we see the new patch? Attached tablespace.c.diff shows my current changes to use an OID lookup list. on second thought,

<    2   3   4   5   6   7   8   9   >