Re: [GENERAL] pg_dump and quoted identifiers

Tom Lane schrieb am 13.12.2016 um 19:35: >>> These cases work for me. Maybe your shell is doing something weird >>> with the quotes? > >> Hmm, that's the default bash from CentOS 6 (don't know the exact version) > > I'm using bash from current RHEL6, should be the same. > > I'm suspicious that

Re: [GENERAL] does postgres log the create/refresh of a materialized view anywhere?

On Wed, Dec 14, 2016 at 11:19 AM, Melvin Davidson wrote: > Originally, all I wanted was a column to record the creation date/time of an > object. One reason it was debunked was that it would lead > to a request for an additional column to record changes in objects. I >

Re: [GENERAL] vacuum freeze in 96

On Wed, Dec 14, 2016 at 5:00 AM, Torsten Förtsch wrote: > one of the major enhancements in 96 is skipping completely frozen pages in > vacuum freeze. I assume that requires a special bit on the page. The freeze map uses an additional bit in the vm, and pg_upgrade would

Re: [GENERAL] does postgres log the create/refresh of a materialized view anywhere?

On Tue, Dec 13, 2016 at 8:50 PM, Kevin Grittner wrote: > On Tue, Dec 13, 2016 at 7:37 PM, Melvin Davidson > wrote: > > On Tue, Dec 13, 2016 at 7:36 PM, Kevin Grittner > wrote: > >> On Tue, Dec 13, 2016 at 5:57 PM, Jonathan Vanasco

Re: [GENERAL] does postgres log the create/refresh of a materialized view anywhere?

On Tue, Dec 13, 2016 at 7:37 PM, Melvin Davidson wrote: > On Tue, Dec 13, 2016 at 7:36 PM, Kevin Grittner wrote: >> On Tue, Dec 13, 2016 at 5:57 PM, Jonathan Vanasco wrote: >> >>> Is there a way to find out when a materialized view was

Re: [GENERAL] does postgres log the create/refresh of a materialized view anywhere?

On Tue, Dec 13, 2016 at 7:36 PM, Kevin Grittner wrote: > On Tue, Dec 13, 2016 at 5:57 PM, Jonathan Vanasco > wrote: > > > Is there a way to find out when a materialized view was > > created/refreshed? > > > I can log this manually in postgresql if needed,

Re: [GENERAL] does postgres log the create/refresh of a materialized view anywhere?

On Tue, Dec 13, 2016 at 5:57 PM, Jonathan Vanasco wrote: > Is there a way to find out when a materialized view was > created/refreshed? > I can log this manually in postgresql if needed, but was hoping > there was some "timestamp" on the view in a system table. This is not

Re: [GENERAL] Install doesnt set SuperUser PW

On 12/13/2016 02:46 PM, Jovi Federici wrote: OMG it worked! I just threw in a PW I had used for something else and it worked! Must have been your good vibes :-) Best guess, at some point in past you did an install where you supplied a password and the installer stored that somewhere, so it

[GENERAL] does postgres log the create/refresh of a materialized view anywhere?

Is there a way to find out when a materialized view was created/refreshed? I couldn't find this information anywhere in the docs. the use-case is that I wish to update a materialized view a few times a day in a clustered environment. i'd like to make sure one of the redundant nodes doesn't

Re: [GENERAL] CRM where pg is a first class citizen?

On 12/13/2016 11:45 PM, Rich Shepard wrote: On Tue, 13 Dec 2016, Adrian Klaver wrote: This killed the community(Open Source) edition going forward: https://community.sugarcrm.com/thread/18434 I'd like to comment regarding this paragraph from the above-referenced blog post: "In the

Re: [GENERAL] CRM where pg is a first class citizen?

On 12/13/2016 10:49 PM, Adrian Klaver wrote: On 12/13/2016 12:36 PM, George Weaver wrote: I've never used it but what about: https://developer.sugarcrm.com/2012/08/03/like-postgresql-and-want-to-use-it-with-sugarcrm-check-out-a-new-community-project/ This killed the community(Open Source)

