Thanks, Jeff.
Now I am going back to my old question.
Even though *Session 2* fails to update with UPDATE 0 message, its txid is
saved in xmax of updated(by *Session 1*) tuple.
As it becomes an old txid, how come new txids are able to view it?
-
--
Thanks,
Rajan.
--
View this message in
Thanks for the explanation.
will I be able to view the information using this function,
SELECT * FROM heap_page_items(get_raw_page('testnumbers', 0));
Also, please let me know which column I should refer for viewing the
pointer.
-
--
Thanks,
Rajan.
--
View this message in cont
Thanks, Adrian. Able to install 10beta1 successfully.
-
--
Thanks,
Rajan.
--
View this message in context:
http://www.postgresql-archive.org/Need-help-on-compiling-postgres-source-code-from-cloned-repo-tp5969667p5969696.html
Sent from the PostgreSQL - general mailing list archive at
10beta --with-pgport=6432
--enable-integer-datetimes --enable-thread-safety --enable-debug
-> And then make and make install
Will the above steps work? Please assist.
-
--
Thanks,
Rajan.
--
View this message in context:
http://www.postgresql-archive.org/Need-help-on-compiling-postgres-so
ax as *Session
2's txid*.
-
--
Thanks,
Rajan.
--
View this message in context:
http://www.postgresql-archive.org/Re-have-trouble-understanding-xmin-and-xmax-with-update-operations-from-two-different-sessions-tp5969644p5969661.html
Sent from the PostgreSQL - general mailing list
visible in
Session 2, which is good.
2. but in *Session 3* (0,4) also carries xmax which means what? Is it also
marked for deletion? It can't be, right?
-
--
Thanks,
Rajan.
--
View this message in context:
http://www.postgresql-archive.org/Re-have-trouble-understanding-xmin-and-xmax-with-
3) | 519112 | 0 | 23
(0,4) | 519114 | 519115 | 24
(2 rows)
-----
--
Thanks,
Rajan.
--
View this message in context:
http://www.postgresql-archive.org/have-trouble-understanding-xmin-and-xmax-with-update-operations-from-two-different-sessions-tp5969629.html
Sent from the PostgreSQL -
thanks for the explanation, Gary.
-
--
Thanks,
Rajan.
--
View this message in context:
http://www.postgresql-archive.org/Unable-to-understand-index-only-scan-as-it-is-not-happening-for-one-table-while-it-happens-for-other-tp5968835p5968976.html
Sent from the PostgreSQL - general mailing
: 0.059 ms
(8 rows)
-
--
Thanks,
Rajan.
--
View this message in context:
http://www.postgresql-archive.org/Unable-to-understand-index-only-scan-as-it-is-not-happening-for-one-table-while-it-happens-for-other-tp5968835p5968971.html
Sent from the PostgreSQL - general mailing list archive at Nabble.c
hes: 0
Planning time: 0.096 ms
Execution time: 0.131 ms
(6 rows)
-
--
Thanks,
Rajan.
--
View this message in context:
http://www.postgresql-archive.org/Unable-to-understand-index-only-scan-as-it-is-not-happening-for-one-table-while-it-happens-for-other-tp5968835p5968844.html
Sent fr
anning time: 0.080 ms
Execution time: 0.050 ms
(7 rows)
-
--
Thanks,
Rajan.
--
View this message in context:
http://www.postgresql-archive.org/Unable-to-understand-index-only-scan-as-it-is-not-happening-for-one-table-while-it-happens-for-other-tp5968835.html
Sent from the PostgreSQL - g
postgres owns the function
Schema | public
Name| testuserfunction
Result data type| x
Argument data types |
Type| normal
Security| definer
Volatility | volatile
Owner | postgres
Language| plpgsql
S
The function is created as postgres user.
And I get a permission denied error.
--
View this message in context:
http://postgresql.nabble.com/Unable-to-select-a-table-as-postgres-user-tp5872036p5872055.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pg
Yes. I agree that the superuser cannot be restricted with any access.
But my scenarios is, I am executing a function(VOLATILE SECURITY DEFINER)
using the superuser and it function fails with unable to select a particular
table.
At the same time, I am able to select the table as a superuser, by ex
I have a database in which tables are created for each user when they create
an account. These auto generated tables are used for generating analytics
using a Function. This function is defined as a SECURITY DEFINER. So that
any user who tries to execute this function will be doing so as a Super
us
R(v_OldDivision,1,3);
v_Message := 'Changed Incident Division to ' || coalesce(v_Value,'')
|| ' from ' || coalesce(v_OldValue,'');
update OM_Incidents
set
Division = v_Division
where
IncidentId = v_IncidentId;
PERFORM om_ins_
ump >yourfunctions.sql
mentioned in
http://archives.postgresql.org/pgsql-general/2005-10/msg01633.php
I'll try this and your solutions as well
From: Raghavendra [mailto:raghavendra@enterprisedb.com]
Sent: Wednesday, February 15, 2012 11:05 AM
To: Rajan, Pavithra
Cc: pg
Hello all- Is there a way to just dump functions in a schema in to a
txt file/ sql file ? Thank you.
___
From: Timo Klecker [mailto:klec...@decoit.de]
Sent: Friday, March 26, 2010 10:51 AM
To: Rajan, Pavithra ; pgsql-general@postgresql.org
Subject: AW: [GENERAL] Need help on updating an entire column with a list of
values, I have.
Hello,
you could use an plpgsql function:
CREATE OR REPLA
Yes thanks -I am trying to figure writing out a script that will do the update
than doing individual inserts or update.I'll try this idea.
From: Timo Klecker [mailto:klec...@decoit.de]
Sent: Friday, March 26, 2010 10:51 AM
To: Rajan, Pavithra ; pgsql-ge
Hello ,
Yes -I need to get the exact the same result as you had listed.Thanks.
From: Timo Klecker [mailto:klec...@decoit.de]
Sent: Friday, March 26, 2010 10:12 AM
To: Rajan, Pavithra ; pgsql-general@postgresql.org
Subject: AW: [GENERAL] Need help on
Hello - I have this table with 90 rows, which contains 2 columns ,column
A (type 'numeric') and column B(type text) . Column 'A' is filled with a
constant number and column 'B' has an unique entry for each row.
E.g. A B
(numeric)(text)
ace(description,'4.8000','4.80') where
description like 'Volt%';
Hence I need to know all the tables and their column name ("data_type
:character varying") that has this 4 digit extn.
Thank you.
-Original Message-
From: John R Pierce [mailto:pie.
Hello - I would like to know if there is a way to find all the table
names in a data base that have a particular column value eg:"volt" .ie
given a column value (not column name) how to I find which tables and
their column names have them .Thank you.
Pavithra Rajan
<mailto:raj...@coned.com>
Title: Message
How to perform COPY from memory instead of
files?Any examples/pointers would be greatly appreciated.
Thanks in
advancedRajan
Hi all,
I need help in inserting a value from sequence. My
code goes like this (from Java). I do face a syntax
level problem.
statement.execute("insert into T_name (id) values (" +
nextval('s_name') + ")");
Thanks in advance for the help.
__
D
Hi all,
I need help in inserting a value from sequence. My
code goes like this (from Java). I do face a syntax
level problem.
statement.execute("insert into T_name (id) values (" +
nextval('s_name') + ")");
Thanks in advance for the help.
__
D
Hi all,
I created two tables with CIDR and inet data values
separately. I was not able to insert values into it.
When I tries to do
insert into ip values (10.20.30.40);
the error I get time and again is
'parser error at or near .30'
It always points to the third part of the IP (ie, 100
in c
Hi all,
If someone can tell me how to start with, connecting
java to postgresql. I suppose I'm right. But, I get
some errors.
import java.sql.*;
public class jd{
public static void main(String[]a rgs){
Class.forName("postgresql.Driver");
String url = "j
Hi all,
If someone can tell me how to start with, connecting
java to postgresql. I suppose I'm right. But, I get
some errors.
import java.sql.*;
public class jd{
public static void main(String[]a rgs){
Class.forName("postgresql.Driver");
String url = "j
Hi all,
If someone can tell me how to start with, connecting
java to postgresql. I suppose I'm right. But, I get
some errors.
import java.sql.*;
public class jd{
public static void main(String[]a rgs){
Class.forName("postgresql.Driver");
String url = "j
Hi,
I am using postgresql under linux. Now that I need to
build up the jdbc driver for postgresql, when I make
under the directory /src/interfaces/jdbc.. I get an
error stating '(u' unexpected syntax...
The version returned by the make is 1.0b4. The
makeVersion.java file returns jdbc0 as the
n
the last qn. so as to be interpreted the way you
meant it.
Thanks.
Soundar.
--- Kevin Heflin <[EMAIL PROTECTED]> wrote:
> On Fri, 15 Oct 1999, soundar rajan wrote:
>
> > hi,
> > Can anyone help me -- how to insert a date value
> into
> > a postgresql db
>
hi,
Can anyone help me -- how to insert a date value into
a postgresql db
Thanks in advance.
__
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com
34 matches
Mail list logo
