Re: [GENERAL] invalid connection type listen_addresses='*'

/postgresql/9.1/main/pg_hba.conf 2014-07-10 16:34:39 EDT FATAL:  could not load pg_hba.conf Adam, listen_addresses='*' parameter doesn't belong in pg_hba.conf This parameter should be in postgresql.conf Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Getting cache lookup failed for aggregate error

answered by question. Thanks! So, instead of dropping aggregate “if exists” why not check pg_catalog for aggregate existence, and create it only if it does NOT exist? Regards, Igor Neyman

Re: [GENERAL] what does pg_activity mean when the database is stuck?

. B.t.w., PgBouncer can also disconnect idle client connections (if you really wish) based on configuration setting. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Re: Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account

be greatly appreciated. Thanks, John I missed the beginning of this thread. Is there a specific reason NOT to use local account for Postgres service? Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Re: Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of boca2608 Sent: Thursday, June 12, 2014 11:05 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Re: Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account Igor,  

Re: [GENERAL] Re: Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account

Server with a domain account After adding the domain user account into the local users group, the postgresql service can be started successfully now. We will do more testing to make sure that all postgresql functions are working. But I want to give my big thanks to Krystian Bigaj, Igor Neyman

Re: [GENERAL] what does pg_activity mean when the database is stuck?

://twitter.com/opentaps When you query pg_stat_activity, what do you see in state column, and how state_change compares to query_start? Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Need help on triggers - postgres 9.1.2

ON center FOR EACH ROW EXECUTE PROCEDURE check_center_changes(); Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Can't delete role because of unknown object

= 'jpate' AND C.relowner = O.oid; Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Lock problem

(in pg_stat_activity) what pid 9830 is doing, because looks like this session is holding other sessions. I don't see recursive lock in your query output. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Lock problem

session and compare their start_time to system time, and then based on your criteria you could kill suspect session/transaction. But this could be dangerous; some long-running transactions could be perfectly valid. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Unattended Installation

=%INSTALLOPTIONS% --serviceaccount postgres SET INSTALLOPTIONS=%INSTALLOPTIONS% --servicepassword pg_password123 In general, to diagnose (silent or not) installation problems find bitrock installer log somewhere under DocumentsandSettings for OS user that runs installation. Regards, Igor Neyman -- Sent

Re: [GENERAL] simple update query stuck

://www.OpenSourceStrategies.com LinkedIn: http://www.linkedin.com/in/opentaps Twitter: http://twitter.com/opentaps Both queries are waiting. Your table must be locked. Check pg_locks. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Complex query

ORDER BY clause to your SELECT statement. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Complex query

-Original Message- From: Leonardo M. Ramé [mailto:l.r...@griensu.com] Sent: Monday, March 31, 2014 2:56 PM To: Igor Neyman Cc: PostgreSql-general Subject: Re: [GENERAL] Complex query On 2014-03-31 18:48:58 +, Igor Neyman wrote: -Original Message- From: pgsql

Re: [GENERAL] getting the current query from pg_stat_activity

are not slightly different, there are two different major releases. Second, both are right. It's just that for IDLE processes (state column) 9.2 shows the last query executed before process became IDLE. 9.0 didn't have this ability. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Help with exclusion constraint

, it is a habit. - Aristotle For this: any given value of fk_col that there is a maximum of one row with bool_col = true. why don't you (instead) create partial unique index: CREATE UNIQUE INDEX on exclusion_example(fk_col, bool_col) WHERE bool_col IS TRUE; Regards, Igor Neyman -- Sent via pgsql

Re: [GENERAL] Increase in max_connections

connection pooler, it should help. The simplest to install and configure would be PgBouncer, and it does the job very well. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] excution time for plpgsql function and subfunction

/auto-explain.html Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Creating an index alters the results returned

. I'm not using jdbc, so can't commect on why this could happen. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] ERROR: out of memory DETAIL: Failed on request of size ???

,  the error doesn't say what kinda memory ran out. - You are testing with work_mem set to between 1GB and 40GB. You were asked to lower this setting. Even 1GB is too much, try something like work_mem=64MB. Regards, Igor Neyman

