[GENERAL] phppgadmin 4.0.1

Hi,i run on Windows XP + apache + php + postgresql 8.1.When i try to log-in with phppgadmin, i have the following error message :"Login disallowed for security reasons."based on some info from internet, i've setup the following value : true to $conf['owned_only'] = true;but nothing changed.my login

[GENERAL] Case for postgreSQL

Hi,I would like to know if it exists a good case tool for creating DB into PostgreSQL ?thanks a lot,Maileen __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

[GENERAL] postgres 7 and eastern language

Hi,i would like to know what i have to do to make postgres 7 store some eastern languages with their particular letters. like czech, slovak, and so oni'm sure that some unicode possibilities exist but which ones ?basically, end user will type some text including these special characters and i w

[GENERAL] stored function and grant execute

Hi,I'm developping a web application which use PostgreSQL as database.I'm quite surprise to see that grant execute does not exist for PostgreSQL v7.x, but only in v8.xSo how can i grant such right (execute) to my user in v7.x ? because function were already existing in v7.xthanks a lot,Maileen Ri

Re: [GENERAL] error in SELECT

Hi Tom,in fact,i needed to move the DECLARE before begin and to adjust some autoincrement...and the problem is solved ;-)thx,MaileenTom Lane <[EMAIL PROTECTED]> wrote: "P.M" <[EMAIL PROTECTED]> writes:> here is my function in PostgreSQL :> CREATE OR REPLACE FUNCTION i

[GENERAL] error in SELECT

Hi,i've just migrated a stored procedure from MySQl to PostgreSQL and i have the following error :ERROR:  syntax error at or near "SELECT" at character 371here is my function in PostgreSQL :CREATE OR REPLACE FUNCTION immense_sp001(VARCHAR,VARCHAR, service_nom VARCHAR, OUT result BOOLEAN, OUT error_

Re: [GENERAL] move from 1 database to another

Thanks.it works well.Ragnar <[EMAIL PROTECTED]> wrote: On fim, 2006-05-25 at 11:52 -0700, P.M wrote:> I would like to know how can i move from 1 database to another one ?> > basically i want to run a *.sql script in which i connect under a> particular database (for example : tem

[GENERAL] move from 1 database to another

Hi,I would like to know how can i move from 1 database to another one ?basically i want to run a *.sql script in which i connect under a particular database (for example : template1 or postgres) and my *.sql script should create a new database (for example : test) and after execute several SQL comm

Re: [GENERAL] drop user / role if exists

first of all, it's not -i as i wrote but \ii work under windows OS.and my script is working now.thanks for your helpMartijn van Oosterhout wrote: On Sun, May 21, 2006 at 02:59:25AM -0700, P.M wrote:> To run the script i use :> > under psql command line, i load my SQL script file vi

Re: [GENERAL] drop user / role if exists

To run the script i use :under psql command line, i load my SQL script file via :psql -i myfile;Martijn van Oosterhout wrote: On Sun, May 21, 2006 at 02:25:44AM -0700, P.M wrote:> Thanks Martijn, but i'm currently working on the SQL script to create the full database. Not on some stored p

Re: [GENERAL] drop user / role if exists

this issue ?thanks a lot,MaileenMartijn van Oosterhout wrote: On Sun, May 21, 2006 at 02:08:38AM -0700, P.M wrote:> Hi,> > How under postgreSQL 7 do the equivalent as DROP USER / ROLE IF EXISTS ?> my web provider only support postgreSQL 7 :-(Do the DROP USER and ignore the error if

[GENERAL] drop user / role if exists

Hi,How under postgreSQL 7 do the equivalent as DROP USER / ROLE  IF EXISTS ?my web provider only support postgreSQL 7 :-(thanks a lot,Maileen Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2¢/min with Yahoo! Messenger with Voice.

[GENERAL] to create a database...

Hi,I'm creating a Visual Basic.net application and i would like to make my application versatile.For that, it should be able to create the same DB on different RDBMS like PostGreSQL, MySQL or MSSQL.I would like to know what is the best way to create a DB from scratch... (DB, table, users, functions

[GENERAL] IF EXISTS

Hi, I would like to know if "IF EXISTS" exists under postgresql ? because i did not find it. before to create users or database, i would like to be sure that they do not exist already. so how can i test it and do something like : IF EXISTS database "test" DROP database "test"; thanks a lot, Ma