Re: [GENERAL] Re: Problem with inheritance

On Fri, 26 Jan 2001, Alfonso Peniche wrote: I like the idea, there's just one problem, a user can be both a student and an employee... - If the guy is an user only, then just fill the user template - If the guy is a student, add a tuple to the is_student relation. - If the guy is an employee,

Re: [GENERAL] get last sequence

"Mr. Chan" wrote: dear all, how to get last sequence from postgresql? I mean such mysql last_insert_id function or ms sql select @@identity. I presume you mean get the last value assigned by the sequence. If the sequence has been used in the current session (since connecting to the

Re: [GENERAL] Wild Cards

Adam Haberlach wrote: On Thu, Jan 25, 2001 at 08:40:23AM -0500, No Name wrote: I am not able to get Wildcards in PostgreSQL, I know its * (asterisk), but its not working. can someone show me a example or something? It's % and you have to use the LIKE operator. SELECT * FROM

Re: [GENERAL] Backends dying due to memory exhaustion--I'm stonkered

Waiting for the next crash with anticipation... Since you said you are running ACS is here you may as well want to set the param Verbose to True in your db pool which will log all queries to the db in the access log. Then when it crashes during normal execution you can simple determine the

[GENERAL] Search engine doesn't work

Hi, I wanted to try in the archives how to store a md5sum best in a database (origin is 16 bytes binary, if I don't get a good answer I will use ASCII like the output of the md5sum UNIX command since this is easy to debug). I got this error: Not Found The requested URL

[GENERAL] PHP/HTTP Logs?

I am finding that a lot of messages (such as the commit messages and various things of the like, as well as messages for complex queries being completed implicitly and various things like that) showing up in my global apache log file (using PHP/Apache). Any ideas how I can either get these to

Re: [GENERAL] Search engine doesn't work

On Sat, 27 Jan 2001, Marc SCHAEFER wrote: Hi, I wanted to try in the archives how to store a md5sum best in a database (origin is 16 bytes binary, if I don't get a good answer I will use ASCII like the output of the md5sum UNIX command since this is easy to debug). I got this error: Not

[GENERAL]

set nomail

[GENERAL] JDBC connection failure

Hi, I'm pulling my hair out trying to establish a jdbc connection to postgresql. The error I recieve is: unable to load class postgresql.Driver I can however import org.postgresql.util.* without generating an error through tomcat when I put the postgresql.jar directly in the