[GENERAL] Exclusive Locks Taken on User Tables?

ng serialized because the ExclusiveLock being requested is not being granted. Any thoughts on why this might be happening and what I could do to resolve it? Thanks, ---Marc

Re: [GENERAL] Exclusive Locks Taken on User Tables?

ER BY pg_class.relname, mode I'm pretty sure this filters out transactionid lock types because I'm joining to pg_database and pg_class. Pls correct me if I'm wrong though. On Nov 6, 2007 2:22 PM, Richard Huxton <[EMAIL PROTECTED]> wrote: > Marc wrote: > > Hi, > >

[GENERAL] Exclusive Locks Taken on User Tables?

t that I always see that UPDATE statement and in the list of locks I see ExclusiveLock granted on the users table for one of the running pids but not the others. On Nov 6, 2007 3:01 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > Marc <[EMAIL PROTECTED]> writes: > > This is

Re: [GENERAL] Exclusive Locks Taken on User Tables?

ation? I feel like that would be a big clue. Here is what I'm referencing: http://www.postgresql.org/docs/8.2/interactive/explicit-locking.html Thanks for your help! ---Marc On Nov 6, 2007 3:43 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > Well, if it's not a foreign key iss

[GENERAL] slow query

Hey Folks, This query is running really slowly. Sometimes much slower then others. I have a feeling that there may be contention on one of the indices it is using. Query and explain plan are below. Seems like it spend the most time doing Index Scan using i_tablea_atextfield on tablea ru (cost=

[GENERAL] Performance Problem - pgsql on MD3000 DAS

estions on how to proceed? It seems to me that this isn't a hardware issue based on the bonnie++ benchmark as we're getting more raw throughput on all of the tests. ---Marc

[GENERAL] Tomcat question/problem

y working with these pieces and hopefully someone with more experience can/will provide some guidance. Thanks in advance, you time and effort is REALLY appreciated! Marc

[GENERAL] Acces via applets

The applet has been self signed.using the java's keytool and jarsigner programs. I've had this same setup working with SQL Server for years now. Self signed applet reads db on separate box. What is going on with PostgreSQL? Sorry for rambling, I'm just so frustrated right now. Thanks in advance. Marc

[GENERAL] postgres array quoting

da like the one above, except taking an ID value as the argument. Given the number of ways that things could be escaped in text stored in the arguments array, such as embedded quotes, commas, back slashes, etc, compounded by the lack of quotes in same cases but not others, p

[GENERAL] Slow query with join

Hello all, I am using PostgreSQL 9.4.1, compiled by Visual C++ build 1800, 64-bit, as downloaded from EnterpriseDB, and is running on my dev system under Win 7 64-bit. I hope someone can help me with a problem I'm having when joining a view with a table. The view is somewhat involved, but I can

Re: [GENERAL] Slow query with join

>-Message d'origine- >De : Tom Lane [mailto:t...@sss.pgh.pa.us] >Envoyé : March-16-15 5:07 PM >À : Tomas Vondra >Cc : pgsql-general@postgresql.org; Marc Watson >Objet : Re: [GENERAL] Slow query with join > >Tomas Vondra writes: >> On 16.3.2015 19:50, Ma

Re: [GENERAL] Slow query with join

Update : My query SELECT * FROM v_actor JOIN f_intervenant_ref ON (actor_id = ir_actor_id) WHERE ir_dos_id = '5226' took 7 secs. If I substitute the _RETURN rule for the view and add the above join, it takes 31 ms. Mark Watson Service au client - R&D Tél. 418 659-7272 ou 1 888 692-1050 www.j

Re: [GENERAL] Group by range in hour of day

7;,'2015-03-18 11:45:00'; insert into t select '2015-03-17 20:15:00','2015-03-18 11:45:00'; insert into t select '2015-03-17 21:15:00','2015-03-18 10:10:00'; insert into t select '2015-03-18 23:30:00','2015-03-19 01:30:00'; SELECT ser, SUM( case when e - ser < interval '1 hour' then e-ser --end interval when s >= ser then interval '1 hour' - (s - ser) --start interval else interval '1 hour' end ) as time_tot FROM (select e,s, generate_series(date_trunc('hour',s), date_trunc('hour',e), '1 hour') ser from t )foo group by ser order by 1 regards, Marc Mamin -- 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] Group by range in hour of day

