Re: [GENERAL] Setting search_path ignored

Hello From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Guyren Howe Sent: Montag, 2. Oktober 2017 16:10 To: David G. Johnston Cc: PostgreSQL General Subject: Re: [GENERAL] Setting

Re: [GENERAL] PostgreSQL COPY Statement Error On Linux

Hello From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Osahon Oduware Sent: Dienstag, 12. September 2017 12:30 To: pgsql-general@postgresql.org Subject: [GENERAL] PostgreSQL COPY Statement Error On Linux Hi All, I am trying to utilize the

Re: [GENERAL] Issue with json_agg() and ordering

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Bob Jones > Sent: Freitag, 1. September 2017 10:12 > To: pgsql-general > Subject: [GENERAL] Issue with json_agg() and ordering >

Re: [GENERAL] Table create time

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of hamann.w@t- > online.de > Sent: Donnerstag, 31. August 2017 08:56 > To: pgsql-general@postgresql.org > Subject: [GENERAL] Table create time > > > Hi, > > is

Re: [GENERAL] 'value too long' and before insert/update trigger

Hi > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Kevin Golding > Sent: Donnerstag, 24. August 2017 07:08 > To: pgsql-general@postgresql.org > Subject: [GENERAL] 'value too long' and before insert/update trigger

Re: [GENERAL] COPY: row is too big

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of doganmeh > Sent: Freitag, 26. Mai 2017 14:08 > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] COPY: row is too big > > I am piggy-backing in this

Re: [GENERAL] Wiki editor privilege

Thanks! On 03/23/2017 10:11 AM, Magnus Hagander wrote: > On Thu, Mar 23, 2017 at 7:57 AM, Charles Clavadetscher > <clavadetsc...@swisspug.org <mailto:clavadetsc...@swisspug.org>> wrote: > > Hello > > I would like to upload the slides of my presentation at

[GENERAL] Wiki editor privilege

Hello I would like to upload the slides of my presentation at Nordic PGDay 2017. Could you please grant me edit privilege on the wiki? My user name is cclavadetscher Thank you and bye Charles -- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Treasurer Motorenstrasse 18 CH – 8005

Re: [GENERAL] How to define the limit length for numeric type?

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of vod vos > Sent: Montag, 13. März 2017 15:52 > To: rob stone > Cc: pgsql-general > Subject: Re: [GENERAL]

Re: [GENERAL] How to define the limit length for numeric type?

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of vod vos > Sent: Sonntag, 12. März 2017 08:01 > To: Pavel Stehule > Cc: pgsql-general > Subject: Re:

Re: [GENERAL] How to define the limit length for numeric type?

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of vod vos > Sent: Sonntag, 12. März 2017 07:15 > To: pgsql-general > Subject: [GENERAL] How to define the limit length for numeric

Re: [GENERAL] Fwd: parameter type is unknown error

Hallo Adrian > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver > Sent: Montag, 6. März 2017 15:13 > To: Günce Kaya <guncekay...@gmail.com>; Charles Clavadetscher > <clava

Re: [GENERAL] Fwd: parameter type is unknown error

Hello Günce > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Günce Kaya > Sent: Montag, 6. März 2017 13:37 > To: Charles Clavadetscher <clavadetsc...@swisspug.org> > Cc: pgsql-general@post

Re: [GENERAL] Fwd: parameter type is unknown error

Hello Günce From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Günce Kaya Sent: Montag, 6. März 2017 13:01 To: Charles Clavadetscher <clavadetsc...@swisspug.org> Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Fwd: paramete

Re: [GENERAL] Fwd: parameter type is unknown error

Hello From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Günce Kaya Sent: Montag, 6. März 2017 12:36 To: pgsql-general@postgresql.org Subject: [GENERAL] Fwd: parameter type is unknown error Hi all, I created a dummy table and related

Re: [GENERAL] column "waiting" does not exist

Hello From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Johann Spies Sent: Donnerstag, 2. März 2017 09:28 To: pgsql-general@postgresql.org Subject: [GENERAL] column "waiting" does not exist I have no idea what is causing this message in the logs

