[GENERAL] Postgres 9.0 Hiding CONTEXT string in Logs

CONTEXT: PL/Perl function "func_some_fun" Is there any way to suppress this as I don't really need it? Thanks Alex

Re: [GENERAL] Postgres 9.0 Hiding CONTEXT string in Logs

ever since upgrading to version 9.0 I also get this annoying string CONTEXT: PL/Perl function "func_some_fun" Is there any way to suppress this as I don't really need it? Thanks Alex

[GENERAL] pg_catalog.pg_stat_activity and current_query

Good morning, I'm trying to make a Postgre profiler reading pg_catalog.pg_stat_activity. But when I read that view... I always find my query. Example: ResultSet rs = st.executeQuery("SELECT query_start,current_query FROM pg_catalog.pg_stat_activity where xact_start is not null"); while(rs.next()

[GENERAL] postgresql install problem

It seems that I don't get the postgresql server installed or available for me to run in admin tools then services. postgresql is not listed as a service available to start or stop! Why do I not get the service installed and running? -- Sent via pgsql-general mailing list (pgsql-general@postgre

[GENERAL] Install issues

Using Windows 7 64 bit. Tried to install 8.4 and 9.0and it fails right near the end when it tries to create or read the conf file. If I transfer my postgres 8.4 file over the upgrade takes but the postgres service doesn't exist so no communication occurs. Is there anyway to just install the po

[GENERAL] Recursive select / updates

)*b3 + (a4-a2)*b2 + (a4-a1)*b1 i.e (7-6)*64 + (7-5)*34 + (7-3)*11 = 64+68+44=176 Has anyone a clever solution for that problem? Thanks for any suggestions. Alex

[GENERAL] Query to return every 1st Sat of a month between two dates

Hi,is there an easy way to return the date of every first Saturday of a month in a data range i.e. 2011-2013 Any help would be appreciated ThanksAlex

[GENERAL] PL/Perl Performance Problems

. Alex _ If It Exists, You'll Find it on SEEK Australia's #1 job site http://clk.atdmt.com/NMN/go/157639755/direct/01/

Re: [GENERAL] PL/Perl Performance Problems

rformance Problems > Date: Fri, 18 Dec 2009 15:25:16 -0500 > From: t...@sss.pgh.pa.us > > Alex - writes: > > Now here is what I noticed. > > a) if I run it in the morning, processing starts very slow, but after a few > > thousand records it will speed up

Re: [GENERAL] PL/Perl Performance Problems

Thank, I will check that out. > To: ainto...@hotmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] PL/Perl Performance Problems > Date: Fri, 18 Dec 2009 15:36:15 -0500 > From: t...@sss.pgh.pa.us > > Alex - writes: > > I actually looked at that to

Re: [GENERAL] PL/Perl Performance Problems

0 1238 6720 2611 352 15 1 75 10 0 > To: ainto...@hotmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] PL/Perl Performance Problems > Date: Fri, 18 Dec 2009 15:36:15 -0500 > From: t...@sss.pgh.pa.us > > Alex - writes: > > I actually looked

Re: [GENERAL] PL/Perl Performance Problems

rmance Problems > > Alex - wrote: > > > > Tom, I am logging these stats now, but i am having a similar issue. both > > jobs in the morning and after noon insert about 400k records (200k each) > > In the morning that job takes 450secIn the afternoon only 150; No sele

Re: [GENERAL] PL/Perl Performance Problems

Hmm...how can that be. This is happening every day, so its not a one off or happens once in the morning then in the afternoon. There is also no other task running on the system, its dedicated to postgres. Could the Autovacuum cause problems? Starting to invoke Analyze at the beginning of the da

Re: [GENERAL] PL/Perl Performance Problems

18 Dec 2009 23:45:07 -0700 > Subject: Re: [GENERAL] PL/Perl Performance Problems > From: scott.marl...@gmail.com > To: ainto...@hotmail.com > CC: t...@sss.pgh.pa.us; pgsql-general@postgresql.org > > On Fri, Dec 18, 2009 at 11:37 PM, Alex - wrote: > > Hmm... > > how can

Re: [GENERAL] PL/Perl Performance Problems

