Re: [HACKERS] [PATCH] WIP Add ALWAYS DEFERRED option for constraints

På onsdag 04. oktober 2017 kl. 00:24:19, skrev Vik Fearing < vik.fear...@2ndquadrant.com <mailto:vik.fear...@2ndquadrant.com>>: On 10/03/2017 10:10 PM, Andreas Joseph Krogh wrote: > While we're in deferrable constraints land...; > I even more often need deferrable /cond

Re: [HACKERS] [PATCH] WIP Add ALWAYS DEFERRED option for constraints

rted: CREATE UNIQUE INDEX some_uk ON email_folder(owner_id, folder_type, name) WHERE parent_idIS NULL DEFERRABLE INITIALLY DEFERRED;   Are there any plans to support this?   Thanks.   -- Andreas Joseph Krogh  

Re: [HACKERS] Clarification in pg10's pgupgrade.html step 10 (upgrading standby servers)

På mandag 18. september 2017 kl. 16:28:07, skrev Bruce Momjian mailto:br...@momjian.us>>: On Sat, Sep 16, 2017 at 11:36:40PM +0200, Andreas Joseph Krogh wrote: > På lørdag 16. september 2017 kl. 18:34:51, skrev Bruce Momjian < > br...@momjian.us>: >     No.  If you ran in

Re: [HACKERS] Clarification in pg10's pgupgrade.html step 10 (upgrading standby servers)

