Re: Unexpected "canceling statement due to user request" error

2019-08-17 Thread Adrian Klaver
do you have any ideas about what might be going on? Here is the relevant source: https://doxygen.postgresql.org/postgres_8c.html#ab7af3ee6ad40efb8454c6f2f790d9588 Start at around line 3078. This is on PostgreSQL 9.6.14 on Ubuntu Xenial. Thank you! -- Adrian Klaver adrian.kla...@aklaver.com

Re: Roles versus users

2019-08-17 Thread Adrian Klaver
database objects and have database privileges; a role can be considered a “user”, a “group”, or both depending on how it is used. ..." So, should I just create roles for each user? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Sorry, real newbie question about connecting to a database

2019-08-19 Thread Adrian Klaver
case multiple readings:)). Still a passing familiarity with the concepts will make your life easier. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Collumn level permissions ?

2019-08-19 Thread Adrian Klaver
o do is "hide" one column of a table from a set of users. Any better way to do this? https://www.postgresql.org/docs/11/sql-grant.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump problems: [archiver (db)] query failed: ERROR: relation "pg_opfamily" does not exist

2019-08-20 Thread Adrian Klaver
? From the bug that introduced the issue: https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=07b39083c "Per bug #15934 from Tom Gottfried. Back-patch to all supported branches." So I'm guessing it is in the most recent release of all current versions. Thanks for your time! Regards, Erwin Moller -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_dump problems: [archiver (db)] query failed: ERROR: relation "pg_opfamily" does not exist

2019-08-20 Thread Adrian Klaver
On 8/20/19 7:37 AM, Erwin Moller wrote: Op 8/20/2019 om 3:32 PM schreef Adrian Klaver: On 8/20/19 6:18 AM, Erwin Moller wrote: Op 8/20/2019 om 2:07 PM schreef Ian Barwick: On 8/20/19 7:12 PM, Erwin Moller wrote: Hi, While trying to move an old 8.1 Postgres install to a new server with

Re: pg_dump problems: [archiver (db)] query failed: ERROR: relation "pg_opfamily" does not exist

2019-08-20 Thread Adrian Klaver
On 8/20/19 8:02 AM, Adrian Klaver wrote: On 8/20/19 7:37 AM, Erwin Moller wrote: That is a bummer. Since I have no idea how to safely install an older version of pg_dump alongside my current 10.10 install, I will wait for the patch. A quick test showed that: 1) Go here: https

Re: Rename a column if not already renamed.?

2019-08-20 Thread Adrian Klaver
nks Dave Day -- Adrian Klaver adrian.kla...@aklaver.com

Re: Rename a column if not already renamed.?

2019-08-20 Thread Adrian Klaver
ithout the error, but any chance there is a quoting problem? EXECUTE format ('ALTER TABLE %s RENAME %I TO %I', schema_table_, old_name_, new_name); Luca -- Adrian Klaver adrian.kla...@aklaver.com

Re: Two Postgres master process are showing - one is on and off

2019-08-20 Thread Adrian Klaver
--color=auto postgres [postgres@SERVER1 data]$ Thanks, Chiru -- Adrian Klaver adrian.kla...@aklaver.com

Re: Rename a column if not already renamed.?

2019-08-21 Thread Adrian Klaver
xists and Not sure about the workflow this function is used within, but maybe you need to consider what to do when both the old and new column names exist. Because that sure sounds like what is happening. regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: Rename a column if not already renamed.?

2019-08-21 Thread Adrian Klaver
the simultaneous possibility. I will include the redefined function in the merge patch and see how it goes. I'll update the thread after some further exploration. Thanks all for your assistance. -- Adrian Klaver adrian.kla...@aklaver.com

Re: psql \copy hanging

2019-08-22 Thread Adrian Klaver
iting to a different location. My first guess (appart from db lock) was that the target file was locked by the filesystem. But wouldn't psql know about it and fail with an error ? Thanks for your help ! -- Arnaud -- Adrian Klaver adrian.kla...@aklaver.com

Re: psql \copy hanging

2019-08-22 Thread Adrian Klaver
On 8/22/19 7:07 AM, Arnaud L. wrote: Le 22/08/2019 à 16:00, Adrian Klaver a écrit : The first thing I think of when seeing this sort of behavior on Windows is anti-virus software. Doing you have any running on the machine? You say it always hangs on the same line. Is that line doing something

