[GENERAL] Database Search in HTML - Help Needed!!!

2000-03-09 Thread Aron Y.B. Ben-Zev
Hi, I heard that there is a way to make an HTML page to search an .mdb (access database file). Does anybody know of such a thing? Please respond to my e-mail address [EMAIL PROTECTED] Thanx in advance, Aron. -- Aron Y.B. Ben-Zev, POB 115

[GENERAL] Re: SQL command ?

2000-03-09 Thread Kevin C. Dorff
Select distinct year from yearstable; --Kevin On Thu, 9 Mar 2000 18:58:44 +0200, "selifx" <[EMAIL PROTECTED]> wrote: >What SQL command can return (one field) recordset without dublicates from >table (one field) with dublicates. >example: > >Table : > >1999 >2000 >1999 >1998 >2000 > >necessary r

Re: [GENERAL] Re: [HACKERS] PostgreSQL Mailing Lists ...

2000-03-09 Thread Larry Rosenman
The biggest problem I'm having at the moment is getting slocal to filter them again. The sender tags are gone :-( LER > On Thu, 9 Mar 2000, The Hermit Hacker wrote: > > > On Thu, 9 Mar 2000, Henk van Lingen wrote: > > > > > On Thu, 9 Mar 2000, The Hermit Hacker wrote: > > > > > > > So far,

Re: [GENERAL] User authentication problem

2000-03-09 Thread Peter Eisentraut
Guillermo Iglesias writes: > I get the following error if i suply an user that exists in /etc/passwd > But if i connect with an user that only exists in PostgreSQL it works > Can someone tell me why That's how it is supposed to work. See the Adminstrator's Guide and/or create user for more info

[GENERAL] cannot extend error

2000-03-09 Thread Brook Milligan
I am running some queries and receive the following message: ERROR: pg_noname.3635.3: cannot extend. Check free disk space. I am confused, because there seems to be plenty of disk space in the partition containing the databases. I have the binaries installed on a different partition,

Re: [GENERAL] Listing Tables Query?

2000-03-09 Thread Jason Vasquez
Wouldn't it be better to do a pg_dump from the source database, and then load that dump file into the new machine? It should fix a lot of these problems -Jason "Robert G. Fisher" <[EMAIL PROTECTED]> on 03/09/2000 10:42:32 AM To: [EMAIL PROTECTED] cc: bcc: Subject: [GENERAL] Li

[GENERAL] SQL command ?

2000-03-09 Thread selifx
What SQL command can return (one field) recordset without dublicates from table (one field) with dublicates. example: Table : 1999 2000 1999 1998 2000 necessary recordset : 1999 2000 1998 Thanks.

Re: [GENERAL] Re: [HACKERS] PostgreSQL Mailing Lists ...

2000-03-09 Thread The Hermit Hacker
On Thu, 9 Mar 2000, The Hermit Hacker wrote: > On Thu, 9 Mar 2000, Henk van Lingen wrote: > > > On Thu, 9 Mar 2000, The Hermit Hacker wrote: > > > > > So far, these are the only lists that are active, with the rest of them > > > being switched over tomorrow during the day ... > > > > >

[GENERAL] Listing Tables Query?

2000-03-09 Thread Robert G. Fisher
I'm relatively new to using PostgreSQL, I've been toying with it on my home machine but now am also using it in the office. In this scenario, rather than creating a DB, I am copying in the database from another site -- this is simply a tar of the directory tree under /usr/local/pgsql/base rather

[GENERAL] SQL HELP

2000-03-09 Thread "Esperon, Juan Martín"
Hello, I need your help I have three question and I need you could respond me please. One of my questions is, how can take data that I have in Visual Basic to use it in an sql statement like for example in the SELECT function? The other question is, how can I execute a saved query with an sql

[GENERAL] Re: [HACKERS] PostgreSQL Mailing Lists ...

2000-03-09 Thread The Hermit Hacker
On Thu, 9 Mar 2000, Henk van Lingen wrote: > On Thu, 9 Mar 2000, The Hermit Hacker wrote: > > > So far, these are the only lists that are active, with the rest of them > > being switched over tomorrow during the day ... > > > > Majordomo2 has *alot* of nice features to it ... but this i

[ADMIN] PostgreSQL Mailing Lists ...

2000-03-09 Thread The Hermit Hacker
As some (most) of you will have noticed today, there were major problems with the mailing lists. After fighting with it for several hours, and not getting anywhere, I've finally bit the bullet and started to migrate over to Majordomo2 ... So far, these are the only lists that are active, with t