[GENERAL] Re: have trouble understanding xmin and xmax with update operations from two different sessions

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

[GENERAL] Re: have trouble understanding xmin and xmax with update operations from two different sessions

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 context: http

Re: [GENERAL] Need help on compiling postgres source code from cloned repo

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

[GENERAL] Need help on compiling postgres source code from cloned repo

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

[GENERAL] Re: have trouble understanding xmin and xmax with update operations from two different sessions

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 archive

[GENERAL] Re: have trouble understanding xmin and xmax with update operations from two different sessions

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-updat

[GENERAL] have trouble understanding xmin and xmax with update operations from two different sessions

| 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 - general mailing list

[GENERAL] Re: Unable to understand index only scan as it is not happening for one table while it happens for other

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

[GENERAL] Re: Unable to understand index only scan as it is not happening for one table while it happens for other

: 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

[GENERAL] Re: Unable to understand index only scan as it is not happening for one table while it happens for other

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 Sen

[GENERAL] Unable to understand index only scan as it is not happening for one table while it happens for other

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

Re: [GENERAL] Unable to select a table as postgres user

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

Re: [GENERAL] Unable to select a table as postgres user

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

Re: [GENERAL] Unable to select a table as postgres user

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

[GENERAL] Unable to select a table as postgres user

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

[GENERAL] Dump functions alone

Hello all- Is there a way to just dump functions in a schema in to a txt file/ sql file ? Thank you.

Re: [GENERAL] Dump functions alone

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: pgsql-general

Re: [GENERAL] Dump functions alone

$ LANGUAGE plpgsql VOLATILE COST 100; ALTER FUNCTION oms.om_change_i_division(integer, text, text) OWNER TO oru; From: Raghavendra [mailto:raghavendra@enterprisedb.com] Sent: Wednesday, February 15, 2012 11:05 AM To: Rajan, Pavithra Cc: pgsql-general@postgresql.org Subject: Re

[GENERAL] Need help on updating an entire column with a list of values, I have.

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)

Re: [GENERAL] Need help on updating an entire column with a list of values, I have.

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

Re: [GENERAL] Need help on updating an entire column with a list of values, I have.

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-general

Re: [GENERAL] Need help on updating an entire column with a list of values, I have.

...@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 REPLACE FUNCTION update(numeric[]) RETURNS

Re: [GENERAL] How to get a list of tables that have a particular column value?

') 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...@hogranch.com] Sent: Wednesday, December 23, 2009 3:11 PM To: Rajan

[GENERAL] How to get a list of tables that have a particular column value?

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

[GENERAL] Performing COPY Command

Title: Message How to perform COPY from memory instead of files?Any examples/pointers would be greatly appreciated. Thanks in advancedRajan

[GENERAL] how to insert from sequence

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

[GENERAL] how to insert from sequence

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

[GENERAL] cidr and inet

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

[GENERAL] jdbc small example

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 =

[GENERAL] how to insert a date

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

Re: [GENERAL] how to insert a date

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 assuming the data type is of the 'date' type

[GENERAL] jdbc problem

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