On a 2nd thought... where does the cach come into play when i only do inserts and no selects. Alex > Date: Fri, 18 Dec 2009 23:45:07 -0700 > Subject: Re: [GENERAL] PL/Perl Performance Problems > From: scott.marl...@gmail.com > To: ainto...@hotmail.com > CC: t...@sss.pgh.pa.us

Re: [GENERAL] PL/Perl Performance Problems

a query 3 Tables, 10-20M records >- inserts a record in Table B .. about 50K > 3. Returns some stats on the whole operation (100 records). > > On Sat, Dec 19, 2009 at 12:07 AM, Alex - wrote: > > On a 2nd thought... where does the cach come into play when i only do > >

Re: [GENERAL] PL/Perl Performance Problems

ugh these records about 50K in total >- for each runs a query 3 Tables, 10-20M records >- inserts a record in Table B .. about 50K > 3. Returns some stats on the whole operation (100 records). > > On Sat, Dec 19, 2009 at 12:07 AM, Alex - wrote: > > On a 2nd thought...

Re: [GENERAL] PL/Perl Performance Problems

s > Date: Sun, 20 Dec 2009 22:39:00 -0500 > From: t...@sss.pgh.pa.us > > Alex - writes: > > Tom, Scott, Alvaro,thanks for the hints on this issue. It looks as if one > > of the EOD maintenance jobs which does a few extensive queries does push > > data out of memory le

[GENERAL] Get Comments on Tables / Functions

Hi,i am adding comments to tables and functions with version information and would like to extract that information through a query. Is there and easy way to do that? simple list. table_name, comment ThanksAlex

[GENERAL] DB Link Question

help on that. Alex _ A world FIRST in property search has arrived! Check out Domain Radar NOW! http://clk.atdmt.com/NMN/go/157631292/direct/01/

[GENERAL] pl/perl setof function

Hi,i have a PL/PERL RETURN SETOF function which processes a few 10k records.The processing takes quite some time and in order to display progressI use a return_next after every few thousand records. However, the function returns all messages when it completes and exists which is not really what

[GENERAL] Slow Query / Check Point Segments

Hii am experience slow queries when i run some functions. I noticed the following entries in my server log. >From this, can anyone tell me if I need to change some config parmeters? System has 18GB Memoryshared_buffers = 4GB# min 128kBtemp_buffers = 32MB #

Re: [GENERAL] Slow Query / Check Point Segments

Greg,thanks for the suggestions, will try an test. You wrote: That just suggests that the system was mostly idle during that period. Thats actually not the case, it was just the time the function finished. Alex Date: Fri, 22 Jan 2010 01:21:59 -0500 From: g...@2ndquadrant.com To: ainto

[GENERAL] Alter Column from inet to inet[]

. Couldn't find anything in the manuals either. Can anyone point me in the right direction or tell me what's wrong with my statement. Thanks for any help. Alex

Re: [GENERAL] Full text index not being used

So this seems to be because the result size is too big. I still don't know why it is looping through every record and printing a warning, but adding a LIMIT makes the queries complete in a reasonable time (although not all that fast). However I need to sort and also have many other facets that ma

[GENERAL] Some Advice needed with historical data

key is Null, then no change has been logged yet. Is there an onther way to implement that? A) seems to be easier but how about the performance? Can A) be done with a simple view too ? Any suggestion is appreciated Thanks Alex ---(end of broadcast

[GENERAL] SQL Question

to retrieve the last 2 dates in record 100| 2005-04-01 | 2005-03-01 200| 2005-04-01 | 2005-03-01 Thanks Alex ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] SQL Question

Julian Scarfe wrote: From: "Alex" <[EMAIL PROTECTED]> - How can i select only the newest record for each ProdId ? 100| 2005-04-01 200| 2005-04-01 DISTINCT ON was made for this and on the similar tables I have performs rather more efficiently than using a subquery. se

[GENERAL] Help with a plperl function

