Tagged Questions

0
votes
0answers
42 views

Zend_Dd_Adapter and postgres insert into select doesnt execute

I have a problem with the following query when running from Zend: INSERT INTO tblname(col1,col2,col3) SELECT * FROM tmp_table While running through pgAdmin3 or console it executes properly ...
0
votes
2answers
81 views

Clearing memory in PHP, for executing on large set of database rows [closed]

I want to execute a complex database query which involves about 60000 rows. When the execution completes on a few rows itself, the memory(RAM) gets filled up, and execution terminates with an error ...
0
votes
0answers
114 views

Defining Zend Framework table relationships with PostgreSQL?

I was used to work with Zend Db Table Relationships with MySQL. I declared $_dependentTables and $_referenceMap in the table classes as described in the manual. Then was able to work with functions ...
1
vote
1answer
44 views

Is there a way to set search_path for Zend_Db connection?

I have a Postgres database with tables spread across multiple schemas. I have a ton of pre-existing models for those tables which do not specify schema name(initial design was to keep all table under ...
0
votes
1answer
65 views

Is there any way to track and kill a Postgres query in Zend framework

I am working on a project using Zend Framework, PHP 5.3, and PostGres. I have built a javascript front end that relies heavily on AJAX requests. For instance, any time a user tries to add a new ...
1
vote
1answer
723 views

How to build a select using Zend with a DISTINCT specific column?

I'm using Zend Framework for my website and I'd like to retrieve some data from my PostgreSQL database. I have a request like : SELECT DISTINCT ON(e.id) e.*, f.*, g.* FROM e, f, g WHERE e.id = ...