Re: [GENERAL] Install doesnt set SuperUser PW

On 12/13/2016 02:44 PM, Jovi Federici wrote: I'm going to try the new installer at bigsql, thanks! I would uninstall the EDB version first. Did the Postgres server actually get installed? - I think so. I have Postgres in Programs folder Do you have a postgres OS user? - I don't know. I

Re: [GENERAL] CRM where pg is a first class citizen?

On Tue, 13 Dec 2016, Adrian Klaver wrote: This killed the community(Open Source) edition going forward: https://community.sugarcrm.com/thread/18434 I'd like to comment regarding this paragraph from the above-referenced blog post: "In the course of the past five years, we have surveyed tens

Re: [GENERAL] Install doesnt set SuperUser PW

On 12/13/2016 02:08 PM, Jovi Federici wrote: Just re-ran installer in Administrator mode with no difference. Correction on previous statement: the installed does ask for Paths but does not ask for a PW. Dept of Late thoughts: Did the Postgres server actually get installed? Do you have a

Re: [GENERAL] Install doesnt set SuperUser PW

On 12/13/2016 02:08 PM, Jovi Federici wrote: Just re-ran installer in Administrator mode with no difference. Correction on previous statement: the installed does ask for Paths but does not ask for a PW. I have no idea at this point. I do not run Windows anymore, so I have nothing to test

Re: [GENERAL] Install doesnt set SuperUser PW

On 12/13/2016 01:49 PM, Jovi Federici wrote: Hi Adrian, I did graphical installer is in https://www.enterprisedb.com/docs/en/9.6/instguide/PostgreSQL_Installation_Guide.1.08.html# Except I was not

Re: [GENERAL] CRM where pg is a first class citizen?

On 12/13/2016 12:36 PM, George Weaver wrote: I've never used it but what about: https://developer.sugarcrm.com/2012/08/03/like-postgresql-and-want-to-use-it-with-sugarcrm-check-out-a-new-community-project/ This killed the community(Open Source) edition going forward:

Re: [GENERAL] Install doesnt set SuperUser PW

On 12/13/2016 12:46 PM, Jovi Federici wrote: Hi Postgres, My installation of Postgress 9.6 did not include any setting of a SuperUser password so I'm at a loss. How did you determine this? Do I have a bad installation? I got it here:

Re: [GENERAL] Install doesnt set SuperUser PW

On Tue, Dec 13, 2016 at 1:46 PM, Jovi Federici wrote: > Hi Postgres, > > My installation of Postgress 9.6 did not include any setting of a > SuperUser password so I'm at a loss. > > Do I have a bad installation? > > I got it here: > >

[GENERAL] Install doesnt set SuperUser PW

Hi Postgres, My installation of Postgress 9.6 did not include any setting of a SuperUser password so I'm at a loss. Do I have a bad installation? I got it here: http://www.enterprisedb.com/postgresql-961-installers-win64?ls=Crossover=Crossover I'm running Windows 7 in 64 bit VM on a Mac Pro.

Re: [GENERAL] Is is safe to use SPI in multiple threads?

Thanks for your reply. Because of the one-backend-per-session concept of PG, I think I should bind one my DSL session to one bg worker only. It seems work. But is there a way to launch a bg worker when a new session starts, just like pg's per-session-backend do? Is it possible to run a bg worker

Re: [GENERAL] CRM where pg is a first class citizen?

On 12/13/2016 09:36 PM, George Weaver wrote: I've never used it but what about: https://developer.sugarcrm.com/2012/08/03/like-postgresql-and-want-to-use-it-with-sugarcrm-check-out-a-new-community-project/ That's one of the first thing I've read and it doesn't look as a good premise to make

Re: [GENERAL] CRM where pg is a first class citizen?

On Tue, Dec 13, 2016 at 3:36 PM, George Weaver wrote: > I've never used it but what about: > > https://developer.sugarcrm.com/2012/08/03/like-postgresql- > and-want-to-use-it-with-sugarcrm-check-out-a-new-community-project/ > > Cheers, > George Looks like not much came out of