Re: [GENERAL] Re: changing port numbers so pgbouncer can read geoserver and postgres

to 127.0.0.1 in your hosts file under windows\system32\drivers\ets directory? If not, change your pgbouncer.ini config file to use IP address 127.0.0.1 instead of localhost in [database] section. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Explanantion on pgbouncer please

Again, this output indicates that pgbouncer is not connecting to postgres server. Regards, Igor Neyman On Thu, Oct 31, 2013 at 11:02 AM, si24 smrcoutt...@gmail.com wrote: I don't know if this will help in terms of my problem? this came from the admin pgbouncer console. pgbouncer=# show

Re: [GENERAL] Explanantion on pgbouncer please

or pool connections from PgBouncer to Postgres server. Second, you could learn a lot about status of your connections, when you connect as administrator to PgBouncer and use commands such as show pools, show clients, etc... Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Connection pooling

. PgBouncer works fine on Windows, and does pretty good job. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] I need more specific instructions for switching to digest mode for this list

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of Raymond O'Donnell Sent: Wednesday, October 09, 2013 11:54 AM To: Bob Futrelle Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] I need more specific

Re: [GENERAL] Query - CPU issue

, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to compare the results of two queries?

'; should work. Be aware, I didn't test it. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to compare the results of two queries?

-Original Message- From: Juan Daniel Santana Rodés [mailto:jdsant...@estudiantes.uci.cu] Sent: Tuesday, September 17, 2013 11:54 AM To: Igor Neyman Subject: Re: [GENERAL] How to compare the results of two queries? El 17/09/13 11:27, Igor Neyman escribió: create or replace

Re: [GENERAL] How to compare the results of two queries?

-Original Message- From: Juan Daniel Santana Rodés [mailto:jdsant...@estudiantes.uci.cu] Sent: Tuesday, September 17, 2013 12:51 PM To: Igor Neyman Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to compare the results of two queries? I want to know

Re: [GENERAL] How to compare the results of two queries?

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of Igor Neyman Sent: Tuesday, September 17, 2013 12:02 PM To: Juan Daniel Santana Rodés; pgsql-general@postgresql.org Subject: Re: [GENERAL] How to compare the results

Re: [GENERAL] Connect postgres to SQLSERVER

to Postgres through ODBC driver. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to compare the results of two queries?

-Original Message- From: Juan Daniel Santana Rodés [mailto:jdsant...@estudiantes.uci.cu] Sent: Tuesday, September 17, 2013 1:38 PM To: Igor Neyman Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to compare the results of two queries? El 17/09/13 12:56, Igor Neyman

Re: [GENERAL] Major upgrade of PostgreSQL and MySQL

. But the way, if users is using Windows, is the link option still works? Thanks, Patrick It definitely works. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Major upgrade of PostgreSQL and MySQL

considering that my whole upgrade process always starts with backing up existing cluster. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Major upgrade of PostgreSQL and MySQL

From: Patrick Dung [mailto:patrick_...@yahoo.com.hk] Sent: Friday, September 13, 2013 3:50 PM To: Igor Neyman; Stephen Frost Cc: pgsql-general@postgresql.org; Ivan Voras; Tom Lane Subject: Re: [GENERAL] Major upgrade of PostgreSQL and MySQL For Windows, is it using symbolic links or hard

Re: [GENERAL] Is there any method to limit resource usage in PG?

with client for a few times till all the data is transferred? Best Regards    No, PG does not have feature similar to Oracle's Resource Manager. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] system catalog to check if auto vacuum is disabled for a particular table

. If autovacuum was disabled one of the elements of the array will be: 'autovacuum_enabled=false'. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Self referencing composite datatype

cannot be made a member of itself SQL state: 42P16 Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Different transaction log for database/schema

, and those are per database, not per schema. On the other hand, MS SQL Server has Transaction Logs, and they are per database. Still, I don't quite understand, what goal original poster is trying to achieve. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] installer woes, 9.1 on windows 2008 R2

