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 /condition

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

lder(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 <br...@momjian.us <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>

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 <br...@momjian.us <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 sep

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 <br...@momjian.us <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 da

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 >     instruc

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 <br...@momjian.us <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 > migh

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 pri

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

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?   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <

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 <br...@momjian.us <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>:

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 <andr...@visena.com> wrote: > There are many ways to do/configure things it seems, resulting in many

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

i, Jul 28, 2017 at 10:35 AM, Andreas Joseph Krogh > > <andr...@visena.com> wrote: > >> I'm reading https://www.postgresql.org/docs/10/static/pgupgrade.html to try > >> to understand how to upgrade standby-servers using pg_upgrade with pg10. > >> > &

Re: [HACKERS] Release Note changes

f 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)

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

/Recursive%20Query%20Throwdown.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 <andr...@visena.com <mailto:andr...@visena.com>> wrote: På fredag 10. mars 2017 kl. 10:09:2

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 <andr...@visena.com <mailto:andr...@visena.com>> wrote: [...] The execution-plan seems (u

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 <andr...@visena.com <mailto:andr...@visena.com>> wrote: På torsdag 09. mars 2017 kl. 18:0

Re: [HACKERS] Gather Merge

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

[HACKERS] Error building docs

.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 "PRODUCTNAME" undefined osx:postgres.sgml:20:16:E: element "P

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 <t...@sss.pgh.pa.us <mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh <andr...@visena.com> writes: > På onsdag 19. oktober 2016 kl. 18:29:31, skrev Bruce Momjian <br...@momjian.us >  I think an open questio

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 <br...@momjian.us <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 <br...@momjian.us > >: >

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 <br...@momjian.us <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 >     &

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.

[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 <andr...@visena.com <mailto:andr...@visena.com>> wrote: (I've set allow_system_table_mods=on in

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

-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

e=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 Execut

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

istinct: [snip]     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

loops=4) Buckets: 8192 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.97

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

På fredag 17. juni 2016 kl. 08:14:39, skrev Amit Kapila <amit.kapil...@gmail.com <mailto:amit.kapil...@gmail.com>>: On Fri, Jun 17, 2016 at 11:39 AM, Andreas Joseph Krogh <andr...@visena.com <mailto:andr...@visena.com>> wrote: På torsdag 16. juni 2016 kl. 20:1

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

hing?   I could dig into this further to reproduce if necessary.   -- 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] 10.0

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

Re: [HACKERS] 10.0

y 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 >: 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 >>

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

s back after the release. Then, 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.c

Re: [HACKERS] Covering + unique indexes

På lørdag 09. april 2016 kl. 06:34:39, skrev Tom Lane <t...@sss.pgh.pa.us <mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh <andr...@visena.com> 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

What about ~> ?   -- Andreas Joseph Krogh

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 <andr...@visena.com <mailto:andr...@visena.com>> wrote: På tirsdag 02. februar 2016 kl. 04:22:57

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

be extremely nice to get this into 9.6.     -- Andreas Joseph Krogh

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 t...@sss.pgh.pa.us mailto:t...@sss.pgh.pa.us: Andreas Joseph Krogh andr...@visena.com 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

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

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...@visena.com

Re: [HACKERS] nulls in GIN index

') = '' 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 'simple' dictionary:   my_fts_column @@ to_tsquery('simple', 'how are you')   -- Andreas Joseph Krogh CTO / Partner

[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] Setting PG-version without recompiling

På torsdag 03. juli 2014 kl. 11:13:44, skrev Abhijit Menon-Sen a...@2ndquadrant.com mailto: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 /

Re: [HACKERS] Setting PG-version without recompiling

På torsdag 03. juli 2014 kl. 16:16:01, skrev Tom Lane t...@sss.pgh.pa.us mailto:t...@sss.pgh.pa.us: Andreas Joseph Krogh andr...@visena.com 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] BDR-project

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