t. (i know that bellow example does not require a function, just want to get a feel for it.) Thanks in advance for any tips. Alex DROP FUNCTION get_item (); DROP TYPE my_items; CREATE TYPE my_items AS ( item_id INTEGER, description TEXT, order_date DATE

[GENERAL] Help with plperl

Hi, could anyone help me with a problem I am having creating a plperl function. The return always complains with the following error: composite-returning Perl function must return reference to hash Thanks Alex CREATE TYPE sometype AS ( jid INTEGER, start_time TEXT

[GENERAL] Formatting TimeStamp

Hi, I am using the timestamp various tables but dont like to see the microseconds. Is there way to format the output of timestamp fields globally (in the postgres.conf)? Preferably i only would like to see the MMDD HH:MM:SS. Or can a formatting be passed to a SELECT * hmmm probably n

[GENERAL] Formatting TimeStamp

TIMESTAMP also a DATETIME type that returns |'-MM-DD HH:MM:SS'. So, I was wondering if there is anything similar in postgres or can i set the precision or format of the timestamp in the postgres.conf or can I define a new type. Alex | Joshua D. Drake wrote: Alex wrote: Hi,

[GENERAL] Function to test for Valid Date

Hi, is there a way to use postgres to check if a date provided is valid and would return true or false. Thanks Alex ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] Question on Insert / Update

to be to logical choice, but will it actually be faster and moreover is that the right way to do it? Thanks Alex ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to

Re: [GENERAL] Question on Insert / Update

Will give that a try. thanks. was actually interested if the 2nd approach is common practice or if there are some reasons not to do it that way. Alex Sean Davis wrote: On 11/9/05 9:45 AM, "Alex" <[EMAIL PROTECTED]> wrote: Hi, have just a general question... I hav

[GENERAL] TRUNCATE Question

Hi, could anyone tell me if it is necessary to run a Vacuum after truncating a table or is that done automatically. Thanks Alex ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] DBD::PgSPI 0.02

pens to scratch yours, more the merrier. -alex ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] [HACKERS] DBD::PgSPI 0.02

ard compatibility (to perl 5.4 for example) or not. Or whether I even care about backward compatibility. I'll remove it in next release, I suppose. -alex ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

[GENERAL] DB Slowing Down

are appreciated. Thanks Alex ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] What HW / OS is recommeded

with RAID1 ( mirroring ) I use Debian Sarge and im very happy. Perl is very slow, maybe you can use PHP ? Alex wrote: Hi, we are planning to upgrade our servers but deciding on the right configuration seems to be quite difficult. As for the system. About 50 tables, 20M records and growing about

Re: [GENERAL] What HW / OS is recommeded

The comment about HW vendor was regarding Raid configuration not the software. Geoffrey wrote: Alex wrote: Hmm... I read that Raid5 is suggested over Raid1. Also HW vendors told us that. Php :-) is not an option and I dont believe Perl is a bottleneck as well. Why would your HW vendor be

Re: [GENERAL] What HW / OS is recommeded

We use perl for the heavy batch jobs, the web interface is written using JSP / applets. If we would change these then it would be Java or C. But all the heavy stuff is handled by Stored Procedures so I dont see a real need for a change. I actually am more interested to hear if there are an rec

[GENERAL] Help needed with QueryPlan

uot;nval_price_hist_idx3" btree (price_id) "nval_price_hist_idx4" btree (sec_code, nval_price_date) Thanks Alex ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[GENERAL] What HW / OS is recommeded

Alex ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] Help needed with QueryPlan

Richard, thanks for the reply. I actually did what you suggested but still the same. Now i set ENABLE_SEQSCAN=false in the perl script which works but I dont think thats the way it shold be done. Alex Richard Huxton wrote: Alex wrote: Hi, I have a query that runs pretty slow and tried to use

Re: [GENERAL] DB Slowing Down

cleanup at the end of the month does not help a lot. it speeds things up but nowhere close to what it would be after recreating the db. Alex Richard Huxton wrote: Alex wrote: Hi, we have a database. not to big about 50 tables, 20m records. On a daily basis we update/insert/delete between 500k to

Re: [GENERAL] DB Slowing Down

Thanks for the suggestions. I run a vaccum analyze every night. I will look into all the options you suggested. Thanks Alex Richard Huxton wrote: Alex wrote: It a gradual process. For example, we have 3 reference tables that get updated very day. they have between 3,5 and 7M records. All we

[GENERAL] Unique Index

Hi, i have a unique index on a table over multiple columns. If now one of the records has a null value in one of the indexed columns i can insert the same record multiple times. Is this a problem within postgres or expected? Example: index unique, btree (colA, colB, colC); would still allow me t

