Re: [GENERAL] psql and blob

2003-09-18 Thread Darko Prenosil
- Original Message - From: "Daniel Schuchardt" <[EMAIL PROTECTED]> To: "Doug McNaught" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, September 18, 2003 4:44 PM Subject: Re: [GENERAL] psql and blob > Yes thats it. > > Ok - one last question. > My Script looks like this and a

Re: [GENERAL] psql and blob

2003-09-17 Thread Darko Prenosil
On Wednesday 17 September 2003 18:32, Daniel Schuchardt wrote: > Hi @ all, > > i'm sure there was a psql-function to transfere my Blob-Data to the > server but I can't remember. > > I have a script like this : > > UPDATE xy SET z = lo_import('localpath_and_file'); > > but i want to execute this scr

Re: [GENERAL] Red Hat 9 Postgres

2003-09-16 Thread Darko Prenosil
It is fully functional, but has few packages. I think that docs interfaces and contrib are in separate packages. There are also pgsql modules for php that are not listed under "database" packages but http server or something like that.   Regards ! - Original Message - From:

Re: [GENERAL] Picture with Postgres and Delphi

2003-09-09 Thread Darko Prenosil
- Original Message - From: "listy.mailowe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 09, 2003 8:10 PM Subject: Re: [GENERAL] Picture with Postgres and Delphi > Hi, > > Edwin Quijada wrote: > > > Hi !! Everybody > > I am developing app using Delphi and I have a

Re: [GENERAL] Picture with Postgres and Delphi

2003-09-09 Thread Darko Prenosil
- Original Message - From: "Edwin Quijada" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 09, 2003 6:54 PM Subject: [GENERAL] Picture with Postgres and Delphi > Hi !! Everybody > I am developing app using Delphi and I have a question: > I have to save pictures into

Re: [GENERAL] German special characters Problem

2003-09-09 Thread Darko Prenosil
On Tuesday 09 September 2003 16:10, Dennis Gearon wrote: > Amin Schoeib wrote: > > Hi, > > Can somebody tell me why german special characters like 'ü' or 'ä' > > will be changed > > To '?' when retrieving data from postgres with Java (JDBC). When I > > select the data under > > Postgres everything

Re: [GENERAL] How can I set postmaster as a service

2003-09-05 Thread Darko Prenosil
- Original Message - From: "Jeffrey Melloy" <[EMAIL PROTECTED]> To: "shreedhar" <[EMAIL PROTECTED]> Cc: "Postgre Admin" <[EMAIL PROTECTED]>; "Postgre General" <[EMAIL PROTECTED]> Sent: Friday, September 05, 2003 7:32 PM Subject: Re: [GENERAL] How can I set postmaster as a service > shree

Re: [GENERAL] Using oids

2003-09-03 Thread Darko Prenosil
On Wednesday 03 September 2003 17:24, Bo Lorentsen wrote: > On Wed, 2003-09-03 at 16:13, Tom Lane wrote: > > The reason OIDs shouldn't be considered unique is that there is no > > mechanism to enforce that they are unique --- unless you make one, > > that is, create a unique index on OID for a tabl

Re: [GENERAL] Why lower's not accept an AS declaration ?

2003-08-18 Thread Darko Prenosil
- Original Message - From: "Hervé Piedvache" <[EMAIL PROTECTED]> To: "Darko Prenosil" <[EMAIL PROTECTED]>; "Postgresql General" <[EMAIL PROTECTED]> Sent: Monday, August 18, 2003 6:59 PM Subject: Re: [GENERAL] Why lower's not accept

Re: [GENERAL] Why lower's not accept an AS declaration ?

2003-08-18 Thread Darko Prenosil
- Original Message - From: "Darko Prenosil" <[EMAIL PROTECTED]> To: "Hervé Piedvache" <[EMAIL PROTECTED]>; "Postgresql General" <[EMAIL PROTECTED]> Sent: Monday, August 18, 2003 10:09 PM Subject: Re: [GENERAL] Why lower's not ac

