[ADMIN] Database directory names

2002-07-03 Thread Kris Deugau
I'm in the final stages of setting up database access for our domain hosting customers. The current system is running PostgreSQL 7.0- with which I haven't met any major problems (other than trying to figure out how to restrict access to each domain's database- solved). However... That box is

Re: [ADMIN] db connection fails

2002-07-03 Thread Mark Tessier
Have you tried doing a network connection with your apache user? (su - apache; psql -h localhost group3.) Yes, I've tried it and get the following: psql: could not connect to server: Connection refused Is the server running on host 192.168.1.2 and accepting TCP/IP

[ADMIN] unsubscribe

2002-07-03 Thread Simeone, Mario
unsubscribe su www.tim.it puoi iscriverti gratis alle TimNews, un modo rapido e tempestivo per conoscere le ultime novita di TIM.

Re: [ADMIN] Help: URGENT!

2002-07-03 Thread Nils Höglund
Exist field type date, question: With format date 'dd/mm/' ? I'm not sure what you wan't to do. To convert and format dates in postgresql you can use to_date()- or to_char()-functions. http://www.postgresql.org/idocs/index.php?functions-formatting.html -- /Nils Höglund,

Re: [ADMIN] unsubscribe

2002-07-03 Thread Davide Bozzelli
On Tue, 2 Jul 2002, Simeone, Mario wrote: unsubscribe ENGLISH: I think could be enough just ONE unsubscribe .. ITALIAN: Non basta un solo unsubscribe ??? ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [ADMIN] Database directory names

2002-07-03 Thread Bruce Momjian
Stephan Szabo wrote: Is this a feature, a bug, or a change related to some other critical functional capability of Postgres? I haven't found anything else that meets our requirements here, and I can work around this annoyance if required- but I'd rather be lazy. ;) Switching to

Re: [ADMIN] Database directory names

2002-07-03 Thread Stephan Szabo
On Wed, 3 Jul 2002, Bruce Momjian wrote: Stephan Szabo wrote: Is this a feature, a bug, or a change related to some other critical functional capability of Postgres? I haven't found anything else that meets our requirements here, and I can work around this annoyance if required-

[ADMIN] PostGre SQL on linux

2002-07-03 Thread chekravarthula
Hi All, I am trying to work with post gre sql on manrdake linux8.2 version , it is having the postgre sql but while i try to star the server it is giving error tcp/ip on unix systemect., or file not found error, I tryed installing the postgre sql 7.1 , i installed it but even then it is giving

[ADMIN] Permissions in PgSQL 7.2.1

2002-07-03 Thread Roger Mathis
Hi I have a problem with permissions. I have a user admin1. His permissions are select, insert, update and delete on table employee. After connecting with this user, I tried to create a table, and it worked. Why does this work? I don't want, that admin1 can create tables. Before I gave admin1

Re: [ADMIN] Oracle data - PostgreSQL

2002-07-03 Thread Bruce Momjian
Leonardo Camargo wrote: Hi How do i migrate data from an Oracle db to a PostgreSQL db ? Is there an article, paper, site, howto, aboutm it? Any point would be helpful Sure, see /contrib/oracle/ora2pg and techdocs.postgresql.org. -- Bruce Momjian|

Re: [ADMIN] Oracle data - PostgreSQL

2002-07-03 Thread Michael G. Martin
If I were tasked to do it, I'd probably use PERL and DBI/DBD. Once you get all the Oracle tables converted and built in Postgres, you could write a PERL program to open a database descriptor to your oracle database and postgres database at the same time. Then, copy all the records in each

Re: [ADMIN] PostGre SQL on linux

2002-07-03 Thread Robert Treat
Sounds like you are trying to do everything as 'root'. You need to login as user 'postgres' (or some other non-privileged account) before everything will function properly. (if you don't have a 'postgres' user you'll need to create it.) Robert Treat On Wed, 2002-07-03 at 08:30, [EMAIL

Re: [ADMIN] Database directory names

2002-07-03 Thread Kris Deugau
Stephan Szabo wrote: Switching to numbers for tables and databases helped a few things (including for tables making it easier to rollback a drop table). There's a contrib item, oid2name which will print out a mapping of directory number to database name. The readme gives an example of

[ADMIN] ecpg problem : pre-processor translated long constant to char

2002-07-03 Thread Raymond Fung
Dear all, A simple testing program : * * * * * * * * * * * * * * begin * * * * * * * * * * * * * * * * #include stdio.h #include stdlib.h int main (void) { unsigned int v; v = 0x87654321L; return (0); } * * * * * * * * * * * * * * end * * * * * * * * * * * * * * * * compile