Jump to content


jcasanova

Member Since 13 Apr 2012
Offline Last Active Aug 19 2019 11:02 PM
-----

#1710 Error on sorting relation_n_n column in flexigrid

Posted jcasanova on 11 May 2012 - 01:09 PM

change log for 1.2.2 looks very nice.

Good work!


#1697 GC in postgres 9.1

Posted jcasanova on 10 May 2012 - 02:06 PM

Here is an updated version, Fixed the relation_n_n, now its working.

this is the link,

http://uploading.com...ltimo+-+PG.rar/


#1669 [ANSWERED] Can I switch databases?

Posted jcasanova on 08 May 2012 - 06:36 PM

Excellent i'll test it asap

Thanks


#1651 set_relation problem

Posted jcasanova on 07 May 2012 - 03:50 PM

@web-johnny,  I fixed the problem, it was a problem with the char '  in the get_list function in the model, because pg uses " instead of '  so the problem is fixed.


if($this->field_exists($related_field_title)){ 
     $select .= ", {$this->table_name}.$related_field_title as '{$this->table_name}.$related_field_title' ";
}

changed to:


if($this->field_exists($related_field_title)){ 
     $select .= ", {$this->table_name}.$related_field_title as \"{$this->table_name}.$related_field_title\"";
}



Thanks for your consern =)  

I'm fixing this issues for a postgres version maybe you should add in the future.

Great Work!!


#1481 GC in postgres 9.1

Posted jcasanova on 26 April 2012 - 02:13 PM

I merged the new version into the model that works with Postgres, maybe doesn't work a 100% , but forme work for almost everything


I attached the model and the library (library has a one little modification) , you could use the  load_model function of GC, if you don't want to mess with the core.

You have to do a one modification (I could not fixed from grocery model) to the postgre_driver.php of CI



function insert_id()
{
$v = $this->_version();
$v = $v['server'];

$table = func_num_args() > 0 ? func_get_arg(0) : NULL;
$column = func_num_args() > 1 ? func_get_arg(1) : NULL;

if ($table == NULL && $v >= '8.1')
{
$sql='SELECT LASTVAL() as ins_id';
}
elseif ($table != NULL && $column != NULL && $v >= '8.0')
{
$sql = sprintf("SELECT pg_get_serial_sequence('%s','%s') as seq", $table, $column);
$query = $this->query($sql);
$row = $query->row();
$sql = sprintf("SELECT CURRVAL('%s') as ins_id", $row->seq);
}
elseif ($table != NULL)
{
// seq_name passed in table parameter
$sql = sprintf("SELECT CURRVAL('%s') as ins_id", $table);
}
else
{
return pg_last_oid($this->result_id);
}
$query = $this->query($sql);
$row = $query->row();
return $row->ins_id;
}



#1214 jquery-ui problem in add section

Posted jcasanova on 13 April 2012 - 03:07 PM

problem resolved, GC works with jquery-ui-1.8.10.custom.min, and not working with 1.8.18