Re: [GENERAL] Listing missing records

As suggested > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ertan Küçükoglu > Sent: Sonntag, 19. Februar 2017 11:27 > To: pgsql-general@postgresql.org > Subject: [GENERAL] Listing missing records > > Hello, > >

Re: [GENERAL] Get tables ending with numbers

Hello Sathesh > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sathesh S > Sent: Mittwoch, 15. Februar 2017 07:17 > To: pgsql-general > Subject: [GENERAL] Get tables ending with

Re: [GENERAL] Special index for "like"-based query

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Job > Sent: Freitag, 30. Dezember 2016 11:42 > To: Francisco Olarte > Cc: David G. Johnston ; >

FW: [GENERAL] performance tuning postgresql 9.5.5.10 [enterprisedb]

Forwarding to list. -Original Message- From: ajmcello [mailto:ajmcell...@gmail.com] Sent: Freitag, 30. Dezember 2016 07:05 To: Charles Clavadetscher <clavadetsc...@swisspug.org> Subject: Re: [GENERAL] performance tuning postgresql 9.5.5.10 [enterprisedb] There are no connections

Re: [GENERAL] performance tuning postgresql 9.5.5.10 [enterprisedb]

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of ajmcello > Sent: Freitag, 30. Dezember 2016 05:54 > To: POSTGRES > Subject: [GENERAL] performance tuning postgresql 9.5.5.10

Re: [GENERAL] Book or other resource on Postgres-local code?

Hi From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Guyren Howe Sent: Donnerstag, 29. Dezember 2016 23:32 To: pgsql-general Subject: [GENERAL] Book or other resource on Postgres-local code? As an aside from my

Re: [GENERAL] Delete from table conditionally

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Arup Rakshit > Sent: Samstag, 17. Dezember 2016 08:39 > To: Pgsql-general > Subject: [GENERAL] Delete from table conditionally >

Re: [GENERAL] Recursive row level security policy

Hello again > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Charles > Clavadetscher > Sent: Freitag, 16. Dezember 2016 07:41 > To: 'Simon Charette' <charett...@gmail.com> > Cc: p

Re: [GENERAL] Recursive row level security policy

Hello Simon > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Simon Charette > Sent: Freitag, 16. Dezember 2016 07:02 > To: Charles Clavadetscher <clavadetsc...@swisspug.org> > Cc: pgsq

Re: [GENERAL] Recursive row level security policy

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Simon Charette > Sent: Freitag, 16. Dezember 2016 06:15 > To: pgsql-general@postgresql.org > Subject: [GENERAL] Recursive row level security policy > > Hello

Re: [GENERAL] Importing SQLite database

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver > Sent: Donnerstag, 8. Dezember 2016 16:09 > To: Igor Korot > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL]

Re: [GENERAL] max_connections limit violation not showing in pg_stat_activity

Hello Kevin Getting back at this. > -Original Message- > From: Kevin Grittner [mailto:kgri...@gmail.com] > Sent: Mittwoch, 23. November 2016 17:04 > To: Charles Clavadetscher <clavadetsc...@swisspug.org> > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERA

Re: [GENERAL] Who dropped a role?

Hello From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Durumdara Sent: Donnerstag, 8. Dezember 2016 10:13 To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Who dropped a role? Hello! Sorry, meanwhile I found it as Group Role. I

Re: [GENERAL] When to use COMMENT vs --

Hi Rich > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Chris Travers > Sent: Mittwoch, 7. Dezember 2016 17:12 > To: Postgres General > Subject: Re: [GENERAL] When to use COMMENT vs

Re: [GENERAL] Extensions and privileges in public schema

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Paul Ramsey > Sent: Sonntag, 4. Dezember 2016 22:24 > To: Lee Hachadoorian > Cc: pgsql-general >

Re: [GENERAL] max_connections limit violation not showing in pg_stat_activity

