[ADMIN] Re: [NOVICE] pg_dump problem

2000-07-21 Thread Tom Lane
John Burski <[EMAIL PROTECTED]> writes: > When I issue the "pg_dump jcon" (jcon being the database name, of > course) I receive the following error message: > getInherits(): SELECT failed It might be time to put this in the FAQ ;-). You're probably trying to run a 6.5 (or earlier?) pg_dum

[ADMIN] pg_dump problem

2000-07-21 Thread John Burski
I'm having a bit of trouble with the "pg_dump' command in PostgeSQL 7.0.2 (running on Red Hat 6.0). When I issue the "pg_dump jcon" (jcon being the database name, of course) I receive the following error message: getInherits(): SELECT failed I'm issuing the command as the postgres "root"

[ADMIN] password encryption

2000-07-21 Thread Silesky Marketing Inc, Support
Hello, I want to encrypt passwords with Postgresql the way mySQL does it with : UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'; How can I do that ? Thanks a lot, Laurent

[ADMIN] OT: asp2php [ Was: MS Access out-performs PostgreSQL 7? ]

2000-07-21 Thread Ragnar Kjørstad
On Fri, Jul 21, 2000 at 11:15:02AM -0300, Paulo Roberto Siqueira wrote: > > (and you can run php under MS-IIS - there is even a tool to convert asp > > to php). > > Where can I find this tool to convert from asp to php? [ totally OT, but I'm CCing to the list since you're the third person to a

RES: [ADMIN] MS Access out-performs PostgreSQL 7?

2000-07-21 Thread Paulo Roberto Siqueira
> -Mensagem original- > De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Em nome > de Ragnar Kjørstad > Enviada em: quinta-feira, 20 de julho de 2000 17:22 > Para: Joseph Sircy > Cc: Gavin M. Roy; The Hermit Hacker; pgsql list > Assunto: Re: [ADMIN] MS Access out-performs PostgreSQL 7? >

[ADMIN]

2000-07-21 Thread Денис Осадчий
Hello, I try to select rows with LIMIT statement: select NICO, NICO, InDate from FirmICO LIMIT 5 OFFSET 5; - It works correctly. But when i try aply this query to declare cursor, it returns me all rows: DECLARE scursor CURSOR FOR select NICO, NICO, InDate from FirmICO LIMIT 5 OFFSET 5; Why it hap

RE: [ADMIN] MS Access out-performs PostgreSQL 7?

2000-07-21 Thread Magnus Hagander
> > Maybe I need to try a different ODBC driver, or if anyone > knows of a better > > way to connect in asp scripts to psql, please let me know. > > I know you said you needed to use MS-IIS, but do you also need to use > asp? > > php has a feature called persistent database connections - it ba