[GENERAL] prob with really simple insert

2004-03-26 Thread marian
When I do this, INSERT INTO orgdata ( name, fax, contact, email, phone, address, preferred ) VALUES ( 'wally', '123456789', 'wally', '[EMAIL PROTECTED]', '987654321', 'wally way', 'f' ) I get ERROR: query rewritten 100 times, may contain cycles : PGRES_FATAL_ERROR What is going on here ---

Re: [GENERAL] Dump/restore indexes and functions in public schema

2012-10-09 Thread marian krucina
error is when only restore database.) On Tue, Oct 9, 2012 at 4:04 AM, Tom Lane wrote: > marian krucina writes: >> pg_upgrade failed on own server, because we used functions from public >> schema in index. We install common functions (e.g. postgresql contrib) >> to public s

Re: [GENERAL] PostgreSQL Developer Network

2005-06-03 Thread Marian POPESCU
> > > The websites is being developed on www.truesoftware.net:8081/pgdn/ using > PHP5 and of course PostgreSQL 8.0.3 > > > > Please do not hesitate to share your ideas. > > > > Kind regards, > > Gevik > > > Hi, Very good idea, indeed! What

[GENERAL] "Invalid multibyte character for locale" still there

2005-01-31 Thread Marian POPESCU
f_salary, t0.comments, t1.srcfileid FROM cv_profiles t0 LEFT JOIN cv_profiles_ocr t1 ON (t0.id_profile = t1.id_profile) WHERE (( upper(t1.ocrcontent) LIKE upper('%langage C%') ) ) ORDER BY t0.last_name, t0.first_name; Questions - 1. What can I do to outcome this issue (kn

[GENERAL] user_write_lock_oid questions

2005-12-02 Thread Marian Naghen
I'm new to PostgreSQL and I'm a litle confused.   I have 2 questions about using user_write_lock functions:   1. if a user set a write lock and then, for some reason (bad connections, app chashes, etc), disconect from server without releasing, what happened with the lock ? It will be still h

[GENERAL] sequences in transaction blocks

2005-12-18 Thread Marian Naghen
I want to insert records inside a transaction block (BEGIN - COMMIT/ROLLBACK). If the transaction fails, the sequence do not rollback and retain the new value.   This is the default behavior of sequences ?     I use the following table:   CREATE TABLE proceduri(  procedura_id int4 NOT NUL

Re: [GENERAL] sequences in transaction blocks

2005-12-19 Thread Marian Naghen
Okay, all clear. Thanx a lot. - Original Message - From: "Tino Wildenhain" <[EMAIL PROTECTED]> To: "Marian Naghen" <[EMAIL PROTECTED]> Cc: Sent: Monday, December 19, 2005 7:50 AM Subject: Re: [GENERAL] sequences in transaction blocks > Am Montag,

[GENERAL] sequences w/o holes

2005-12-19 Thread Marian Naghen
Can anyones suggest some readings about implementing sequences w/o holes ?     thanx in advance.

[GENERAL] XPath question - big trouble

2006-08-07 Thread Marian POPESCU
--'xpath_string(''rawdata'',''@objid'') = ''2_1'' ' --'xpath_bool(''rawdata'',''/mydocument/body/chapter/content/[EMAIL PROTECTED]"2_1"]'')' 'true&

Re: [GENERAL] XPath question - big trouble

2006-08-07 Thread Marian POPESCU
I wrote to say that there was nothing on output - which makes me think there is something wrong with XPath implementation. Anyway, is there a solution to my problems? Marian Csaba Nagy wrote: > [snip] >> >

Re: [GENERAL] XPath question - big trouble

2006-08-07 Thread Marian POPESCU
ce I make a fool of myself ;) Thank you for the replies and sorry for wasting your time! Csaba Nagy wrote: > Marian, > > On Mon, 2006-08-07 at 17:47, Marian POPESCU wrote: > >> SELECT >> xpath_nodeset(rawdata, '/mydocument/body/chapter/contents/paragraph') >

Re: [GENERAL] XPath question - big trouble

2006-08-07 Thread Marian POPESCU
You are right; I had a typo : contents is content Thanks for replying ... Guy Rouillier wrote: > Marian POPESCU wrote: >> There is also a weird thing: >> >> >> SELECT >> xpath_nodeset(rawdata, >> '/mydocument/body/chapter/contents/para

Re: [GENERAL] XPath question - big trouble

2006-08-07 Thread Marian POPESCU
Thank you! Since you brought up the subject, will this //[EMAIL PROTECTED] = "02"] be slower than /mydocument/body/chapter/contents/[EMAIL PROTECTED] >> = "02"] when handling a big document? I mean from the query time point of view ... Csaba Nagy wrote: &g

Re: [GENERAL] PostgreSQL 8.0.0 Beta 3 Uploaded

2004-10-01 Thread Marian POPESCU
Are there also SRPMs? I'm interested on Fedora Core 2 ones. I have rebuilt from SRPMs the Beta2 and it works OK - I only had to change the init script - the version provided was 7.4. Marian ---(end of broadcast)--- TIP 3: if posting/re

[GENERAL] PowerDesigner support?

2000-12-29 Thread Marian Simpetru
Can enyone make a plug-in (?) or something so Sybase's PowerDesigner can generate Postrgres SQL? tnx... Marian Simpetru

[GENERAL] How to list databases with SQL statement?

2004-11-22 Thread Marian D Marinov
Hello, Is there a way to list all databases which belong to the current user with an SQL query? Regards M.Marinov -- One Planet, One Internet. We Are All Connected. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL