Re: [GENERAL] How to express categorized items in relational tables

On Thu, 13 May 1999, Doo Suk Yang wrote: > I'm novice in database world. > Now I have to make design a database where categorized items should be > stored. It resembles the structure something like seen in Yahoo. > > Thanks for reading and generous comments of yours. Though this _is_ a postgre

Re: [GENERAL] RH 6.0 and PostgreSQL

On Sun, 16 May 1999, Ricardo Peres wrote: > After upgrading to RedHat 6.0, PostgreSQL no longer works... > Whenever I try to start the postmaster daemon, using > /erc/rc.d/init.d/postmaster script, I receive a message about postgresql > not finding the data directory. I checked /var/lib/pgsql, an

[GENERAL] Relations between tables.

ables tied together automatically, thus removing the need to use a 'WHERE table1.index = table2.t1index' in select clauses retreiving data in table2 and table1? christian

Re: [GENERAL] unrecognized configuration parameter "bdr.connections"

Thanks IAM Regards - Christian Vazquez -- View this message in context: http://postgresql.nabble.com/unrecognized-configuration-parameter-bdr-connections-tp5843957p5844078.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing

[GENERAL] How to speed up pg_trgm / gin index scan

ve already tried to throw quite a bunch of memory at the problem: shared_buffers = 64GB work_mem = 16GB but it didn't improve between this and the 32GB shared/ 2GB work GB I had before. This is on Postgres 9.1.15 on Linux. Thanks Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to speed up pg_trgm / gin index scan

an error message etc.). It must be matched exactly including all punctuation etc, so trigrams look very suitable. Cheers Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to speed up pg_trgm / gin index scan

ew installation from backup and it receives no new data at all. But it is in 9.1.15 so I try to give 9.4 a shot, as apparently I'm missing out on a lot of stuff. Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to speed up pg_trgm / gin index scan

I'll try to get 9.4 installed and report back with the results. Thanks Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Slow index performance

ull and reindexed. Can anybody explain the difference? Why is the current table so slow? And what can we do to improve performance? Thanks for your help, Christian Deriva GmbH Financial IT and Consulting Christian Schröder Gesc

Re: [GENERAL] Slow index performance

You are right ... How embarrassing ... Why did I not see this? I will change the index and check again. I guess that the problem should be fixed then. Thanks a lot! Christian Deriva GmbH Financial IT and Consulting Christian Schröder

Re: [GENERAL] How to speed up pg_trgm / gin index scan

On 22/06/15 13:51, Christian Ramseyer wrote: > Hi > > I have a pretty large table with syslog messages. > > It is already partitioned by month, and for a single month I have e.g. > > > DM=# \d+ logs_01 > >

Re: [GENERAL] How to speed up pg_trgm / gin index scan

d all the hard work you guys are putting into this. I'll follow the further development closely and report back if we get any new breakthroughs with this rather big data set. Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] GIN Trigram Index Size

Hi Some weeks ago I got some advice here on how to build a trigram index. Now, I have implemented this in our rather large database, which looks like this: We have one table of log events per month, used as partitions via "logs": public | logs | table| postgres public |

Re: [GENERAL] GIN Trigram Index Size

affraid of making the inserts slower, but I'll see if I can do a benchmark of fastupdate vs. nofastupdate and will post it here if I get to it. Thanks for your help Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Sequences, txids, and serial order of transactions

ortant properties that one order satisfies but the other doesn't, or that neither satisfies but that we should be aware of? (3) and (4) seem like strong reasons to go with a sequence, as long as we can live without (5) and figure out (7) and (8). Any help appreciated, Christian.

[GENERAL] Avoid deadlocks on alter table

ation 17248 is tariff_plan and 17016 is customers, both only in public schema (shared tables). I cannot understand why altering a table in a customer schema bumps into a deadlock with these two tables. Any hints how to solve this problem? Thanks. -- *Christian Castelliskype: christrack*

Re: [GENERAL] Avoid deadlocks on alter table

e FKs one at a time, rather > than all in one transaction. > Ok I'll try first to do this. Thanks. -- *Christian Castelliskype: christrack*

