ansaction command it throwing the runtime error
as
" ERROR: SPI_execute_plan failed
executing query "commit": SPI_ERROR_TRANSACTION ";
Can any one send me an example of how to
use the start transaction or how to commit an nested transaction.
Thanks in advance.
Thanks & Regards,
Sri
es or any
thing
end;
:
:
end;
It seems that all the statements between begin and end are treated as one
transaction while execution.
Thanks & Regards,
Sri
- Original Message -
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
To: "Sri" <[EMAIL PROTECTED]>
Cc:
Hello,
I am using a foreign data wrapper where i get a portion of my data
pre-loaded , i.e I get a set of rows before hand . So now i want to run
multiple update queries on this loaded data , write the changes to file ,
load the next set and continue with updates again.
How should i try
Hi,
In PostgreSQL , does the order in which the criteria is given matter ??
For example
Query 1 : Select * from TABLE where a > 5 and b < 10;
Query 2 : Select * from TABLE where b <10 and a > 5;
Are query 1 and query 2 the same in PostgreSQL or different ?? If its
different , WHY ??
Than
Hi,
Is it possible to use threads in Postgresql ?? I am using threads in my
foreign data wrapper and i get the following error when i use the threads .
*ERROR: stack depth limit exceeded*
*HINT: Increase the configuration parameter "max_stack_depth" (currently
2048kB), after ensuring the pla
Hi,
I have the raw fields of a particular row in char * . Now my requirement
is to convert these value into datum * . How should i go about this ? Does
converting into datum depends on the type of the field too ?
-- Harsha
Hi,
Is it possible to implement TRUNCATE and CREATE TABLE LIKE for a foreign
table. Is there anyway i can write a function to implement those queries in
my FDW ??
Thanks,
Harsha
Hi,
I have a few doubts regarding table locks. Assume I am executing the
following query
Query 1 -- INSERT INTO FOREIGN_TABLE SELECT * FROM POSTGRES_TABLE
Query 2 -- INSERT INTO FOREIGN_TABLE SELECT * FROM FOREIGN_TABLE
If i get a table lock for the foreign table , will the second table from
Hi John.
What if my query was INSERT INTO Postgres_Table_A SELECT * FROM
Postgres_Table_B ?? What are the locks given for the two tables ??
--Harsha
On Fri, Jan 16, 2015 at 10:50 AM, John R Pierce wrote:
> On 1/15/2015 9:14 PM, sri harsha wrote:
>
>> What kind of lock wil
Hi,
Is there any way to stop concurrent inserts to happen on a single table
??
Query 1 : INSERT INTO TABLE_A SELECT * FROM TABLE1;
Query 2 : INSERT INTO TABLE_A SELECT * FROM TABLE2;
Query 3 : SELECT * FROM TABLE_A;
Assume i have the above queries. Query 1 and Query 3 can occur concurrently
.
, Albe Laurenz
wrote:
> sri harsha wrote:
> >Is there any way to stop concurrent inserts to happen on a single
> table ??
> >
> > Query 1 : INSERT INTO TABLE_A SELECT * FROM TABLE1;
> > Query 2 : INSERT INTO TABLE_A SELECT * FROM TABLE2;
> > Query 3 : SELECT *
Hi,
I want to know about the flow in which delete query is executed in
postgres .
Assume i have a following query.
*Delete from table_a * where column_a = 'something'*
How is this query executed ? Are the rows first filtered out and then
deleted one by one ?? Or is the row deleted as and whe
In message <[EMAIL PROTECTED]>you write:
>
>This is now in the doc directory as README.NT.
>
>
>[Charset iso-8859-1 unsupported, filtering to ASCII...]
>> These are the steps I used to compile and run PostgreSQL on Windows NT.
>> Notice that I have not verfied it after 24-3-99. In the coming week
In message <[EMAIL PROTECTED]>yo
u write:
>Hello,
>
>My company is pretty impressed with postgre on unix, but we also need a
>native port for nt (it is not an option to have our customers install cygwin
>on their production systems.) Ideally we would like to see the backend
>running as a native s
In message <[EMAIL PROTECTED]>you write:
>Hello folks,
>
>I'm running 6.5.1 on NT. I think I've applied all the patches to the
>ipc-daaemon, but after a while it starts hogging the CPU, even when no
>queries of any sort are being made (although there is a postmaster present).
>Reducing the priori
In message <[EMAIL PROTECTED]>you write:
>> Bruce,
>>
>> As I am not going to be able to help on the coding I won't try to
>> comment on it's dificulty.
>>
>> But I will ask what realistic expectations are for the current NT port
>> using cgywin. My current concern is that the installation is ve
In message <[EMAIL PROTECTED]>you write:
>
>Call this script postmasterangel.sh (as in guardian angel) and run it
>instead of the postmaster. Change the postmaster line in here to be
>your postmaster boot configuration options.
>
>
>This runs under linux. It will probably work under most un*x
>fla
In message <[EMAIL PROTECTED]>you write:
>
>Bruce Momjian writes:
> >
> > We run on NT now.
> >
>
>
>Has anyone tried running it as an NT service with the SRVANY.EXE
>program?
>
>
>--
>===
> Life is short. | Cr
In message <[EMAIL PROTECTED]>you write:
>>
>> Is this a standard (official) NT build that I can download from somewhere
>> or have you done your own conversion?
>
>It is part of the distribution. Get the tarball, and read the README.NT
>file on the web site or in the doc directory. We should
19 matches
Mail list logo
