RE: [SQL] really need help

Hi, I would like to stop spending my work day deleting these messages. Is there anybody out there responsible for this? Make it stop! Now! Thanks > -Original Message- > From: Jie Liang [SMTP:[EMAIL PROTECTED]] > Sent: Friday, November 03, 2000 1:35 PM > To: [EMAIL PROTECTED]; [EMAIL P

[SQL] need help urgent

Hi, Is anybody have experience about core dump? We have some scripts have been used for a long time, however, recently, they seem to have some problems, the message I got: SSELECT priority from priority where source=lower('questionable') Total insert into preunchecked: 1 Segmentation fault - cor

Re: [SQL] Subqueries in from clause

Pierre Habraken <[EMAIL PROTECTED]> writes: > It looks like if subqueries in from clause are not supported by > PostgreSQL. Am I right ? If yes, are there any plans to provide this > feature soon ? Already there in current sources for 7.1 ... regards, tom lane

[SQL] Subqueries in from clause

It looks like if subqueries in from clause are not supported by PostgreSQL. Am I right ? If yes, are there any plans to provide this feature soon ? I would like to use Postgres for teaching SQL as a replacement for a well known commercial product which I find too heavy, too not open source, too e

[SQL] Urgent trigger problem.

I'm using V6.5. I want to write trigger to update database transaction logs. I have followed the examples, but have now run into some problems. I'm using plpsql to create a function for the trigger. I don't want to end up with very large transaction log tables and not all fields from a table wil

Re: [SQL] Connecting to Postgres from Windows

check your pg_hba.conf file for correct permissions. you need to have host based authenticationenabled for the network/hosts from where you are trying to connect. HTH \Indraneel On Fri, 3 Nov 2000, Umashankar Kotturu wrote: > Hi > > I am connecting to postgres in a java program running on wind

[SQL] Connecting to Postgres from Windows

Hi I am connecting to postgres in a java program running on windows 98. a) I am running the postgres on linux with -i option b) I am using the url as "jdbc:postgresql://:5432/testdb" The program is unable to resolve the url? The same thing happens when executing the java code on the linux mach

[SQL] user defined functions in Java ?

Hi, I am a beginner in postgres. a) I understand from postgres documentation that a user-defined function can be in sql or C language. Do any of you have an idea if such a function can be defined in Java ? b) if some one has examples of code, can you please forward the same ? Regards Uma.