Re: [GENERAL] psql reports back wrong number of affected rows.

many records were deleted solely due to my DELETE statement's FROM and WHERE clauses. Agree 100%. I am not a big fan of CASCADING effects (I rather do it 'by hand'), but in this case it was a really easy solution. Thanks you for your response. Regards, Erwin Moller Davi

[GENERAL] psql reports back wrong number of affected rows.

now deletes all rows that had a 1 for parentissueid. (5 in my testcase). That was correct, and as I intended, but why does Postgres answer "DELETE 1" instead of DELETE 6? Can somebody explain that to me please? Thanks for your time. Regards, Erwin Moller PS: I found a few possible

Re: [GENERAL] Sequences change in a rolled-back transactions

Alvaro Herrera schreef: Erwin Moller wrote: I thought a transaction that is rolled back, rolls back *everything* done in that transaction. Appearantly sequences are not included. Hi Alvaro, Thanks for your reply. Yes. This is actually a desirable property, because it allows

[GENERAL] Sequences change in a rolled-back transactions

ifferently, but I was unpleasantly surprised. :-/ Can anybody comment on this behaviour? Am I missing something? Thanks! Regards, Erwin Moller -- 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] create a 'range' of dates/numbers?

A. Kretschmer schreef: In response to Erwin Moller : Hi, Is it possible to create a range of dates or numbers inside a query without wrining in procedural language? I am looking for something that creates some kind of 'temp table' inside a query. eg: generate_Serie

[GENERAL] create a 'range' of dates/numbers?

3 I have been looking through the manual, but cannot find anything. Maybe it doesn't exist. Thanks for your time. Regards, Erwin Moller -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] noobquestion: How does Postgres delete 'smart' when deleting with FK contraints?

pulls that trick? Thanks for your time. Regards, Erwin Moller -- 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] Foreign Key 'walker'?

Erwin Moller schreef: Craig Ringer schreef: Erwin Moller wrote: No, that is not the kind of chicken I was talking about. ;-) My chicken is more along these lines: I often have some tables to which everything is related (eg tblcourse that contains everything belonging to a certain course). I

Re: [GENERAL] Foreign Key 'walker'?

Hi Pavel, Thanks for that. But I already wrote a nice extension to my DB-class in PHP that uses Thomas Kellerer's approach. It was simple once you know how to retrieve the info from the systemtables. :-) Regards, Erwin Moller Pavel Stehule schreef: Hello I used this code CREA

Re: [GENERAL] Foreign Key 'walker'?

Craig Ringer schreef: Erwin Moller wrote: No, that is not the kind of chicken I was talking about. ;-) My chicken is more along these lines: I often have some tables to which everything is related (eg tblcourse that contains everything belonging to a certain course). I don't want to m

Re: [GENERAL] Foreign Key 'walker'?

Shane Ambler schreef: ries van Twisk wrote: On Nov 18, 2008, at 9:47 AM, Erwin Moller wrote: Hi group, Considering following (simplified) example: Suppose I want to delete a record in tblnr1. Does Postgres has some command/procedure/function to list tables that have FK constraints on

Re: [GENERAL] Foreign Key 'walker'?

Thomas Kellerer schreef: Erwin Moller, 18.11.2008 15:47: Suppose I want to delete a record in tblnr1. Does Postgres has some command/procedure/function to list tables that have FK constraints on that table (tblnr1) That could be resolved with a query against the INFORMATION_SCHEMA Something

Re: [GENERAL] Foreign Key 'walker'?

ries van Twisk schreef: On Nov 18, 2008, at 9:47 AM, Erwin Moller wrote: Hi group, Considering following (simplified) example: CREATE TABLE tblnr1( nr1id SERIAL PRIMARY KEY, firstname TEXT ); CREATE TABLE tblnr2( nr2id SERIAL PRIMARY KEY, nr1id INTEGER REFERENCES tblnr1(nr1id) ); CREATE

[GENERAL] Foreign Key 'walker'?

kind of FK 'walker'. I want this because: 1) I hate DELETE CASCADE because I am chicken (So I use a script to delete all related records in the right order in a transaction) 2) I have a lot of tables and am afraid I miss some. And I am also a bit lazy .-) Thanks for your time. Rega

Re: [GENERAL] missing FROM-clause entry for table

Raymond O'Donnell schreef: On 12/11/2008 18:08, Erwin Moller wrote: LEFT OUTER JOIN tblcategorypropertylang AS CPL ON ((CLP.languageid=DRV1.languageid) AND (CPL.categorypropertyid=DRV1.categorypropertyid)); ERROR: missing FROM-clause entry for table "clp" You've

[GENERAL] missing FROM-clause entry for table

like to use the first way because that makes sense in my current project.) I Googled a little for the errormessage, but to no avail. The second query is also good enough for me, but I am curious what I am missing here. What is causing this? Thanks for your time. Regards, Erwin Moller -- Sent

[GENERAL] UTF8 in commandprompt (CMD) on XP fails. Tips?

osoft (probably the latter) Anyway, Is it possible to have psql working with UTF8 in a windows commandprompt? TIA! Regards, Erwin Moller -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Strange error while working with derived table

27;||tempwordstable.zoekwoord||'%'); all works fine. I understand the ::TEXT part. Since I fill this 'table' on the fly, I should tell WHAT I am using. What I don't understand is why Postgres8.1 need the cast to TEXT for 1 entry in my derived table, and NOT when I use m

Re: [GENERAL] Postgres8: subselect and optimizer/planner

Erwin Moller wrote: SELECT U.userid, U.username, (SELECT G.groupname FROM tblgroup WHERE (G.userid=U.userid)) AS ingroup typo, that should be 'tblgroup as G' of course. FROM tbluser WHERE (bla..bla...); ------- Erwin Moller Darwine BV Groenendaal 25f 3011 SK Rot

[GENERAL] Postgres8: subselect and optimizer/planner

estion too general and is the answer 'it depends'? I found a lot of queries I wrote like that in earlier projects, and I wonder if I should fix them. Thanks for any insights! Regards, Erwin Moller -- ------- Erwin Moller Darwine BV Groenendaal 25f 3011 SK Rotte

Re: [GENERAL] Tutorial EXPLAIN for idiots?

A. Kretschmer wrote: am Fri, dem 07.09.2007, um 12:30:06 +0200 mailte Erwin Moller folgendes: Hi group, Does anybody know of an tutorial for EXPLAIN for idiots like me? (I am fairly confortable with Postgres, but never used EXPLAIN before.) I need to optimize a few slow running queries

[GENERAL] Tutorial EXPLAIN for idiots?

/performance-tips.html A bit hard for starters. :-/ Any tips/sites? TIA Regards, Erwin -- --- Erwin Moller Darwine BV Groenendaal 25f 3011 SK Rotterdam tel 010-2133996 --- ---(end of broadcast)--- TIP 6: explain

Re: [GENERAL] TSEARCH2: disable stemming in indexes and triggers

Thanks Teodor. That did the trick. :-) At first I didn't see a change, but after reconnecting to the database it worked for some reason beyound my meager knowledge. Thanks to Oleg Bartunov too for his suggestion about writing my own procedure. This solution seemed simpler and worked the first

[GENERAL] TSEARCH2: disable stemming in indexes and triggers

cature BEFORE UPDATE OR INSERT ON tblvacature FOR EACH ROW EXECUTE PROCEDURE tsearch2(idxFTI, title, shortintro, werkgever, vacaturesteller, standplaats, divafdelingwerkgever); Step 2 worked fine: no stemming. But how do I cange my step6 (trigger) so it keeps using 'simple'? Or do