Re: How to install Postgres 12 beta with YUM

2019-08-22 Thread Adrian Klaver
I do not see it, e.g. `yum list postgresql* | grep 12` doesn't show anything with version 12. Any ideas? Thanks, Igal Sapir Lucee Core Developer Lucee.org <http://lucee.org/> -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to install Postgres 12 beta with YUM

2019-08-22 Thread Adrian Klaver
On 8/22/19 12:35 PM, Igal @ Lucee.org wrote: Adrian, On 8/22/2019 12:22 PM, Adrian Klaver wrote: On 8/22/19 11:29 AM, Igal @ Lucee.org wrote: I have installed the CentOS 7 PGDG file from https://yum.postgresql.org/repopackages.php If I `cat /etc/yum.repos.d/pgdg-redhat-all.repo` I see

Re: How to install Postgres 12 beta with YUM

2019-08-22 Thread Adrian Klaver
On 8/22/19 12:35 PM, Igal @ Lucee.org wrote: Adrian, On 8/22/2019 12:22 PM, Adrian Klaver wrote: On 8/22/19 11:29 AM, Igal @ Lucee.org wrote: I have installed the CentOS 7 PGDG file from https://yum.postgresql.org/repopackages.php If I `cat /etc/yum.repos.d/pgdg-redhat-all.repo` I see

Re: database files are incompatible with server

2019-08-22 Thread Adrian Klaver
th an argument other than "/usr/local/pgsql11_dev". Thank you, Igal Sapir Lucee Core Developer Lucee.org <http://lucee.org/> -- Adrian Klaver adrian.kla...@aklaver.com

Re: database files are incompatible with server

2019-08-22 Thread Adrian Klaver
On 8/22/19 6:29 PM, Ron wrote: On 8/22/19 7:08 PM, Adrian Klaver wrote: On 8/22/19 4:52 PM, Igal @ Lucee.org wrote: I have a data directory that was created by Postgres 12 (I thought beta 3 but now am not sure anymore) running in Docker. I have installed Postgres 12b3 as a Systemd service

Re: database files are incompatible with server

2019-08-22 Thread Adrian Klaver
On 8/22/19 7:12 PM, Ron wrote: On 8/22/19 8:49 PM, Adrian Klaver wrote: On 8/22/19 6:29 PM, Ron wrote: On 8/22/19 7:08 PM, Adrian Klaver wrote: On 8/22/19 4:52 PM, Igal @ Lucee.org wrote: I have a data directory that was created by Postgres 12 (I thought beta 3 but now am not sure anymore

Re: How to install Postgres 12 beta with YUM

2019-08-23 Thread Adrian Klaver
to install I do not see it, e.g. `yum list postgresql* | grep 12` doesn't show anything with version 12. Any ideas? Thanks, Igal Sapir Lucee Core Developer Lucee.org <http://lucee.org/> -- Sent from my Android device with K-9 Mail. Please excuse my brevity

Re: slow queries on system tables

2019-08-23 Thread Adrian Klaver
sql-archive.org/PostgreSQL-general-f1843780.html> at Nabble.com. -- Adrian Klaver adrian.kla...@aklaver.com

Re: slow queries on system tables

2019-08-23 Thread Adrian Klaver
REATE INDEX." Assuming tables/indexes have changed enough to trigger vacuum run: 78,000 * 1 vacuum = 78,000 updates -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Adrian Klaver adrian.kla...@aklaver.com

Re: Postgres SQLSTATE[08006] [7] timeout expired

2019-08-24 Thread Adrian Klaver
  md5 The $_SERVER["REMOTE_ADDR"]; line shown in my PHP program above always comes back with the address of the load balancer. I'm new to Postgres, so any help with this connection problem will be very appreciated.  Thanks a lot. In addition to what Rob suggested, what do you see or not in the Postgres logs when you try the connections(both direct to db and to load balancer). -- Adrian Klaver adrian.kla...@aklaver.com

Re: Postgres SQLSTATE[08006] [7] timeout expired

2019-08-25 Thread Adrian Klaver
On Sunday, August 25, 2019 9:36 AM, Condor wrote: On 25-08-2019 02:54, Adrian Klaver wrote: On 8/24/19 3:42 PM, Howard Wells wrote: I have three servers behind a load balancer and a fourth server solely for Postgres 10 database that is not behind the load balancer.  All four are behind the s

Re: Postgres SQLSTATE[08006] [7] timeout expired

2019-08-25 Thread Adrian Klaver
ewall, with port 5432 open." 2) A subsequent post: "Only when I go to the IP address of the server with the Postgres database will the transaction complete, and it happens quickly." Thanks to Rob Sargent, Adrian Klaver and Condor for your help. Howard ‐‐‐ Original Messa

Re: import job not working

2019-08-26 Thread Adrian Klaver
? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Postgres SQLSTATE[08006] [7] timeout expired

2019-08-26 Thread Adrian Klaver
ctually going on, or you run the risk of being bitten by this again. Howard ‐‐‐ Original Message ‐‐‐ On Sunday, August 25, 2019 4:55 PM, Adrian Klaver wrote: On 8/25/19 2:59 PM, Howard Wells wrote: I solved this problem. All four servers are behind a firewall, but port 5432

Re: import job not working

2019-08-26 Thread Adrian Klaver
? 3) no idea What are the import parameters you are using? 4) nothing I could find What I could find elsewhere on google is that people have resolved this by reverting to PgAdmin 3. What where you using when it last worked, pgAdmin3 or pgAdmin4? On 26/08/2019 11:04, Adrian Klaver wrote

