replication_slots
WHERE slot_name = '';
provides a measure in Logical Replication environment of how far did (or did
not) Subscriber fell behind Publisher, and hence some kind of measure of how
much "extra" WALs is stored on the Publisher.
Regards,
Igor Neyman
--
Sent
I wonder, does plpgsql compilation check for existence of the add_job_history
function or is that a runtime check?
At runtime.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your su
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Igor Neyman
Sent: Friday, June 02, 2017 9:45 AM
To: PAWAN SHARMA ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.
Attention: This email was
OLD.hire_date, LOCALTIMESTAMP,
OLD.job_id, OLD.department_id);
RETURN NEW;
END
$BODY$
LANGUAGE 'plpgsql';
Regards,
Igor Neyman
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Thursday, May 25, 2017 3:13 PM
To: Igor Neyman ; George Neuner ;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/25/2017 11:09 AM, Igor Neyman wrote
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, May 24, 2017 7:06 PM
To: Igor Neyman ; George Neuner ;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/24/2017 08:30 AM, Igor Neyman wrote
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, May 24, 2017 10:00 AM
To: Igor Neyman ; George Neuner ;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/24/2017 06:31 AM, Igor Neyman wrote
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, May 23, 2017 7:42 PM
To: Igor Neyman ; George Neuner ;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
So take the local line out of pg_hba. Then from the
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, May 23, 2017 5:48 PM
To: Igor Neyman ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/23/2017 08:15 AM, Igor Neyman wrote:
>
> -Original M
+, Igor Neyman wrote:
>Interestingly, when I add this line to pg_hba.conf:
>
>localall all md5
>
>Postgres is not starting with the following error in the log file:
>
>2017-05-23 11:02:10.397 EDT [4796] LOG: local connections are not
>supported b
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver
Sent: Tuesday, May 23, 2017 10:04 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/23/2017 06:52 AM, Igor
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, May 23, 2017 10:31 AM
To: Igor Neyman ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/23/2017 07:05 AM, Igor Neyman wrote:
>>
>> pg_hba.conf
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, May 23, 2017 9:45 AM
To: Igor Neyman ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/23/2017 06:33 AM, Igor Neyman wrote:
>
> Yeah, my mistake
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Thomas Kellerer
Sent: Tuesday, May 23, 2017 9:46 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
Igor Neyman schrieb am
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, May 23, 2017 9:26 AM
To: Igor Neyman ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/23/2017 06:17 AM, Igor Neyman wrote:
> -Original Mess
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Monday, May 22, 2017 7:56 PM
To: Igor Neyman ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/22/2017 12:33 PM, Igor Neyman wrote:
> Hi,
>
> Does built-i
Hi,
Does built-in logical replication work on Windows in PG10 BETA release?
I can't make it working so far.
I created Publication on "source" PG server, but when I'm trying to CREATE
SUBSCRIPTION... on "destination" server, I'm getting:
"ERROR: could not connect to the publisher: could not send
,
ANALYZEing the table, none of these change the behavior.
Why does the query planner choose to ignore the index when the command is
parameterised?
It’s because when optimizer builds execution plan for parametrized queiry, it
doesn’t know what values for t1 and t2 will be provided for WHERE clause.
Regards,
Igor Neyman
andard OS level monitoring is a
good idea. You don't wanna run out of space on drives etc.
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
And there lies another difference with Oracle: Postgres does not allocate disk
space for data files “in advance” (like Oracle does).
Regards,
Igor Neyman
” connections
(and their state change – how long they’ve been idle), especially considering
that unlike Oracle Postgres doesn’t have (yet) built-in connection pooler, so
there is risk to run out of connections. There are very good add-on poolers
such as PgBouncer, PgPool.
Regards,
Igor Neyman
From: Moreno Andreo [mailto:moreno.and...@evolu-s.it]
Sent: Friday, April 14, 2017 3:11 PM
To: Igor Neyman ; Melvin Davidson
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Service outage: each postgres process use the exact
amount of the configured work_mem
Attention: This email was
From: Moreno Andreo [mailto:moreno.and...@evolu-s.it]
Sent: Friday, April 14, 2017 3:00 PM
To: Igor Neyman ; Melvin Davidson
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Service outage: each postgres process use the exact
amount of the configured work_mem
Attention: This email was
-weight and easy to configure.
Regards,
Igor Neyman
ed from 10 to 2 minutes.
Since I did everything with one shot, I can't tell the weight of every single
action.
Regards
IF
You can always run EXPLAIN ANALYZE and see what's going on.
Also, it could show possibilities for improvement.
Igor Neyman
gories_stat_materialized_view ) takes about 8 minutes (
it takes about 3 to create the MV ).
I'd like to know if there is a way to speed up the refresh ( or the creation )
with some additional indexes, maybe ?
Thanks in advance
____
Also, in regards to:
Sort Method: external merge Disk: 287784kB
I'd increase work_mem setting, to avoid on-disk sorting.
Regards,
Igor Neyman
gories_stat_materialized_view ) takes about 8 minutes (
it takes about 3 to create the MV ).
I'd like to know if there is a way to speed up the refresh ( or the creation )
with some additional indexes, maybe ?
Thanks in advance
________
I'd try the following index:
(giomo:date, categoria, utenti, action)
on categories_stat table and see if it improves performance.
Regards,
Igor Neyman
be the possible ways, where i can look into.
Due to business impact auto vacuum is off.
Sent from Outlook<http://aka.ms/weboutlook>
You just stated the reason:
"auto vacuum is off"
Regards,
Igor Neyman
er alternatives ? In Ingres for example
I can use dbevent and an esqlc app which listens
Thank you
Armand
__
Similar mechanism exists in Postgresql.
Read about LISTEN/NOTIFY in the docs.
, they are
not obligated to read your mind.
Regards,
Igor Neyman
ry'
else 'Owner_Inventory'
end) AS `Lot_Status`,
__
isnull(`s`.`Actual_Close_Date`) in MySQL is equivalent to:
s.actual_close_date IS NULL in Postgres.
What exactly didn't
a new row with a start ts
running on from that.
Of course, the adds are just inserting new rows.
cheers,
Chris
So, what is the value for "end ts", when the record is inserted (the range
ustered index (with the heap row stored in the index leaf)
because of the way how MVCC implemented: multiple row versions are stored in
the table itself (e.g. Oracle for that purpose keeps table “clean” and stores
multiple row versions in UNDO tablespace/segment).
Regards,
Igor Neyman
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Craig James
Sent: Tuesday, August 23, 2016 4:00 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Foreign key against a partitioned table
How do you create a foreign key that references a parti
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alexander Farber
Sent: Tuesday, August 23, 2016 3:33 PM
Cc: pgsql-general
Subject: Re: [GENERAL] Forward declaration of table
Hi Igor,
On Tue, Aug 23, 2016 at 8:15 PM, Igor Neyman
mailto:iney
Regards,
Igor
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alexander Farber
Sent: Tuesday, August 23, 2016 1:11 PM
To: pgsql-general
Subject: [GENERAL] Forward declaration of table
Good evening,
with PostgreSQL 9.5.3 I am using the follow
-Original Message-
From: Alex Ignatov [mailto:a.igna...@postgrespro.ru]
Sent: Thursday, July 28, 2016 11:26 AM
To: Igor Neyman ; Rakesh Kumar
Cc: PostgreSQL General
Subject: Re: [GENERAL] Uber migrated from Postgres to MySQL
On 28.07.2016 18:09, Igor Neyman wrote:
> -Origi
-Original Message-
From: Alex Ignatov [mailto:a.igna...@postgrespro.ru]
Sent: Thursday, July 28, 2016 11:26 AM
To: Igor Neyman ; Rakesh Kumar
Cc: PostgreSQL General
Subject: Re: [GENERAL] Uber migrated from Postgres to MySQL
On 28.07.2016 18:09, Igor Neyman wrote:
> -Origi
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alex Ignatov
Sent: Thursday, July 28, 2016 10:59 AM
To: Rakesh Kumar
Cc: PostgreSQL General
Subject: Re: [GENERAL] Uber migrated from Postgres to MySQL
On 28.07.2016 17:
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G. Johnston
Sent: Thursday, July 28, 2016 11:05 AM
To: Markus Kolb
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Multiple NOTIFY is ignored
On Thu, Jul 28, 2016 at 10:29 AM, Markus
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Job
Sent: Friday, June 17, 2016 9:01 AM
To: Albe Laurenz ; pgsql-general@postgresql.org
Subject: [GENERAL] R: Hot disable WAL archiving
Hi Albe and thank you, first of all
reate new db).
Probably your unexpected table and sequence are coming from there.
Regards,
Igor Neyman
for 9.4 and 9.5) on
various Linux platforms, and I'm stuck with Windows, hence the question.
If it didn't make 9.6 core, is there plan to include it in 9.7, or may be
pglogical becomes available on Windows?
Regards,
Igor Neyman
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Allan Kamau
Sent: Thursday, May 12, 2016 9:59 AM
To: Daniel Westermann
Cc: Postgres General Postgres General
Subject: Re: [GENERAL] Release Notes Link is broken on the website
Provide a link to th
ind the queries that are causing that much IO?
Please, if anyone can share anything.. Thanks a lot!
Lucas
So, what’s wrong with using pg_stat_statements?
It has a set of columns pertaining to IO.
Regards,
Igor Neyman
-Original Message-
From: James Robinson [mailto:jlrob...@socialserve.com]
Sent: Friday, March 25, 2016 11:29 AM
To: Igor Neyman
Cc: Melvin Davidson ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Way to get at parsed trigger 'WHEN' clause expression?
> On Mar 25, 2
e_tree, relation_oid)” – looks like it doesn’t work
with pg_trigger, because as a second parameter (Var) it expects relation_oid,
and relation could have multiple triggers, so pg_get_expr() wouldn’t know which
trigger’s tgqual you want to decompile.
Regards,
Igor Neyman
/www.postgresql.org/docs/9.5/static/ecpg-preproc.html seems to be
something different?
Regards
Alex
Psql directive \i – is your friend.
In your words.sql:
\i words_hash
\i words_join_new_game
\i …
Regards,
Igor Neyman
W dniu 28.02.2016 o 03:35, David G. Johnston pisze:
> W dniu 23.02.2016 o 09:39, Rafal Pietrak pisze:
> > Can anybody suggest any other way out of this mass?
>
>
> The only thought that sticks while reading your prose is:
>
> message > message-person < person
>
>
> mess
Regards,
Igor Neyman
ightly worse
performance.
It seems like a huge improvement, given that your data fits BRIN's use case.
Felipe,
What kind of queries you used in your test?
Where they based on clustering columns?
Regards
Igor Neyman
ex on FK (col1, col2) are in the same order (and in the
beginning) of PK index.
So, no need for additional index (col1, col2).
Regards,
Igor Neyman
ld be greatly
appreciated.
Do you know what “process 41915” is? And what it was doing to cause
ExclusiveLock?
Regards,
Igor Neyman
From: Sean Rhea [mailto:sean.c.r...@gmail.com]
Sent: Friday, October 09, 2015 4:30 PM
To: Igor Neyman
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Merge join vs merge semi join against primary key
It does the merge (not-semi) join:
production=> explain analyze SELECT ac.* F
r: 212699113
Total runtime: 201995.044 ms
(7 rows)
What if you rewrite your second query like this:
SELECT ac.*
FROM balances ac JOIN customers o ON (o.id<http://o.id> = ac.customer_id AND
o.group_id = 45);
Regards,
Igor Neyman
OM my_table
WHERE (x*10 + y) >= (1*10 + 3) AND (x*10 + y) <= (3*10 + 2)
ORDER BY x, y;
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
From: David G. Johnston [mailto:david.g.johns...@gmail.com]
Sent: Monday, September 28, 2015 3:14 PM
To: Igor Neyman
Cc: Ramesh T ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Format
On Mon, Sep 28, 2015 at 1:59 PM, Igor Neyman
mailto:iney...@perceptron.com>> wrote:
Hi All,
How to change sql format to look beautiful and understandable using
pgadmin3 or else ther tools for postgres.
any help appreciated..
Are you looking for SQL editor?
If that’s the case, take a look at contexteditor.org
Regards,
Igor Neyman
n
load_id else null end );
how can i convert case expressed to postgres..above it is oracle.
any help appreciated...
CREATE UNIQUE INDEX idx_load_pick ON pick (load_id) where picked='y';
Regards,
Igor Neyman
tml
Regards,
Igor Neyman
in schema “new”.
The obvious problem is that there is no table “new” in schema “new”, the table
will still be called “old”.
Jim’s example is very similar to what I provided a few days ago.
Regards,
Igor Neyman
ect column “field” from table “new”, which does not exists.
Not sure, what other example you need.
Regards,
Igor Neyman
f schema “vector” is copied into some destination schema
using your script?
Melvin, you needn’t consider every critique of your script to be a personal
attack on you.
Regards,
Igor Neyman
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: Wednesday, September 09, 2015 4:48 PM
To: Igor Neyman
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] clone_schema function
Thanks Igor,
hmm, apparently the "INCLUDING CONSTRAINTS' option of "CREATE TABLE' ha
ent sequnce values, table data, views and functions.
As always, use with caution.
--
Melvin Davidson
I assume you are aware that this script does not produce complete copy of the
source schema.
Foregn Key constraints are not recreated along with the tables.
Regards,
Igor Neyman
d but doesn't address
this use-case. It's unfortunate that we don't have a better answer at this
time.
Thanks!
Stephen
___
Could you please provide reference to pg_audit?
TIA,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql
ust for the sake of completeness...
If the value (empname in the above example) can be NULL, the compare does not
work, because
SELECT NULL = NULL
returns NULL which is treated as FALSE.
But I am sure you know this :-)
HTH,
Ladislav Lenart
___
Right. And that
al PK (for db convenience) and unique NATURAL
key (for GUI representation).
Regards,
Igor Neyman
healthcare domain (
irrespective of open-source or proprietary tool )
We need to showcase to our customer for building analytical database
Please do share, it will be really helpful
Thanks
Sridhar BN
Did you check this page:
http://www.postgresql.org/about/users/
Regards,
Igor Neyman
from information_schema.columns where
table_name = 'install_crash';
Regards,
Igor Neyman
('12.32.42','.',-1) ,any help appreciated
__
There are lots of string functions and operators:
http://www.postgresql.org/docs/9.3/static/functions-string.html
There is definitely a replacement for Oracle’s instr(…).
Regards,
Igor Neyman
0) a limit
10;
and then check the size of the indexes:
for "select pg_relation_size('U1')" I get 2834432
while " select pg_relation_size('U2')" returns 2285568.
So, index based on randomly populated column is bigger than the one based on
sequentially pop
?
Please tell me what Im doing wrong?
And another question, if I want to specify remote postgres DB's in the .ini
file. How do I do that?
Thanks
Ali.
You should specify pgbouncer with “-d” option:
-bash-4.2$ psql -p 6432 –d pgbouncer
Regards,
Igor Neyman
t require much additional
resource, but will eliminate some network traffic that you have with the
current configuration.
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
From: Sheena, Prabhjot [mailto:prabhjot.si...@classmates.com]
Sent: Friday, June 05, 2015 2:38 PM
To: Igor Neyman; pgsql-general@postgresql.org; pgsql-performa...@postgresql.org
Subject: RE: Query running slow for only one specific id. (Postgres 9.3) version
When I run vacuum analyze it fixes
cords while really getting only 1.
Regards,
Igor Neyman
database
using ODBC.
Thanks
Stuart Richler
Montreal
Sure.
What appears to be a problem?
Igor Neyman.
200 GB ?
Thanks a lot,
cheers
Filip
---
PG 2.7 to 3.6???
Anyway, did you look at pg_upgrade?
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
B.col2
FROM table2 B
WHERE A.col3 = B.col4;
Regards,
Igor Neyman
, your RAM is 8GB. Your work_mem is too high. Actual memory used for
sorting, etc... could be multiples of work_mem setting.
That could be the reason for your memory problems. I'd suggest to set it to
16MB, and see if you can avoid "on disk" sorting. If not - gradually increase
work_mem.
Regards,
Igor Neyman
; Seq Scan on z0
(cost=0.00..1538.30 rows=42530 width=38) (actual time=0.010..82.125
rows=42530 loops=1)"
"Total runtime: 4414.655 ms"
--
Didn't see replies to this message, so...
Your query spends most of the time on sorting:
"Sort Method: external merge Disk: 21648kB"
and it doesn't fit in memory.
Try increasing work_mem somewhat to 50MB, you could do it for this particular
connection only, if you don't want to change it for the whole server.
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
;
> Compatibility
>
> The CREATE TABLE command conforms to the SQL standard, with exceptions
> listed below.
>
> Temporary Tables
>
> >
> > Regards,
> > Igor Neyman
> >
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
m.b. I'm mis
From: inspector morse [mailto:inspectormors...@gmail.com]
Sent: Thursday, March 05, 2015 10:37 AM
To: Adrian Klaver
Cc: Merlin Moncure; Igor Neyman; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Sharing data between stored functions?
I'm confused with what Igor said. He said to c
Just create global temp tables once with “ON COMMIT PRESERVE ROWS“ option, and
when any session uses them their contents will be private to this session.
Regards,
Igor Neyman
nce in Postgres when using dynamic SQL variables inside EXECUTE
‘…’ are “positional” prefixed with ‘$’, eg.: $1, $2,…
Regards,
Igor Neyman
org/docs/9.3/interactive/app-pgdump.html
"
Diagnostics
pg_dump internally executes SELECT statements. If you have problems
running pg_dump, make sure you are able to select information from the
database using, for example, psql."
To answer your question, this is intentional. At the mome
.3.x).
Is there a way to find out which channels have listeners?
thanks
--Cory
Take a look at pg_listening_channels() in PG docs.
Regards,
Igor Neyman
This works just fine. It's not in the spec, but postgres supports it.
I'll leave it to others to argue about it being a best practice or not.
---
I use this feature a lot.
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
ed. Try dropping it now.
Regards,
Igor Neyman
G (SELECT … FOR UPDATE)…
Can’t you just do:
DELETE FROM table_name
WHERE id_A = ANY(array_of_id_A)
AND id_B = ANY(array_of_id_B);
?
Regards,
Igor Neyman
alue from the matched row to every record in "second" table.
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
m/a-large-database-does-not-mean-large-shared_buffers/#comment-945
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
only means that some resource that this
query is looking for was not released by some other connection (user locked
some object and went for a coffee break ☺
Regards,
Igor Neyman
-Original Message-
From: Richard Frith-Macdonald [mailto:richard.frith-macdon...@brainstorm.co.uk]
Sent: Monday, October 06, 2014 1:53 PM
To: Igor Neyman
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to get good performance for very large lists/sets?
On 6 Oct 2014, at 17
your query, corresponding plans, and what don't you like about
them?
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
t) up
from _tbl
where id between startid and stopid
) a
where (up).userid is not NULL
)
I want to pass the _tbl to the select query integrated in the unpacking(), how
can I make it?
thanks
Alec
You can't.
You have to use dynamic s
;s exactly why OP prefers Mongo, which doesn't care about such
"small" things as ACID.
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
L” in BEFORE INSRT
trigger, you could assign NEW.id value nextval('...'::regclass) right then
and there explicitly in such cases.
Regards,
Igor Neyman
ce?
>
> Said another way:
>
> I think of table scanning as sequential, and fast. That would be loading db
> record 1,2,3, etc.
>
> Would it be faster to load db records "mostly sequential": 1,3,4,7,10
> compared to randomly: 7,3,10,1,4
>
> -Andy
>
runs.
Using Control Panel you can try to revoke "log in local" from PostgreSQL
account (in Win7 it's actually "deny log in local").
Regards,
Igor Neyman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
EDT CONTEXT: line 75 of configuration file
"/etc/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
Regar
1 - 100 of 249 matches
Mail list logo