Re: [GENERAL] Why lower's not accept an AS declaration ?

2003-08-18 Thread Darko Prenosil
On Monday 18 August 2003 13:04, Darko Prenosil wrote: > On Monday 18 August 2003 10:20, Hervé Piedvache wrote: > > Hi, > > > > May be my question is stupid ... but I'm a little suprised : > > > > SELECT id_letter as letter from my_table; > >

Re: [GENERAL] Why lower's not accept an AS declaration ?

2003-08-18 Thread Darko Prenosil
On Monday 18 August 2003 10:20, Hervé Piedvache wrote: > Hi, > > May be my question is stupid ... but I'm a little suprised : > > SELECT id_letter as letter from my_table; > > letter > - > B > C > a > A > > SELECT id_letter as letter from my_table order by letter; > > letter > - > A > B > C

Re: Install new language - Prev: Re: [GENERAL] Are you frustrated with PostgreSQL

2003-07-16 Thread Darko Prenosil
I'm going to skip the questions that I don't know the answer. - Original Message - From: "Terence Chang" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 16, 2003 9:05 PM Subject: Install new language - Prev: Re: [GENERAL] Are you frustrated with PostgreSQL > Folks: > >

Re: [GENERAL] Couple Postgres View Questions

2003-07-16 Thread Darko Prenosil
- Original Message - From: "Brian Maguire" <[EMAIL PROTECTED]> To: "Postgresql General Mail List" <[EMAIL PROTECTED]> Sent: Wednesday, July 16, 2003 6:44 PM Subject: [GENERAL] Couple Postgres View Questions >I have a couple questions about Postgres and Views. >I am curious about what Po

Re: [GENERAL] Firebird vrs Postgresql

2003-07-15 Thread Darko Prenosil
- Original Message - From: "Dann Corbit" <[EMAIL PROTECTED]> To: "Erick Dennis" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, July 15, 2003 11:04 PM Subject: Re: [GENERAL] Firebird vrs Postgresql > -Original Message- > From: Erick Dennis [mailto:[EMAIL PROTECTED] > Sent

Re: [GENERAL] Q: Executing functions at connect/disconnect?

2003-07-04 Thread Darko Prenosil
- Original Message - From: "Mattias Kregert" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Darko Prenosil" <[EMAIL PROTECTED]> Sent: Friday, July 04, 2003 7:11 PM Subject: Re: [GENERAL] Q: Executing functions at connect/disconnect? Is

Re: [GENERAL] Q: Executing functions at connect/disconnect?

2003-07-04 Thread Darko Prenosil
- Original Message - From: "Mattias Kregert" <[EMAIL PROTECTED]> To: "Darko Prenosil" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, July 04, 2003 6:08 PM Subject: Re: [GENERAL] Q: Executing functions at connect/disconnect? Just as i th

[GENERAL] Passing NEW to function

2003-07-04 Thread Darko Prenosil
Is there a way to pass NEW or OLD from inside of trigger into some function ? I have situation where "versions" of row calculations are offten changed, so I would like to make "case" with function calls depending on version number. If I make case with actual code inside trigger function, i

Re: [GENERAL] Q: Executing functions at connect/disconnect?

2003-07-03 Thread Darko Prenosil
On Thursday 03 July 2003 17:28, Mattias Kregert wrote: > Is there a way to automagically execute a function at connect/disconnect? > I was thinking about the possibility to have some kind of automatic cleanup > when the client disconnects. > > I would like to: > - Register a session id at connect t

Re: [GENERAL] Unable to create or drop plpgsql

2003-06-21 Thread Darko Prenosil
- Original Message - From: "Jason Underdown" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 20, 2003 11:00 PM Subject: [GENERAL] Unable to create or drop plpgsql > Hi everyone, > > This is my first post to this group, so please be kind. > > My database used to have suppor