Hello Kevin Thank you very much for your input. I appreciate it very much. > -Original Message- > From: Kevin Grittner [mailto:kgri...@gmail.com] > Sent: Dienstag, 22. November 2016 22:37 > To: Charles Clavadetscher <clavadetsc...@swisspug.org> > Cc: pgsql-g

[GENERAL] max_connections limit violation not showing in pg_stat_activity

the database, but is the only one where we expect such peaks). So I'd be very grateful for advice on this subject. Thank you. Regards Charles -- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Treasurer Motorenstrasse 18 CH – 8005 Zürich http://www.swisspug.org

Re: [GENERAL] Request to share information regarding deadlock in postgresql-9.3.6

Rethinking that > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Charles > Clavadetscher > Sent: Donnerstag, 17. November 2016 09:12 > To: 'Yogesh Sharma' <yogesh1.sha...@nectechnologie

Re: [GENERAL] Request to share information regarding deadlock in postgresql-9.3.6

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Yogesh Sharma > Sent: Donnerstag, 17. November 2016 08:31 > To: John R Pierce ; pgsql-general@postgresql.org > Subject: Re: [GENERAL]

Re: [GENERAL] Request to share information regarding errors

Hello Yogesh > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Yogesh Sharma > Sent: Mittwoch, 16. November 2016 07:59 > To: Charles Clavadetscher <clavadetsc...@swisspug.org>; > pgsq

Re: [GENERAL] Request to share information regarding errors

Good morning > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Yogesh Sharma > Sent: Mittwoch, 16. November 2016 07:09 > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Request to share information

Re: [GENERAL] pg_sample

N PGP SIGNATURE- iEYEAREDAAYFAlgG4NkACgkQvJuQZxSWSsge4ACePhBOBtBFnGNxXt5qpY7X+w3o d04AoKTzAgxcaqy8qfIE0LPuzG9x0KIU =sS+m -END PGP SIGNATURE- -- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Treasurer Motorenstrasse 18 CH – 8005 Zürich http://w

Re: [GENERAL] Restricted access on DataBases

Hello > > Also try this: > > ALTER DEFAULT PRIVILEGES FOR ex_mainuser GRANT INSERT, SELECT, UPDATE, > > DELETE, TRUNCATE, REFERENCES, TRIGGER > >ON TABLES TO ex_dbuser; > > > > You execute the ALTER DEFAULT PRIVILEGES as su, so the grant applies to > > objects created by su and

Re: [GENERAL] Question on replace function [solved]

Hello Tom and Adrian > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver > Sent: Sonntag, 25. September 2016 18:38 > To: Tom Lane <t...@sss.pgh.pa.us>; Charles Clavade

Re: [GENERAL] Question on replace function [solved]

Hi Rob On 09/25/2016 01:39 PM, rob stone wrote: > > On Sun, 2016-09-25 at 10:29 +0200, Charles Clavadetscher wrote: >> Hello >> >> I am using PostgreSQL 9.4.7 on x86_64-unknown-linux-gnu, compiled by >> gcc >> (Debian 4.7.2-5) 4.7.2, 64-bit >&g

[GENERAL] Question on replace function

doing wrong? Thank you for your help. Charles -- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Treasurer Motorenstrasse 18 CH – 8005 Zürich http://www.swisspug.org +---+ | __ ___ | | /)/ \/ \ | | ( / ___\) | | \(/ o) ( o

Re: [GENERAL] Restricted access on DataBases

Hello From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Durumdara Sent: Mittwoch, 14. September 2016 17:13 Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Restricted access on DataBases Dear Adrian and Charles! I tried to create

Re: [GENERAL] Restricted access on DataBases

Hello I did oversee the additional questions... On 09/07/2016 06:45 PM, Charles Clavadetscher wrote: Hello On 09/07/2016 03:24 PM, Durumdara wrote: Dear Everybody! I read the documentation based on your example. First reactions. 2016-09-05 18:25 GMT+02:00 Charles Clavadetscher <clavade

Re: [GENERAL] Restricted access on DataBases