12:49 PM, Igor Neyman wrote: Look for bitrock_installer.log in the \Users\account_you_are_using\AppData\Local\Temp. Or just do search for bitrock_installer.log file. ahhh. two weirdnesses below... A) why is it using 'myusername' (the account I ran the installer from) instead

Re: [GENERAL] installer woes, 9.1 on windows 2008 R2

it started) -- john r pierce 37N 122W somewhere on the middle of the left coast Look for bitrock_installer.log in the \Users\account_you_are_using\AppData\Local\Temp. Or just do search for bitrock_installer.log file. Igor Neyman -- Sent via pgsql-general

Re: [GENERAL] pg_upgrade link mode

. However, I'd suggest to try the  --check at first of pg_upgrade. -- Why? Do you have specific experience, when link mode caused any problems? Could you share? Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] pg_upgrade link mode

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of Lonni J Friedman Sent: Thursday, May 16, 2013 2:23 PM To: Igor Neyman Cc: AI Rumman; Fabio Rueda Carrascosa; pgsql-general Subject: Re: [GENERAL] pg_upgrade link

Re: [GENERAL] Running out of memory on vacuum

vacuum and autovacuum running at the same time, each requesting 2GB (your current setting). 3. Use connection pooling software (e.g. PgBouncer) and reduce max_connections. Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Running out of memory on vacuum

-Original Message- From: Ioana Danes [mailto:ioanasoftw...@yahoo.ca] Sent: Tuesday, May 14, 2013 10:30 AM To: Igor Neyman; PostgreSQL General Subject: Re: [GENERAL] Running out of memory on vacuum Hi Igor, 1. I could remove the nightly vacuum but I think

Re: [GENERAL] Running out of memory on vacuum

-Original Message- From: Ioana Danes [mailto:ioanasoftw...@yahoo.ca] Sent: Tuesday, May 14, 2013 11:29 AM To: Igor Neyman; PostgreSQL General Subject: Re: [GENERAL] Running out of memory on vacuum Hi Igor, I don't need the manual vacuum. I just don't want to remove it now

Re: [GENERAL] Update from select

the case: UPDATE tbl1 t1 SET col3 = t2.col3, col4 = t2.col4, col5 = t2.col5 FROM tbl2 t2 WHERE t1.col1 = t2.col1 AND t.col1 = criteria; Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] pg_upgrade fails, mismatch of relation OID - 9.1.9 to 9.2.4

out what relation it belongs to? Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_upgrade fails, mismatch of relation OID - 9.1.9 to 9.2.4

-Original Message- From: Evan D. Hoffman [mailto:evandhoff...@gmail.com] Sent: Wednesday, May 08, 2013 3:35 PM To: Igor Neyman Subject: Re: [GENERAL] pg_upgrade fails, mismatch of relation OID - 9.1.9 to 9.2.4 Looks like it IS the same OID every time, referencing an index. I

Re: [GENERAL] pg_upgrade fails, mismatch of relation OID - 9.1.9 to 9.2.4

-Original Message- From: Evan D. Hoffman [mailto:evandhoff...@gmail.com] Sent: Wednesday, May 08, 2013 4:22 PM To: Igor Neyman Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_upgrade fails, mismatch of relation OID - 9.1.9 to 9.2.4 Well, each time it fails it refers

Re: [GENERAL] How to INSERT INTO one table from another table, WHERE

for column name, being a data type it's on the list of reserved words. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Windows query weird result

. The only way I know is to execute SELECT on the table that will cause full index scan. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Windows query weird result

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of Igor Neyman Sent: Tuesday, April 30, 2013 9:30 AM To: Lutz Fischer; pgsql-general@postgresql.org Cc: Aaron Abreu Subject: Re: [GENERAL] Windows query weird result

Re: [GENERAL] Windows query weird result

the problem. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_restore from split files

How exactly did you create split dump? Igor Neyman From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of akp geek Sent: Monday, April 22, 2013 3:36 PM To: pgsql-general Subject: [GENERAL] pg_restore from split files Hi All - I have created

