Re: jsonb_set() strictness considered harmful to data

2019-10-19 Thread Adrian Klaver
On 10/18/19 7:18 PM, Ariadne Conill wrote: Hello, On Fri, Oct 18, 2019 at 7:04 PM Adrian Klaver wrote: On 10/18/19 4:31 PM, Ariadne Conill wrote: Hello, On Fri, Oct 18, 2019 at 6:01 PM Adrian Klaver wrote: On 10/18/19 3:11 PM, Ariadne Conill wrote: Hello, On Fri, Oct 18, 2019 at 5:01

Re: releasing space

2019-10-19 Thread Adrian Klaver
9.6.15, you're 13 minor versions (~30 months) of fixes behind. You might want to consider upgrading ... -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Adrian Klaver adrian.kla...@aklaver.com

Re: releasing space

2019-10-19 Thread Adrian Klaver
On 10/19/19 4:51 PM, Julie Nishimura wrote: an entire cluster *From:* Adrian Klaver *Sent:* Saturday, October 19, 2019 4:34 PM *To:* Julie Nishimura ; Tomas Vondra *Cc:* pgsql-general@lists.postgresql.org ; pgsql

Re: Calling jsonb_array_elements 4 times in the same query

2019-10-21 Thread Adrian Klaver
(select gid, played from word_moves where mid = 39146) AS m_id ON word_moves.gid = m_id.gid WHERE ... Thank you Alex -- Adrian Klaver adrian.kla...@aklaver.com

Re: jsonb_set() strictness considered harmful to data

2019-10-21 Thread Adrian Klaver
n the above to me as I thought there are exception blocks in stored functions and now sub-transactions in stored procedures. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Postgres Point in time Recovery (PITR),

2019-10-21 Thread Adrian Klaver
net. Taking Offline Backups is not the only right way to ensure Reliable Backups. We are way ahead of the days where you need to face downtime to take backups. Online Backups are reliable in PostgreSQL. -- Adrian Klaver adrian.kla...@aklaver.com

Re: jsonb_set() strictness considered harmful to data

2019-10-21 Thread Adrian Klaver
On 10/21/19 12:50 PM, Tomas Vondra wrote: On Mon, Oct 21, 2019 at 08:06:46AM -0700, Adrian Klaver wrote: On 10/20/19 11:07 PM, Tomas Vondra wrote: On Sun, Oct 20, 2019 at 06:51:05PM -0400, Andrew Dunstan wrote: True. And AFAIK catching exceptions is not really possible in some code, e.g

Re: Calling jsonb_array_elements 4 times in the same query

2019-10-21 Thread Adrian Klaver
b -> 0 -> 'one'; pg_typeof | ?column? ---+-- text | 1 words_ru=> \i src/slova/dict/words_get_move.sql psql:src/slova/dict/words_get_move.sql:28: ERROR:  cannot cast type jsonb to integer LINE 17: (t.tile->'col')::int

Re: A question about sequences and backup/restore cycles

2019-10-21 Thread Adrian Klaver
are of the dependencies. 2) Are you using a home built method to populate the database? In that case you take responsibility for dependencies. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Having more than one constraint trigger on a table

2019-10-22 Thread Adrian Klaver
t order by fld_1 ; id | fld_1 +--- (0 rows) test=# select * from trg_str order by fld_1 ; fld_1 - trigger_1_check_nocycle trigger_1_update_fts trigger_2 trigger_3 Is this how you want them to fire as it does not match what you say above?: "The

Re: existing dblinks

2019-10-22 Thread Adrian Klaver
/contrib-dblink-get-connections.html dblink_get_connections — returns the names of all open named dblink connections Thanks -- Adrian Klaver adrian.kla...@aklaver.com

Re: A question about sequences and backup/restore cycles

2019-10-22 Thread Adrian Klaver
ings are run on a higher level do something like: pg_dump -Fc -d some_db -f db.out pg_restore -l db_out > db_toc.txt -l on pg_restore creates a TOC(table of contents) showing the ordering of the schema recreation. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Primary key definition?