Hello On 09/07/2016 03:24 PM, Durumdara wrote: Dear Everybody! I read the documentation based on your example. First reactions. 2016-09-05 18:25 GMT+02:00 Charles Clavadetscher <clavadetsc...@swisspug.org <mailto:clavadetsc...@swisspug.org>>: GRANT us_a, us_b, us_c T

Re: [GENERAL] Check if there 6 last records of same type without gaps

Hello > On 06.09.2016, at 14:35, Alexander Farber wrote: > > No, I am sorry - for struggling with probably basic questions, but without > GROUP BY I get another error: > > org.postgresql.util.PSQLException: ERROR: column "words_moves.played" must > appear in the

Re: [GENERAL] Restricted access on DataBases

Hello On 09/05/2016 05:56 PM, Charles Clavadetscher wrote: Hello On 09/05/2016 04:19 PM, Adrian Klaver wrote: On 09/05/2016 05:45 AM, Durumdara wrote: Dear PG-masters! We want to put more databases to one server, to "public" schema: DB_A, DB_B, DB_C. The PUBLIC schema is contai

Re: [GENERAL] Restricted access on DataBases

understanding what you are doing. Charles Thank you for the help. information, or an example! DD -- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Treasurer Motorenstrasse 18 CH – 8005 Zürich http://www.swisspug.org +---+ | __ ___ |

Re: [GENERAL] Upgrading using pg_dumpall

Hi On 09/04/2016 05:16 PM, Charles Clavadetscher wrote: Hi On 09/04/2016 05:14 PM, Rich Shepard wrote: On Sat, 3 Sep 2016, Adrian Klaver wrote: Or if you are fine running the 9.5 instance at port 5432, what happens if you do?: psql -d postgres -U some_user -p 5432 $ psql -d postgres -U

Re: [GENERAL] Upgrading using pg_dumpall

already answered that. You can set the connection authentication method to trust. This can have some risks, however. Bye Charles Thanks again, Rich -- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Treasurer Motorenst

Re: [GENERAL] Upgrading using pg_dumpall

I ran initdb from the command line as user postgres. Rich -- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Treasurer Motorenstrasse 18 CH – 8005 Zürich http://www.swisspug.org +---+ | __ ___

Re: [GENERAL] Upgrading using pg_dumpall

: password authentication failed for user "rshepard" Does the user rshepard exist in the new 9.5 instance? What was the error message? As above. Thanks, Rich -- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Treasurer Motorenstrasse 18 CH – 8005 Zü

Re: [GENERAL] RETURNS TABLE function: ERROR: column reference "word" is ambiguous

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alexander Farber > Sent: Mittwoch, 10. August 2016 14:54 > To: pgsql-general > Subject: [GENERAL] RETURNS TABLE function: ERROR:

Re: [GENERAL] lower() silently fails for 9.5.3 on Windows, but works on Mac, Linux

Hello Alexander > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alexander Farber > Sent: Montag, 8. August 2016 10:21 > Cc: pgsql-general > Subject: Re: [GENERAL] lower() silently

Re: [GENERAL] lower() silently fails for 9.5.3 on Windows, but works on Mac, Linux

Hello > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alexander Farber > Sent: Montag, 8. August 2016 10:12 > Cc: pgsql-general > Subject: Re: [GENERAL] lower() silently fails for 9.5.3 on Windows, but works >

Re: [GENERAL] lower() silently fails for 9.5.3 on Windows, but works on Mac, Linux

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Charles > Clavadetscher > Sent: Montag, 8. August 2016 09:30 > To: 'Alexander Farber' <alexander.far...@gmail.com>; 'pgsql-ge

Re: [GENERAL] lower() silently fails for 9.5.3 on Windows, but works on Mac, Linux

Hello > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alexander Farber > Sent: Montag, 8. August 2016 09:10 > To: pgsql-general > Subject: Re: [GENERAL] lower() silently fails for 9.5.3 on Windows, but works >

Re: [GENERAL] Extract data from JSONB

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Michael Paquier > Sent: Montag, 8. August 2016 05:24 > To: Alex Magnum > Cc: Postgres General > Subject:

