Re: [GENERAL] kinda newbie - ish question

2001-10-15 Thread Richard Lynch
http://php.net/pg_getlastoid This is the *ONLY* time you should actually use OIDs -- To get the unique value you just inserted. -- WARNING [EMAIL PROTECTED] address is an endangered species -- Use [EMAIL PROTECTED] Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer

[GENERAL] pg_shadow.passwd versus pg_hba.conf password passwd

2001-02-20 Thread Richard Lynch
Re-Sending due to rejection after subscribing, before confirming. Sorry if two make it through... Background: Trying to use a Cobalt box that has PostgreSQL pre-installed. I can change localhost "crypt" to "trust" in pg_hba.conf, but I don't really want to do that long-term. If I'm reading "m

[GENERAL] Re: Weird: attribute 'input' not found

1999-06-03 Thread Richard Lynch
Gah! I had:

[GENERAL] Weird: attribute 'input' not found

1999-06-03 Thread Richard Lynch
The error message: PostgreSQL query failed: ERROR: attribute 'input' not found in ... on line 40 Normally I would think I just mis-typed a field name, but the word 'input' is *NOT* anywhere in the query. Honest. I spit it out before pg_exec() just to be sure. I even spit it out after to make

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-24 Thread Richard Lynch
>On Fri, 24 Jul 1998, Richard Lynch wrote: > >> At 8:28 AM 7/24/98, Marc Fournier wrote: >> >> >So, essentially, our VACUUM command provides functionality that >> >Oracle *doesn't* have, right? >> >> Yes, but yours doesn't run aut

Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!

1998-07-24 Thread Richard Lynch
At 10:36 AM 7/24/98, Byron Nikolaidis wrote: >Bruce Tong wrote: >> Another window appeared and said "Error while executing the query. ERROR: >> The field being ordered by must appear in the target list (#1)." >> >> Since I hadn't specified any sorting, the "order by" part of the message >> had me

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-24 Thread Richard Lynch
At 8:28 AM 7/24/98, Marc Fournier wrote: >So, essentially, our VACUUM command provides functionality that >Oracle *doesn't* have, right? Yes, but yours doesn't run automatically. Ideally, when one created a database, one could specify vacuum frequency and/or time slot, and PostgreSQL w

[GENERAL] Vacuum

1998-07-03 Thread Richard Lynch
Is there some tool[s] to indicate the % of waste and/or column/index performance or some other criteria to indicate relative need for vacuum?...

[GENERAL] Re: [PHP3] Doing \copy after a file upload.

1998-07-03 Thread Richard Lynch
Again cross-posted due to duality of php/psql question. Don't cross-post specific replies. THANKS!!! At 3:11 PM 7/3/98, Richard Lynch wrote: >C. I should research system/shell/passthrough stuff >Do you get the idea that I'm not even sure which one does what?...

[GENERAL] Doing \copy after a file upload.

1998-07-03 Thread Richard Lynch
This is cross-posted to PHP3 and pgsql-general because it's a half/half sort of thing... Please check replies carefully and avoid too-specific answers going to both lists. If in doubt, email me direct, and I'll summarize where appropriate THANKS!!! #1 I'm running PHP3b6 because my ISP can't ge

Re: [GENERAL] Re: [HACKERS] custom types and optimization

1998-06-02 Thread Richard Lynch
At 12:12 AM 6/1/98, Bruce Momjian wrote: >Users, we need to hear from you on this, and why you chose to use >PostgreSQL. We don't need people foaming at the mouth, but we do need >our users to give use good visibility and publicity. I'm using pgsql because that's what my ISP has, and I'm having

[GENERAL] User Authentication Failed

1998-05-19 Thread Richard Lynch
The PostgreSQL Glimpse mailing list search thing is down. I found some similar things in PHP's archives, but none that really seemed applicable. I only know half the story, though, because my ISP is running PostgreSQL and compiling PHP for me, so it's hard to play around with options and such.