Re: [GENERAL] [Solved] SQL Server to PostgreSQL

2000-08-22 Thread Tressens Lionel
Le 22.08.00 a 09:37, "Roderick A. Anderson" m'ecrivait : )I was able to get the table format by using MS Access. Only question left )is what is the corresponding field type in PostgreSQL for a memo field in )SQL Server/Access (varchar())? 'text' type perhaps ? Lionel

Re: [GENERAL] php and pgsql and rpm/compile

2000-09-07 Thread Tressens Lionel
Le 07.09.00 a 14:23, "Lamar Owen" m'ecrivait : > It is coming back with a dependency for libpq.so.2.0 I had this problem. I created a symlink for this file and a told rpm not to check dependies, and it worked. rpm --nodeps -ivh ... Lionel == Lion

[GENERAL] permissions on databases

2001-02-06 Thread Tressens Lionel
Hi all, I am the super user of my DBMS and if create a database for a simple user, I do : => create database formyuser; But If this user connects to the database and tries to create a table, he has no rights. I must (the super user) create the table for him and then give him all the permissions

[GENERAL] Quotas on databases

2001-02-07 Thread Tressens Lionel
Hi all, Is it possible to set quotas for each user of my DBMS ? I run a web server and I gave the users the opportunity to have a personal database for their homepage but I don't want them to put large objects such as files in the DBMS, so I want to apply quotas. Thanks in advance for your help

[GENERAL] Problems when dumping a database

2001-02-20 Thread Tressens Lionel
Hi all, My pgsql DBMS works great except that when I want to dump a database, pg_dump says that database template1 doesn't exist (actually it does !) and the dump is aborted... Any ideas ??? Thanks a lot Lionel

Re: [GENERAL] Problems when dumping a database

2001-02-24 Thread Tressens Lionel
Le 22.02.01 à 22:23, "Tom Lane" écrivait : )> SELECT oid FROM pg_database WHERE datname = 'template1' ) )> But this SELECT returns two tuples ! I have two identical tuples in )> pg_database for template1. )> Perhaps deleting one will help me, but which one (equal ?). ) )This is definitely uncool,