Re: [GENERAL] pg_restore from split files

I don't think pg_restore is able to deal with your split files. What was the reasoning for doing this? Did you try first on smaller table/files to see if your dump/split/restore procedure would work? Igor Neyman From: akp geek [mailto:akpg...@gmail.com] Sent: Monday, April 22, 2013 3:47 PM

Re: [GENERAL] Can you spot the difference?

) could have bad statistics as well. That could cause different execution plans. Regards, Igor Neyman From: Moshe Jacobson [mailto:mo...@neadwerx.com] Sent: Tuesday, April 16, 2013 3:07 PM To: pgsql-general Subject: Can you spot the difference? Hi PostgreSQL friends, I have two databases in the same

Re: [GENERAL] PostgreSQL Backup Booklet

__ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email Shaun, Is there plans for e-book edition? Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] PostgreSQL Backup Booklet

-Original Message- From: Shaun Thomas [mailto:stho...@optionshouse.com] Sent: Wednesday, April 03, 2013 1:51 PM To: Igor Neyman Cc: PostgreSQL General Subject: Re: PostgreSQL Backup Booklet On 04/03/2013 12:49 PM, Igor Neyman wrote: Is there plans for e-book edition? I

Re: [GENERAL] configuring timezone

Terence, Thank you for the offer. But, I will probably be creating custom install scripts to run at destination location to modify parameter in Postgresql.conf. Regards, Igor Neyman From: Terence Ferraro [mailto:terencejferr...@gmail.com] Sent: Wednesday, February 06, 2013 6:47 PM To: Igor

[GENERAL] configuring timezone

), and then moved to other (not known during system build) location with different timezone. After relocation, OS timezone will change, but we can't allow user to edit timezone parameter in Postgresql.conf. Regards, Igor Neyman

Re: [GENERAL] configuring timezone

Terence, Thanks for quick reply, I read your thread (Dec, 2012) before posting my question. But, recompile is not an option for me. Was hoping, that something regarding this issue changed since... Igor Neyman From: Terence Ferraro [mailto:terencejferr...@gmail.com] Sent: Wednesday, February

Re: [GENERAL] configuring timezone

I am on Windows (both 32 and 64 bit) using 32-bit Postgres. So, your binaries are for 9.2.1, you aren't planning to go to 9.2.2? From: Terence Ferraro [mailto:terencejferr...@gmail.com] Sent: Wednesday, February 06, 2013 3:07 PM To: Igor Neyman Cc: pgsql-general@postgresql.org Subject: Re

Re: [GENERAL] configuring timezone

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Wednesday, February 06, 2013 4:40 PM To: Igor Neyman Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] configuring timezone On 02/06/2013 10:32 AM, Igor Neyman wrote: Timezone configuration

Re: [GENERAL] configuring timezone

Thank you for explaining. Regards, Igor Neyman From: Tom Lane [t...@sss.pgh.pa.us] Sent: Wednesday, February 06, 2013 5:11 PM To: Igor Neyman Cc: Adrian Klaver; pgsql-general@postgresql.org Subject: Re: [GENERAL] configuring timezone Igor Neyman iney

Re: [GENERAL] speeding up a join query that utilizes a view

Yes, my mistake, I meant to ask about fifteen_min_stacked_view definition, and Postgres parameters from postgresql.conf configuration file, at least those - modified from default setting and related to resource consumption and query tuning. Regards, Igor Neyman -Original Message

Re: [GENERAL] speeding up a join query that utilizes a view

Kirk, Are you doing un-pivoting in most of your queries? Did you try normalized design for fifteen_minute table? Is there specific reason for de-normalization? Regards, Igor Neyman -Original Message- From: Kirk Wythers [mailto:kwyth...@umn.edu] Sent: Friday, January 18, 2013 10:50 AM

Re: [GENERAL] speeding up a join query that utilizes a view

