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 >

[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. ---

[ADMIN] tedia2sql (UML ERD-->SQL Converter) Update

2002-07-03 Thread Tim Ellis
Hello Lists, J.K. Lowden, tedia2sql now has a permanent and well-hosted homepage: http://tedia2sql.tigris.org. CVS. Bugtracking. Mailing list. Tarballs. It's all good. faemalia.net/tedia2sql now contains only a simple reference link. I'd *LOVE* to have a copy of a large, distributable ERD create

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öglun

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? http://www.po

Re: [ADMIN] Database directory names

2002-07-03 Thread Stephan Szabo
On Tue, 2 Jul 2002, Kris Deugau wrote: > 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'

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

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 > > >

[ADMIN] Oracle data -> PostgreSQL

2002-07-03 Thread Leonardo Camargo
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 Thnx in advance. Kal ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://a

[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 the

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| http

Re: [ADMIN] Oracle data -> PostgreSQL

2002-07-03 Thread Nick Fankhauser
http://techdocs.postgresql.org/ (Look about halfway down the page) -Nick > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Leonardo Camargo > Sent: Wednesday, July 03, 2002 1:57 AM > To: [EMAIL PROTECTED] > Subject: [ADMIN] Oracle data -> PostgreSQ

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 ta

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 PROTECTED]

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 exam

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

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