[GENERAL] upgrading tsearch2: how to call function in trigger

2011-12-06 Thread robert
Hi there, I am in the process of porting an application from V8.1 to 9.x Now I have the following situation: there is a function tsearch2: CREATE FUNCTION tsearch2() RETURNS "trigger" AS '$libdir/tsearch2', 'tsearch2' LANGUAGE c; a second function: CREATE FUNCTION dropatsymbols(text) RE

Re: [GENERAL] [pgadmin-support] Help for Migration

2011-12-06 Thread Mamatha_Kagathi_Chan
Hi Alban/Craig, Employeedetailinsert is procedure I have created in PostgreSQL. When I try to execute the procedure directly in Pgadmin as EXEC Employeedetailinsert (parameters same as below) It works fine with desired result. But When I call the procedure in Classic ASP I get the below error.

Re: [GENERAL] Installing different PostgreSQL versions in parallel

2011-12-06 Thread John R Pierce
On 12/06/11 10:37 PM, Rafael Ostertag wrote: > > its apparent to me from the /opt/csw prefix he mentions that he's > building PostgreSQL for the Blastwave/OpenCSW Solaris software > repositories, and HAS to put the libs in /opt/csw/lib due to project > policies. > Exactly. Thanks for cla

Re: [GENERAL] Installing different PostgreSQL versions in parallel

2011-12-06 Thread Rafael Ostertag
Hi John On Tue, Dec 06, 2011 at 08:35:58PM -0800, John R Pierce wrote: > On 12/06/11 8:30 PM, raghu ram wrote: > > > >I'm in the course of creating PostgreSQL packages for Solaris. One > >of the > >requirement is to install different PostgreSQL versions in > >parallel, the other > >

Re: [GENERAL] [BUGS] BUG #6325: Useless Index updates

2011-12-06 Thread Craig Ringer
On 06/12/11 22:51, Daniel Migowski wrote: > Continuing this talk on general, as requested by Craig. > > I have a functional Index on a table that is relative expensive to calculate. > Now I noticed on every update of even index-unrelated fields of the table the > index function is calculated agai

Re: [GENERAL] Installing different PostgreSQL versions in parallel

2011-12-06 Thread John R Pierce
On 12/06/11 8:30 PM, raghu ram wrote: I'm in the course of creating PostgreSQL packages for Solaris. One of the requirement is to install different PostgreSQL versions in parallel, the other is to have all the libraries stuffed in one place. Now, if I install, let's say,

Re: [GENERAL] psql query gets stuck indefinitely

2011-12-06 Thread tamanna madaan
Hi All Please help me . Thanks... Tamanna On Mon, Dec 5, 2011 at 12:45 PM, tamanna madaan < tamanna.mad...@globallogic.com> wrote: > Hi Tomas > > I tried it on the system having postgres-8.4.0 . And the behavior is same > . > > Cluster means a group of machines having postgres installed on all

Re: [GENERAL] Installing different PostgreSQL versions in parallel

2011-12-06 Thread raghu ram
On Tue, Dec 6, 2011 at 12:13 AM, Rafael Ostertag wrote: > Hi list > > I'm in the course of creating PostgreSQL packages for Solaris. One of the > requirement is to install different PostgreSQL versions in parallel, the > other > is to have all the libraries stuffed in one place. > > Now, if I ins

Re: [GENERAL] PostgreSQL DBA in SPAAAAAAAACE

2011-12-06 Thread Esmin Gracić
voted. good luck!

Re: [GENERAL] PostgreSQL DBA in SPAAAAAAAACE

2011-12-06 Thread Rob Sargent
On 12/06/2011 02:31 PM, Joe Miller wrote: > I've had a couple people mention that they hadn't received it, but > most people seem to be getting it no problem. I'll mention it to > RedGate. > > Thanks! > > On Tue, Dec 6, 2011 at 4:27 PM, Scott Marlowe wrote: >> On Tue, Dec 6, 2011 at 2:20 PM, Ro

Re: [GENERAL] PostgreSQL DBA in SPAAAAAAAACE

2011-12-06 Thread Larry Rosenman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/6/2011 3:27 PM, Scott Marlowe wrote: > On Tue, Dec 6, 2011 at 2:20 PM, Rob Sargent > wrote: >> >> >> >> On 12/06/2011 01:56 PM, Glyn Astill wrote: >>> __ >>> From: Merlin Moncure To: Joe Miller Cc: pgs