2019-10-22 Thread Adrian Klaver
use the new data you inserted after the restore was using PK values that overlapped the old data. That is probably down to some script not starting at a value > max(PK). -- Adrian Klaver adrian.kla...@aklaver.com

Re: A question about sequences and backup/restore cycles

2019-10-22 Thread Adrian Klaver
On 10/22/19 1:35 PM, stan wrote: On Tue, Oct 22, 2019 at 12:48:41PM -0700, Adrian Klaver wrote: On 10/22/19 10:48 AM, stan wrote: Please reply to list also: Ccing list. Sorry if my description was not clear. No, we do not mix test, and production data. Let me try to clarify the question

Re: date function bug

2019-10-23 Thread Adrian Klaver
At: https://www.postgresql.org/docs/11/functions-formatting.html I would read the section starting : "Usage notes for date/time formatting: ..." several times. There a lot of 'if and or buts' in there. -- Adrian Klaver adrian.kla...@aklaver.com

Re: date function bug

2019-10-23 Thread Adrian Klaver
1" Behavior changed in v10: https://www.postgresql.org/docs/10/release-10.html " Make to_timestamp() and to_date() reject out-of-range input fields (Artur Zakirov) For example, previously to_date('2009-06-40','-MM-DD') was accepted and returned 2009-07-

Re: Is this a bug ?

2019-10-23 Thread Adrian Klaver
-linux-gnu, compiled by gcc (SUSE Linux) 7.4.1 20190424 [gcc-7-branch revision 270538], 64-bit (1 row) test_(postgres)# select to_date('2018150X','MMDD'); ERROR: date/time field value out of range: "2018150X" -- Adrian Klaver adrian.kla...@aklaver.com

Re: A very puzzling backup/restore problem

2019-10-24 Thread Adrian Klaver
] stan@stan=> \dt Did not find any relations. [local] stan@stan=> \q ]0;stan@smokey: ~stan@smokey:~$ exit Script done on 2019-10-24 06:30:48-0400 quiting psql and reconecting shows that the obkects ARE there, with the taks)instance table empty. What am I doing wrong? -- Adrian Klaver adrian.kla...@aklaver.com

Re: PGPool version 4.0.6-1

2019-10-24 Thread Adrian Klaver
3.4.0-2pgdg.rhel6.x86_64.rpm etc. is PostgreSQL extension and should be installed into PostgreSQL server. Please use suitable one depending on PostgreSQL version presented by "-pgXX"." Regards Vikas -- Adrian Klaver adrian.kla...@aklaver.com

Re: A very puzzling backup/restore problem

2019-10-24 Thread Adrian Klaver
On 10/24/19 7:32 AM, stan wrote: On Thu, Oct 24, 2019 at 07:04:11AM -0700, Adrian Klaver wrote: On 10/24/19 3:52 AM, stan wrote: I have a very confusing isse. I am trying to backup and restre a signle table . first I dump the table. Actually you are just dumping the table data. More

Re: Having more than one constraint trigger on a table

2019-10-24 Thread Adrian Klaver
On 10/22/19 8:26 AM, Andreas Joseph Krogh wrote: På tirsdag 22. oktober 2019 kl. 17:12:59, skrev Adrian Klaver mailto:adrian.kla...@aklaver.com>>: [snip] No. When I sort the triggers I get: test=# create table trg_str(fld_1 varchar); CREATE TABLE test=# inser

Re: Search path

2019-10-24 Thread Adrian Klaver
g-client.html so it works for clients that connect to Postgres not just psql. I can confirm it works with Access. -- Adrian Klaver adrian.kla...@aklaver.com

Re: A very puzzling backup/restore problem

2019-10-24 Thread Adrian Klaver
On 10/24/19 2:58 PM, stan wrote: On Thu, Oct 24, 2019 at 07:40:29AM -0700, Adrian Klaver wrote: On 10/24/19 7:32 AM, stan wrote: On Thu, Oct 24, 2019 at 07:04:11AM -0700, Adrian Klaver wrote: On 10/24/19 3:52 AM, stan wrote: I have a very confusing isse. I am trying to backup and restre a

Re: Updating data: confirmation and question