Re: [GENERAL] Log all queries before migration ?

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of ben.play > Sent: Mittwoch, 3. August 2016 15:29 > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Log all queries before migration ? > > Hi guys, >

Re: [GENERAL] Proposal "stack trace" like debugging option in PostgreSQL

function inner_func() line 5 at GET DIAGNOSTICS PL/pgSQL function outer_func() line 3 at RETURN CONTEXT: PL/pgSQL function outer_func() line 3 at RETURN outer_func 1 (1 row) Regards Charles -- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Tre

Re: [GENERAL] Array value from table as parameter

Hello > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Aislan Luiz Wendling > Sent: Mittwoch, 20. Juli 2016 19:17 > To: pgsql-general@postgresql.org > Subject: [GENERAL] Array value from table as parameter > > Hi, > > I need to pass an array

Re: [GENERAL] For storing XML version in our table.

> From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of zubair alam > Sent: Mittwoch, 20. Juli 2016 09:09 > To: pgsql-general@postgresql.org > Subject: [GENERAL] For storing XML version in our table. Hi How i can store my xml data with their

Re: [GENERAL] Running query without trigger?

Good morning > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of hamann.w@t- > online.de > Sent: Samstag, 9. Juli 2016 08:20 > To: pgsql-general@postgresql.org > Subject: [GENERAL] Running query without trigger? > >

Re: [GENERAL] How SQL SELECT * statement works in Postgres?

a good start: https://www.postgresql.org/docs/9.5/static/overview.html Regards, Charles Regards, SSR -- Charles Clavadetscher Swiss PostgreSQL Users Group http://www.swisspug.org http://www.pg

Re: [GENERAL] Ascii Elephant for text based protocols - Final function proposal

Hello again > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Charles > Clavadetscher > Sent: Dienstag, 17. Mai 2016 14:50 > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Ascii El

Re: [GENERAL] Ascii Elephant for text based protocols - Final function proposal

xt based protocols - Final > > On Tue, May 17, 2016 at 06:58:14AM +0200, Charles Clavadetscher wrote: > > > A question to the naming. I find pg_logo() also a good name, but is > > the prefix pg_* not reserved for system functions? Of course I could > > use the name I

Re: [GENERAL] Fast way to delete big table?

Hello > The reason I dont have condition when selecting is it's faster than having. > Because my aim is to go through every row, find values of few columns and > append them to a summary table. Then > delete the row from the table. So find the rows on the fly is fine for me. > > I have tried to

Re: [GENERAL] Ascii Elephant for text based protocols - Final

Hello On 05/16/2016 10:50 PM, Michael Paquier wrote: On Tue, May 17, 2016 at 5:13 AM, Karsten Hilbert wrote: select pg_logo(); seems like a good idea to me :-) If you propose a patch with a function that returns a setof text, I am sure it would get some

Re: [GENERAL] Connections - Postgres 9.2

Hello > On 16.05.2016, at 18:32, Francisco Olarte wrote: > > Hi Lucas > >> On Mon, May 16, 2016 at 4:10 AM, Lucas Possamai wrote: >> >> Those IDLE connections, might be because the user/application didn't commit >> the transaction? > > ​IIRC

Re: [GENERAL] Connections - Postgres 9.2

Hello > On 16.05.2016, at 04:10, Lucas Possamai wrote: > > Hi guys, > > > > Those IDLE connections, might be because the user/application didn't commit > the transaction? I think that idle means that a client is connected but is doing nothing. Possibly It includes

Re: [GENERAL] Ascii Elephant for text based protocols - Final

Hi all OK. I must come to an end with this task. This is what I find a decent final version and I plan to use it in my SwissPUG signature until the end of the year. ++ | __ ___| | /)/ \/ \ | | ( / ___\) | | \(/ o) ( o)

Re: [GENERAL] Ascii Elephant for text based protocols

\(/ o) ( o) ) \_ (_ ) \ ) _/ \ /\_/\)/ \/ | | |_/ <-- -- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Motorenstrasse 18 CH - 8005 Zürich http://www.swisspug.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To ma