5-03-16 11:05:00'; >insert into t select '2015-03-16 08:00:00','2015-03-16 11:45:00'; >insert into t select '2015-03-17 15:15:00','2015-03-18 11:45:00'; >insert into t select '2015-03-17 20:15:00','2015-03-18 11:45:00'; >in

Re: [GENERAL] :Posgres - performance problem

date master_items set feedback_to_de <> 'Yes' WHERE feedback_to_de IS DISTINCT FROM 'Yes' depending on the column nullable. regards, Marc Mamin -- 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] PGFoundry Sample databases (particularly world)?

Fixed .. .let me know if there are any other issues … > On May 5, 2015, at 09:55, William Dunn wrote: > > PgFoundry.org went down some months ago, I contacted webmaster Marc Fournier > and he was able to get it back up but a lot of it no longer works and I don't > thin

Re: [GENERAL] Restarting DB after moving to another drive

Hi, have you checked that the links in $PGDATA\pg_tblspc on the new drive are valid ? They possibly still point to the old drive. I guess you have to correct them per hand before starting the moved DB. regards, Marc Mamin Von: pgsql-general-ow

[GENERAL] Row visibility issue with consecutive triggers, one being DEFERRED

Hello, The test below is running fine but if you add the trigger push_foo_tr (uncomment) then the exception is raised. It seems that this additional trigger to be called at the first place changes the deferrable status of the second one. Is this an expected behaviour ? regards, Marc Mamin

Re: [GENERAL] pg_relation_size performance issue

table. Have you checked the statistics and vacuum state of the catalog tables (pg_*) Maybe some of them haven't been analyzed yet as this is a freshly created DB. (and with a lot of DLL statements we regularly have to call vacuum full on part of the catalog to avoid bloating there.) You&#

[GENERAL] Re: Row visibility issue with consecutive triggers, one being DEFERRED

recall! this self containing case works well if I call the correct functions in the triggers :) Marc > -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Marc Mamin > Sent: Donnerstag, 4. Juni 201

Re: [GENERAL] Row visibility issue with consecutive triggers, one being DEFERRED

> -Original Message- > From: Tom Lane [mailto:t...@sss.pgh.pa.us] > Sent: Donnerstag, 4. Juni 2015 15:56 > To: Marc Mamin > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Row visibility issue with consecutive triggers, > one being DEFERRED > > Marc

[GENERAL] select count(*);

, Marc Mamin -- 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] select count(*);

t: > > I think that if we accept that > > chris=> select 'foo'; > ?column? > -- > foo > (1 row) > > returns 1 row, then naturally > > chris=> select count('foo'); > count > --- > 1 > (1 row) > > sh

Re: [GENERAL] select count(*);

>>That's the point. * has no meaning without FROM >But COUNT(*) > >does have meaning - it means "the number of rows". which rows? :-) > It's not counting the number of columns in the row, so postgres doesn't need > to know what columns exist in the row to return a row count. >Geoff -- Sen

Re: [GENERAL] select count(*);

> -Original Message- > From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] > Sent: Donnerstag, 11. Juni 2015 16:31 > To: Marc Mamin; 'Geoff Winkless'; Postgres General > Subject: Re: [GENERAL] select count(*); > > On 06/11/2015 07:17 AM, Marc Mami

[GENERAL] Counting the occurences of a substring within a very large text

, 'g') from mytable where id =-2146999703 )foo; ERROR: invalid memory alloc request size 1447215584 regards, Marc Mamin -- 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] Counting the occurences of a substring within a very large text

> -Original Message- > From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at] > Sent: Mittwoch, 24. Juni 2015 13:44 > To: Marc Mamin; Postgres General > Subject: RE: Counting the occurences of a substring within a very large > text > > Marc Mamin wrote: > >

Re: [GENERAL] Counting the occurences of a substring within a very large text

> -Original Message- > From: Chris Mair [mailto:ch...@1006.org] > Sent: Mittwoch, 24. Juni 2015 13:26 > To: Marc Mamin; Postgres General > Subject: Re: [GENERAL] Counting the occurences of a substring within a > very large text > > > Hello, > >