Re: Include a connection pooler in Postgres

2019-08-27 Thread Adrian Klaver
developer time it would be nice to include in core. To get an idea of what the developers are currently facing see the latest Commitfest: https://commitfest.postgresql.org/24/ - Lev -- Adrian Klaver adrian.kla...@aklaver.com

Re: Recomended front ends?

2019-08-27 Thread Adrian Klaver
plete, unlike any Model-based migration system. +1 Using the Django ORM to create complex queries is a joy (especially nesting subqueries), and you don't lose all the other Django facilities (decent auth model, decent CRUD interface, customisation when "decent" is not enough).

Re: Work hours?

2019-08-27 Thread Adrian Klaver
EXTRACT: https://www.postgresql.org/docs/11/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT to find the dates with a dow(The day of the week as Sunday (0) to Saturday (6)) or isodow(The day of the week as Monday (1) to Sunday (7)) that falls in Mon-Fri and add to counter. -- Adrian Kl

Re: Question about password character in ECPG's connection string

2019-08-28 Thread Adrian Klaver
nd up with an extra parameter pwd Have you tried quoting the password? If user and password cannot write in connection string, what are parameters allowed in "connection_option" ? I hope I can get this information from the ECPG documentation. Regards. -- Yusuke, Egashira. -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to log 'user time' in postgres logs

2019-08-28 Thread Adrian Klaver
impacted by bloated tables/out-of-date statistics. Some questions: 1) How did you arrive at the 6 second figure? 2) Is the PHP application on the same server as the database? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Selecting rows having substring in a column

2019-08-29 Thread Adrian Klaver
s/11/functions-textsearch.html > Regards, Rich -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to log 'user time' in postgres logs

2019-08-29 Thread Adrian Klaver
but this is what we battled with for 2.5 days until the light came on that the vacuum had been set to off on the target system during server migration. -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to log 'user time' in postgres logs

2019-08-29 Thread Adrian Klaver
e light came on that the vacuum had been set to off on the target system during server migration. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Upgrade 96 -> 11

2019-09-02 Thread Adrian Klaver
is free of viruses or other defects. If you have received this communication in error, you may not copy or distribute any part of it or otherwise disclose its contents to anyone. Please advise the sender of your incorrect receipt of this correspondence. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Upgrade 96 -> 11

2019-09-02 Thread Adrian Klaver
f PostGIS? 2) "Both the versions have PostGIS 2.5.1 installed and working" How do you know it is working on the 11 version? -- James Sewell, Chief Architect -- Adrian Klaver adrian.kla...@aklaver.com

Re: Upgrade 96 -> 11

2019-09-02 Thread Adrian Klaver
On 9/2/19 2:45 PM, James Sewell wrote: On Tue, 3 Sep 2019 at 7:41 am, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 9/2/19 2:20 PM, James Sewell wrote: > >     So this is a separate cluster from the one you used pg_upgrade on? >

Re: Upgrade 96 -> 11

2019-09-02 Thread Adrian Klaver
and -p? Does it shows the schema creation in the order you need? Yes. It's only in the binary_upgrade mode I see issues (because the extension stuff isn't created with CREATE EXTENSION) What is the pg_upgrade command you are using? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Upgrade 96 -> 11

2019-09-02 Thread Adrian Klaver
files might be shared between the old and new cluster: I have set PGBINOLD, PGBINNEW, PGDATAOLD, PGDATANEW correctly. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Upgrade 96 -> 11

2019-09-02 Thread Adrian Klaver
On 9/2/19 5:38 PM, James Sewell wrote: On Tue, 3 Sep 2019 at 10:34, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 9/2/19 5:20 PM, James Sewell wrote: > >     What is the pg_upgrade command you are using? > > > pg_upgrade --

Re: Upgrade 96 -> 11

2019-09-03 Thread Adrian Klaver
On 9/2/19 5:52 PM, Adrian Klaver wrote: It's still creating the schema elements when it fails, it hasn't started linking yet Alright at least you still a working 9.6 cluster . Not sure where to go from here. Like you I am not sure how it can CREATE EXTENSION and not actually foll

Re: Running a Simple Update Statement Fails, Second Time Suceeds.

2019-09-03 Thread Adrian Klaver
- This message is intended only for the use of the addressee and may contain information that is PRIVILEGED AND CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify the sender immediately. Thank you. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Upgrade 96 -> 11

2019-09-03 Thread Adrian Klaver
later. So to be clear you ran pg_dump with --binary-upgrade and the extension elements where created after the user table that tripped the error? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Running a Simple Update Statement Fails, Second Time Suceeds.

2019-09-04 Thread Adrian Klaver
Type | Collation | Nullable | Default I see ora2pg in the function and product_master_fdw above. Is this a foreign table? -- Adrian Klaver adrian.kla...@aklaver.com

Re: floating point output