Re: [GENERAL] Build postgresql

to get static libs? Thanks -- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Motorenstrasse 18 CH - 8005 Zürich http://www.swisspug.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] View not allowing to drop column (Bug or Feature enhancement )

ortunately I have no answer to that, but somebody else may. Regards Charles -- Thanks and Regards, Sachin Kotwal -- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Motorenstrasse 18 CH - 8005 Zürich http://www.swisspug.org -- Sent via pgsql-general mailing list (pgsql-general@post

Re: [GENERAL] Fast way to delete big table?

. This notice should not be removed. -- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Motorenstrasse 18 CH - 8005 Zürich http://www.swisspug.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] View not allowing to drop column (Bug or Feature enhancement )

d additional columns to the end of the list. The calculations giving rise to the output columns may be completely different. Regards, Charles Thanks. -- Shrikant Bhende +91-9975543712 -- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Motorenstrasse 18 CH - 8005 Zürich http://www.swisspug.org

Re: [GENERAL] Ascii Elephant for text based protocols

is entirely up to you. -- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Motorenstrasse 18 CH - 8005 Zürich http://www.swisspug.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Ascii Elephant for text based protocols

Hello Tom Thanks for your feedback. On 05/16/2016 05:31 AM, Tom Lane wrote: Charles Clavadetscher <clavadetsc...@swisspug.org> writes: On 05/16/2016 02:51 AM, dandl wrote: * the trunk is (how shall I put this?) somewhat phallic. Mmh... This could apply to any elephant picture. I

Re: [GENERAL] Ascii Elephant for text based protocols

, 16 May 2016 9:11 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Ascii Elephant for text based protocols On 2016-05-15 14:02:56 +0200, Charles Clavadetscher wrote: ++ | __ ___| | /)/ \/ \ | | ( / ___\) | | \(/ o

[GENERAL] Ascii Elephant for text based protocols

even be added to the list of available logos? Enjoy and thanks for any feedback. Charles Swiss PostgreSQL Users Group c/o Charles Clavadetscher Motorenstrasse 18 CH - 8005 Zürich http://www.swisspug.org

Re: [GENERAL] Thoughts on "Love Your Database"

Good morning > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Guyren Howe > Sent: Mittwoch, 4. Mai 2016 06:11 > To: pgsql-general > Subject: [GENERAL] Thoughts on "Love Your Database"

Re: [GENERAL] Why are data files stored in /var/lib

Hello Manuel > -Original Message- > From: Manuel Gómez [mailto:tar...@gmail.com] > Sent: Samstag, 30. April 2016 05:45 > To: Charles Clavadetscher <clavadetsc...@swisspug.org> > Cc: Postgres General <pgsql-general@postgresql.org> > Subject: Re: [GENERAL] Why

[GENERAL] Why are data files stored in /var/lib

Hello I use version 9.5 on Linux Mint 17.3. I had a discussion yesterday with some friends, who are sysadmins about the location of database files. In a default installation from a distribution (apt-get install) PostgreSQL creates a cluster unter /var/lib/. According to my colleagues /var/lib

Re: [GENERAL] 9.5: tsvector problem

life itself, my lips will praise you. (Psalm 63:3) -- Swiss PostgreSQL Users Group c/o Charles Clavadetscher Motorenstrasse 18 CH - 8005 Zürich http://www.swisspug.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] max_stack_depth problem though query is substantially smaller

Hello We have a process in R which reads statistical raw data from a table and computes time series values from them. The time series values are in a hstore field with the date as the key and the value as the value. The process writes the computed value into a temporary table and locks the

Re: [GENERAL] CONCAT returns null

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Andreas Kretschmer > Sent: Sonntag, 28. Februar 2016 11:30 > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] CONCAT returns null > > Sterpu Victor

Re: [GENERAL] CONCAT returns null

Hello again > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Charles > Clavadetscher > Sent: Sonntag, 28. Februar 2016 11:24 > To: 'Sterpu Victor' <vic...@caido.ro>; 'PostgreSQL Ge