Re: [GENERAL] Avoid deadlocks on alter table

lobal views so how can I update these global views without interfering with other processes? Should I avoid using these views and build by myself the queries with code? Is there another better approach for finding results with this type of architecture? Thanks. 2016-07-06 9:43 GMT+02:00 Chri

Re: [GENERAL] Running query without trigger?

session_replication_role = DEFAULT; This only affects the current session i.e. you and not any other sessions which is what you seemed to require. All this assuming you run a supported version of postgres Regards, Christian Elmerot, Systems Engineer One.com -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] RHEL 7

igration procedure (so I wonder why they've included it). -- *Christian Castelliskype: christrack*

[GENERAL] Detecting if current transaction is modifying the database

r ways? Are there ways to avoid false positives due to temp tables? Thanks in advance, Christian.

Re: [GENERAL] Detecting if current transaction is modifying the database

res Professional: http://www.postgrespro.com > Russian Postgres Company > > > > > On Fri, Aug 5, 2016 at 10:25 PM +0300, "Christian Ohler" > wrote: > > Hi, >> >> I'm trying to find a way to have Postgres tell me if the current >> transaction would modif

Re: [GENERAL] Detecting if current transaction is modifying the database

On Fri, Aug 5, 2016 at 12:55 PM, Rob Sargent wrote: > > What sort of interface are you looking for. Where/When would you grab the > information? Do what with it? Log triggers are the typical pattern here > (with packages just for that sort of thing). I'm looking for a statement (or sequence o

Re: [GENERAL] Detecting if current transaction is modifying the database

On Fri, Aug 5, 2016 at 1:24 PM, Tom Lane wrote: > Christian Ohler writes: >> Thanks, fair point. I should have mentioned that I know about triggers but >> was hoping to find a less invasive mechanism (IIUC, I'd have to install a >> trigger on every table) – it seems

Re: [GENERAL] Detecting if current transaction is modifying the database

On Fri, Aug 5, 2016 at 1:26 PM, Rob Sargent wrote: > On 08/05/2016 02:15 PM, Christian Ohler wrote: >> >> I'm looking for a statement (or sequence of statements) that, when run >> within a transaction, tells the client if any writes are happening in >> that tran

Re: [GENERAL] Detecting if current transaction is modifying the database

On Mon, Aug 8, 2016 at 8:23 AM, Kevin Grittner wrote: > Your check for a exclusive self-lock on transactionid should work. > It may be possible to find a way to do it that is less expensive, > so I would definitely encapsulate that in a function; but off-hand > I'm not thinking of a better way. G

Re: [GENERAL] C++ port of Postgres

rent HEAD? I ask because I'd like to compare your approach to the one Peter has posted, and I think that will be easier if I can use a common (or at least similar) baseline for the comparison. Kind regards, Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

[GENERAL] Changing varchar length by manipulating pg_attribute

9.4? Also, best practice seems to be to use text nowadays, is there even a variant of this that lets me convert a "column from character varying(256)" to "text" without having to recreate all the nested views? Thanks Christian -- Sent via pgsql-general mailing list (pg

[GENERAL] "out of memory" error

ch seems to be high enough)? Thanks for any help! Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91 Hans-Böckler-Straße 2 http://www.deriva.de D-37079 Göttingen Deriva

Re: [GENERAL] "out of memory" error

hubert depesz lubaczewski wrote: On Wed, Aug 22, 2007 at 07:07:20PM +0200, Christian Schröder wrote: These are the current settings from the server configuration: shared_buffers = 3GB this is *way* to much. i would suggest lowering it to 1gig *at most*. Ok, I can do this, but

Re: [GENERAL] "out of memory" error

's considered impolite to post so many lines to this mailing list. Thanks a lot again for your help,     Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91 Hans-Böckler-Straße 2 http://www.deriva.de

Re: [GENERAL] "out of memory" error

pages before, but I seem to have been blind ... Ok, many thanks for putting me right! Regards, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91 Hans-Böckler-Straße 2 http://www.deriva.de D-370

Re: [GENERAL] "out of memory" error

cal memory, must set kernel shared memory max first. Will see noticeable difference. Since the first links are also mentioned on the official PostgreSQL website (http://www.postgresql.org/docs/techdocs.2) I think they should be trusted more. Regards,     Christian -- Deriva GmbH

Re: [GENERAL] "out of memory" error

Side note: Why does Thunderbird send HTML mails albeit being configured for sending plain text mails? Sorry for that! And sorry for being off-topic. Regards, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91

[GENERAL] Query with "like" is really slow

73.631 ms. As far as I have understood the docs this includes the child nodes. But I cannot find the time-consuming child node. I only see two child nodes: The inner nested loop (which took 31.692 ms) and the index scan (which took 243.643 ms). Or do I have to multiply the 243.643 ms with 1

Re: [GENERAL] Query with "like" is really slow

Gregory Stark wrote: Christian Schröder <[EMAIL PROTECTED]> writes: ... -> Seq Scan on table2 (cost=0.00..186.64 rows=2 width=4) (actual time=0.052..2.259 rows=42 loops=1) Filter: (c ~~ '1131%'::text) ... -> Seq Scan on tabl

[GENERAL] "like" vs "substring" again

rt of a more complex query. So I have the following questions: 1. Why does the query optimizer not recognize that the expressions are equivalent? 2. What can I do to improve the estimation of the query optimizer? I tried to create an index (with opclass "bpchar_patte

[GENERAL] Performance Issues (was: "like" vs "substring" again)

not like '113%'") this is clearly not the case, so it might be an interesting point to address. Do you have any other tips for me? Kind regards, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax:

Re: [GENERAL] Performance Issues

John D. Burger wrote: Christian Schröder wrote: Or would it be possible to tweak how the planner determines the selectivity? I have read in the docs (chapter 54.1) that in case of more than one condition in the where clause, independency is assumed. In my case ("... where test like 

Re: [GENERAL] Performance Issues

Alvaro Herrera wrote: Christian Schröder wrote: I think it is my job as db admin to make the database work the way my users need it, and not the user's job to find a solution that fits the database's needs ... Is there really nothing that I can do? You can improve the s

Re: [GENERAL] TSearch - Bulgarian

You might have to create a Bulgarian dictionary first before you will be able to successfully use tsearch. Maybe some information here will help you: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung

Re: [GENERAL] Error while database creation

I guess that "No space left on device" explains a lot, i.e. there is no space left on your hard drive/partition. Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Rege

[GENERAL] Privileges on information_schema

admin. I tried explicitly setting the SELECT privileges on the above mentioned view but without success. I really appreciate any help. Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11

Re: [GENERAL] Upper and Lower-cased Database names?

This error probably does not have anything to do with the case of your database name. Instead you probably logged into a database which is not MyTest, because it is not possible to log into a database x and make a query on database y. Christian Rengstl M.A. Klinik und Poliklinik für Innere

[GENERAL] DROP VIEW lasts forever

x27;m using psql 8.2 Thanks in advance Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 ---(end of broa

Re: [GENERAL] DROP VIEW lasts forever

Nevermind, by mistake I tried dropping it as a different user. But, just a question, wouldn't it make more sense to issue an error message or something instead of letting the query run indefinitely? Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Fors

Re: [GENERAL] (Never?) Kill Postmaster?

Ow Mun Heng wrote: look for the query's procpid and then issue a select pg_cancel_backend('the_id') Does it do any harm if I kill (either with signal 9 or signal 15) the single backend process (and not the postmaster)? Regards, Christian -- Deriva GmbH

Re: [GENERAL]

Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Wed, Oct 31, 2007 at 4:07 AM, in message <[EMAIL PROTECTED]>, ca

Re: [GENERAL] (Never?) Kill Postmaster?

recovery in progress <2007-10-31 22:53:58 CET - > LOG: redo starts at 153/FE9FAF70 <2007-10-31 22:53:58 CET - > LOG: record with zero length at 153/FEA05E70 <2007-10-31 22:53:58 CET - > LOG: redo done at 153/FEA05E40 <2007-10-31 22:53:58 CET - > LOG: database system is

Re: [GENERAL] (Never?) Kill Postmaster?

r experience this problem. If I see the phenomenon again I will use strace or something similar to find out what the backend process is doing. Regards, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91 Hans-Böc

[GENERAL] current_user changes immediately after login

es are accessible again. This problem does only occur with this database. Do you have any explanation? Regards, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91 Hans-Böckler-Straße 2 http://

Re: [GENERAL] current_user changes immediately after login

se) has issued this "alter database" command (probably without really understanding what he did *g*). After "alter database testdb reset role" everything is ok now. Thanks for your help! Regards, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Fin

[GENERAL] Questions concerning check constraints

constraint might be simpler. 2) Is it possible to issue custom error messages in case a constraint is violated? Thanks! Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg

Re: [GENERAL] (Never?) Kill Postmaster?

lect () #15 0x00581446 in PortalRun () #16 0x0057d625 in exec_simple_query () #17 0x0057ea72 in PostgresMain () #18 0x00558218 in ServerLoop () #19 0x00558db8 in PostmasterMain () #20 0x0051a213 in main () Do you need anything else? Can you still tell

[GENERAL] How does the query planner make its plan?

ors and 8 GB memory. Thanks for your help, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91 Hans-Böckler-Straße 2 http://www.deriva.de D-37079 Göttingen Deriva CA Certificate: http://www.deriva.de/deriva-c

Re: [GENERAL] (Never?) Kill Postmaster?

se NLWP (the number of threads in the process) is 1 for all processes. Is it necessary to recompile the server with debugging information enabled? As I already mentioned this is a productive database, so I would have to do it by night which would be somewhat uncomfortable for me ...

Re: [GENERAL] (Never?) Kill Postmaster?

does this tell you? Regards, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91 Hans-Böckler-Straße 2 http://www.deriva.de D-37079 Göttingen Deriva CA Certificate: http://www.deriva.de/der

Re: [GENERAL] (Never?) Kill Postmaster?

afraid that eventually the maximum number of connections will be exceeded. I don't want to "kill -9" the processes because the last time I did this the database was in recovery mode for a substantial amount of time. Any help is still highly appreciated! Regards, Christian P.S.

Re: [GENERAL] (Never?) Kill Postmaster?

n I will follow your advice. Regards, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91 Hans-Böckler-Straße 2 http://www.deriva.de D-37079 Göttingen Deriva CA Certificate: http://www.de

Re: [GENERAL] (Never?) Kill Postmaster?

;SELECT session_user', 1); $_TD->{new}{$field} = $query->{rows}[0]{session_user}; return 'MODIFY'; = if ($_TD->{argc} > 0) { foreach (@{$_TD->{args}}) { $_TD->{new}{$_} = $_TD->{old}{$_} if exists $_TD-&g

Re: [GENERAL] (Never?) Kill Postmaster?

exist at all. Since I have now a total of 69 connections and already touched the connection limit yesterday I will now restart the server. Thus, I won't be able to provide any more detailed information until the problem arises again. Of course, I can still give you general informati

Re: [GENERAL] (Never?) Kill Postmaster?

ement, there are some that are idle, but do not respond to SIGINT or even SIGTERM. Is this sufficient? Then I could change the root password and send all the login data to you. Regards, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting

Re: [GENERAL] (Never?) Kill Postmaster?

0) at main.c:188 I now did the same again and will wait some time. Maybe the process will come to the same state the other processes had been. If not, I'm pretty sure that my users will be able to create some really persistent processes again ... ;-) Regards, Christian -- Deriva Gmb

Re: [GENERAL] (Never?) Kill Postmaster?

I have some, I will send you the login data for the server so that you can have a look for yourself. Regards, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91 Hans-Böckler-Straße 2

Re: [GENERAL] Usúario Conectados

Hi, you could use "select usename from pg_stat_activity;" PS. this is an english-speaking list, so for the future please write your mails in english. Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 F

Re: [GENERAL] (Never?) Kill Postmaster?

cess I will probably restart the database server once in a week to remove those old connections. Thanks a lot for your help! Christian P.S.: Can I change the root password again? -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 48

[GENERAL] "and then" / "or else"

't always meet the logical requirements and leads to less readable code. Some programming languages (e.g. Eiffel) know the operators "and then" and "or else" which explicitly are "short-circuited". Would it be possible to add these operators to PostgreSQL in general

Re: [GENERAL] "and then" / "or else"

Michael Glaesemann wrote: On Nov 17, 2007, at 3:53 , Christian Schröder wrote: Unfortunately, the trick from the docs (chapter 4.2.12) using "case ... then" does not work inside an "if" statement (the "then" of the "case" is interpreted as belonging

[GENERAL] Trigger problem

_NAME; INSERT INTO history(aennam, action, table_name) VALUES(current_user, act, tab); RETURN NULL; END; Now the problem is that a tuple gets added to the table history, but the field "action" (whatever the user did) is 99% empty, whereas the others are filled and I don't see wh

Re: [GENERAL] Trigger problem

;') || ' TO ' || coalesce(NEW.gruppe, ''); there still seem to be null values. Of course, it can be that the user deletes a value and then there is a NULL value, say for NEW.gruppe for example, but shouldn't the coalesce in this case avoid that the whole field-string is empty?

[GENERAL] Archiving problem on Windows

ied one or two weeks ago and since then i have not change the command. Thanks for any advice! Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-94

Fwd: Re: [GENERAL] Archiving problem on Windows

lt; failed: error code 1 >>copy pg_xlog\myfile C:\Archive\DBArchive\myfile<< failed: error code 1 WARNING: transaction log file could not be archived: too many errors Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Reg

Re: [GENERAL] Archiving problem on Windows

Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Tue, Dec 4, 2007 at 12:03 PM, in message <[EMAIL PROTECTED]>,

Re: Fwd: Re: [GENERAL] Archiving problem on Windows

Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Tue, Dec 4, 2007 at 11:44 AM, in message <[EMAIL PROTECTED]>,

Re: [GENERAL] Archiving problem on Windows

Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Tue, Dec 4, 2007 at 12:21 PM, in message <[EMAIL PROTECTED]>,

Re: [GENERAL] Archiving problem on Windows

Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Wed, Dec 5, 2007 at 2:47 AM, in message <[EMAIL PROTECTED]>, Paul

Re: [GENERAL] Archiving problem on Windows

Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Wed, Dec 5, 2007 at 8:25 AM, in message <[EMAIL PROTECTED]>, Paul

Re: [GENERAL] Archiving problem on Windows

Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Wed, Dec 5, 2007 at 8:25 AM, in message <[EMAIL PROTECTED]>, Paul

[GENERAL] Views and permissions

e view's sql, everything works fine. But when I try to select from the view, I get an "ERROR: permission denied for relation EDITORS". How can this happen? As far as I understand, views are simply rewrite rules, so it should make no difference if I use the vi

Re: [GENERAL] Views and permissions

er of the "zert_readers" group: zertifikate=# select pg_has_role('www', 'zert_readers', 'MEMBER'); pg_has_role ----- t (1 row) I have also tried to drop and recreate the view, but it didn't help. Regards, Christian -- Deriva GmbH

Re: [GENERAL] Views and permissions

p the databases one by one (using "pg_dump" and not "pg_dumpall"), so the system catalogs (especially the roles) must be transferred separately. That doesn't explain why views behave the way they do, but at least it describes why things suddenly stopped working. Many

Re: [GENERAL] Views and permissions

know the new role concept, but I didn't realize that it had these impacts on my script. Anyway, I won't need it anymore, now that you told me the "pg_dumpall -g" solution. Thanks again, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial

Re: [GENERAL] How to search ignoring spaces and minus signs

7; ','') = '12344'; prod_code | replace ---+- 12 3-44 | 12344 12-3-44 | 12344 123 44| 12344 Or just store the codes in a uniform format to begin with. Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Optimal settings for embedded system running PostgreSQL

this forum. Thanks for any help, Christian -- +--+---+ Embedded Solutions | DI Christian Walter Lorenz Böhler Gasse 4/4, A-1200 Wien | cwal...@embedded-solutions.at http://www.embedded-solutions.at

Re: [GENERAL] Optimal settings for embedded system running PostgreSQL

> > Von: pgsql-general-ow...@postgresql.org im Auftrag von Ivan Voras > Gesendet: Do 13.01.2011 15:47 > An: pgsql-general@postgresql.org > Betreff: Re: [GENERAL] Optimal settings for embedded system running > PostgreSQL > > On 13/01/2011

Re: [GENERAL] PostgreSQL 9.0.1 PITR can not copy WAL file

n copy the file yourself, you have a permissions problem. Make sure the PostgreSQL service user has full control on both the source and target directories. -- Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www

Re: [GENERAL] PostgreSQL 9.0.1 PITR can not copy WAL file

Make sure the PostgreSQL data directory and the backup directory are excluded. Run procmon <http://technet.microsoft.com/en-us/sysinternals/bb896645> to see what copy tries to do when it fails. -- Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

[GENERAL] Using copy for WAL archiving on Windows

change. Now two servers archive to the same shared directory, and neither notices. Should PostgreSQL maybe provide its own file-copy utility for Windows that meets the requirements for safe WAL archiving? -- Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PostgreSQL 9.0.1 PITR can not copy WAL file

* Magnus Hagander wrote: On Wed, Jan 19, 2011 at 19:20, Christian Ullrich wrote: So when PostgreSQL runs "copy 000...5E D:\...", it fails, and when you do the same thing as the PostgreSQL user, it works. Interesting. Try increasing the log level in postgresql.conf to see if i

Re: [GENERAL] PostgreSQL 9.0.1 PITR can not copy WAL file

* tuanhoanganh wrote: I download postgresql from Enterprise DB On Thu, Jan 20, 2011 at 6:06 AM, Christian Ullrich mailto:ch...@chrullrich.net>> wrote: We cannot assume that the one-click installer was used, but if it was, the service account it creates will be a member of the

Re: [GENERAL] PostgreSQL 9.0.1 PITR can not copy WAL file

events from cmd.exe for the ten seconds following that timestamp. If it is overly much, please send it to me directly. -- Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PostgreSQL 9.0.1 PITR can not copy WAL file

TR/WAL/%f' It works with the forward slashes if the destination path is quoted, but it looks like you did not do that in any of your examples. Other than that, I have no idea. -- Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to you

Re: [GENERAL] Using copy for WAL archiving on Windows

return ((argc == 3 && CopyFile(argv[1], argv[2], TRUE) != 0) ? 0 : 1); } ### end ### archive_command = "archive_wal %p c:\wal\%f" -- Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Multithreaded query onto 4 postgresql instances

nning multiple queries in parallel, especially if you can limit I/O and lock contention by matching queries to partitions. -- Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Drop CHECK Constraint

table from the catalog: SELECT conname FROM pg_constraint WHERE conrelid = 'backup_table'::regclass You may have to add more conditions to the query. -- Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

Re: [GENERAL] Upgrade to 9.3

> > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- *Christian Jensen* 2151 Burnside Road West Unit #5 Victoria, BC V9B 0P5 +1 (778) 996-4283 christ...@jensenbox.com

Re: [GENERAL] indexed range queries on jsonb?

cribed here: http://www.postgresql.org/docs/9.1/static/indexes-expressional.html Christian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] multiple parameters to an AGGREGATE function

Hi, maybe this will help: CREATE OR REPLACE FUNCTION _final_nth( anyarray, integer ) RETURNS anyelement AS $BODY$ SELECT a FROM unnest( $1 ) a ORDER BY a offset $2 LIMIT 1; $BODY$ USE it without an extra aggregate-function. SELECT _final_nth(array_agg(someelement),n) AS someelement FROM so

Re: [GENERAL] Perl function leading to out of memory error

t of memory error occurs. Interestingly, if we change the type specification in the call to "spi_prepare" from "isin" to "char(12)" the problem no longer occurs. Can you explain this behavior? Regards, Christian -- Deriva GmbH Tel.: +49 551 48

Re: [GENERAL] Perl function leading to out of memory error

NSERT INTO foo (isin) VALUES (isin); END; $$ LANGUAGE plpgsql VOLATILE STRICT; This works without any problem. Regards, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91 Hans-Böckler-Straße 2 http://www.

  1   2   3   4   >