Re: [GENERAL] CRM where pg is a first class citizen?

I've never used it but what about: https://developer.sugarcrm.com/2012/08/03/like-postgresql-and-want-to-use-it-with-sugarcrm-check-out-a-new-community-project/ Cheers, George On 13/12/2016 2:24 PM, Joshua D. Drake wrote: On 12/13/2016 12:19 PM, John R Pierce wrote: On 12/13/2016 10:19 AM,

Re: [GENERAL] Regrding:- Arduino-Postgresql Direct Connection

On 09/12/16 21:30, John R Pierce wrote: On 12/8/2016 8:56 PM, Roshan Jha wrote: In my project ,I have to send the data from the arduino to the direct postgresql for storing .So i want know that is it possible to make direct connection between arduino to postgresql ,If yes, then let me know,

Re: [GENERAL] CRM where pg is a first class citizen?

On Tue, 13 Dec 2016, John R Pierce wrote: CRM (Customer Relationship Manager) != CMS (Content Management System). John, True, and Django can be used for a CRM; there's an example by a North Carolina shop. Search the web for "django crm". I was going to use django but decided to make my CRM

Re: [GENERAL] CRM where pg is a first class citizen?

On 12/13/2016 12:24 PM, Joshua D. Drake wrote: Tryton is an ERP that has CRM functionality. Although it is a bit of a beast. indeed, most any ERP is pretty much a kitchen sink, trying to be all things.AR/AP/PR/PO/Inventory/etc/etc/etc. -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] CRM where pg is a first class citizen?

On 12/13/2016 12:19 PM, John R Pierce wrote: On 12/13/2016 10:19 AM, Joshua D. Drake wrote: I was looking for a open source CRM, PHP or python based, with a large community where Postgresql is a first class citizen. I'd prefer ease of use over features. DjangoCMS Drupal 7+ CRM (Customer

Re: [GENERAL] CRM where pg is a first class citizen?

On 12/13/2016 10:19 AM, Joshua D. Drake wrote: I was looking for a open source CRM, PHP or python based, with a large community where Postgresql is a first class citizen. I'd prefer ease of use over features. DjangoCMS Drupal 7+ CRM (Customer Relationship Manager) != CMS (Content

[GENERAL] vacuum freeze in 96

Hi, one of the major enhancements in 96 is skipping completely frozen pages in vacuum freeze. I assume that requires a special bit on the page. If I upgrade from 93 using pg_upgrade, that is re-using the data files, can it still do that? Or do I have to recreate the table? Thanks, Torsten

Re: [GENERAL] is this a known bug in 9.6?

Thanks Tom On Tue, Dec 13, 2016 at 7:22 PM, Tom Lane wrote: > I wrote: > > Yup, sure looks like a bug to me, especially since it seems to work as > > expected before 9.5. No idea offhand what broke it. > > The answer is, I broke it, through some ill-advised neatnik-ism :-(,

Re: [GENERAL] pg_dump and quoted identifiers

Thomas Kellerer writes: > Tom Lane schrieb am 13.12.2016 um 18:02: >> These cases work for me. Maybe your shell is doing something weird >> with the quotes? > Hmm, that's the default bash from CentOS 6 (don't know the exact version) I'm using bash from current RHEL6, should

Re: [GENERAL] is this a known bug in 9.6?