on fifteen_min (cost=0.00..525136.58 rows=1798711 width=1072) (actual time=0.034..96077.588 rows=428093218 loops=1) Shows to big of a difference between estimated and actual row counts. Are these tables analyzed often enough? Regards, Igor Neyman -Original Message- From: Kirk Wythers

Re: [GENERAL] speeding up a join query that utilizes a view

, and data_key? View definition for fifteen_min_stacked_view? Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] speeding up a join query that utilizes a view

What about index definition, Postgres version, config parameters? Hardware configuration would be helpful too. -Original Message- From: Kirk Wythers [mailto:kwyth...@umn.edu] Sent: Thursday, January 17, 2013 3:59 PM To: Igor Neyman Cc: Kirk Wythers; pgsql-general@postgresql.org

Re: [GENERAL] Large number of rows in pg_type and slow gui (pgadmin) refresh

are not the types Robert created explicitly. There must be lots of tables/views (m.b. lots of partitions) in the database. Every table/view adds couple records to pg_type: one type for table/view record and one type the set (array) of table/view records. Regards, Igor Neyman -- Sent via pgsql

Re: [GENERAL] unlooged tables

-Original Message- From: Sergey Konoplev [mailto:gray...@gmail.com] Sent: Thursday, December 06, 2012 4:52 PM To: Igor Neyman Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] unlooged tables Hi, On Thu, Dec 6, 2012 at 7:08 AM, Igor Neyman iney...@perceptron.com wrote

[GENERAL] unlooged tables

Hello, Is there any way to change regular table to unlogged without dropping said table and recreating it as unlogged? Didn't find the answer in the docs. Looks like alter table ... does not support unlogged. TIA, Igor Neyman

Re: [GENERAL] pg_listening_channels()

the client that LISTENs and gets notifications. Also, what sense pg_listening_channels() function makes, if it returns channels that I created (in my current session/connection)? I don't need this function to know whether I issued LISTEN my_channel or not. Regards, Igor Neyman -- Sent via

Re: [GENERAL] pg_listening_channels()

-Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Wednesday, November 28, 2012 6:13 PM To: Igor Neyman Cc: Greg Sabino Mullane; pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_listening_channels() Igor Neyman iney...@perceptron.com writes: With PG 9.0

Re: [GENERAL] set value var via execute

1'; do this: execute 'select id from '||v_table||' order by random() limit 1' INTO v_holder; Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] When does CLUSTER occur?

physically. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_listening_channels()

From: Greg Sabino Mullane [g...@turnstep.com] Sent: Wednesday, November 28, 2012 10:26 AM To: pgsql-general@postgresql.org Subject: Re: pg_listening_channels() -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Igor Neyman asked: [Postgres 9.2] How

[GENERAL] pg_listening_channels()

relname = listener_name. Not any more, the table doesn't exist in newer versions. Regards, Igor Neyman

Re: [GENERAL] How to verify pg_dump files

to check whether the output file is valid in the sense that it is complete and syntactically correct? -- GaryPlease do NOT send me 'courtesy' replies off-list. The only 100% fool-proof test would be to restore from your backup files. Regards, Igor Neyman -- Sent via pgsql-general

Re: [GENERAL] Postgres will not start due to corrupt index

. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgres will not start due to corrupt index

-Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Wednesday, October 03, 2012 2:47 PM To: Igor Neyman Cc: Robert Sosinski; Merlin Moncure; pgsql-general@postgresql.org; Spike Grobstein Subject: Re: [GENERAL] Postgres will not start due to corrupt index Igor

Re: [GENERAL] Running CREATE only on certain Postgres versions

-Original Message- From: Daniele Varrazzo [mailto:daniele.varra...@gmail.com] Sent: Tuesday, September 25, 2012 11:26 AM To: Adrian Klaver Cc: David Johnston; Robert James; Igor Neyman; Postgres General Subject: Re: [GENERAL] Running CREATE only on certain Postgres versions On Tue

Re: [GENERAL] Running CREATE only on certain Postgres versions