[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 andr...@officenet.no      mob: +47 909 56 963 Senior Software Developer / CTO - OfficeNet AS - http

Re: [HACKERS] Covering Indexes

On 06/28/2012 02:16 PM, David E. Wheeler wrote: Hackers, Very interesting design document for SQLite 4: http://www.sqlite.org/src4/doc/trunk/www/design.wiki I'm particularly intrigued by covering indexes. For example: CREATE INDEX cover1 ON table1(a,b) COVERING(c,d); This allows the

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

, 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? -- Andreas Joseph Krogh andr...@officenet.no - mob: +47 909 56 963

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

it with arguments doesn't make sense. I'm surprised creating the other triggers didn't produce an error stating No function defined with the name trigger_ix and the given argument-type. -- Andreas Joseph Krogh andr...@officenet.no Senior Software Developer / CTO Public key: http://home.officenet.no

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 parameters. I've found a potential bug when

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

Hi. 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 words And came over this from -general: http://www.techienuggets.com/Comments?tx=106813 Then after some

Re: [HACKERS] 8.5 vs. 9.0

On Friday 22. January 2010 01.22.09 Tom Lane wrote: Larry Rosenman l...@lerctr.org 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 version-bump? Is there a link somewhere

Re: [HACKERS] 8.5 vs. 9.0

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 andr...@officenet.no Senior Software Developer / CTO

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

On Tuesday 12. January 2010 11.10.09 Takahiro Itagaki wrote: Andreas Joseph Krogh andr...@officenet.no 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 value in column public.mytable.created

[HACKERS] NOT NULL violation and error-message

... -- Andreas Joseph Krogh andr...@officenet.no Senior Software Developer / CTO +-+ OfficeNet AS| The most difficult thing in the world is to | Rosenholmveien 25 | know how to do a thing and to watch | 1414

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

://archives.postgresql.org/pgsql-hackers/2008-10/msg00729.php -- Andreas Joseph Krogh [EMAIL PROTECTED] Senior Software Developer / CEO +-+ OfficeNet AS| The most difficult thing in the world is to | Karenslyst Allé 11

[HACKERS] Window Functions

. 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 [EMAIL PROTECTED] Senior Software Developer / CEO

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 bit on hackers these days. Can window

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 remove the need to use quotes in that case

Re: [HACKERS] Identifier case folding notes

'); ^ andreak=# insert into test(user) values('testuser'); INSERT 0 1 As you know, the only way of referring to the user-column is to qoute it in lowercase, which many apps and tools don't do. -- Andreas Joseph Krogh [EMAIL PROTECTED] Senior Software Developer / Manager -- Sent

Re: [HACKERS] Sorting Improvements for 8.4

; Users don't care about portability-issues, they care about performance. If multi-threading is a way to speed up sorting considerably, it should, IMHO, be considered seriously. -- Andreas Joseph Krogh ---(end of broadcast)--- TIP 9: In versions

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 thing in the world

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

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 [EMAIL PROTECTED] Senior Software Developer / Manager

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 kind of obvious wasn't it! I failed to parse that because

Re: [HACKERS] psql show dbsize?

. 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 Joseph Krogh [EMAIL PROTECTED] Senior Software Developer / Manager

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 thing

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 Joseph Krogh [EMAIL PROTECTED

Re: [HACKERS] 8.3 version of ts_headline

=/span'); ERROR: syntax error Aha, thanks! -- Andreas Joseph Krogh [EMAIL PROTECTED] Senior Software Developer / Manager +-+ OfficeNet AS| The most difficult thing in the world is to | Karenslyst Allé 11 | know

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=span class=style1, StopSel=/span'); ERROR: syntax error DETAIL: Syntax error in position 15

[HACKERS] 8.3 version of ts_headline

Joseph Krogh [EMAIL PROTECTED] Senior Software Developer / Manager +-+ OfficeNet AS| The most difficult thing in the world is to | Karenslyst Allé 11 | know how to do a thing and to watch | PO. Box 529

[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 logical... -- Andreas Joseph Krogh

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

of the components is not known, how can you know what is the result ? That's like saying: SELECT sum(field) should return NULL(value not known) if some of the tuples are NULL, which is definitly not what you want. -- Andreas Joseph Krogh [EMAIL PROTECTED] Senior Software Developer / Manager gpg

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 || 'fisk'; But in Oracle, it returns 'fisk

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

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 +-+ OfficeNet AS| The most difficult

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 NULL in PG: SELECT NULL || 'fisk

[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

[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] Senior Software

Re: [HACKERS] pg_dump schema breakup

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/public_key.asc +-+ OfficeNet AS| The most difficult thing

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

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 solutions on platforms supporting more features. -- Andreas Joseph Krogh [EMAIL PROTECTED] Senior Software Developer / Manager gpg

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

-- 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 in the world is to | Hoffsveien 17

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 'pgrep postmaster' or 'ps -axu | grep [p]ostmaster

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

. 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] Senior Software Developer / Manager gpg public_key: http

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`.log start ... and manually after login, ie

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 upon proper shutdown. Upon start-up, after

Re: [HACKERS] Running PostGre on DVD

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. -- Andreas Joseph Krogh [EMAIL PROTECTED] Senior Software Developer

Re: [HACKERS] Running PostGre on DVD

they are very very broken indeed. That was the way I read it and I agree, that's a very broken way to set things up. 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

Re: [HACKERS] Running PostGre on DVD

is very easy. Go into src/backend/main/main.c and find the line if (pgwin32_is_admin()) and change it to if (false pgwin32_is_admin()) Thanks, I'll see if I can build PG on Windows now. -- Andreas Joseph Krogh [EMAIL PROTECTED] Senior Software Developer / Manager

Re: [HACKERS] Running PostGre on DVD

on Windows. -- 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 in the world

Re: [HACKERS] Running PostGre on DVD

believe more than me agree that having this as an option on Windows wouldn't hurt anybody, but would rather make life simpler for some Windows people. Anyway, I don't use Windows on a regular basis, so it's not that important to me... -- Andreas Joseph Krogh [EMAIL PROTECTED] Senior Software

Re: [HACKERS] pgdump

. -- 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 drive?| Hoffsveien 17

Re: [HACKERS] pgdump

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 public_key: http://dev.officenet.no/~andreak/public_key.asc

Re: [HACKERS] Unexpected subquery behaviour

IN (SELECT b.id FROM bar b); ERROR: column b.id does not exist -- Andreas Joseph Krogh [EMAIL PROTECTED] Senior Software Developer / Manager gpg public_key: http://dev.officenet.no/~andreak/public_key.asc +-+ OfficeNet

Re: [HACKERS] patch for allowing multiple -t options to pg_dump

if you just want to dump 2 or 3 tables in a database containing lots of tables. Why not include both? -- Andreas Joseph Krogh [EMAIL PROTECTED] Senior Software Developer / Manager gpg public_key: http://dev.officenet.no/~andreak/public_key.asc

  1   2   >