2019-10-26 Thread Adrian Klaver
n the .sql file but have not before learned how/whether I can change a database name using psql. What's the best approach to changing the existing hypephenated name? This?: https://www.postgresql.org/docs/11/sql-alterdatabase.html ALTER DATABASE name RENAME TO new_name TIA, Rich -

Re: PostgreSQL - unrecognized win32 error code: 38

2019-10-26 Thread Adrian Klaver
er" statement 1 Not sure how that can be answered without knowing what ComputeComputer is doing? Thanks Jacky -- Adrian Klaver adrian.kla...@aklaver.com

Re: Updating data: confirmation and question

2019-10-26 Thread Adrian Klaver
On 10/26/19 10:39 AM, Rich Shepard wrote: On Sat, 26 Oct 2019, Adrian Klaver wrote: That depends on how you ran pg_dumpall. For instance did you use -c?: Adrian, Yes. Always. Then the question is, do you really want to overwrite the new database? https://www.postgresql.org/docs/11/sql

Re: Updating data: confirmation and question

2019-10-26 Thread Adrian Klaver
On 10/26/19 1:39 PM, Rich Shepard wrote: On Sat, 26 Oct 2019, Adrian Klaver wrote: Then the question is, do you really want to overwrite the new database? Adrian, I want to overwrite the old databases with the new .sql file. I _think_ there's only one database that's ch

Re: SQL pretty pritner?

2019-10-27 Thread Adrian Klaver
reaks, and does some formatting. Development being done in an Ubuntu Linux environment. Anyone have a recommendation? http://sqlformat.darold.net/ https://sourceforge.net/projects/pgformatter/ -- Adrian Klaver adrian.kla...@aklaver.com

Re: QUERY: autovacuum: VACUUM ANALYZE table versus QUERY: autovacuum: VACUUM table

2019-11-02 Thread Adrian Klaver
ete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. -- Adrian Klaver adrian.kla...@aklaver.com

Re: select view definition from pg_views feature request

2019-11-05 Thread Adrian Klaver
es are in the current search > path. > Is it possible to either have the definition always qualify all tables > independent of the search_path (or else provide a new column that does > that)? Why don't you just change the search path to empt

Re: here does postgres take its timezone information from?

2019-11-05 Thread Adrian Klaver
Hong Kong, Italy, and Palestine. This update also adds support for zic's new -b slim option to reduce the size of the installed zone files, though it is not currently being used by PostgreSQL." cheers, Chris -- Adrian Klaver adrian.kla...@aklaver.com

Re: here does postgres take its timezone information from?

2019-11-05 Thread Adrian Klaver
/obtain its timezone zone information and how would this be updated? As to where it gets its timezone info: https://www.postgresql.org/docs/11/datetime-config-files.html cheers, Chris -- Adrian Klaver adrian.kla...@aklaver.com

Re: here does postgres take its timezone information from?

2019-11-05 Thread Adrian Klaver
On 11/5/19 3:00 PM, Chris Withers wrote: On 05/11/2019 22:54, Adrian Klaver wrote: On 11/5/19 2:46 PM, Chris Withers wrote: Hi All, Brazil recently abolished daylight savings time, resulting in updates to system timezone information packages. Does postgres use these? If so, does it need a

Re: Locked out of schema public

2019-11-06 Thread Adrian Klaver
ission denied for schema public How can this happen? I don't think I twiddled anything with schemas, in fact I never used them in any way. cheers, PMc -- Adrian Klaver adrian.kla...@aklaver.com

Re: SQL SERVER migration to PostgreSql

2019-11-07 Thread Adrian Klaver
ATION-PARAMETERS https://www.postgresql.org/docs/11/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING If that does not help then post an example of what you are trying to do. -- Adrian Klaver adrian.kla...@aklaver.com

Re: broken backup trail in case of quickly patroni switchback and forth

2019-11-07 Thread Adrian Klaver
e that the whole wal sequence trail will be backuped? any idea? Probably best to ask the Patroni folks: https://github.com/zalando/patroni#community - Markus -- Adrian Klaver adrian.kla...@aklaver.com

Re: AW: broken backup trail in case of quickly patroni switchback and forth

