Re: [HACKERS] listing triggers

[Erwin Moller]

Christopher Kings-Lynne wrote:

 Thanks for your response, but this is what I get:
 
 column, Type, and Modifiers
 +
 Indexes and foreign key contraints.
 No triggers.
 
 It lists triggers.  Trust me, I wrote it.

(Sorry for late response)
Hi Chris,

You wrote it?!?
Ok, in that case I'll better take your word for it. :-)

This is a perfect chance to compliment you for your contributions to that 
great database, so.. Thanks! I love it. It actually always works.

I never realized that there is a difference between triggers created 
implicitly and explicitly.

Robert Treat explained also that the reason that I don't see them has to do 
with the fact that the triggers were created implicitly (dervied from 
references syntax in create table, or alter table add foreign key syntax).

Thanks for your help/explanation. (Robert too!)

Regards,
Erwin Moller (a happy PostgreSQL end-user)




---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match

Re: [HACKERS] listing triggers

[Erwin Moller]

Christopher Kings-Lynne wrote:

 futhermore:
 \dt lists tables
 \ds lists sequences
 \d tablename lists that table.
 
 etc. etc.
 
 But how can I get a listing of all used triggers on a certain table?
 
 \d tablename
 
 Chris
 

Hi Chris,

Thanks for your response, but this is what I get:

column, Type, and Modifiers
+ 
Indexes and foreign key contraints.
No triggers.

The triggers are responsible for checking FK-contraints in other tables, 
that use the table I want to list as refering key.

This is what the help says:

 \d [NAME]  describe table, index, sequence, or view
 \d{t|i|s|v|S} [PATTERN] (add + for more detail)
list tables/indexes/sequences/views/system tables

No triggers

So, I am still in the dark.

Regards,
Erwin Moller

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

Re: [HACKERS] Enter the #1 Hacker site on the entire internet!

[Erwin Moller]

ApocalypseKnight wrote:

 
 Learn how to Hack into computers,websites,Aol/Yahoo/Msn accounts,view
 webcams without permission,computer programming,and much,MUCH more at:
 
 http://stop.to/Hacker
 
 and:
 
 http://groups.msn.com/SecretsoftheCyberWarrior
 
 ApocalypseKnight

I think ApocalypseKnight ment 'crackers'.

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[HACKERS] listing triggers

[Erwin Moller]

Hi,

When using psql I can list the tables and sequences by typing:
\d

futhermore:
\dt lists tables
\ds lists sequences
\d tablename lists that table.

etc. etc.

But how can I get a listing of all used triggers on a certain table?

Thanks for your time

Regards,
Erwin Moller

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Is this possible? concatenating results from a subquery

[Erwin Moller]

Thanks Janko!

I was hoping for a query-only solution (SQL only), but this will work just 
great. :-)

If I switch database this code will give me some trouble.
I guess I'll have to stick to Postgresql. ;-) 

Thanks.

Regards,
Erwin Moller



Janko Richter wrote:

 Perhaps this helps:
 
 CREATE AGGREGATE concat (
  BASETYPE = text,
  SFUNC= textcat, -- is function of operator 'text || text'
  STYPE= text,
  INITCOND = ''
 );
 
 
 SELECT
   P.personid,
   P.name,
   concat( N.note ) AS allnotesbythisperson
 FROM tblperson AS P
 INNER JOIN tblnotes AS N ON N.personid=P.personid
 WHERE P.personid=34
 GROUP BY P.personid, P.name;
 
 Regards, Janko
 
 
 Erwin Moller wrote:
 Hi!
 
 I face the following problem:
 2 tables: tblperson and tblnotes
 tblperson:
 colums: personid (PK), name
 
 tblnotes:
 colums: noteid(PK), personid(references tblperson(personid)), note
 
 tblnotes has notes stored written by a person from tblperson identified
 (FK) by its personid.
 
 I make a select on one table with certain criteria and want to have a
 concatenation on a subquery results.
 Something like this:
 
 SELECT
  P.personid,
  P.name,
  concat(SELECT N.note FROM tblnotes AS N WHERE (N.personid=P.personid) )
  AS allnotesbythisperson
   FROM tblperson AS P WHERE (P.personid=34);
 
 The concat word I use is pure fantasy.
 Is this at all possible?
 
 I know I can easily circumvent te problem by my scriptinglanguage (PHP),
 but that will result in many extra queries.
 
 How do I proceed?
 
 TIA!!
 
 Regards,
 Erwin Moller



---(end of broadcast)---
TIP 8: explain analyze is your friend

[HACKERS] Is this possible? concatenating results from a subquery

[Erwin Moller]

Hi!

I face the following problem:
2 tables: tblperson and tblnotes
tblperson:
colums: personid (PK), name

tblnotes:
colums: noteid(PK), personid(references tblperson(personid)), note

tblnotes has notes stored written by a person from tblperson identified (FK) 
by its personid.

I make a select on one table with certain criteria and want to have a 
concatenation on a subquery results.
Something like this:

SELECT 
 P.personid, 
 P.name,
 concat(SELECT N.note FROM tblnotes AS N WHERE (N.personid=P.personid) ) 
 AS allnotesbythisperson
  FROM tblperson AS P WHERE (P.personid=34);

The concat word I use is pure fantasy.
Is this at all possible?

I know I can easily circumvent te problem by my scriptinglanguage (PHP), but 
that will result in many extra queries.

How do I proceed?

TIA!!

Regards,
Erwin Moller


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org