Re: [GENERAL] Counting the occurences of a substring within a very large text

message, E'\n', > '')) > > FROM mytable WHERE id = -2146999703; > > > no, they both yeld the same error. > and this fails too, which is more annoying as it looks like a bug: SELECT replace(full_message, E'\n', '') FROM stadium_rprod.aserror

Re: [GENERAL] Counting the occurences of a substring within a very large text

>>On 24 June 2015 at 14:51, Marc Mamin wrote: >>note that the 345MB text only contains 635 lines. This might be the issue... >There's similar issue discussed here: >http://www.postgresql.org/message-id/6046.1353874...@sss.pgh.pa.us >Tom did seem to accept that the

[GENERAL] how to extract the page "address" from the ctid

tinct myColumn) as c FROM myTable GROUP BY substring(ctid::text, '^.([^,]+)') )foo GROUP BY c order by 1 desc; Is there a quicker way to extract the page reference from the ctid? regards, Marc Mamin -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] how to extract the page "address" from the ctid

> -Original Message- > From: Michael Paquier [mailto:michael.paqu...@gmail.com] > Sent: Mittwoch, 1. Juli 2015 07:05 > To: Marc Mamin > Cc: Postgres General > Subject: Re: [GENERAL] how to extract the page "address" from the ctid > > On Tue, Jun 30, 201

Re: [GENERAL] Systemd vs logging collector

combinations of # stderr, csvlog, syslog, and eventlog, # depending on platform. csvlog # requires logging_collector to be on. regards, Marc Mamin > > -- > Sent via pg

Re: [GENERAL] Slow index performance

e "extra" > "rec_isins_current_attachment" btree (attachment), tablespace > "extra" Hello, Are you sure that the column order of the PKs is the same in both tables? (attachment, isin) or (isin, attachment). When isin is at the s

[GENERAL] next postgres version on Amazon RDS ?

Hello, has anyone some insight on when we can expect a newest 9.4.x Version on RDS ? Or knows a better forum to ask for this? I should upgrade an application DB currently on 9.3 that might go on RDS but I'm a bit reluctant to go only on 9.4.1 ... regards, Marc Mamin

[GENERAL] Problem with ALTER TYPE, Indexes and cast

7;XY' as 'month2.foo'::regtype) Is there a way for it ? regards, Marc Mamin -- 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] Problem with ALTER TYPE, Indexes and cast

> -Original Message- > From: Tom Lane [mailto:t...@sss.pgh.pa.us] > Sent: Mittwoch, 8. Juli 2015 15:44 > To: Marc Mamin > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Problem with ALTER TYPE, Indexes and cast > > Marc Mamin writes: > > Now

Re: [GENERAL] Creating table with data from a join

M a JOIN b on a.id = b.id WHERE a.id%4 = [0,1,2,3} I usually avoid parallel INSERTS to avoid I/O contention and random distribution within the target tables. Are you monitoring the I/O activity in your tests ? Have you tried to use only 2 parallel processes? regards, Marc Mamin >(accor

Re: [GENERAL] Index Only Scan vs Cache

ver got analyzed. Can this fool the query planner in a negative way ? regards, Marc Mamin >> The table blocks would fall out of cache if they're never touched. >> >>regards, tom lane >> >> > >Sweet! Thanks Tom. > > >--

Re: [GENERAL] Creating table with data from a join

> Marc, I am using postgres 9.4. I didn't benchmark, but intuitively the modulo > operator will force traversing every record in table "a" 4 times, as it can't > use an index. Not necessarily. seq scans can be synchronized: "This allows sequential scans of lar

[GENERAL] Drop down in connect time between 9.3.6 and 9.3.9 ?

$i -lt 1000 ]; do let i++; psql -c 'select 1' ; done; } >/dev/null real0m11.081s user0m0.140s sys 0m0.208s regards, Marc Mamin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] [pgsql-general] Daily digest v1.13732 (15 messages)

ersonal preference and works for me, your mileage may vary. __ Marc -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] PostgreSQL Developer Best Practices

in the standard, someone will eventually create tables with names that don't gel with everything else. __ Marc -- 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] Any thoughts on a better approach to this query?