2019-11-07 Thread Adrian Klaver
e that the whole wal sequence trail will be backuped? any idea? Probably best to ask the Patroni folks: https://github.com/zalando/patroni#community - Markus -- Adrian Klaver adrian.kla...@aklaver.com

Re: 11 -> 12 upgrade on Debian Ubuntu

2019-11-07 Thread Adrian Klaver
I have sued this, having used pg_dump in the past. Database is fairly small with just one tablespace if that matters. Thanks for anyone's input. -- Adrian Klaver adrian.kla...@aklaver.com

Re: AW: AW: broken backup trail in case of quickly patroni switchback and forth

2019-11-07 Thread Adrian Klaver
y first and moved to tape afterwards. we got a case where Patroni switched back and forth sides quickly, e.g.: 12:00h: primary - standby 12:05h: standby - primary 12:10h: primary - standby we realised that we will not have a wal backup of those wal's generated between 12:05h and 12:10h in this scenario. how can we make sure that the whole wal sequence trail will be backuped? any idea? Probably best to ask the Patroni folks: https://github.com/zalando/patroni#community - Markus -- Adrian Klaver adrian.kla...@aklaver.com

Re: INOUT PARAMETERS WITH RETURN TABLES IN FUNCTION

2019-11-08 Thread Adrian Klaver
bl_employees" ; END; $$ LANGUAGE plpgsql; I can not create that because of inout parameters. Another place; do $$ DECLARE b integer = 1; DECLARE d integer = 2 ; BEGIN   select * from public."test"(); END; $$;  Anybody have an idea ? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Storing a time interval

2019-11-08 Thread Adrian Klaver
around looking for values within the range, whereas the OP is looking for two discrete values. The two field method you suggest above also encapsulates that. -- Adrian Klaver adrian.kla...@aklaver.com

Re: firewall trouble on Windows

2019-11-08 Thread Adrian Klaver
icle.howto80775.html Thanks. Ross Boylan -- Adrian Klaver adrian.kla...@aklaver.com

Re: announce: spark-postgres 3 released

2019-11-10 Thread Adrian Klaver
-etl/tree/master/spark-postgres -- Adrian Klaver adrian.kla...@aklaver.com

Re: `pg_ls_dir` can query some directories, but not others

2019-11-13 Thread Adrian Klaver
s_dir('/home')) a; count --- 2 (1 row) SELinux (or equivalent) in play? My postgres version is 11.5, running on Arch Linux. -- Adrian Klaver adrian.kla...@aklaver.com

Re: ERROR: COPY escape must be a single one-byte character (multi-delimiter appears to work on Postgres 9.0 but does not on Postgres 9.2)

2019-11-13 Thread Adrian Klaver
way to copy the old Postgres server, dependencies, and executables to our new server, in case the source was modified? Brandon Ragland Software Engineer BREAKFRONT SOFTWARE Office: 704.688.4085 | Mobile: 240.608.9701 | Fax: 704.973.0607 -- Adrian Klaver adrian.kla...@aklaver.com

Re: Problems modifyiong view

2019-11-14 Thread Adrian Klaver
w query must generate the same columns that were generated by the existing view query (that is, the same column names in the same order and with the same data types), but it may add additional columns to the end of the list. The calculations giving rise to the output columns may be completely

Re: Problems modifyiong view

2019-11-14 Thread Adrian Klaver
On 11/14/19 7:12 AM, Tom Lane wrote: Adrian Klaver writes: On 11/14/19 5:53 AM, stan wrote: I am trying to add columns to a view using CREATE OR REPLACE VIEW, and I am getting the following error: ERROR: cannot change name of view column "descrip" to "contact_person_1" Am

Re: INOUT PARAMETERS WITH RETURN TABLES IN FUNCTION

2019-11-14 Thread Adrian Klaver
NOUT "y"text)RETURNS TABLE("id"integer,"filesize"character varying(36))AS$$BEGINRETURNQUERY SELECT*FROMpublic."tbl_employees";END;$$LANGUAGE plpgsql;| |I need to call table and inout parameters together at another place.| Adrian Klaver <mailto:adrian.kla..

Re: Problems modifyiong view