Re: [GENERAL] Unique Index

I actually just wanted to know if there is a way around this problem. Obviously it is implemented that way for whatever reason. I still though think some arguments given in some of the replies, while probably correct, are besides the point. I use a unique index that may contain null values. On

[GENERAL] Help with COPY Error: invalid UTF-8 byte ....

entire copy job? Alex ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Delete Question

statement? Thanks for any advise Alex ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Delete Question

Thanks , this one works beautifully. Alex PS: also thanks to the other suggestions, have a look at this one hubert depesz lubaczewski wrote: On 12/7/05, *Alex* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: I have a table where I store changes made to an order. Th

[GENERAL] SELECT Question

a function but I wonder if there is an easier and faster way. Any suggestion or help would be appreciated. Thanks in advance Alex ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index

[GENERAL] PLPERL Function very Slow

function returns. Thanks for any advice. Alex ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] Slow Performance with 7.4.1

the time. The weird thing however is, that normal inserts seem to be much faster on the new system and I am wondering if it is Postgres or HW related. Does anyone has an advise ? Thanks Alex ---(end of broadcast)--- TIP 4: Don't 'ki

Re: [GENERAL] Slow Performance with 7.4.1

very slow, the screen almost freezes. Thanks Alex Doug McNaught wrote: Alex <[EMAIL PROTECTED]> writes: Hi, I just installed pg 7.4.1 on a new system P4, 3.2Gh HT, 1GB Mem, RH9 and discovered that some of the processes have become extremely slow. Mainly I am talking about a SELECT COUNT

Re: [GENERAL] Slow Performance with 7.4.1

Yup, DMA is not enabled, probably that is the problem. Tried to enable it but get an error HDIO_SET_DMA failed: Operation not permitted. Thanks for the hint. Alex Doug McNaught wrote: Alex <[EMAIL PROTECTED]> writes: The old system has a 80GB, 5200rpm ATA , the new system a 120GB, 7

Re: [GENERAL] SQL Exception Relation xxx does not exist

tomcat every night which is not a bad thing anyway but still am wondering what the real reason could be. Alex Kris Jurka wrote: On Tue, 20 Jan 2004, Alex wrote: Hi, I am getting the following error when running an update from a JAVA program using a Tomcat Connection Pool. SQLException: Error

[GENERAL] HELP with a Query

219' AND A.sec_code=123456 AND Z.ref_code=123456 LIMIT 10; Thanks for any help. Alex ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[GENERAL] Running multiple databases PG vs MySQL

Hi, what is the recommended way to run multiple databases under postgres. In MySQL it is rather simple to give different users or websites their own database with all the access rights. Any suggestion or links to documents are highly appreciated. Alex ---(end of

Re: [GENERAL] PG vs MySQL

topic here :-) Cheers Alex Frank Finner wrote: On Sun, 28 Mar 2004 14:24:15 +0900 Alex <[EMAIL PROTECTED]> sat down, thought long and then wrote: Hi, what is the recommended way to run multiple databases under postgres. In MySQL it is rather simple to give different users or websites thei

[GENERAL] plpgsql FOUND Variable

Hi, when I run a SELECT INTO and the result is 0 or zero row, then I still get a positive result if using IF FOUND THEN Is there a problem or do we need to use ROW_COUNT instead ? Alex ---(end of broadcast)--- TIP 3: if posting/reading

[GENERAL] plpgsql , dynamic queries

Hi, I am having problems in forming a dynamic query that can be used in Execute statements. Problem: I have database fields that are either INT or VARCHAR. Both can have NULL. If I use variables that hold the db field's values ... how do I need to quote them to pass them to the query string. e

Re: [GENERAL] plpgsql FOUND Variable

cuted in psql result = 0 rows. However I do get the return string "found" back. Alex Tom Lane wrote: Alex <[EMAIL PROTECTED]> writes: when I run a SELECT INTO and the result is 0 or zero row, then I still get a positive result if using IF FOUND THEN I recall Neil Con

[GENERAL] Question Join/Subselect

Hi, I have some problems with creating a query that will replace values in one table from another one. Table 1: userName : refCode1 : refCode2 -- alex : 12 : 24 Table 2: refCode : ActualCode - 12 AA 24 BB

