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
---
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
>
>
> 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
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
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
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
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,
Can anyones suggest some readings about
implementing
sequences w/o holes ?
thanx in advance.
--'xpath_string(''rawdata'',''@objid'') = ''2_1'' '
--'xpath_bool(''rawdata'',''/mydocument/body/chapter/content/[EMAIL
PROTECTED]"2_1"]'')'
'true&
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]
>> >
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')
>
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
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
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
Can enyone make a plug-in (?) or something so Sybase's PowerDesigner can
generate Postrgres SQL?
tnx...
Marian Simpetru
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
16 matches
Mail list logo