2019-11-14 Thread Adrian Klaver
On 11/14/19 7:45 AM, Tom Lane wrote: Adrian Klaver writes: On 11/14/19 7:12 AM, Tom Lane wrote: If you actually want to rename an existing view column, use ALTER TABLE ... RENAME COLUMN ... for that. Alright, I'm missing something here: test=# alter table up_test rename COLUMN co

Re: Problems modifyiong view

2019-11-14 Thread Adrian Klaver
On 11/14/19 7:54 AM, Adrian Klaver wrote: On 11/14/19 7:45 AM, Tom Lane wrote: Adrian Klaver writes: On 11/14/19 7:12 AM, Tom Lane wrote: If you actually want to rename an existing view column, use ALTER TABLE ... RENAME COLUMN ... for that. Alright, I'm missing something here:

Re: naming triggers for execution

2019-11-15 Thread Adrian Klaver
the same kind are defined for the same event, they will be fired in alphabetical order by name." Use appropriate naming or combine/nest the functions. -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: Create array of data from JSONB in PG 9.5

2019-11-15 Thread Adrian Klaver
e ERROR. In other words run the jsonb_array_elements() independently and then start adding them together. Thanks, Arup Rakshit a...@zeit.io -- Adrian Klaver adrian.kla...@aklaver.com

Re: Authentication: MD5 to SCRAM-SHA-256 error

2019-11-15 Thread Adrian Klaver
! What Linux distro and version? How was Postgres installed? Do you have more then one instance of Postgres installed? Thanks! -- Adrian Klaver adrian.kla...@aklaver.com

Re: access to original-statement predicates in an INSTEAD-OF row trigger

2019-11-15 Thread Adrian Klaver
ot possible. I am looking for some self-contained way in trigger or similar code. -- Adrian Klaver adrian.kla...@aklaver.com

Re: access to original-statement predicates in an INSTEAD-OF row trigger

2019-11-15 Thread Adrian Klaver
On 11/15/19 12:57 PM, John Lumby wrote: Adrian Klaver wrote : On 11/15/19 10:37 AM, John Lumby wrote: Suppose the original statement is UPDATE myview VW set VW.counter = 11 where VW.primary_key = and VW.counter = 10; and my trigger constructs this statement UPDATE

Re: access to original-statement predicates in an INSTEAD-OF row trigger

2019-11-15 Thread Adrian Klaver
On 11/15/19 1:54 PM, John Lumby wrote: Adrian Klaver wrote : Seems you are looking for Serializable Isolation Level: True ,   that would solve the race condition,  but it is too drastic. We need to run with Read Committed. I am looking for a solution which does not alter the application or

Re: Function's execute overhead reducing

2019-11-17 Thread Adrian Klaver
not the way i would like to use, because it leads to more issues to solve (invalidation, for instance) -- Adrian Klaver adrian.kla...@aklaver.com

Re: ERROR: there is no unique constraint matching given keys for referenced table "audit_p"

2019-11-18 Thread Adrian Klaver
ROR:  there is no unique constraint matching given keys for referenced table "audit_p"* The PK(UNIQUE constraint) on audit_logging.audit_p is: "audit_pk1" PRIMARY KEY, btree (id, create_dtt) You are only specifying id: REFERENCES audit_logging.audit_p(id) sd_tems

Re: postgres backup question

2019-11-19 Thread Adrian Klaver
match at least one -t switch but no -T switches. If -T appears without -t, then tables matching -T are excluded from what is otherwise a normal dump. Thank you -- Adrian Klaver adrian.kla...@aklaver.com

Re: mysysconf ?

2019-11-19 Thread Adrian Klaver
://www.postgresql.org/message-id/ofcecdfa08.38a13a4f-onc1256c5d.00544...@axxessit.no -- Adrian Klaver adrian.kla...@aklaver.com

Re: Making "invisible" characters visible ? (psql)

2019-11-20 Thread Adrian Klaver
misunderstanding on my part, i suppose. NULL is a value so it should 'show' up. Thank you for your help. -- Adrian Klaver adrian.kla...@aklaver.com

Re:

2019-11-20 Thread Adrian Klaver
-- Adrian Klaver adrian.kla...@aklaver.com

Re: Isolation of multiple databse instances provided by a single postgres server

2019-11-21 Thread Adrian Klaver
e, only the whole cluster. Yours, Laurenz Albe -- Adrian Klaver adrian.kla...@aklaver.com

Re: Isolation of multiple databse instances provided by a single postgres server

2019-11-21 Thread Adrian Klaver
e, only the whole cluster. Yours, Laurenz Albe -- Adrian Klaver adrian.kla...@aklaver.com

Re: deep debug log for psql

2019-11-21 Thread Adrian Klaver
bu.statusrech IN (0,1) ) GROUP BY ha.hnr; The -L logfilename flag of psql is not sufficient enough. It logs only the query and the final result. client_min_messages?: https://www.postgresql.org/docs/11/runtime-config-client.html#GUC-CLIENT-MIN-MESSAGES Thanks matthias -- Adrian

Re: Tablespace setup issue

2019-11-21 Thread Adrian Klaver
ve the same name. I would greatly appreciated any pointers to reference material on these issues or advises on how to approach this. Thank you in advance for your time. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Help with authentication on Debain/Ubuntu installation

2019-11-21 Thread Adrian Klaver
you want to test password connection then use a -h localhost to get a host connection. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Remote Connection Help

2019-11-21 Thread Adrian Klaver
I would like to be able to connect to my Ubuntu PostgreSQL server from all Windows 10 machines as well as from a client on my Android phone while away from home. That is my goal now. I am hoping that someone can help me to get this working. This is been very frustrating. -- Adrian Kl

Re: Help with authentication on Debain/Ubuntu installation

2019-11-21 Thread Adrian Klaver
On 11/21/19 8:12 AM, stan wrote: Please reply to list also Ccing list. On Thu, Nov 21, 2019 at 07:56:10AM -0800, Adrian Klaver wrote: On 11/21/19 6:35 AM, stan wrote: If the 1st rule matches, I am thinking this will override any rule I put in after such as: local all postgres md5 Is my

Re: Help with authentication on Debain/Ubuntu installation

2019-11-21 Thread Adrian Klaver
only connect on the local socket as the db postgres user if they are also the os postgres user. You can work around that by having other users connect to the database using a -h(host) connection that requires a password. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Remote Connection Help

2019-11-21 Thread Adrian Klaver
: Tom Lane Sent: Thursday, November 21, 2019 02:42 PM To: Jason L. Amerson Cc: 'Steve Crawford' ; 'Adrian Klaver' ; 'PostgreSQL' Subject: Re: Remote Connection Help "Jason L. Amerson" writes: Yes "listen_addresses" is not commented. I did n

Re: Remote Connection Help

2019-11-21 Thread Adrian Klaver
What Postgres version did you install from source? 2) In /usr/local/pgsql/data what is the exact setting for listen_addresses and port in postgresql.conf sudo ./configure -- Adrian Klaver adrian.kla...@aklaver.com

Re: Remote Connection Help

2019-11-21 Thread Adrian Klaver
.PGSQL.5432" -2019-11-21 13:49:30.322 PST-0LOG: redirecting log output to logging collector process -2019-11-21 13:49:30.322 PST-0HINT: Future log output will appear in directory "log". -- Adrian Klaver adrian.kla...@aklaver.com

Re: Help with authentication on Debain/Ubuntu installation

2019-11-21 Thread Adrian Klaver
On 11/21/19 1:52 PM, stan wrote: On Thu, Nov 21, 2019 at 12:14:16PM -0800, Adrian Klaver wrote: 5) Now in your case you have peer auth(first in the list) for local socket connections which means a user can only connect on the local socket as the db postgres user if they are also the os

Re: Remote Connection Help

2019-11-22 Thread Adrian Klaver
ile is NULL. This is either because the value is not coming from a file or because you where not a superuser when you did the select on pg_settings. Can you run the select as a superuser? Jason L. Amerson -Original Message- From: Adrian Klaver Sent: Thursday, November 21, 2019

Re: Constants in the foreighn key constraints