when type='A' then link end ))as ar_a, array_not_nulls(array_agg(case when type='B' then link end ))as ar_b, array_not_nulls(array_agg(case when type NOT IN ('A', 'B') then link end)) as ar_others from demo GROUP BY id ) SELECT id, a_ct, b_ct, ar_a, ar_b, ar_others, coalesce (ar_a[1], case when b_ct > 1 then ar_b[2] else ar_others[1] end ) as link_a, coalesce (ar_b[1], case when a_ct > 1 then ar_a[2] when a_ct = 0 then ar_others[2] else ar_others[1] end) as link_b, -- unused others case when a_ct + b_ct >=2 then ar_others else ar_others[3 - (a_ct + b_ct) : array_length(ar_others,1)] end || -- unused A & B case when has_a AND has_b then ar_a[2:a_ct] || ar_b[2:b_ct] when a_ct > 2 then ar_a[3:a_ct] when b_ct > 2 then ar_b[3:b_ct] end as unused FROM PREP order by id regards, Marc Mamin

Re: [GENERAL] clone_schema function

t take care of the column statistic targets (i.e. ALTER TABLE t ALTER COLUMN c SET STATISTICS n;) regards, Marc Mamin From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Melvin Davidson Sent: Donnerstag, 17. September 2015 15:48 To: David

Re: [GENERAL] clone_schema function

Von: Melvin Davidson [melvin6...@gmail.com] Gesendet: Donnerstag, 17. September 2015 17:11 An: Marc Mamin Cc: pgsql-general@postgresql.org Betreff: Re: [GENERAL] clone_schema function Thanks, >I'm not sure why you had trouble with the REPLACE(),

Re: [GENERAL] Best practices for aggregate table design

I would store your monthly data within a separate table. regards, Marc Mamin -- 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] Duplicate rows during pg_dump

>>remote_db=> insert into users_copy_without_indexes select * from users; >>INSERT 0 523342 >> remote_db=> select count(1) from users_copy_without_indexes where id >> = 123; >> count >>--- >> 2 >>(1 row) >>

Re: [GENERAL] Duplicate rows during pg_dump

> -Original Message- > From: Jim Nasby [mailto:jim.na...@bluetreble.com] > Sent: Montag, 26. Oktober 2015 01:55 > To: Marc Mamin; Adrian Klaver; Chaz Yoon; pgsql-general@postgresql.org > Subject: Re: [GENERAL] Duplicate rows during pg_dump > > On 10/24/15 3:15

Re: [GENERAL] regexp_replace to remove sql comments

rrent_database()) >) > >SELECT regexp_replace(q,'/\*.*\*/','') as q /* strip off comments like >this */ <-- cannot get a regex to do this >FROM to_clean ORDER BY q Hi, Does this help ? select regexp_replace(' aaa /* x y z */ foo', '\/\

Re: [GENERAL] Uber migrated from Postgres to MySQL

also mean removing the requirement for ‘double the disk space’ to do the upgrade … I don’t have a 1TB database to try it on, mind you, so your ‘wait couple of days’ might be *with* the —link option? -- Marc G Fournier http://www.2ndQuadrant.com <http://www.2ndquadrant.com/> PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services

Re: [GENERAL] Uber migrated from Postgres to MySQL

ging the binaries … downgrading an older ‘major release’ requires a dump/reload … Unless I’m missing something, whether on PostgreSQL or MySQL, if you want to go back a major release, you would need to dump./ reload that 1TB database … -- Marc G Fournier

[GENERAL] row => text => row

rows as text,but in their (default) csv representation: select to_csv((c.*)) from foo c; regards, Marc Mamin

Re: [GENERAL] Migrating data from DB2 zOS to PostgreSQL

Please, file these as issues on github (i'm the author). It will be much easier to solve your problems. Regards On 06/12/2016 11:42, Sameer Kumar wrote: > > > On Tue, 6 Dec 2016, 9:27 p.m. Swapnil Vaze, > wrote: > > > Hello Julien, > > We created DDLs fr

Re: [GENERAL] is this a known bug in 9.6?

as (select 1::int x), j as (select 1::int x) select max(x) from (select x from i union all select x from j) b; --- ERROR: could not find plan for CTE "i" regards, Marc Mamin -- 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] pg_dump and quoted identifiers

t; in front of that > to see what gets printed: > > $ echo pg_dump -d postgres -t "\"Statuses\"" > pg_dump -d postgres -t "Statuses" Hello, Have you checked if the problem is limited to pg_dump ? Maybe you're facing a trivial mistake, like a space in the

[GENERAL] Fetching from psql procedures

good tutotial for a task like this ? thanks and best regards, Marc Mamin -- 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] Fetching from psql procedures

can try CTE Common Table Expression. It isn't possible with plpgsql :( > Theoretically you can write C extension where SRF function can returns data > continually.But plpgsql function using local stack and returns data as block. > Regards > Pavel Thanks. A simpler solution will be

Re: [GENERAL] Unique index problem

d_lab_tests_siui, id_lab_tests_groups, valid_from, id_lab_sample_types) in the index definition, but I've never tried that and suspect the planner will also have trouble to include such an index in the plan. regards, Marc Mamin -- 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 do I implement a .XSD in Postgres?

run using psql. Unfortunately, I have not gotten around to documenting the xml schema for skit, but if you run the regression tests you should be able to get enough examples to figure it out. If you want to give this a try, you can email me off list and I'll do what I can to help. __ Marc

Re: [GENERAL] execute same query only one time?

cte as (select ..), tmp as ( INSERT INTO result2 select ... from cte), SELECT ... from cte; query_2: select * from result2; regards, Marc Mamin -- 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] 9.5 - Is there any way to disable automatic rollback?

Hello, if you are using pgjdbc, there is a discussion about adding an option to modify this behavior: https://github.com/pgjdbc/pgjdbc/issues/423 This would simplify the migration of java projects, e.g. from oracle to postgres. regards, Marc Mamin From: pgsql-general-ow

Re: [GENERAL] Do parallel queries work with only dblink not with fdw?

