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 actually i can

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 script from

Re: [GENERAL] Red Hat 9 Postgres

2003-09-16 Thread Darko Prenosil
It is fully functional, buthasfew packages. I think that docsinterfaces 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] 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 is ok. The

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 my

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 question: I

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 shreedhar wrote:

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 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 a SELECT

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; letter - B C a A SELECT id_letter as letter from

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 accept an AS declaration ? - Original Message - From: Hervé

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 an AS declaration ? Hi, An to be more precise what I exactly

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 Postgres

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: I would

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: Tuesday,

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 thought... I have only one solution then; to have

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 it possible to use pg_backend_pid() or pg_stat_activity

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 time.

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 support for