[GENERAL] Notification EXTRA data

[news.postgresql.org]

sql-notify.html :


Higher-level mechanisms can be built by using tables in the database
to pass additional data (beyond a mere notification name) from notifier
to listener(s).

How ?


root2=> select * from pg_listener ;
 relname | listenerpid | notification
-+-+--
 aaa | 723 |0
(1 row)


grep -5  "typedef struct pgNotify" /usr/local/include/libpq-fe.h

typedef struct pgNotify
{
char   *relname;   /* notification condition name */
int   be_pid;  /* process ID of server process
*/
char   *extra;/* notification parameter */
} PGnotify;



I need to insert "extra" data - uid, ...

 PGnotify   *notify;
 notify->extra;


Thanks



---(end of broadcast)---
TIP 1: 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

[GENERAL] PostgresqlODBC

[news.postgresql.org]

Hi,

I have a few questions concerning odbc.
I have set up Mandrake7.2 and compiled PostgreSQL with the unicode option.

What is the current state of postgres odbc unicode support?
Does the odbc-driver, which comes with postgres, support unicode?
I know that the DB supports it, but how about the driver?

If so, where can I find more info on it? I already searched through the
postgresql site but couldn't really find a lot.

If it does not yet support unicode, can anyone tell me what the status is on
it?
Is someone working on it? If so, who (if I am allowed to know ofcourse).
Can we help in any way?

Thanx,
Bjorn Segers
[EMAIL PROTECTED]