[GENERAL] Date Time Function / Age

Hi, is there an easy way to get the Difference between 2 dates in Days... as an integer? age('date1','date2') results in x years y days or something similar. but I would like to have the result in number of days as an integer. Thanks for your help Alex --

Re: [GENERAL] Arrays and Indices / Foreign Keys

Joe, that is good news. When will be 7.4 availbable? Also, what i actually wanted is to ckeck that if lets say ARRAY[1,2,3] is inserted but 1,2 or 3 (the the entire array) is not present in the reference table. Will that be available too ? Alex Joe Conway wrote: Alex wrote: a) index array

[GENERAL] Fast Table Replication / Mirroring

appreciated. Alex ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [GENERAL] Quetions on Joins

Ron, the idea is to provide a table where users can define filters. But it this table may be as well empty. Alex Ron Johnson wrote: On Sun, 2003-08-31 at 11:56, Alex wrote: Hi, I have a query where I want to filter out records from table_a if a field in table_a matches in table table_b

[GENERAL] Prevent from Deletion

Hi, I have tables that have default records that must not be deleted or modified. Is there an easy way to do this. Like setting a trigger on the Primary key value ? Alex ---(end of broadcast)--- TIP 2: you can get off all lists at once with the

Re: [GENERAL] SELECT Question

Jeffrey, second solution is a beauty... thanks a lot. Alex Jeffrey Melloy wrote: If I'm understanding you correctly, you can do something like: select cola, colb, exists (select 'x' from tableb where co

[GENERAL] Cannot Delete

? Thanks Alex ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] PG_RESTORE/DUMP Question

postings on the net suggesting otherwise. Is there anything to pay attention too ? Thanks for any advise Alex ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] SELECT question

le 1100111 = SM--TFS. thanks for any suggestions Alex ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] Changes in Rel. 7.4

Hi, is there a document available describing the changes / additions in 7.4 ? Thanks Alex ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] Question on Select

Hi, I have two tables, Table A: item_id Table B: item_id, ref_code and i want to list all ref_codes in table B that are not referenced by Table A. Table A has about 3million records./ table B 200 What is the best way to do that ? Thanks Alex ---(end of broadcast

[GENERAL] Concatenation in SELECT

Hi, is it possible to concatenate two rows (same or different data type) into one. like First Name, Last Name or ZIP City etc. Thanks Alex ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] SELECT Question

All, thanks for the many suggestions Alex Manfred Koizar wrote: On Thu, 20 Nov 2003 16:52:37 +0900, Alex <[EMAIL PROTECTED]> wrote: Is there an easy way to write a select statement that returns me the frist free number or any within the range of 200? For example if 1-30, and 32-50 are oc

[GENERAL] PG_DUMP question

Hi, is ther a way to pass a password to the pg_dump command to avoid being prompted for it. I want to execute the dump from a perl or shell script and dont want to open accees for the user in the pg_hba.conf I tried PGUSER=userid PGPASSWD=passwd pg_dump -Fc -f dump.db mydb; Thanks Alex

[GENERAL] timestamp changed on 7.1.1 ?

imestamp with time zone. anyway, how can I make a timestamp data type be outputted without the time zone? I just want the so common "-MM-DD HH:MM:SS" format, not a "-MM-DD HH:MM:SS-time-stamp_offset" I expect to get this result *WITHOUT* rewritting existing queries. Any o

[GENERAL] Timestamp Format

a strict '-MM-DD HH:MM:SS' can postgresql do this at all (once again, without using functions or altering the query) Thanks in advance, Alex ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister comma

[GENERAL] Working with Array of Composite Type

-- 1 | 4 | (1,"This is Image A",f,f) 1 | 4 | (2,"This is Image B",f,f) 1 | 4 | (3,"This is Image C",f,t) 1 | 4 | (4,"This is Image D",t,f) Any help or suggestion on this topic is highly appreciated. Thanks Alex

[GENERAL] PostgreSQL HA config recommendations

could be greatly appreciated. Thanks for the assistance, Alex signature.asc Description: Message signed with OpenPGP using GPGMail

[GENERAL] PostgreSQL HA config recommendations

could be greatly appreciated. Thanks, Alex signature.asc Description: Message signed with OpenPGP using GPGMail