compatible? For instance, how can I tell it to check the version, and only run if 8.3 or lower? Or another way to make it cross-version? Find your PG version with: SELECT version(); and continue accordingly... Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Best free tool for relationship extraction

original recursive query. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] information_schema.referential_constraints broken?

to add explicit type casts. Context: SQL function _pg_keysequal during inlining I don't have more recent 8.4 releases to try it on. It works fine on PG 9.1.3. Did anyone else experienced this problem? Regards, Igor Neyman

Re: [GENERAL] information_schema.referential_constraints broken?

information_schema.referential_constraints; against information_schema.referential_constraints work without errors. Sorry, for the noise. Igor Neyman From: Igor Neyman Sent: Friday, July 27, 2012 9:27 AM To: pgsql-general@postgresql.org Subject: information_schema.referential_constraints broken? This query: select * from

Re: [GENERAL] TYPE TABLE OF NUMBER

or _int2 (or whatever integer length you need). No need to create new type. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Stability in Windows?

. For last 5 years we are running PG on many, many (hundreds) servers under WIN, and we have no complains regarding PG stability. Regards, Igor Neyman From: Serge Fonville [mailto:serge.fonvi...@gmail.com] Sent: Friday, February 24, 2012 11:07 AM To: mgo...@isstrucksoftware.net Cc

Re: [GENERAL] Vacuum and Large Objects

-Original Message- From: Stefan Keller [mailto:sfkel...@gmail.com] Sent: Friday, January 06, 2012 1:12 AM To: Igor Neyman Cc: Simon Windsor; pgsql-general@postgresql.org Subject: Re: Vacuum and Large Objects Hi Igor 2011/12/16 Igor Neyman iney...@perceptron.com wrote:  But I

Re: [GENERAL] Vacuum and Large Objects

Stefan, -Original Message- From: Stefan Keller [mailto:sfkel...@gmail.com] Sent: Friday, January 06, 2012 1:12 AM To: Igor Neyman Cc: Simon Windsor; pgsql-general@postgresql.org Subject: Re: Vacuum and Large Objects Hi Igor 2011/12/16 Igor Neyman iney...@perceptron.com wrote

Re: [GENERAL] Vacuum and Large Objects

in this discussion. But I think, your problem is right here: running VACUUM FULL pg_largeobject If you are running VACUUM FULL ... on the table, you should follow it with the REINDEX TABLE ..., at least on PG versions prior to 9.0. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Rules going away

-Original Message- From: Gregg Jaskiewicz [mailto:gryz...@gmail.com] Sent: Friday, September 30, 2011 5:18 AM To: Igor Neyman Cc: Ondrej Ivanič; pgsql-general@postgresql.org Subject: Re: [GENERAL] Rules going away speaking of DO INSTEAD, for insert/update case. Try using RETURNING

Re: [GENERAL] Rules going away

they are, they definitely have their use when properly implemented with specific purpose. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgresql problem with update double precision

? -- Regards, Condor double precision is imprecise data type, that's why you see what you see. If you want to avoid your problem, switch to NUMERIC(precision, scale), which is precise data type. Alter the type of your double columns. Regards, Igor Neyman -- Sent via pgsql-general mailing list

Re: [GENERAL] query to get the list of key (reserverd) words?

://people.collaborativefusion.com/~wmoran/ Use pg_get_keywords(OUT word text, OUT catcode char, OUT catdesc text) Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Constraint to ensure value does NOT exist in another table?

.Key, however what if I want to do the reverse? I want to ensure Table1.ColA does NOT exist in Table2.Key.. Can I do this with any sort of CHECK constraint, trigger, custom function, etc? Thanks! Mike Trigger (with corresponding trigger function) will definitely do the job. Regards, Igor

Re: [GENERAL] Rearranging simple where clauses

than one index based on the column in question? - Which one optimizer is supposed to satisfy by rearranging where clause? Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] A join of 2 tables with sum(column) 30

, sum(col1) from tab Where id 10 Group by id Having sum)col1) 30; Spend some time reading basic SQL docs/books - it'll help you tremendously. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

<    1   2   3   >