Re: [GENERAL] CONCAT returns null

Hello Just a short question to that. > CONCAT(f.nrfo, '/', TO_CHAR(fd1.validfrom, '-MM-DD'), f2.nrfo, > TO_CHAR(fd7.validfrom, '-MM-DD'), > DATE(fd5.validto)-DATE(fd1.validfrom)) > that works fine but when I change to this(I added a ' with '): > ARRAY_AGG(CONCAT(f.nrfo, '/',

Re: [GENERAL] ERROR: missing FROM-clause entry for table

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of bigkev > Sent: Mittwoch, 10. Februar 2016 08:11 > To: pgsql-general@postgresql.org > Subject: [GENERAL] ERROR: missing FROM-clause entry for table > > I am

Re: [GENERAL] ERROR: check constraint - PostgreSQL 9.2

; Subject: Re: [GENERAL] ERROR: check constraint - PostgreSQL 9.2 > > On 1/24/16, Christophe Pettus <x...@thebuild.com> wrote: > > > > On Jan 24, 2016, at 9:01 PM, Charles Clavadetscher > > <clavadetsc...@swisspug.org> wrote: > > > >> What is the poin

Re: [GENERAL] ERROR: check constraint - PostgreSQL 9.2

Hello Althought both options are technically correct, I guess that the first one is the only reasonable one. What is the point of having a check constraint that is not checked? If all fields in the check constraint must not be null there must be a reason for it. Possibly the "wrong" data is

Re: [GENERAL] Giving error for function

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sachin Srivastava > Sent: Dienstag, 12. Januar 2016 08:40 > To: pgsql-general@postgresql.org >> PG-General Mailing List > >

Re: [GENERAL] Slow Query - PostgreSQL 9.2

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Saulo Merlo > Sent: Montag, 11. Januar 2016 08:12 > To: Vitaly Burovoy > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL]

Re: [GENERAL] Function error

Hello If I understand you correctly you have two functions create_catexp_ss_1 and create_catexp_ss_2 that you then call from create_catexp_master. If so then you probably need to change the call to them: > -- Exposure for single supplier without category filtering >

Re: [GENERAL] How do I implement a .XSD in Postgres?

Hello XML is an extensible object description language and XSD is not an XML derivative, but an implementation of the XML extensibility as a replacement for DTD. It is finally nothing else than an XML file following the validation schema of itself (

Re: [GENERAL] Strange syntax with select

Hello I am not in clear what your use case is, but you may have a look at that: http://www.depesz.com/2013/02/25/variables-in-sql-what-how-when/ The bottom line is that in a psql interactive session you cannot really set a variable as the result of a select statement (or at least I

Re: [GENERAL] Transfer db from one port to another

Hello Killian >> I want to transfer my db with three schemas from port 5432 to port 5532 to >> use >> within the bitnami stack. I have used pgAdmin to create a backup.sql and when >> using pgAdmin to restore the .sql to port 5532 I get the following error > >Try it with plain pg_dump. > >pg_dump

Re: [GENERAL] Transfer db from one port to another

From: Killian Driscoll [mailto:killiandrisc...@gmail.com] Sent: Mittwoch, 23. Dezember 2015 11:02 To: Charles Clavadetscher <clavadetsc...@swisspug.org> Cc: Andreas Kretschmer <akretsch...@spamfence.net>; pgsql-general <pgsql-general@postgresql.org> Subject: Re: [GENERAL] Tr

Re: [GENERAL] Transfer db from one port to another

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Killian Driscoll Sent: Mittwoch, 23. Dezember 2015 11:19 To: John R Pierce Cc: pgsql-general Subject: Re: [GENERAL] Transfer db from one port to

Re: [GENERAL] Transfer db from one port to another

We had that already upthread. Did you set the path to the bin dir of PostgreSQL as of previous posts? Regards Charles From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Killian Driscoll Sent: Mittwoch, 23. Dezember 2015 15:14 To: Adrian

  1   2   >