Re: [HACKERS] php with postgres
Joe Conway wrote: ivan wrote: ok, but php should build this lang for postgres i think so, we should talk with php group ? I have been talking with several people about this on-and-off for a while now. If I can find some time in the next few months, I will probably write it (if no one beats me to it). I'm thinking that it should be written using Postgres 7.5devel (once 7.4 stable is branched) and PHP5 (which is in alpha/early-beta testing). I had been briefly talking with Marcus Boerger (included in CC) from the PHP team about it. He knows the PHP5 SAPI embed well. Can you include him into the team (if not already)? From what I know about this SAPI I think the PL/Tcl implementation would be a good point to start from, as it looks very similar with respect to the possibilities. Jan -- #==# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #== [EMAIL PROTECTED] # ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] php with postgres
Jan Wieck wrote: I had been briefly talking with Marcus Boerger (included in CC) from the PHP team about it. He knows the PHP5 SAPI embed well. Can you include him into the team (if not already)? Sure! From what I know about this SAPI I think the PL/Tcl implementation would be a good point to start from, as it looks very similar with respect to the possibilities. I was going to start from PL/R, which is a descendent of PL/Tcl -- reason being, in PL/R I've already got SRF/table-function support and polymorphic argument/return-type support working. Also, I've done a fair amount of work to preserve arrays and composite types as they move back-and-forth. My plan is to add a few missing things to PL/R over the next couple (or so) weeks, and then start PL/PHP from that: 1) Cache lookup based on function oid and argument signature ala the patch I recently sent in (and improved by Tom) for PL/pgSQL -- this is needed to properly support polymorphic arguments. 2) Trigger support -- just haven't needed this so far, but we'll want it in PL/PHP, so I may as well add it to PL/R too. 3) Re-add nested error handling -- I removed this from PL/R early on just to simplify life. Should be easy to drop back in. I've read some examples posted regarding the PHP embed SAPI, and it looks very similar to the R interpreter also. It should be fairly easy to drop the PHP embed calls in for the libR calls. The bulk of the work will be in modifying the data conversion functions that map Postgres composite types and arrays to similar structures in PHP. Help on the PHP side of things would be most appreciated, because that's the part I'm least familiar with. Joe ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] row level locks
How do we acquire row level locks and is there a way to detect them from the any of lock data structures (like Lock, ProcLock, PGPROCK, and LockData)? thanks jennyThe new MSN 8: smart spam protection and 2 months FREE*
[HACKERS] table level and row level locks
Iam trying to acquire rowlevel locks in postgresql. I try doing this: 'select * from students where name='Larry' for update; But by looking at the holding array of proclock , I've noticed that by doing this only AccessShareLock gets acquired which is a table level lock. How do I acquire rowlevelock and what fields of Lock or Proclock datastructures indicate it. Thanks JennyAdd photos to your e-mail with MSN 8. Get 2 months FREE*.
[HACKERS] locking mechanism
hi, 1)If the same PROCLOCKhas some already-granted locks and be waiting for more, how do we know? I currently use the holding array of PROCLOCKto figure out what lockmodes a transaction(process) has been granted on LOCK,and if holdings sum comes to 0 that means this PROCLOCK is waiting for its associate LOCK. But howif the PROCLOCK has already been granted a lock and is waiting for another lock onthe sameobject( LOCK), how dofigure that out? 2)Is tuple level locks the same as row level locks? Thanks!! JennyMSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*.
Re: [HACKERS] php with postgres
what aoubt stream ? in plpgsql you can just write command INSERT ... or DELETE if you want sht like this in php you need to correct zend i think . in php all var is declared as variant type but we need look at realy type. I have other view, to first write php interpreter to postgres, and then write a translator, which translate plphp code to C code . I cound be only a another way, to remember about speed (compiled code is always faster then src ) . Php source will be to testing, and to relese will be option to translate this src to C src and then compile it. ps. there could be also interpreter with debug version and relese version (without checking some things) dont forget about default value of functions args !! : On Sun, 13 Jul 2003, Joe Conway wrote: Jan Wieck wrote: I had been briefly talking with Marcus Boerger (included in CC) from the PHP team about it. He knows the PHP5 SAPI embed well. Can you include him into the team (if not already)? Sure! From what I know about this SAPI I think the PL/Tcl implementation would be a good point to start from, as it looks very similar with respect to the possibilities. I was going to start from PL/R, which is a descendent of PL/Tcl -- reason being, in PL/R I've already got SRF/table-function support and polymorphic argument/return-type support working. Also, I've done a fair amount of work to preserve arrays and composite types as they move back-and-forth. My plan is to add a few missing things to PL/R over the next couple (or so) weeks, and then start PL/PHP from that: 1) Cache lookup based on function oid and argument signature ala the patch I recently sent in (and improved by Tom) for PL/pgSQL -- this is needed to properly support polymorphic arguments. 2) Trigger support -- just haven't needed this so far, but we'll want it in PL/PHP, so I may as well add it to PL/R too. 3) Re-add nested error handling -- I removed this from PL/R early on just to simplify life. Should be easy to drop back in. I've read some examples posted regarding the PHP embed SAPI, and it looks very similar to the R interpreter also. It should be fairly easy to drop the PHP embed calls in for the libR calls. The bulk of the work will be in modifying the data conversion functions that map Postgres composite types and arrays to similar structures in PHP. Help on the PHP side of things would be most appreciated, because that's the part I'm least familiar with. Joe ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[HACKERS] did you read my mails ?
someone looked at my files function ?? ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] 7.4 Beta RPMS?
On Sunday 13 July 2003 18:09, Matthew T. O'Connor wrote: I know it's early, but I was just wondering if there would be 7.4 rpms during beta? I plan to have them. I'm on vacation this week, so it will be next at earliest, depending upon when the beta itself is ready. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[HACKERS] Win32 port - current status?
Hi all, just wondering if the guys involved in the Win32 port could give a quick update? I'm just (one of the many?) hanging out for this, to justify continued use of Postgres to the powers that be. Seems like there has been no word on this for a couple weeks, and I'm not even sure whether or not it has made/will make it into 7.4? Perhaps I've missed a crucial message somewhere... All the best, Claudio Certain disclaimers and policies apply to all email sent from Memetrics. For the full text of these disclaimers and policies see http://www.memetrics.com/emailpolicy.html ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