2019-11-22 Thread Adrian Klaver
2/sql-createtrigger.html Regards, Aliaksei. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Remote Connection Help

2019-11-22 Thread Adrian Klaver
show the server is running. But otherwise, all I see is that it just goes to a new line with no confirmation or errors. Jason L. Amerson -Original Message- From: Adrian Klaver Sent: Thursday, November 21, 2019 04:53 PM To: Jason L. Amerson Cc: 'Steve Crawford' ; 'Postgr

Re: Remote Connection Help

2019-11-22 Thread Adrian Klaver
ws 10 computers that will be clients, need PostgreSQL installed in order to connect remotely to my server or is pgAdmin or some other client all I need? Jason L. Amerson -Original Message- From: Adrian Klaver Sent: Friday, November 22, 2019 09:56 AM To: Jason L. Amerson Cc: 'PostgreSQL

Re: automated 'discovery' of a table : potential primary key, columns functional dependencies ...

2019-11-22 Thread Adrian Klaver
/ constraints) I'd be glad to have some feedback / pointers to tools in plpgsql or even plpython. Thank you very much Remi -- Adrian Klaver adrian.kla...@aklaver.com

Re: And I thought I had this solved.

2019-11-22 Thread Adrian Klaver
ot; during startup How can I solve this issue? If the above is the entire function I am not seeing that you need to SET search_path as there is no object that needs schema qualification. I would comment it out and run it. If that fails then set the function volatile. -- Adrian Klaver adrian.kla...@aklaver.com

Re: And I thought I had this solved.

2019-11-22 Thread Adrian Klaver
usted schema(s), then 'pg_temp'. SET search_path = admin, pg_temp; Put the SET outside the function body. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Constants in the foreighn key constraints

2019-11-23 Thread Adrian Klaver
tgres community could add this functionality in the nearest releases. Regards, Aliaksei. On Fri, Nov 22, 2019 at 4:25 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 11/22/19 6:32 AM, aleksey ksenzov wrote: > Hi team. > Latest time we faced several i

Re: Pgadmin 4 schema visibility

2019-11-25 Thread Adrian Klaver
are shown; supply a pattern or the S modifier to include system objects. If + is appended to the command name, each object is listed with its associated permissions and description, if any. Thank you -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_restore with connection limit 0

2019-11-27 Thread Adrian Klaver
aight approach do not use CONNECTION LIMIT 0 is this case, but change ALLOW_CONNECTIONS to accept values: false, true, superuser. ("Superuser" to accept connections from superuser only). Why not use pg_hba.conf to allow only connection from superuser for duration? -- Adrian Kl

Re: Install different directory issues

2019-11-27 Thread Adrian Klaver
Thanks for any help! -- Tom Carter -- Adrian Klaver adrian.kla...@aklaver.com

Re: Install different directory issues

2019-11-27 Thread Adrian Klaver
more then one installer, which one? Do you have another instance of Postgres installed? I’m not sure if I would have the same issue right now if I used rpm —prefix. Tom Carter On Nov 27, 2019, at 2:00 PM, Adrian Klaver wrote: On 11/27/19 10:49 AM, Thomas Carter wrote: I installed Postgres

Re: ROLE VALID UNTIL timezone?

2019-11-27 Thread Adrian Klaver
7;; CREATE ROLE ts_test| Cannot login +| {} | Password valid until 2020-12-31 00:00:00-08 | Best guess it operates like if specifying a value for a timestamptz field. -- Adrian Klaver adrian.kla...@aklaver.com

Re: ROLE VALID UNTIL timezone?

2019-11-27 Thread Adrian Klaver
On 11/27/19 2:25 PM, Adrian Klaver wrote: On 11/27/19 2:19 PM, Ron wrote: Hi, In 9.6, does it default to UTC, the postgresql.conf timezone value (US/Eastern) value or to local system time? test_(postgres)# show timezone;   TimeZone  US/Pacific test_(postgres)# create role

Re: Rows violating Foreign key constraint exists

2019-11-28 Thread Adrian Klaver
not want to invoke during data reload. ... " How do I proceed from here - Do I just delete the inconsistent rows or is there something more I have to do? Thanks for your help. Regards, Nanda -- Adrian Klaver adrian.kla...@aklaver.com