Re: [GENERAL] PostgreSQL DBA in SPAAAAAAAACE

2011-12-06 Thread Joe Miller
I've had a couple people mention that they hadn't received it, but most people seem to be getting it no problem. I'll mention it to RedGate. Thanks! On Tue, Dec 6, 2011 at 4:27 PM, Scott Marlowe wrote: > On Tue, Dec 6, 2011 at 2:20 PM, Rob Sargent wrote: >> >> >> >> On 12/06/2011 01:56 PM, Gly

Re: [GENERAL] PostgreSQL DBA in SPAAAAAAAACE

2011-12-06 Thread Scott Marlowe
On Tue, Dec 6, 2011 at 2:20 PM, Rob Sargent wrote: > > > > On 12/06/2011 01:56 PM, Glyn Astill wrote: >> __ >> >>> From: Merlin Moncure >>> To: Joe Miller >>> Cc: pgsql-general@postgresql.org >>> Sent: Tuesday, 6 December 2011, 17:30 >>> Subject: Re: [GENERAL] Postgre

Re: [GENERAL] PostgreSQL DBA in SPAAAAAAAACE

2011-12-06 Thread Rob Sargent
On 12/06/2011 01:56 PM, Glyn Astill wrote: > __ > >> From: Merlin Moncure >> To: Joe Miller >> Cc: pgsql-general@postgresql.org >> Sent: Tuesday, 6 December 2011, 17:30 >> Subject: Re: [GENERAL] PostgreSQL DBA in SPCE >> >> On Tue, Dec 6, 2011 at 10:56 AM,

Re: [GENERAL] PostgreSQL DBA in SPAAAAAAAACE

2011-12-06 Thread Glyn Astill
__ > From: Merlin Moncure >To: Joe Miller >Cc: pgsql-general@postgresql.org >Sent: Tuesday, 6 December 2011, 17:30 >Subject: Re: [GENERAL] PostgreSQL DBA in SPCE > >On Tue, Dec 6, 2011 at 10:56 AM, Joe Miller wrote: >> You may have seen this, but RedGate s

Re: [GENERAL] Foreign keys question (performance)

2011-12-06 Thread Adrian Klaver
On 12/06/2011 08:45 AM, Phoenix Kiula wrote: On Sun, Dec 4, 2011 at 7:41 PM, Phoenix Kiula wrote: On Sun, Dec 4, 2011 at 7:14 PM, Alban Hertroys wrote: On 4 Dec 2011, at 11:19, Phoenix Kiula wrote: I have a problem. Here's my table designs. The problem is that if Table 1 (stores) has a fo

Re: [GENERAL] PostgreSQL DBA in SPAAAAAAAACE

2011-12-06 Thread Bèrto ëd Sèra
+1 say hello to Laika, if she's still there :) Bèrto On 6 December 2011 20:33, Torello Querci wrote: > 2011/12/6 Merlin Moncure : > > On Tue, Dec 6, 2011 at 10:56 AM, Joe Miller > wrote: > >> You may have seen this, but RedGate software is sponsoring a contest > >> to send a DBA on a suborbita

Re: [GENERAL] PostgreSQL DBA in SPAAAAAAAACE

2011-12-06 Thread Torello Querci
2011/12/6 Merlin Moncure : > On Tue, Dec 6, 2011 at 10:56 AM, Joe Miller wrote: >> You may have seen this, but RedGate software is sponsoring a contest >> to send a DBA on a suborbital space flight. >> >> And there is a PostgreSQL representativeme! >> >> https://www.dbainspace.com/finalists/jo

Re: [GENERAL] PostgreSQL DBA in SPAAAAAAAACE

2011-12-06 Thread Merlin Moncure
On Tue, Dec 6, 2011 at 10:56 AM, Joe Miller wrote: > You may have seen this, but RedGate software is sponsoring a contest > to send a DBA on a suborbital space flight. > > And there is a PostgreSQL representativeme! > > https://www.dbainspace.com/finalists/joe-miller > > Voting is open for 7 d

Re: [GENERAL] Foreign keys question (performance)

2011-12-06 Thread David Johnston
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Phoenix Kiula Sent: Tuesday, December 06, 2011 11:46 AM To: Alban Hertroys Cc: PG-General Mailing List Subject: Re: [GENERAL] Foreign keys question (performance) On Sun, Dec

[GENERAL] PostgreSQL DBA in SPAAAAAAAACE