I wrote: > Yup, sure looks like a bug to me, especially since it seems to work as > expected before 9.5. No idea offhand what broke it. The answer is, I broke it, through some ill-advised neatnik-ism :-(, ie clearing a field I thought would be unused but it wasn't. Fix pushed. Thanks for the

Re: [GENERAL] CRM where pg is a first class citizen?

On 12/13/2016 08:58 AM, Ivan Sergio Borgonovo wrote: Hi, I was looking for a open source CRM, PHP or python based, with a large community where Postgresql is a first class citizen. I'd prefer ease of use over features. DjangoCMS Drupal 7+ JD Thanks -- Command Prompt, Inc.

Re: [GENERAL] pg_dump and quoted identifiers

On Tue, Dec 13, 2016 at 11:24 AM, Thomas Kellerer wrote: > David G. Johnston schrieb am 13.12.2016 um 18:05: > >> On Tue, Dec 13, 2016 at 9:43 AM, Pavel Stehule > >wrote: >> >> >> pg_dump -t '"Statuses"' postgres

Re: [GENERAL] pg_dump and quoted identifiers

Tom Lane schrieb am 13.12.2016 um 18:02: -bash-4.1$ pg_dump -d postgres -t '"Statuses"' pg_dump: no matching tables were found -bash-4.1$ pg_dump -d postgres -t 'public."Statuses"' pg_dump: no matching tables were found These cases work for me. Maybe your shell is doing

Re: [GENERAL] pg_dump and quoted identifiers

David G. Johnston schrieb am 13.12.2016 um 18:05: On Tue, Dec 13, 2016 at 9:43 AM, Pavel Stehule >wrote: pg_dump -t '"Statuses"' postgres ​To elaborate - your shell was removing the double-quotes. You need make it so after shell

Re: [GENERAL] pg_dump and quoted identifiers

On Tue, Dec 13, 2016 at 9:43 AM, Pavel Stehule wrote: > >> pg_dump -t '"Statuses"' postgres > > ​To elaborate - your shell was removing the double-quotes. You need make it so after shell processing the double-quotes remain. Wrapping the double-quote string in

Re: [GENERAL] pg_dump and quoted identifiers

Thomas Kellerer writes: > postgres=# create table "Statuses" (id integer); > CREATE TABLE > -bash-4.1$ pg_dump -d postgres -t "Statuses" > pg_dump: no matching tables were found This is expected since those quotes are eaten by the shell. > -bash-4.1$

[GENERAL] CRM where pg is a first class citizen?

Hi, I was looking for a open source CRM, PHP or python based, with a large community where Postgresql is a first class citizen. I'd prefer ease of use over features. Thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it http://www.borgonovo.net -- Sent via pgsql-general mailing list

Re: [GENERAL] pg_dump and quoted identifiers

2016-12-13 17:38 GMT+01:00 Thomas Kellerer : > Inspired by this question: > >http://dba.stackexchange.com/q/158044/1822 > > I tried that for myself, and it seems that pg_dump indeed can not parse > quoted identifiers: > > psql (9.6.1) > Type "help" for help. > >

Re: [GENERAL] is this a known bug in 9.6?

Thanks for confirming. Here are a few more examples that also work: with i(x) as (values (1::int)) select x from (select x from i union all select 3::int) b order by x desc limit 1; with i(x) as (values (1::int)) select max(x) from (select x from i union select 3::int) b; It also works with

[GENERAL] pg_dump and quoted identifiers

Inspired by this question: http://dba.stackexchange.com/q/158044/1822 I tried that for myself, and it seems that pg_dump indeed can not parse quoted identifiers: psql (9.6.1) Type "help" for help. postgres=# create table "Statuses" (id integer); CREATE TABLE postgres=#

Re: [GENERAL] is this a known bug in 9.6?

> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Tom Lane > Sent: Dienstag, 13. Dezember 2016 16:32 > To: Torsten Förtsch > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] is this a known bug in 9.6? >

Re: [GENERAL] is this a known bug in 9.6?

=?UTF-8?Q?Torsten_F=C3=B6rtsch?= writes: > postgres=# with i(x) as (values (1::int)), j(y) as (values (2::int)) select > x from (select x from i union all select y from j) b; > x > --- > 1 > 2 > (2 rows) > postgres=# with i(x) as (values (1::int)), j(y) as (values

Re: [GENERAL] When updating row that has TOAST column, is the TOAST column also reinserted ? Or just the oid to the value?

Albe Laurenz writes: > Dorian Hoxha wrote: >> When updating row that has TOAST column, is the TOAST column also inserted ? >> Or just the oid? > The TOAST table will remain unchanged by the UPDATE; you can see that with the > "pageinspect" contrib module: You can also