Re: [GENERAL] PostgreSQL HA config recommendations

significant enough to warrant looking into it. These are dedicated servers which means fill replication is not a problem. I will look into BDR. Seems like another advantage if we can do with 9.4. Thanks, Alex > On Apr 29, 2015, at 1:01 PM, William Dunn wrote: > > The streaming replicat

Re: [GENERAL] PostgreSQL HA config recommendations

<https://github.com/smbambling/PGSQL_HA_CLUSTER/wiki/Building-A-Highly-Available-Multi-Node-PostgreSQL-Cluster> Thanks, Alex > On Apr 29, 2015, at 2:50 PM, Alex Gregory wrote: > > Thank for for the valuable feedback everyone. Much appreciated. > > As I look at the Jabber in

Re: [GENERAL] PostgreSQL HA config recommendations

came across this matrix with some good information to go from: https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling#Features_in_the_Core_of_PostgreSQL Thanks, Alex > On Apr 30, 2015, at 6:03 PM, Fabio Ugo Venchiarutti wrote: > > Point taken. William

[GENERAL] Sorting CSV string and removing Duplicates

Hello, I have a csv string in a text field that is unsorted and contains duplicates. Is there a simple way to remove these and sort the string. E.g 2,18,20,23,1,27,1,2,8,16,17,18,20,22,23,27 i tried string to array and unique but that did not work... Any suggestions on how to do this without wri

Re: [GENERAL] Sorting CSV string and removing Duplicates

Hi Danish, yes thats the one I was looking for. Thanks a lot!!! On Tue, Jul 28, 2015 at 1:32 AM, dinesh kumar wrote: > > > On Mon, Jul 27, 2015 at 12:57 PM, dinesh kumar > wrote: > >> On Mon, Jul 27, 2015 at 12:53 PM, Alex Magnum >> wrote: >> >>> He

[GENERAL] PLPerl Trigger to update text search

ould help me out if that is actually possible? Thanks in advance Alex

Re: [GENERAL] PLPerl Trigger to update text search

On Fri, Jul 31, 2015 at 6:07 AM, Alex Magnum wrote: > Hi, > > I am trying to update a tsvector field through a plperl trigger. > > $_TD->{new}{text_search} = to_tsvector('pg_catalog.english', 'text1 > text2'); > > You need to wrap that into

Re: [GENERAL] PLPerl Trigger to update text search

On Fri, Jul 31, 2015 at 7:15 PM, Alex Hunsaker wrote: > > > > $_TD->{new}{text_search} = > spi_exec_query("to_tsvector('pg_catalog.english', ". quote_literal('text1 > text2') .";")->{rows}[0]{to_tsvector}; > > Err that

[GENERAL] Rounding Float Array

| 101.70037 (5 rows) Any suggestion is highly appreciated. Thanks Alex

[GENERAL] Inject rows into query resultes

results returned for the current page. Any one having an idea how to solve that? Thanks Alex

[GENERAL] Grant SELECT/Execute to View/Function but not underlying Table

on this Alex

[GENERAL] Left Join with Limit 1

Hello, I am trying to extract ip addresses from golite by joining two tables as posted below. Running the queries individually and using a limit on the golite ip db results are back immediately 1-2ms but when using the first query it takes 2-3 seconds. Is there a way to use a limit in the join?

[GENERAL] Creating Report for PieChart

Singapore |65 | 11.0 Thailand|57 | 9.7 Indonesia |26 | 4.4 France |15 | 2.6 United States |14 | 2.4 India |14 | 2.4 Others |95 | 16.1 Total | 588 | 100 Thanks a lot for any suggestions Alex

[GENERAL] pg_restore tells schema “test” already exists but it isn't actually

When restoring a dump like this: pg_restore --clean --create --exit-on-error --dbname=test test.tar these error messages got printed out: pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 21; 2615 80924 SCHEMA test test pg_restore: [archiver

[GENERAL]

Hello, I created a new database by create database icare; then quit off psql and run: pg_restore --clean --create --exit-on-error --dbname=icare icare-test.tar it complains: pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_re

Re: [GENERAL] Deleting a table file does not raise an error when the table is touched afterwards, why?

you fall it some issues with "file not exist" and other. Alex Ignatov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company

  1   2   3   4   5   6   7   >