emented that solution... something like db_link_send_query('conn0', 'CREATE UNLOGGED TABLE my_result... db_link_send_query('conn1', 'INSERT INTO my_result statement based on partitioning field'); db_link_send_query('conn2', 'INSERT INTO my_res

Re: [GENERAL] Thoughts on "Love Your Database"

What counts are the data and how they are arranged within the DB. Therefore they should put more focus on them, rather then think in OOM. That book is a great idea. A collection of bad code example and the SQL equivalents, strengthend with runtimes figures, may help move some minds best regards

[GENERAL] revert function for to_json ?

Hello, I'm looking for $subject example: how to revert select to_json(E'a\n''b'::text) I can achieve it with something like this: select json_extract_path_text(('{"a":'||to_json(E'a\n''b'::text)||'}')::json,'a') does anybody knows a less ugly solution ? regards, Marc Mamin

Re: [GENERAL] revert function for to_json ?

>From: pgsql-general-ow...@postgresql.org >[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Marc Mamin >Sent: Montag, 23. Mai 2016 16:03 >To: pgsql-general@postgresql.org >Subject: [GENERAL] revert function for to_json ? > >Hello, > >I'm looking for

[GENERAL] Foreign keys and indexes

Dear list, This might be too basic for a question but I just couldn't find the answer so far. Does PostgreSQL create an implicit index also for foreign keys? or must I create it explicitly? Thank you, Marc Compte ---(end of broa

Re: [GENERAL] Foreign keys and indexes

each of the fields? or is the index created on the composition only? For instance, in the implementation of a N:M relationship, declaring the primary as (foreign1, foreign2) will create two indexes? or just one? Thanks again Marc Compte En/na Richard Broersma Jr ha escrit: Does PostgreSQL

Re: [GENERAL] Postmaster processes taking all the CPU

Hello, if vacuuming does not help, you may also want to log all queries running more than x milliseconds to help localize the problem. see log_min_duration_statement= #ms in postgresql.conf (i didn't check its avaibility in older version) HTH,

Re: [GENERAL] UPDATES hang every 5 minutes

thread for others who may experience the same problem in the future. Thanks again, Marc - Original Message From: Greg Smith <[EMAIL PROTECTED]> Cc: mr19 <[EMAIL PROTECTED]>; pgsql-general@postgresql.org Sent: Thursday, August 9, 2007 11:10:42 PM Subject: Re: [GENERAL] UPDATES ha

Re: [GENERAL] UPDATES hang every 5 minutes

processes. Given the time constraints I'm working under this unfortunately was the quickest route. Again, I can't say thanks enough for the great info you have provided. I'll continue to post any changes/results I make/see. Marc ---

Re: [GENERAL] UPDATES hang every 5 minutes

pointing a little more often with less data? (right now I hit the checkpoint_timeout). Thanks again, Marc - Original Message From: Greg Smith <[EMAIL PROTECTED]> To: Marc Rossi <[EMAIL PROTECTED]> Cc: pgsql-general@postgresql.org Sent: Friday, August 10, 2007 2:36:28 AM Subje

[GENERAL] cascade and restrict options to alter domain drop constraint

affected, so no dependant objects should be affected. Could someone please explain what I am missing? Thanks in advance __ Marc signature.asc Description: This is a digitally signed message part

[GENERAL] Reliability of WAL replication

tomer demands a final statement from us, so we would appreciate a soon reply ( I know, it's always urgent, isn't it? ;) ). Regards, Marc Schablewski click:ware Informationstechnik GmbH ---(end of broadcast)--- TIP 1: if posting/reading th

[GENERAL] Exclusive Locks Taken on User Tables?

ng serialized because the ExclusiveLock being requested is not being granted. Any thoughts on why this might be happening and what I could do to resolve it? Thanks, ---Marc

Re: [GENERAL] Exclusive Locks Taken on User Tables?

t that I always see that UPDATE statement and in the list of locks I see ExclusiveLock granted on the users table for one of the running pids but not the others. On Nov 6, 2007 3:01 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > Marc <[EMAIL PROTECTED]> writes: > > This is

[GENERAL] Coordinating database user accounts with active directory

database accounts. Is there a simple way of coordinating active directory users with database accounts? I am happy to write tools to deal with the database end of things, but have no experience with active directory. Any and all suggestions would be appreciated. __ Marc

[GENERAL] Identifying casts

pre-defined function. __ Marc signature.asc Description: This is a digitally signed message part

[GENERAL] Oddity in column specifications for table creation

pg_catalog.varchar(40) But this does: create table "public"."additional" ( "str1""pg_catalog"."text" not null, "str2"varchar(40) ); For now, I will simply not quote or schema-specify anything from pg_catalog (though I guess I should force the search path to only include pg_catalog in this case) but I find the limitation kinda odd. This is in 8.1 and 8.2 __ Marc signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Oddity in column specifications for table creation

On Tue, 2007-11-12 at 19:32 -0500, Tom Lane wrote: > Marc Munro <[EMAIL PROTECTED]> writes: > > This works fine: > > "str2"varchar(40) > > This does not: > > "str2""pg_catalog"."varch

[GENERAL] advisory locks: documentation hint and feature request

d be the dafault behaviour for pg_advisory_lock_shared (..) and pg_try_advisory_lock_shared (...) --and possibly define a max number of allowed shared locks (over all sessions) pg_[try_]advisory_lock_shared_max(key bigint, max_count int) regards, Marc Mamin

[GENERAL] Question on STABLE functions limitations

Hello, I wonder if there are some special cases where STABLE functions should be avoided. I think for example of functions using set_config or querying the advisory locks. Thanks in advance, Marc Mamin

[GENERAL] pg_get_procdef ?

... Does anyone have a handmade solution for a pg_get_procdef function. I'm still on Postgres 8.3 ... Thanks for any help, Marc Mamin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] dblink_get_result issue

ed FROM clause rowtype SQL state: 42804 A subsequent call returns an empty result set, as described here: http://www.postgresql.org/docs/8.3/interactive/contrib-dblink-get-result .html Thanks for any help. Marc Mamin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To ma

Re: [GENERAL] dblink_get_result issue

> (Postgres 8.3.9) oops, this is actually 8.4.4 on Windows. -Original Message- From: Marc Mamin Sent: Mittwoch, 10. November 2010 18:25 To: 'pgsql-general@postgresql.org' Subject: dblink_get_result issue Hello, I'm experimenting with dblink, and have an issue with a

Re: [GENERAL] REINDEX requirement?

, old_ratio double precision, new_ratio double precision, old_pagecount integer, new_pagecount integer, execution_count integer, reindex_time bigint, CONSTRAINT reindex_list_pk PRIMARY KEY (nspname_oid, index_oid) ) regards, Marc Mamin From: pgsql-general-ow

