jppr

same problem here... fix it please... thanks a lot for your services

Hi! i really need some help... i have some problem with timestamp without time zone my data output is like this: 2009-11-02 06:19:30.494011 the problem is that i just want to show my seconds, and not milliseconds... i don't know how to do this.. i think it's maybe when i'm definning the type of data... what should i put beside "timestamp without time zone" ? is it the extension?! help.. done!!! in extension : "0" thanks a lot

Hi! i need to get superuser permissions so i can add new language (plpgsql) on my database (postgreSQL - phpPgAdmin) because When I try to create a function with CREATE OR REPLACE FUNCTION x() RETURNS void AS $func$ <function boddy> $func$ LANGUAGE plpgsql; I get : ERROR: language "plpgsql" does not exist so i need to add a new language plpgsql ... but how can i add? or how can i get permissions to add it? or i cannot become a superuser of my database?

got it, thanks. it can be closed. ^^

Hi! I need help... i'm having some problems on my PostgreSQL database... here's the deal: i create a table with some collumns.. and i need to insert a collumn with the expression: nextval ( i need that, because i want to, when i insert my things it increments my id.. ) how & where i make it on my phpPgAdmin ??! please.. it's for a school project.. i really need some help... thanks a lot and continue the good work!

i'm fine now

i tried host=stevie.heliohost.org . and it seems it work... but now i got another problem: Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "gpss" does not exist in /home/gpss2009/public_html/_classes/Banco.php on line 16 Warning: pg_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/gpss2009/public_html/_classes/info.php on line 12 got this error messages, any help? :S Code: Banco.php line 16 error: function Query($sql){ $exec = pg_query($this->db, $sql); return $exec; } info.php line 12 error: $rs = $db->Query("select id_gpss, latitude from GPSS"); $row = pg_fetch_assoc($rs);

Hi! i got somet doubt's... heres my code: function __construct(){ $strconn = "host= ?????? port=5432 user=XX password=XX dbname=XX"; $this->db = pg_connect($strconn); } what should i put on host = ?!!! help please.. thanks