Re: [GENERAL] Appending to multidimentional array.

On Tue, Dec 13, 2016 at 6:08 AM, VENKTESH GUTTEDAR < venkteshgutte...@gmail.com> wrote: > Hello, > > Is there a way to append an array to a multidimentional array in > PL/PGSQL procedure? > > EG: > Array_1 = [][]; > Array_2 = '{1,2,3,4,5}'; > > Result should be : >Array_1 =

Re: [GENERAL] When updating row that has TOAST column, is the TOAST column also reinserted ? Or just the oid to the value?

Great info Albe! On 13/12/2016 16:20, Albe Laurenz wrote: Dorian Hoxha wrote: When updating row that has TOAST column, is the TOAST column also inserted ? Or just the oid? Say I have a 1MB value in the TOAST column, and I update the row by changing another column, and since every update is

Re: [GENERAL] Appending to multidimentional array.

Hello Chris Travers. Its working. You saved my day.:) Thanks a tons. On Tue, Dec 13, 2016 at 9:18 AM, Chris Travers wrote: > Array_1 :== Array_1 || Array[Array_2] > > I think > > On Tue, Dec 13, 2016 at 6:08 AM, VENKTESH GUTTEDAR < > venkteshgutte...@gmail.com>

Re: [GENERAL] When updating row that has TOAST column, is the TOAST column also reinserted ? Or just the oid to the value?

Dorian Hoxha wrote: > When updating row that has TOAST column, is the TOAST column also inserted ? > Or just the oid? > > Say I have a 1MB value in the TOAST column, and I update the row by changing > another column, and since > every update is an insert, will it also reinsert the toast-column

Re: [GENERAL] Appending to multidimentional array.

Array_1 :== Array_1 || Array[Array_2] I think On Tue, Dec 13, 2016 at 6:08 AM, VENKTESH GUTTEDAR < venkteshgutte...@gmail.com> wrote: > Hello, > > Is there a way to append an array to a multidimentional array in > PL/PGSQL procedure? > > EG: > Array_1 = [][]; > Array_2 =

[GENERAL] Appending to multidimentional array.

Hello, Is there a way to append an array to a multidimentional array in PL/PGSQL procedure? EG: Array_1 = [][]; Array_2 = '{1,2,3,4,5}'; Result should be : Array_1 = {{1,2,3,4,5}}; -- Regards : Venktesh Guttedar.

[GENERAL] Appending to multidimentional array.

Hello, Is there a way to append an array to a multidimentional array? EG: -- Regards : Venktesh Guttedar.

[GENERAL] When updating row that has TOAST column, is the TOAST column also reinserted ? Or just the oid to the value?

Hello friends, When updating row that has TOAST column, is the TOAST column also inserted ? Or just the oid? Say I have a 1MB value in the TOAST column, and I update the row by changing another column, and since every update is an insert, will it also reinsert the toast-column ? The column that I

[GENERAL] is this a known bug in 9.6?

Hi, this is a stock PGDG 9.6: postgres=# with i(x) as (values (1::int)), j(y) as (values (2::int)) select x from (select x from i union all select y from j) b; x --- 1 2 (2 rows) postgres=# with i(x) as (values (1::int)), j(y) as (values (2::int)) select max(x) from (select x from i union all

Re: [GENERAL] pg_upgrade 9.0 to 9.6

On 12/13/2016 1:57 AM, Mikhail wrote: Should i check all the production environments for the problems, mentioned in all interim versions release notes, is it enough only to check the last minor upgrade release note (9.6 --> 9.6.1) or there is another quick way to check if i should apply some

[GENERAL] pg_upgrade 9.0 to 9.6

Hi all, We've tested upgrading from postgresql 9.0.x to 9.6.1 on the test environment and everything passed fluently. But there are concerns about the production environments upgrade because of notes to some interim updates that recommends reindex and/or vacuuming to exclude data corruption,