Re: [GENERAL] dblink_get_result issue

For now I just ignore the first exception. BEGIN PERFORM * from dblink_get_result('myconn')as x (t text); EXCEPTION WHEN datatype_mismatch THEN NULL; END; PERFORM * from dblink_get_result('myconn')as x (t text); thanks, Marc Mamin -Original Message- From

Re: [GENERAL] Considering Solid State Drives

SSD caveats are well described here: http://www.postgresql.org/about/news.1249 HTH, Marc Mamin -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Allan Kamau Sent: Donnerstag, 11. November 2010 07:42 To: Postgres General

Re: [GENERAL] Schema tool

Hello, may schemaspy help you ? http://schemaspy.sourceforge.net/sample/relationships.html HTH, Marc Mamin -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Aram Fingal Sent: Donnerstag, 11. November 2010 17:51 To

Re: [GENERAL] Counting boolean values (how many true, how many false)

sum(case when fair then 1 else 0 end) as fair, => sum(case when fair then 1 end) as fair, :) regards, Marc Mamin -- 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] Survey on backing up unlogged tables: help us with PostgreSQL development!

ed table has a higher priority. The best solution in my opinion, would allow to dump/restore these 2 table types in separate processes (or threads..). (and by the way: would it be possible to choose the compress tool as an option for pg_dump) pgdump -F.. -Compress pigz -f out.dmp -f_unlogged o

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

d the indexes - drop the live table - rename the shadow table to the visible one. Is it imaginable to use unlogged tables foe the shadow one and then enable logging after the switch ? regards, Marc Mamin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

yep, but I'll miss this as I only use WAL for crash recovery... regards, Marc Mamin -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Mittwoch, 17. November 2010 23:40 To: Marc Mamin Cc: PostgreSQL general; Josh Berkus Subject: Re: [GENERAL] Survey on backi

[GENERAL] plpgsql, Exception handling: catching the message ?

ail: ERROR: relation "my_share4" already exists (=> DUPLICATE TABLE) best regards, Marc Mamin -- 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] Survey on backing up unlogged tables: help us with PostgreSQL development!

> What are the use-cases for replicating unlogged tables? Hello, I guess they could be useful in cloud infrastructures. (see http://archives.postgresql.org/pgsql-general/2010-11/msg00865.php) regards, Marc Mamin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To m

Re: [GENERAL] Help on explain analyze

Hello, did you also try defininig partial indexes? e.g. CREATE INDEX xx on task_definitions (ctrlid) WHERE (name::text = 'UseWSData') CREATE INDEX yy on ctrl_definitions (ctrlid) WHERE (name::text = 'IrrPeriodStart') HTH, Marc Mamin -Original Message- Fr

[GENERAL] RESET ROLE and search_path, Connection pool

y bound to the pg_backend_pid(). Here I will have to add the current_user within the GUC name to better isokate them) show search_path; "$user",public SET ROLE 'xxx'; show search_path; xxx,public RESET ROLE show search_path; xxx,public best regards, Marc Mamin

Re: [GENERAL] RESET ROLE and search_path, Connection pool

Hello, > Obviously each "user" could use RESET ROLE and become the super user.  Yes, this is a point not to forget, but isn't an issue in our case. best regards, Marc Mamin From: Derrick Rice [mailto:derrick.r...@gmail.com] Sent: Samstag, 4. Dezember 2010 00:21 To: Ma

Re: [GENERAL] pg_dump order of rows

etting a consistent dump of all your data may be an issue thought... regards, Marc Mamin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] commit delay with dblink.

is off # - Archiving - #archive_mode = off # allows archiving to be done #archive_command = '' # command to use to archive a logfile segment #archive_timeout = 0# force a logfile segment switch after this Thanks, Marc Mamin -- Sent

  1   2   3   4   5   6   7   8   >