2011-12-06 Thread Joe Miller
You may have seen this, but RedGate software is sponsoring a contest to send a DBA on a suborbital space flight. And there is a PostgreSQL representativeme! https://www.dbainspace.com/finalists/joe-miller Voting is open for 7 days. Don't let one of those Oracle or SQL Server punks win :p J

Re: [GENERAL] Foreign keys question (performance)

2011-12-06 Thread Phoenix Kiula
On Sun, Dec 4, 2011 at 7:41 PM, Phoenix Kiula wrote: > On Sun, Dec 4, 2011 at 7:14 PM, Alban Hertroys wrote: >> On 4 Dec 2011, at 11:19, Phoenix Kiula wrote: > > >> >> INSERTs in the parent table don't need to check for any reference from the >> child table, since they're new; there can't b

Re: [GENERAL] [BUGS] BUG #6325: Useless Index updates

2011-12-06 Thread Gregg Jaskiewicz
btw, HOT was introduced in 8.3. On 6 December 2011 14:51, Daniel Migowski wrote: > > Continuing this talk on general, as requested by Craig. > > I have a functional Index on a table that is relative expensive to calculate. > Now I noticed on every update of even index-unrelated fields of the ta

Re: [GENERAL] [BUGS] BUG #6325: Useless Index updates

2011-12-06 Thread Daniel Migowski
Continuing this talk on general, as requested by Craig. I have a functional Index on a table that is relative expensive to calculate. Now I noticed on every update of even index-unrelated fields of the table the index function is calculated again and again. I currenly understand that if the u

Re: [GENERAL] How to retrieve rows with empty value in numeric(12,8) columns

2011-12-06 Thread Bèrto ëd Sèra
Hi, > As I understand it, your first query returned nothing because NULL is > simply "unknown" - and since you can never know what it's equal to, > looking for equality with NULL will never find anything. > Yes, you can basically think of NULLs in SQL as having the same role of zeros in division

Re: [GENERAL] How to retrieve rows with empty value in numeric(12,8) columns

2011-12-06 Thread Alban Hertroys
On 6 December 2011 12:00, Adarsh Sharma wrote: >> select * from table where lat IS NULL; > can you explain how it works or any link that explain the difference between > 2 queries. That's because of the 3-valued logic of SQL. x=NULL always evaluates to NULL, because it is unknown whether the t

Re: [GENERAL] How to retrieve rows with empty value in numeric(12,8) columns

2011-12-06 Thread Raymond O'Donnell
On 06/12/2011 11:00, Adarsh Sharma wrote: > try >> >> select * from table where lat IS NULL; >> >> Bèrto > :-) It works, Thanks a lot Berto ! > > can you explain how it works or any link that explain the difference > between 2 queries. As I understand it, your first query returned nothing because

Re: [GENERAL] How to retrieve rows with empty value in numeric(12,8) columns

2011-12-06 Thread Adarsh Sharma
try select * from table where lat IS NULL; Bèrto :-) It works, Thanks a lot Berto ! can you explain how it works or any link that explain the difference between 2 queries. Best regards Adarsh -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your su

Re: [GENERAL] How to retrieve rows with empty value in numeric(12,8) columns

2011-12-06 Thread Adarsh Sharma
select * from table where lat=NULL; Above query also returns 0 rows. Thanks Bèrto ëd Sèra wrote: Hi, haven't checked this personally, but first of all... what if they are simply stored as NULLs? Bèrto On 6 December 2011 13:39, Adarsh Sharma > wrote: D

[GENERAL] How to retrieve rows with empty value in numeric(12,8) columns

2011-12-06 Thread Adarsh Sharma
Dear all, I have a table with more than 10 million rows in a postgresql database. In the table two columns are of type numeric(12,8) and contains lat lon of the locations. But in more than thousand rows values are empty. Below is the snapshot of two rows :- *"1004364";"MM";"Pye";"ENG";"Town"

Re: [GENERAL] pg_standby: How to check in which state the server is currently?

2011-12-06 Thread Frank Lanitz
Am 05.12.2011 17:02, schrieb Cédric Villemain: > Le 5 décembre 2011 12:16, Frank Lanitz a écrit : >> Hi list, >> >> We had in past from time to time the issue, that the standby server is >> stopping recovering, creating a new timeline and become up and running. >> In parallel to check for the reas

Re: [GENERAL]

2011-12-06 Thread gouse shaik
http://transportequispe.sc36.info/gifts.php?mid=52&s=63&aqusa=397&ob=67 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general