Re: MS Access Frontend

2019-11-29 Thread Adrian Klaver
updated to the latest versions. This might help: https://support.office.com/en-us/article/Manage-linked-tables-1d9346d6-953d-4f85-a9ce-4caec2262797 Thank you, Jason L. Amerson -- Adrian Klaver adrian.kla...@aklaver.com

Re: Counting booleans in GROUP BY sections

2019-11-29 Thread Adrian Klaver
ds_moves_score_check" CHECK (score >= 0) Foreign-key constraints:     "words_moves_gid_fkey" FOREIGN KEY (gid) REFERENCES words_games(gid) ON DELETE CASCADE     "words_moves_uid_fkey" FOREIGN KEY (uid) REFERENCES words_users(uid) ON DELETE CASCADE Referenced by:

Re: Counting booleans in GROUP BY sections

2019-11-29 Thread Adrian Klaver
or the mid to display and so it throws the error. To go forward it would help to know what it is you are trying to achieve? Regards Alex -- Adrian Klaver adrian.kla...@aklaver.com

Re: Counting booleans in GROUP BY sections

2019-11-30 Thread Adrian Klaver
8dee |    6767 |        40  May 2018  |         3 | f          |   86180 | 4d47a65263331cf4e2d2956886b6a72f |    6706 |        26  May 2018  |         3 | f          |   85736 | debb1efd673c91947a8aa7f38be4217c |    6680 |        28  May 2018  |         3 | f          |   82522 | e55ec68a5a5dacc2bc463e397198cb1c |    6550 |        27  Apr 2018  |         0 | f          |   78406 | f5d264ccfe94aaccd90ce6c019716d4d |    5702 |        58  Apr 2018  |         0 | f          |   77461 | 404886e913b698596f9cf3648ddf6fa4 |    1048 |        26 (415 rows) -- Adrian Klaver adrian.kla...@aklaver.com

Re: MS Access Frontend

2019-11-30 Thread Adrian Klaver
On 11/30/19 3:15 AM, Tim Clarke wrote: On 29/11/2019 17:30, Adrian Klaver wrote: On 11/29/19 9:23 AM, Jason L. Amerson wrote: I am trying to setup MS Access as a frontend so that it would be easier on my wife and children to interact with PostgreSQL. I looked online for some tutorials but the

Re: MS Access Frontend

2019-11-30 Thread Adrian Klaver
erson -- Adrian Klaver adrian.kla...@aklaver.com

Re: Why are clobs always "0"

2019-12-01 Thread Adrian Klaver
/docs/11/unsupported-features-sql-standard.html So what are you referring to? 2) Comment on field definition is what exactly? 3) How are you fetching the metadata? -- Adrian Klaver adrian.kla...@aklaver.com

Re: slow insert speeds with bytea

2019-12-02 Thread Adrian Klaver
performance delta is so significant that i feel like i'm missing something It would help to have more information: 1) The schema of the table e.g. the output of \d in psql. 2) The actual INSERT query. 3) An EXPLAIN ANALYZE of the INSERT query. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Upgrading from V11 to V12 on Debian install

2019-12-02 Thread Adrian Klaver
afety." -- Benjamin Franklin -- Adrian Klaver adrian.kla...@aklaver.com

Re: Syntax error for UPDATE ... RETURNING INTO STRICT

2019-12-03 Thread Adrian Klaver
dden space issue or something. (or otherwise, in very strange cases - the SQL would fail and my java-servlet would throw SQLException) Regards Alex -- Adrian Klaver adrian.kla...@aklaver.com

Re: Syntax error for UPDATE ... RETURNING INTO STRICT

2019-12-03 Thread Adrian Klaver
On 12/3/19 8:24 AM, Alexander Farber wrote: Thanks for your replies! Tom has hinted that STRICT is pl/pgSQL syntax and not SQL I finally read the full function and see you declared the LANGUAGE as sql. Now things make sense:) Regards Alex -- Adrian Klaver adrian.kla...@aklaver.com

<    6   7   8   9   10   11   12   13   14   15   >