Re: [ADMIN] [NOVICE] pg or DBI

2002-10-25 Thread Jason Earl
Actually there are two PostgreSQL Perl interfaces the DBI based one and Pg. It has been a while since I have used Perl (and it has been even longer since I used the Pg interface), but I can tell you that most people use the DBI version. The two interfaces are very similar, but the Pg interface i

Re: [ADMIN] [GENERAL] Need help

2002-01-14 Thread Jason Earl
Why do you want a database where two tables have the same name? When you do a "SELECT * from Table1" what table do you expect PostgreSQL to use? Now, that being said, it's possible to create temporary tables in different connections with the same name. These tables will dissapear when the conn

Re: [ADMIN] Migrating from 6.4.2 on MkLinux (PowerPC) to 6.5 onDebian (Intel)

1999-12-16 Thread Jason Earl
gt; > Nico > > On Wed, 15 Dec 1999, Jason Earl wrote: > > > It seems to me that I ran into a similiar problem recently. I also had > > trouble loading tables with their permissions. This is fixed in the > > newer versions, (if you are upgrading now make sure you ge

Re: [ADMIN] Migrating from 6.4.2 on MkLinux (PowerPC) to 6.5 on Debian (Intel)

1999-12-15 Thread Jason Earl
It seems to me that I ran into a similiar problem recently. I also had trouble loading tables with their permissions. This is fixed in the newer versions, (if you are upgrading now make sure you get 6.5.3) but for now the trick is to get your table moved across. Would it be possible to do a pg_

[ADMIN] Transferring data to/from Paradox 4.5

1999-06-30 Thread Jason Earl
something like this possible, or am I just dreaming? Jason Earl

Re: [ADMIN] pg_access

1999-06-16 Thread Jason Earl
Derek Del Conte wrote: > > This might not be the exact proper place for this, but I'm gonna try anyway :) > > I have pgsql setup and working fine. I am able to access it through odbc > using access to maintain a database. What I'd like to do though is use > php3 to extract the data and put it

[ADMIN] Problems re-loading permissions on database.

1999-05-10 Thread Jason Earl
lag must use "+-=" What does this mean, and where can I read more about it? It's not a big deal now, as I already have a sql script that will set my permissions up correctly. Last time I re-loaded my database I learned about the -z flag for pg_dump :). Thanks for the help, Jason Earl

Re: [ADMIN] Problems re-loading permissions on database.

1999-05-10 Thread Jason Earl
tainly hope that I haven't triggered something from the FAQ. I suppose this is one more reason to look forward to 6.5. Jason Earl