På lørdag 16. september 2017 kl. 18:34:51, skrev Bruce Momjian mailto:br...@momjian.us>>: On Sat, Sep 16, 2017 at 06:11:17PM +0200, Andreas Joseph Krogh wrote: > I'm a little unsure what scenario we're trying to describe here. Copying the > pg_wal separately (for which ther

Re: [HACKERS] Clarification in pg10's pgupgrade.html step 10 (upgrading standby servers)

På lørdag 16. september 2017 kl. 17:24:14, skrev Bruce Momjian mailto:br...@momjian.us>>: On Fri, Sep 15, 2017 at 01:23:45AM +0200, Andreas Joseph Krogh wrote: > I tested upgrading from 9.6 to 10 now, using pg_upgrade, and pg_upgrade creates > the new data-dir with pg_wal "

Re: [HACKERS] Clarification in pg10's pgupgrade.html step 10 (upgrading standby servers)

På torsdag 14. september 2017 kl. 21:13:56, skrev Bruce Momjian < br...@momjian.us <mailto:br...@momjian.us>>: On Thu, Sep 14, 2017 at 08:49:24PM +0200, Andreas Joseph Krogh wrote: >     I think the tablespace example is clear enough to modify for WAL and we >     instruct the

Re: [HACKERS] Clarification in pg10's pgupgrade.html step 10 (upgrading standby servers)

På torsdag 14. september 2017 kl. 20:39:34, skrev Bruce Momjian < br...@momjian.us <mailto:br...@momjian.us>>: On Wed, Sep 13, 2017 at 04:31:09PM +0200, Andreas Joseph Krogh wrote: > På onsdag 13. september 2017 kl. 15:26:27, skrev Bruce Momjian < > br...@momjian.us>:

Re: [HACKERS] Clarification in pg10's pgupgrade.html step 10 (upgrading standby servers)

På onsdag 13. september 2017 kl. 15:26:27, skrev Bruce Momjian mailto:br...@momjian.us>>: On Wed, Sep 13, 2017 at 01:35:17AM +0200, Andreas Joseph Krogh wrote: [snip] > I know I'm being a little nitty-gritty here, but if it helps me understand it > might help others. I

Re: [HACKERS] Clarification in pg10's pgupgrade.html step 10 (upgrading standby servers)

På onsdag 13. september 2017 kl. 01:54:15, skrev Stephen Frost < sfr...@snowman.net <mailto:sfr...@snowman.net>>: Andreas, * Andreas Joseph Krogh (andr...@visena.com) wrote: > I have to ask; Why not run pg_upgrade on standby, after verifying that it's in > sync with p

Re: [HACKERS] Clarification in pg10's pgupgrade.html step 10 (upgrading standby servers)

PG to realize they should do. Thanks! Stephen     Thanks for th explaination.   I have to ask; Why not run pg_upgrade on standby, after verifying that it's in sync with primary and promoting it to primary if necessary and then making it standby again after pg_upgrade is finished

Re: [HACKERS] Clarification in pg10's pgupgrade.html step 10 (upgrading standby servers)

På onsdag 13. september 2017 kl. 01:00:20, skrev Bruce Momjian mailto:br...@momjian.us>>: On Wed, Sep 13, 2017 at 12:40:32AM +0200, Andreas Joseph Krogh wrote: > På tirsdag 12. september 2017 kl. 23:52:02, skrev Bruce Momjian < > br...@momjian.us>: > >     On Tue, Se

Re: [HACKERS] Clarification in pg10's pgupgrade.html step 10 (upgrading standby servers)

På tirsdag 12. september 2017 kl. 23:52:02, skrev Bruce Momjian < br...@momjian.us <mailto:br...@momjian.us>>: On Tue, Sep 12, 2017 at 08:59:05PM +0200, Andreas Joseph Krogh wrote: >     Improvements? > > Thanks, that certainly improves things. > But; I still fin

Re: [HACKERS] Clarification in pg10's pgupgrade.html step 10 (upgrading standby servers)

På tirsdag 12. september 2017 kl. 21:11:45, skrev Robert Haas < robertmh...@gmail.com <mailto:robertmh...@gmail.com>>: On Tue, Sep 12, 2017 at 2:59 PM, Andreas Joseph Krogh wrote: > There are many ways to do/configure things it seems, resulting in many ifs > and buts whic

Re: [HACKERS] Clarification in pg10's pgupgrade.html step 10 (upgrading standby servers)

På tirsdag 12. september 2017 kl. 19:19:22, skrev Bruce Momjian < br...@momjian.us <mailto:br...@momjian.us>>: On Thu, Aug  3, 2017 at 11:37:32AM +0200, Michael Paquier wrote: > On Mon, Jul 31, 2017 at 6:13 PM, Robert Haas wrote: > > On Fri, Jul 28, 2017 at 10:35 AM,

Re: [HACKERS] Release Note changes

that case;   "If upgrading from a 9.4 server or later, and you don't use Large Objects, external utilities using logical decoding, such as pglogical or proprietary alternatives, can also provide an alternate route, often with lower downtime."   pg_upgrade or pg_dump is really the only option for us using LOs.   -- Andreas Joseph Krogh

[HACKERS] Clarification in pg10's pgupgrade.html step 10 (upgrading standby servers)

ed, and step 10-f should provide a clarer example with more detailed values for the directory-structures involved.   I really think section 10 needs improvement as I'm certainly not comfortable upgrading standbys following the existing procedure.   Thanks.   -- Andreas Joseph Krogh

Re: [HACKERS] CTE inlining

.pdf   PG is not on top wrt. CTE, but could have been if CTEs were not this "established" fence.   +1 for removing this fence and get all the possible optimization we can. -- Andreas Joseph Krogh  

Re: [HACKERS] Gather Merge

På fredag 10. mars 2017 kl. 10:34:48, skrev Rushabh Lathia < rushabh.lat...@gmail.com <mailto:rushabh.lat...@gmail.com>>:     On Fri, Mar 10, 2017 at 2:42 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På fredag 10. mars 2017 kl. 10:09:22, skrev Rushabh Lathia

Re: [HACKERS] Gather Merge

På fredag 10. mars 2017 kl. 10:09:22, skrev Rushabh Lathia < rushabh.lat...@gmail.com <mailto:rushabh.lat...@gmail.com>>:     On Fri, Mar 10, 2017 at 2:33 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: [...] The execution-plan seems (unsurprisingly) to depend on

Re: [HACKERS] Gather Merge

På fredag 10. mars 2017 kl. 09:53:47, skrev Rushabh Lathia < rushabh.lat...@gmail.com <mailto:rushabh.lat...@gmail.com>>:     On Fri, Mar 10, 2017 at 1:44 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På torsdag 09. mars 2017 kl. 18:09:45, skrev Robert Ha

Re: [HACKERS] Gather Merge

 │ │ Execution time: 170.859 ms                │     -- Andreas Joseph Krogh  

[HACKERS] Error building docs

es.sgml:14:19:E: element "BOOK" undefined osx:postgres.sgml:15:7:E: element "TITLE" undefined osx:postgres.sgml:17:10:E: element "BOOKINFO" undefined osx:postgres.sgml:18:13:E: element "CORPAUTHOR" undefined osx:postgres.sgml:19:14:E: element "PRODUC

Re: [HACKERS] Move pg_largeobject to a different tablespace *without* turning on system_table_mods.

På onsdag 19. oktober 2016 kl. 18:44:24, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > På onsdag 19. oktober 2016 kl. 18:29:31, skrev Bruce Momjian   I think an open question is why you would not want to move the other >  system tables at the same t

Re: [HACKERS] Move pg_largeobject to a different tablespace *without* turning on system_table_mods.

På onsdag 19. oktober 2016 kl. 18:42:11, skrev Bruce Momjian mailto:br...@momjian.us>>: On Wed, Oct 19, 2016 at 06:33:55PM +0200, Andreas Joseph Krogh wrote: > På onsdag 19. oktober 2016 kl. 18:29:31, skrev Bruce Momjian >: > >     On Tue, Oct 18, 2016 at 04:51:54PM +02

Re: [HACKERS] Move pg_largeobject to a different tablespace *without* turning on system_table_mods.

På onsdag 19. oktober 2016 kl. 18:29:31, skrev Bruce Momjian mailto:br...@momjian.us>>: On Tue, Oct 18, 2016 at 04:51:54PM +0200, Andreas Joseph Krogh wrote: >     > 2. Being able to move pg_largeobject to a different tablespace >     >    *without* turning on system_t

Re: [HACKERS] Move pg_largeobject to a different tablespace *without* turning on system_table_mods.

På tirsdag 18. oktober 2016 kl. 16:26:37, skrev Euler Taveira < eu...@timbira.com.br <mailto:eu...@timbira.com.br>>: On 18-10-2016 10:13, Andreas Joseph Krogh wrote: > From time to time pg_largeobject comes up as an issue with being > implemented as a system-catalog. &g

[HACKERS] Move pg_largeobject to a different tablespace *without* turning on system_table_mods.

one willing to discuss this?   Thanks.   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://www.visena.com> <https://www.visena.com>

Re: [HACKERS] pg_upgrade 9.5 -> 9.6 fails when pg_largeobject is in separate tablespace

På søndag 09. oktober 2016 kl. 23:43:23, skrev Robert Haas < robertmh...@gmail.com <mailto:robertmh...@gmail.com>>: On Sat, Oct 8, 2016 at 9:02 AM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: (I've set allow_system_table_mods=on in postgresql.conf) Any conf

[HACKERS] pg_upgrade 9.5 -> 9.6 fails when pg_largeobject is in separate tablespace

O andreak andreak psql -U postgres -c "alter table pg_largeobject set tablespace andreak_lo" -d andreak Is this a bug or not a supported configuration by pg_upgraded? Any hints on how to proceed?   Thanks.   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://www.visena.com> <https://www.visena.com>

Re: [HACKERS] Bogus ANALYZE results for an otherwise-unique column with many nulls

anon onp_crm_activity act (cost=0.00..10591.45 rows=217245 width=8) (actualtime=0.186..139.016 rows=220147 loops=1) -> Hash (cost=262.35..262.35 rows=13711 width=4) (actual time=28.980..28.980 rows=13760 loops=1) Buckets: 16384Batches: 1 Memory Usage: 612kB -> Index Only Scan using onp_crm_project_pkeyon onp_crm_project proj (cost=0.29..262.35 rows=13711 width= 4) (actual time=0.067..26.575 rows=13760 loops=1) Heap Fetches: 6146 Planning time: 41.021 ms Execution time: 605.530 ms (60 rows)   That's 420195 / 605 = 695x speedup! Thanks!   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://www.visena.com> <https://www.visena.com>  

Re: [HACKERS] Bogus ANALYZE results for an otherwise-unique column with many nulls

  Will this then make it into the soon-to-be-released 9.5.4?   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://www.visena.com> <https://www.visena.com>  

Re: [HACKERS] Bogus ANALYZE results for an otherwise-unique column with many nulls

Batches: 1 Memory Usage: 69kB -> IndexScan using onp_crm_person_onp_id_idx on onp_crm_person logfor (cost =0.14..25.02rows=4515 width=8) (actual time=0.032..0.270 rows=119 loops=4) Filter: (NOT is_resource) Rows Removed by Filter: 8 Planning time: 2.443 ms Executiontime: 239.979 ms (38 rows)   A

Re: [HACKERS] ERROR: ORDER/GROUP BY expression not found in targetlist

På fredag 17. juni 2016 kl. 08:14:39, skrev Amit Kapila mailto:amit.kapil...@gmail.com>>: On Fri, Jun 17, 2016 at 11:39 AM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På torsdag 16. juni 2016 kl. 20:19:44, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Amit Kapi

Re: [HACKERS] ERROR: ORDER/GROUP BY expression not found in targetlist

to use INT_MAX ... regards, tom lane   As of 4c56f3269a84a81461cc53941e0eee02fc920ab6 I'm still getting it in one of my queries: ORDER/GROUP BY expression not found in targetlist   Am I missing something?   I could dig into this further to reproduce if necessary.   -- Andreas Joseph Krog

Re: [HACKERS] 10.0

På fredag 13. mai 2016 kl. 18:22:00, skrev Magnus Hagander mailto:mag...@hagander.net>>: On Fri, May 13, 2016 at 5:42 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På fredag 13. mai 2016 kl. 17:05:23, skrev Robert Haas mailto:robertmh...@gmail.com>>: Hi, There

Re: [HACKERS] 10.0

lly fast FTS (with proper, index-backed, sorting etc.) - Pluggable storage-engines   Thanks.   -- Andreas Joseph Krogh  

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

På fredag 22. april 2016 kl. 14:56:33, skrev Robert Haas mailto:robertmh...@gmail.com>>: On Thu, Apr 21, 2016 at 7:20 PM, Tom Lane wrote: > Robert Haas writes: >> On Thu, Apr 21, 2016 at 4:01 PM, Gavin Flower >> wrote: >>> Why not 4?  As most processors now have at least 4 physical cores, &

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

hen, at the end of beta, we can decide what the default should be.   +1   Not enabling it per default gives the signal "It's not safe".   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com

Re: [HACKERS] Covering + unique indexes

På lørdag 09. april 2016 kl. 06:34:39, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > Any reason $subject didn't make it (commited but reverted)? See the thread on -committers.   Ah, thanks.   -- Andreas Joseph Krogh

[HACKERS] Covering + unique indexes

Any reason $subject didn't make it (commited but reverted)?   This is a great feature and lots of work seems to have been put into this patch along with quite some reviewing. It would be nice to know why -hackers think it's not ready for 9.6.   Thanks.   -- Andreas Joseph Krogh

Re: [HACKERS] [PATCH] Phrase search ported to 9.6

select 'fat'::tsquery *** 'cat'; ? Single '*' ?  That's close to regex, any number of tokens. And it saves rules about duplicating character. select 'fat'::tsquery ** 'cat'; select 'fat * cat'::tsquery; select 'fat * [3] cat'::tsqyery; -- for non-default distance.   What about ~> ?   -- Andreas Joseph Krogh

Re: [HACKERS] [PATCH] Phrase search ported to 9.6

På tirsdag 02. februar 2016 kl. 12:04:21, skrev Alvaro Herrera < alvhe...@2ndquadrant.com <mailto:alvhe...@2ndquadrant.com>>: Andreas Joseph Krogh wrote:    > Which seems to indicate it has received a fair amount of testing and is quite > stable. > Hopefully it in

Re: [HACKERS] [PATCH] Phrase search ported to 9.6

På tirsdag 02. februar 2016 kl. 09:20:06, skrev Oleg Bartunov < obartu...@gmail.com <mailto:obartu...@gmail.com>>:     On Tue, Feb 2, 2016 at 10:18 AM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På tirsdag 02. februar 2016 kl. 04:22:57, skrev Michael Paquier m

Re: [HACKERS] [PATCH] Phrase search ported to 9.6

d Oleg Bartunov in 2009, so all credit goes to them. Any feedback is welcome. This is not a small patch: 28 files changed, 2441 insertions(+), 380 deletions(-) And the last CF of 9.6 should not contain rather large patches. -- Michael     OTOH; It would be extremely nice to get this into 9.6.    

Re: [HACKERS] Triggers on transaction?

only run once, and on the last update of "col" so that it sees 'bar'.   -- Andreas Joseph Krogh CTO / Partner - Visena AS

Re: [HACKERS] Support for detailed description of errors cased by trigger-violations

På lørdag 08. november 2014 kl. 23:39:50, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > Hi. �� When working with Oracle it is possible to catch constraint-violations > caused by triggers using JDBC, but it seems this isn't possible using PG, s

[HACKERS] Support for detailed description of errors cased by trigger-violations

ports this fine, with details about which table, column etc. causing the violation. Is there any work going on or are there any plans to support similar info for violations caused by triggers?   Thanks.   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visen

Re: [HACKERS] nulls in GIN index

ftstext. plainto_tsquery('English', 'how are you') = '' and the ftstext of some rows is also = '' So why doesn't the index return all these rows when a null string is searched. I think you can see what im trying to achieve, how do I do it?   Use the

Re: [HACKERS] Setting PG-version without recompiling

På torsdag 03. juli 2014 kl. 16:16:01, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > Hi. �� I'm up for testing 9.4 but my JDBC-driver fails to connect due to PG's > minor-version string: "4beta1". Is it possible to set this somewhere

Re: [HACKERS] Setting PG-version without recompiling

På torsdag 03. juli 2014 kl. 11:13:44, skrev Abhijit Menon-Sen < a...@2ndquadrant.com >: At 2014-07-03 11:02:34 +0200, andr...@visena.com wrote: > > Is it possible to set this somewhere without > recompiling PG? I'm afraid not.   Ok   -- Andreas Jospeh Krogh CTO /

[HACKERS] Setting PG-version without recompiling

Hi.   I'm up for testing 9.4 but my JDBC-driver fails to connect due to PG's minor-version string: "4beta1". Is it possible to set this somewhere without recompiling PG?   Thanks.   -- Andreas Jospeh Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com

Re: [HACKERS] BDR-project

På onsdag 08. januar 2014 kl. 18:57:52, skrev Simon Riggs mailto:si...@2ndquadrant.com>>: On 25 December 2013 12:01, Andreas Joseph Krogh wrote: > Ref: > http://wiki.postgresql.org/wiki/BDR_Project > > Is implementing main BDR features into core Postgres a probable objec

[HACKERS] BDR-project

Hi hackers.   Ref: http://wiki.postgresql.org/wiki/BDR_Project   Is implementing main BDR features into core Postgres a probable objective to version 9.4?   Thanks.   -- Andreas Joseph Krogh       mob: +47 909 56 963 Senior Software Developer / CTO - OfficeNet AS - http://www.officenet.no

Re: [HACKERS] Covering Indexes

lumns. And I wonder if it would work well with expressions, too? David This is analogous to SQL Server's "include" : |CREATE NONCLUSTERED INDEX my_idx| |ON my_table (status)| |INCLUDE (someColumn, otherColumn)| Which is useful, but bloats the index. -- Andreas Joseph Krogh -

Re: [HACKERS] WIP: SP-GiST, Space-Partitioned GiST

-obvious here, but will this patch bring indexed substring-search to PG? So queries conceptually equal to this will be possible to index: WHERE som_col @@ ':substr1:&:substr2!substr3:' meaning "contains substr1" AND "ends with substr2" OR "starts with substr3&

Re: [HACKERS] potential bug in trigger with boolean params

På onsdag 11. mai 2011 kl 11:30:51 skrev Szymon Guz <mabew...@gmail.com>: On 11 May 2011 11:01, Andreas Joseph Krogh <andr...@officenet.no> wrote: På onsdag 11. mai 2011 kl 10:56:19 skrev <t...@fuzzy.cz>:   > > Hi, > > I was trying to create a trigger with para

Re: [HACKERS] potential bug in trigger with boolean params

true' is > not one of them (TRUE is). See this: > > http://www.postgresql.org/docs/9.0/interactive/datatype-boolean.html What are you trying to accomplish? "CREATE OR REPLACE FUNCTION trigger_x()" does not declare any formal-parameters, so calling it with arguments doesn

Re: [HACKERS] accentuated letters in text-search

On 07/22/2010 07:42 AM, Guillaume Lelarge wrote: Le 21/07/2010 23:23, Andreas Joseph Krogh a écrit : [...] I was googling for how to create a text-seach-config with the following properties: - Map unicode accentuated letters to an un-accentuated equivalent - No stop-words - Lowercase all

[HACKERS] accentuated letters in text-search

more googling I found this: http://www.sai.msu.su/~megera/wiki/unaccent Any reason the unaccent dict. and function did not make it in 9.0? -- Andreas Joseph Krogh Senior Software Developer / CTO +-+ OfficeNet AS| The

Re: [HACKERS] 8.5 vs. 9.0

On Friday 22. January 2010 01.22.09 Tom Lane wrote: > "Larry Rosenman" writes: > > On Thu, January 21, 2010 5:53 pm, Andreas Joseph Krogh wrote: > >> Care to shed some light on what features (yes, we users care about > >> features) warrant this major ve

Re: [HACKERS] 8.5 vs. 9.0

decided that the next release shall be > > Wait for it > > 9.0. Care to shed some light on what features (yes, we users care about features) warrant this major version-bump? Is there a link somewhere? -- Andreas Joseph Krogh Senior

Re: [HACKERS] NOT NULL violation and error-message

On Tuesday 12. January 2010 11.10.09 Takahiro Itagaki wrote: > > Andreas Joseph Krogh wrote: > > > ERROR: null value in column "created" violates not-null constraint > > It is easy to add the table name to the message, but ... > > > ERROR: null val

[HACKERS] NOT NULL violation and error-message

t; violates not-null constraint Oracle does this btw... -- Andreas Joseph Krogh Senior Software Developer / CTO +-+ OfficeNet AS| The most difficult thing in the world is to | Rosenholmveien 25 | know how t

Re: [HACKERS] Windowing Function Patch Review -> ROW_NUMBER without ORDER BY

max(row_number()) over() as total_rows from employees; To get the maximum number of rows in a separate column. Very usefull when writing queries to retrieve "paged" results. Like "Give me the 20 top articles sorted on date and also the total number of articles" in

Re: [HACKERS] Window Functions

On Tuesday 14 October 2008 18:19:07 Hannu Krosing wrote: > On Tue, 2008-10-14 at 11:05 +0200, Andreas Joseph Krogh wrote: > > Hi all. > > This is not very "hackers"-related, but related to the topic of > > window-funcitons, which seems to be discussed quite a b

[HACKERS] Window Functions

returns the total number or columns in a separate column. This is very handy for web-pages which for example need to display the rist 20 results of several million, without having to do a separate count(*) query. -- Andreas Joseph Krogh &

Re: [HACKERS] Identifier case folding notes

On Wednesday 09 July 2008 00:35:07 Tom Lane wrote: > Andreas Joseph Krogh <[EMAIL PROTECTED]> writes: > > Right. From a user's perspective 4) sounds best. I often run into problems > > having keywords as column-names: > > None of the proposals on the table will

Re: [HACKERS] Identifier case folding notes

LINE 1: insert into test("USER") values('testuser'); ^ andreak=# insert into test(user) values('testuser'); ERROR: syntax error at or near "user" LINE 1: insert into test(user) values('testuser');

Re: [HACKERS] Sorting Improvements for 8.4

el executions for sorting, aggregates nodes or other parts of the > executor? > > Hope this helps, regards, And remember; Users don't care about portability-issues, they care about performance. If multi-threading is a way to speed up sorting considerably, it shou

Re: [HACKERS] Javascript support in the backend, i.e. PL/JS

On Friday 16 November 2007 12:23:26 Sam Mason wrote: > On Fri, Nov 16, 2007 at 12:05:02PM +0100, Andreas Joseph Krogh wrote: > > On Friday 16 November 2007 11:29:09 Sam Mason wrote: > > [snip] > > > > > SP? > > > > Stored Procedure > > That was ki

Re: [HACKERS] Javascript support in the backend, i.e. PL/JS

On Friday 16 November 2007 11:29:09 Sam Mason wrote: [snip] > SP? Stored Procedure -- Andreas Joseph Krogh <[EMAIL PROTECTED]> Senior Software Developer / Manager +-+ OfficeNet AS| The most difficult thi

Re: [HACKERS] Javascript support in the backend, i.e. PL/JS

browser language with lots of bad side-effects", but that's 'cause they don't know the language, really. JS actually has some nice programming concepts and being able to use it as an SP seems pretty attractive. Keep up the good work! -- Andreas Joseph Krogh <[E

Re: [HACKERS] psql show dbsize?

\l should print this info at all. > > regards, tom lane What about \l+ ? The '+' is already in \d, so it's a known "feature", and then people wanting more info from \l can use \l+. -- Andreas Josep

Re: [HACKERS] Including Snapshot Info with Indexes

On Friday 12 October 2007 11:49:17 Heikki Linnakangas wrote: > Andreas Joseph Krogh wrote: > > Will $SUBJECT make it possible for count(*) to use index? This is a much > > wanted feature. > > Yes, both the DSM approach and the approach proposed by Gokul. Good. -- Andreas

Re: [HACKERS] Including Snapshot Info with Indexes

Will $SUBJECT make it possible for count(*) to use index? This is a much wanted feature. -- Andreas Joseph Krogh <[EMAIL PROTECTED]> Senior Software Developer / Manager +-+ OfficeNet AS| The most difficult th

Re: [HACKERS] 8.3 version of ts_headline

gt; >>> SELECT headline('default', 'a b c', 'c'::tsquery, > >>> 'StartSel=, StopSel='); > >>> ERROR: syntax error Aha, thanks! -- Andreas Joseph Krogh <[EMAIL PROTECTED]> Senior Software Developer / Manager --

Re: [HACKERS] 8.3 version of ts_headline

On Friday 14 September 2007 20:26:28 Tom Lane wrote: > Andreas Joseph Krogh <[EMAIL PROTECTED]> writes: > > In 8.2 this produces an error: > > > > SELECT headline('default', 'a b c', 'c'::tsquery, > > 'StartSel=, StopSel=&

[HACKERS] 8.3 version of ts_headline

:tsquery, 'StartSel=, StopSel='); headline -- a b c (1 row) In the modern age people use stylesheets and it seems awkward that it's not possible to highlight headlines using stylesheets in PG. Is this intentional, or a glitch? Is it possible to extend ts_hea

Re: [HACKERS] bug or feature, || -operator and NULLs

On Wednesday 18 October 2006 14:44, Mario Weilguni wrote: > Am Mittwoch, 18. Oktober 2006 13:52 schrieb Andreas Joseph Krogh: > > This has been been discussed before, but Oracle behaves differently, and > > IMHO in a more correct way. > > > > The following query returns

Re: [HACKERS] bug or feature, || -operator and NULLs

"coalesce" "nvl" => a lot easier to type ;-) They actually support COALESCE now and explicit JOINs too. -- Andreas Joseph Krogh <[EMAIL PROTECTED]> Senior Software Developer / Manager gpg public_key: http://dev.officenet.no/~andreak/public_key.asc --

Re: [HACKERS] bug or feature, || -operator and NULLs

On Wednesday 18 October 2006 15:13, Andrew Dunstan wrote: > Andreas Joseph Krogh wrote: > > This has been been discussed before, but Oracle behaves differently, and > > IMHO in a more correct way. > > > > The following query returns NULL in PG: > > SELECT NULL ||

Re: [HACKERS] bug or feature, || -operator and NULLs

. > Concatenate "value not known" with 'fisk' -> what's the logical answer? > > I would say the logical result is 'value not known'... if one of the > components is not known, how can you know what is the result ? That's like saying: S

[HACKERS] bug or feature, || -operator and NULLs

This has been been discussed before, but Oracle behaves differently, and IMHO in a more correct way. The following query returns NULL in PG: SELECT NULL || 'fisk'; But in Oracle, it returns 'fisk': SELECT NULL || 'fisk' FROM DUAL; The latter seems more logica

[HACKERS] lower() not working correctly...?

I have the following query: select lower(firstname) || ' ' || lower(lastname) from person firstname and lastname are VARCHAR lower() returns NULL when firstname OR lastname is NULL, is this correct? This is 8.2devel from 24.08.2006. -- Andreas Joseph Krogh <[EMAIL PROTECTED]>

[HACKERS] Wrong list, sorry (was: lower() not working correctly...?)

Sent to pgsql-sql now. -- Andreas Joseph Krogh <[EMAIL PROTECTED]> Senior Software Developer / Manager gpg public_key: http://dev.officenet.no/~andreak/public_key.asc +-+ OfficeNet AS| The most difficult thing

Re: [HACKERS] pg_dump schema breakup

er", but > the above are poor names for these concepts. But it certainly would be nice to be able to dump all that "stuff":-) -- Andreas Joseph Krogh <[EMAIL PROTECTED]> Senior Software Developer / Manager gpg public_key: http://dev.officenet.no/~andreak/pu

Re: [HACKERS] file-locking and postmaster.pid

that because one solution doesn't fit all needs on all platforms(or NFS), it shouldn't be implemented on those platforms it *does* work on. Why can't those platforms(like Linux) benefit from a better solution, if one exists? There are plenty of examples of software providing better solut

Re: [HACKERS] file-locking and postmaster.pid

On Wednesday 24 May 2006 20:52, Andrej Ricnik-Bay wrote: > On 5/24/06, Andreas Joseph Krogh <[EMAIL PROTECTED]> wrote: > > > My PG is not started with startup-scripts, but with this command: > > > > > > pg_ctl -D $PGDATA -l $PGDIR/log/logfile-`date +%Y-%m-%d

Re: [HACKERS] file-locking and postmaster.pid

t; We've ignored Andreas' original question. Why not use a lock to > indicate that the postmaster is still running? At first blush, that > seems more reliable than checking for a (possibly recycled) process ID. As Tom replied: Portability. -- Andreas Joseph Krogh <[EMAIL PROTECTED

Re: [HACKERS] file-locking and postmaster.pid

On Wednesday 24 May 2006 11:36, Andreas Joseph Krogh wrote: > On Tuesday 23 May 2006 19:36, Tom Lane wrote: > > Adis Nezirovic <[EMAIL PROTECTED]> writes: > > > Well, maybe you could tweak postgres startup script, add check for post > > > master (either 'p

Re: [HACKERS] file-locking and postmaster.pid

ts, but with this command: pg_ctl -D $PGDATA -l $PGDIR/log/logfile-`date +%Y-%m-%d`.log start -- Andreas Joseph Krogh <[EMAIL PROTECTED]> Senior Software Developer / Manager gpg public_key: http://dev.officenet.no/~andreak/public_key.asc +---

Re: [HACKERS] file-locking and postmaster.pid

On Tuesday 23 May 2006 17:54, Tom Lane wrote: > Andreas Joseph Krogh <[EMAIL PROTECTED]> writes: > > I've experienced several times that PG has died somehow and the > > postmaster.pid file still exists 'cause PG hasn't had the ability to > > delete it

[HACKERS] file-locking and postmaster.pid

ng it the way it is, having so many smart knowledgeable people working on this project. Could someone please explain the rationale of the current solution to me? -- Andreas Joseph Krogh <[EMAIL PROTECTED]> Senior Software Developer / Manager gpg public_key: http:/

Re: [HACKERS] Running PostGre on DVD

gt; my local admins insist on an utterly brain-dead security policy." Tom, nobody wants to reduce everybody's security, and nobody is proposing changes leading to such. I just believe more than me agree that having this as an option on Windows wouldn't hurt anybody, but would ra

Re: [HACKERS] Running PostGre on DVD

is has been proposed before, and always rejected. While you're always > welcome to provide a patch, I'm very doubtful it would be accepted into > the main product. Oracle allows you to run it as admin... Don't

Re: [HACKERS] Running PostGre on DVD

I have been kicking around the idea of posting a change to allow > you to run as admin, but in the meanwhile if you can build Postgres on > your machine, the fix is very easy. Go into src/backend/main/main.c and > find the line > > if (pgwin32_is_admin()) > > and c

Re: [HACKERS] Running PostGre on DVD

> Have a nice day, Broken or not, it's a setup I'm not in control over. And I'm certainly not the guy to hack the "disable admin-security-check on windows" feature:-( -- Andreas Joseph Krogh <[EMAIL PROTECTED]> Senior Software Developer / Manager gpg public_key

Re: [HACKERS] Running PostGre on DVD

o install Tomcat+PG to run a demo-webapp for a customer on one of their machines. There really should be an option for "Yes, I really want to run PG as a user with Administrator-privileges on Windows. I promiss not to bug -hacker about any potential security-problems I might experience&qu

Re: [HACKERS] pgdump

.x version. Actually, it's for 7.4beta3, but should probably apply to 7.4 final as well Here it is: http://dev.officenet.no/~andreak/pg_dump.c.diff -- Andreas Joseph Krogh <[EMAIL PROTECTED]> Senior Software Developer / Manager gpg pub

Re: [HACKERS] pgdump

hard to port to 8.0. -- Andreas Joseph Krogh <[EMAIL PROTECTED]> Senior Software Developer / Manager gpg public_key: http://dev.officenet.no/~andreak/public_key.asc +-+ OfficeNet AS| Can i wash my clothes with my dvd

  1   2   >