2019-09-04 Thread Adrian Klaver
d (variable in a single select's output) and the dropping of a trailing zero (to some implying a loss of precision).  Is the code my only guide here? Some examples would help explain your concerns. Bottom line, if you want precision use numeric. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Cannot restore dump when using IS DISTINCT FROM on a HSTORE column

2019-09-05 Thread Adrian Klaver
n advance, ciao, lele. [1] https://www.postgresql-archive.org/BUG-15695-Failure-to-restore-a-dump-ERROR-operator-does-not-exist-public-hstore-public-hstore-td6077272.html [2] https://www.postgresql.org/message-id/flat/ffefc172-a487-aa87-a0e7-472bf29735c8%40gmail.com -- Adrian Klaver adrian.kla...@aklaver.com

Re: Cannot restore dump when using IS DISTINCT FROM on a HSTORE column

2019-09-05 Thread Adrian Klaver
cussion of providing a simpler way to do this, but nothing's been done about that either. My 2 cents would be for a --unsecure-path option to pg_dump/restore that would drop the pg_catalog.set_config('search_path', '', false). regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: Environment Variable for --data-checksum during initdb

2019-09-05 Thread Adrian Klaver
re: https://doxygen.postgresql.org/initdb_8c.html The PostgreSQL documentation has a nice page of environment variables for when PostgreSQL is running, but I'm not finding the variable to set during the initdb phase. Any help to jog my memory greatly appreciated. --Ray -- Adrian Klaver adrian.kla...@aklaver.com

Re: Question from someone who is not trained in computer sciences

2019-09-05 Thread Adrian Klaver
ation less painful. Thank you in advance, Judith -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_restore issues with intarray

2019-09-05 Thread Adrian Klaver
tify us by reply e-mail, and destroy the original transmission and its attachments without reading them or saving them to disk. Thank you. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_restore issues with intarray

2019-09-05 Thread Adrian Klaver
On 9/5/19 4:06 PM, Kevin Brannen wrote: From: Adrian Klaver On 9/5/19 2:57 PM, Kevin Brannen wrote: I think I need some help to understand what’s going here because I can’t figure it out and google isn’t helping. This is for Pg 9.6.5. (Yes, we are upgrading to 12.x in a few months, or so the

Re: pg_restore issues with intarray

2019-09-05 Thread Adrian Klaver
On 9/5/19 4:24 PM, Adrian Klaver wrote: On 9/5/19 4:06 PM, Kevin Brannen wrote: From: Adrian Klaver On 9/5/19 2:57 PM, Kevin Brannen wrote: I think I need some help to understand what’s going here because I can’t figure it out and google isn’t helping. This is for Pg 9.6.5. (Yes, we are

Re: pg_restore issues with intarray

2019-09-05 Thread Adrian Klaver
On 9/5/19 5:05 PM, Kevin Brannen wrote: On 9/5/19 4:24 PM, Adrian Klaver wrote: On 9/5/19 4:06 PM, Kevin Brannen wrote: From: Adrian Klaver On 9/5/19 2:57 PM, Kevin Brannen wrote: I think I need some help to understand what’s going here because I can’t figure it out and google isn’t helping

Re: pg_restore issues with intarray

2019-09-06 Thread Adrian Klaver
On 9/6/19 8:45 AM, Kevin Brannen wrote: From: Adrian Klaver On 9/5/19 5:05 PM, Kevin Brannen wrote: It feels like the restore is adding the intarray extension, which does a CREATE OPERATOR FAMILY on its own, then later the restore does CREATE OPERATOR FAMILY on again causing the problem. Yet

Re: Environment Variable for --data-checksum during initdb

2019-09-07 Thread Adrian Klaver
           subsequent call of `pg_upgrade`.  For more info                              about possible options please look at man                              pg_upgrade(1).   PGSETUP_DEBUG              Set to '1' if you want to see debugging output. -- Adrian Klaver adrian.kla...@aklaver.com

Re: kind of a bag of attributes in a DB . . .

2019-09-07 Thread Adrian Klaver
don't find the idea that half way off either. What is the pattern, anti-pattern or whatever relating to such design? Do you know of such implementations with such data? lbrtchx -- Adrian Klaver adrian.kla...@aklaver.com

Re: Convert a row to a nested JSON document containing all relations in PostgreSQL

2019-09-07 Thread Adrian Klaver
trigger function as generic as possible, because I plan to use it on all tables. One level of depth in following foreign keys is currently enough for me. Thank you. -- Adrian Klaver adrian.kla...@aklaver.com

Re: How to access Postgres .pgpass file from php?

2019-09-07 Thread Adrian Klaver
uestions are: 1. How can I access it from the .pgpass file instead? I think what you are looking for is the connection service file: https://www.postgresql.org/docs/11/libpq-pgservice.html 2. Where is .phpass loccated in Apache2 Ubuntu 18.04? Information on where .pgpass can be:

Re: Convert a row to a nested JSON document containing all relations in PostgreSQL

2019-09-08 Thread Adrian Klaver
help or directions. And there might be simpler solutions to this problem, which I would like to know about. Also see my question on SO: https://stackoverflow.com/questions/57830543/convert-a-row-to-a-nested-json-document-containing-all-relations-in-postgresql -- Adrian Klaver adrian.kla...@aklaver.com

Re: database "cdf_100_1313" does not exist

2019-09-09 Thread Adrian Klaver
l and SQL.  You need something like /usr/lib/postgresql/11/bin/psql -p 5432 -U postgres -d "$DBLIST" -c "GRANT CONNECT ON DATABASE \"$DBLIST\" TO cpupdate"                         regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: pgrounting extension in 11

2019-09-10 Thread Adrian Klaver
/psql -p 5434 psql (11.5) Type "help" for help. postgres=# create extension pgrouting; ERROR:  could not open extension control file "/usr/pgsql-11/share/extension/pgrouting.control": No such file or directory postgres=# postgres=# -- Thanks, Prakash.R -- Adrian Klaver adrian.kla...@aklaver.com

Re: pgrounting extension in 11

2019-09-10 Thread Adrian Klaver
Tue, Sep 10, 2019, 19:16 Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 9/10/19 5:59 AM, Prakash Ramakrishnan wrote: > Hi Team, > > Anyone help me to solve the below issue not able to create the pgrouting > extension 11 version in r

Re: kind of a bag of attributes in a DB . . .

2019-09-10 Thread Adrian Klaver
On 9/10/19 9:59 AM, Albretch Mueller wrote: On 9/7/19, Adrian Klaver wrote: Is the metadata uniform or are you dealing with a variety of different data? You can expect for all files to have a filename and size, but their kinds (the metadata describing them) can be really colorful and wild

Re: kind of a bag of attributes in a DB . . .

2019-09-11 Thread Adrian Klaver
On 9/11/19 9:46 AM, Albretch Mueller wrote: On 9/10/19, Adrian Klaver wrote: If there is no rhyme or reason to the metadata I am not sure how you could come up with an efficient search strategy. Seems it would be a brute search over everything. Not exactly. Say some things have colours but

Re: How to reformat output of "age()" function

2019-09-11 Thread Adrian Klaver
ract(epoch from '2019.11.20 20:00:00'::timestamptz) - test-# extract(epoch from '2019.06.10 10:00:00'::timestamptz) as test-# elapsed_seconds; elapsed_seconds - 14122800 test=# select extract(epoch from '2019.11.20 20:00:00'::timestamptz -&

Re: How to reformat output of "age()" function

2019-09-12 Thread Adrian Klaver
On 9/12/19 4:50 AM, Francisco Olarte wrote: Adrian: On Wed, Sep 11, 2019 at 11:19 PM Adrian Klaver wrote: On 9/11/19 9:34 AM, Francisco Olarte wrote: ... If you want to know the elapsed minutes between two timestamps, it might be better to do it directly, extract the epoch from both

Re: update returning order by syntax error question

2019-09-12 Thread Adrian Klaver
; 3 RETURNING * ) SELECT * FROM u; BEGIN id | col1 | col_2 +--+--- 1 | t| 2 2 | NULL | 3 (2 rows) I'm missing something. ^ regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com

Re: Web GUI for PG table ?

2019-09-12 Thread Adrian Klaver
tabular form. It does not care about the backend just that it gets data. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Web GUI for PG table ?

2019-09-12 Thread Adrian Klaver
callbacks. On Thu, Sep 12, 2019 at 10:42 AM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 9/12/19 7:08 AM, David Gauthier wrote: > Hi: > > We're considering replacing a windows AccessDB based system with PG. > Access was chosen because of

Re: PG SQL and LIKE clause

2019-09-13 Thread Adrian Klaver
better than in Sybase. It's just different to Sybase. SQL Server derives from Sybase, and it would also fail on this statement. Any hints to address this problem? Or is there any compile time option for the PG server to address this? Thanks matthias -- Adrian Klaver adrian.kla...@aklaver.com

Re: PG SQL and LIKE clause

2019-09-13 Thread Adrian Klaver
On 9/13/19 7:35 AM, Ron wrote: On 9/13/19 9:14 AM, Adrian Klaver wrote: On 9/12/19 11:11 PM, Ron wrote: On 9/13/19 12:28 AM, Matthias Apitz wrote: Hello, We're porting a huge Library Management System, written using all kind of languages one can think of (C, C++, ESQL/C, Perl, Java, ..

Re: problems importing from csv

2019-09-13 Thread Adrian Klaver
ot;$1.00" CONTEXT: COPY employee, line 2, column hourly_rate: "$1.00" How can I work around this? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Cascade Trigger Not Firing

2019-09-14 Thread Adrian Klaver
ht have some other design issues.)                         regards, tom lane -- ---------- *Judy Loomis* 469.235.5839 -- Adrian Klaver adrian.kla...@aklaver.com

Re: kind of a bag of attributes in a DB . . .

2019-09-14 Thread Adrian Klaver
://www.postgresql.org/docs/11/datatype-json.html the metadata contained in json files would require more than one small databases, but such an import feature should be trivial Again, not sure I understand why small databases are required? C -- Adrian Klaver adrian.kla...@aklaver.com

Re: kind of a bag of attributes in a DB . . .

2019-09-14 Thread Adrian Klaver
ycopg/docs/extras.html?highlight=json Not sure if this is what you are looking for or not. the metadata contained in json files would require more than one small databases, but such an import feature should be trivial C -- Adrian Klaver adrian.kla...@aklaver.com

Re: Can I wrtie a function that has a BEFORE trigger that is not column name dpendent?

2019-09-14 Thread Adrian Klaver
columns so you will need some way of identifying the column(s) in the table. Trigger functions can take arguments even though they are not declared in the function creation. So that is one way of defining the column. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Can I wrtie a function that has a BEFORE trigger that is not column name dpendent?

2019-09-14 Thread Adrian Klaver
On 9/14/19 12:44 PM, stan wrote: Please reply to list also. Ccing list. On Sat, Sep 14, 2019 at 11:50:08AM -0700, Adrian Klaver wrote: On 9/14/19 11:33 AM, stan wrote: I would like to write a generic function that I can place as a BEFORE trigger on several tables. It would do a max() on the

Re: Shouldn;t this trigger be called?

2019-09-15 Thread Adrian Klaver
this fucntion be aclled for that? -- Adrian Klaver adrian.kla...@aklaver.com

Re: FW: Re: Shouldn;t this trigger be called?

2019-09-15 Thread Adrian Klaver
On 9/15/19 8:55 AM, stan wrote: Sorry forgot to cc the list On Sun, Sep 15, 2019 at 08:42:02AM -0700, Adrian Klaver wrote: On 9/15/19 8:33 AM, stan wrote: I have defined this function: CREATE FUNCTION fix_customer_types_case() and this trigger: CREATE TRIGGER fix_customer_types_case_trig

Re: FW: Re: FW: Re: Shouldn;t this trigger be called?

2019-09-15 Thread Adrian Klaver
On 9/15/19 10:46 AM, stan wrote: Forgot to cc the list again. Have to look at settings in mutt. Sorry forgot to cc the list On Sun, Sep 15, 2019 at 08:42:02AM -0700, Adrian Klaver wrote: On 9/15/19 8:33 AM, stan wrote: I have defined this function: CREATE FUNCTION fix_customer_types_case

Re: FW: Re: FW: Re: Shouldn;t this trigger be called?

2019-09-15 Thread Adrian Klaver
On 9/15/19 6:04 PM, stan wrote: On Sun, Sep 15, 2019 at 12:27:14PM -0700, Adrian Klaver wrote: On 9/15/19 10:46 AM, stan wrote: Forgot to cc the list again. Have to look at settings in mutt. What validity check? The check to see if it is the type enum. This would get solved a lot

Re: FW: Re: FW: Re: Shouldn;t this trigger be called?

2019-09-16 Thread Adrian Klaver
On 9/16/19 11:52 AM, stan wrote: On Mon, Sep 16, 2019 at 12:12:34AM -0400, Tom Lane wrote: stan writes: On Sun, Sep 15, 2019 at 12:27:14PM -0700, Adrian Klaver wrote: On 9/15/19 10:46 AM, stan wrote: So, my test tell me that the validity check is done BEFORE an attempt to insert (thus

Re: Dubugging an intermittent foreign key insert error with csvlog

2019-09-16 Thread Adrian Klaver
 I intend to re-work this to use returning id (available in postgres since 8.2!) instead of the serial sequence / last_value hack but not quite there yet. Thanks, Jeff Ross -- Adrian Klaver adrian.kla...@aklaver.com

Re: FW: Re: FW: Re: Shouldn;t this trigger be called?

2019-09-16 Thread Adrian Klaver
On 9/16/19 12:55 PM, stan wrote: On Mon, Sep 16, 2019 at 12:44:49PM -0700, Adrian Klaver wrote: On 9/16/19 11:53 AM, stan wrote: On Sun, Sep 15, 2019 at 09:16:35PM -0700, Adrian Klaver wrote: On 9/15/19 6:04 PM, stan wrote: On Sun, Sep 15, 2019 at 12:27:14PM -0700, Adrian Klaver wrote: On

Re: Dubugging an intermittent foreign key insert error with csvlog

2019-09-16 Thread Adrian Klaver
On 9/16/19 3:16 PM, Jeff Ross wrote: On 9/16/19 4:07 PM, Adrian Klaver wrote: On 9/16/19 1:46 PM, Jeff Ross wrote: The csvlog snip shows what I believe are 2 simultaneous but separate sessions and the session that attempts to insert into the cargo_det table is not the same session that

Re: FW: Re: FW: Re: Shouldn;t this trigger be called?

2019-09-17 Thread Adrian Klaver
it to a BOOLEAN field active_status and be done with the ENUM dance. 4) If status may ever be more then ACTIVE/ACTIVE then change it to varchar and use the trigger to set case(if still important) and/or verify correct entries. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pldbgapi extension

2019-09-17 Thread Adrian Klaver
i--unpackaged--1.0.sql [root@cvgrhehhsd006 extension]# ll total 16 -rw-r--r--. 1 root root 7457 Sep 17 02:46 pldbgapi--1.0.sql -rw-r--r--. 1 root root  181 Sep 17 02:46 pldbgapi.control -rw-r--r--. 1 root root 2258 Sep 17 02:46 pldbgapi--unpackaged--1.0.sql -- Thanks, Prakash.R PostgreSQL - Off

Re: pldbgapi extension

2019-09-17 Thread Adrian Klaver
e package one. You are using the PGDG repos? Did you install postgresql11-devel from the repo? I am not that familiar with the RH based multi-version install so I am not sure that -devel will help or not, but it is worth a try. Regards, Prakash.R On Tue, Sep 17, 2019, 19:10 Adr

Re: pldbgapi extension

2019-09-17 Thread Adrian Klaver
ution. Regards, Prakash.R On Tue, Sep 17, 2019, 19:58 Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 9/17/19 7:20 AM, Prakash Ramakrishnan wrote: > Hi Adrian, > > I did it yum installation postgresql 11 from repo file.but I don't

Re: pldbgapi extension

2019-09-17 Thread Adrian Klaver
On 9/17/19 9:20 AM, Rob Sargent wrote: On 9/17/19 10:16 AM, Adrian Klaver wrote: On 9/17/19 7:44 AM, Prakash Ramakrishnan wrote: I installed devel and contrib also but not worked here. Yeah, --contrib won't help as pldbpgapi is not one of the contrib modules as found here:

Re: install pgcrypto module to existing postgreSQL

2019-09-17 Thread Adrian Klaver
* *Take Risks; if you win, you will be very happy. If you lose you will be Wise * -- Adrian Klaver adrian.kla...@aklaver.com

Re: install pgcrypto module to existing postgreSQL

2019-09-17 Thread Adrian Klaver
://www.postgresql.org/docs/11/contrib.html On Tue, Sep 17, 2019 at 4:06 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 9/17/19 1:25 PM, Pavan Kumar wrote: > hello experts, > > i have Installed and created postgres 11.2 and created couple o

Re: Pg_auto_failover

2019-09-18 Thread Adrian Klaver
On 9/18/19 7:19 AM, Sonam Sharma wrote: Can someone please guide me in installing pg_auto_failover.. where can I get the rpm package for this ? OS and version? Postgres version? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: No existing local cluster is suitable as a default target

2019-09-18 Thread Adrian Klaver
..@unixarea.de <mailto:g...@unixarea.de>, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub May, 9: Спаси́бо освободители! Thank you very much, Russian liberators! -- Adrian Klaver adrian.kla...@aklaver.com

Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: No existing local cluster is suitable as a default target

2019-09-18 Thread Adrian Klaver
On 9/18/19 7:49 AM, Matthias Apitz wrote: El día miércoles, septiembre 18, 2019 a las 07:41:41a. m. -0700, Adrian Klaver escribió: On 9/18/19 6:13 AM, Marco Ippolito wrote: Thanks Matthias, very kind. Hopefully I will get some hints on how to solve my problem. You should probably take a

Re: Pg_auto_failover

2019-09-18 Thread Adrian Klaver
://github.com/citusdata/pg_auto_failover and see your other options. On Wed, Sep 18, 2019, 8:01 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: On 9/18/19 7:19 AM, Sonam Sharma wrote: > Can someone please guide me in installing pg_auto_failover.. where can I

Re: PostgreSQL License

2019-09-18 Thread Adrian Klaver
Postgres. -- Adrian Klaver adrian.kla...@aklaver.com

<    4   5   6   7   8   9   10   11   12   13   >