On 2/28/16, John R Pierce wrote:
> I don't see why anyone with delete privileges shouldn't be able to
> truncate (after all, thats the same as deleting all records).
Firstly, because you can prevent deleting some rows by a trigger;
TRUNCATE doesn't deal with rows.
Secondary, TRUNCATE is _NOT_ MVC
On 2/28/2016 8:58 PM, Tom Lane wrote:
>I should the check for whether a given user can or cannot analyze a table
>should be whether the user has INSERT, UPDATE, or DELETE privileges.
By that argument, we should allow anyone with any write access to do
TRUNCATE. Or perhaps even DROP TABLE. I'm
On Sun, Feb 28, 2016 at 9:58 PM, Tom Lane wrote:
> "David G. Johnston" writes:
> > Given the amount of damage a person with write access to a table can get
> > into it seems pointless to not allow them to analyze the table after
> their
> > updates - since best practices would say that normal wo
"David G. Johnston" writes:
> Given the amount of damage a person with write access to a table can get
> into it seems pointless to not allow them to analyze the table after their
> updates - since best practices would say that normal work with a table
> should not be performed by an owner.
> I s
Given the amount of damage a person with write access to a table can get
into it seems pointless to not allow them to analyze the table after their
updates - since best practices would say that normal work with a table
should not be performed by an owner.
I should the check for whether a given use
On 02/28/2016 09:20 AM, Karsten Hilbert wrote:
On Sun, Feb 28, 2016 at 09:09:02AM -0800, Adrian Klaver wrote:
I have found that my best design tool is a legal pad and a pencil/pen.
http://www.howtomakesenseofanymess.com/
Wow, that is an interesting link. Have just skimmed it at this
What exactly are you trying to do? Dump/backup your data (e.g. pg_dump)?
Read binary data from a table? If so, what field type (bytea, blob, ...)?
Export to where?
Cheers,
Steve
On Sun, Feb 28, 2016 at 9:12 AM, drum.lu...@gmail.com
wrote:
> Hi all,
>
>
> Which command would be to export the bi
On Sun, Feb 28, 2016 at 09:09:02AM -0800, Adrian Klaver wrote:
> I have found that my best design tool is a legal pad and a pencil/pen.
http://www.howtomakesenseofanymess.com/
Karsten Hilbert
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E4
This has been solved...
The difference between the files must be the indexes...
All good now.
Thank you
On 26 February 2016 at 17:26, drum.lu...@gmail.com
wrote:
> Hi all,
>
>
> I'm doing the pg_restore now in a 1.5TB file:
>
> *# ls -la*
>
> postgres postgres 1575324616939 Feb 20 13:55 devdb_
Hi all,
Which command would be to export the binary data for a table?
I was unable to find it...
Thanks
On 02/28/2016 06:09 AM, Aaron Christensen wrote:
On Sun, Feb 28, 2016 at 12:36 AM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 02/27/2016 09:19 PM, Aaron Christensen wrote:
There is somewhat a method to this madness :). There isn't a
formula
that de
Adrian Klaver wrote:
>>
>> NULL concat with a value returns NULL. You can avoid that using
>> COALESCE(value, ''), that returns the value, or, if the value NULL, ''.
>
>
> http://www.postgresql.org/docs/9.5/interactive/functions-string.html
> "
> concat(str "any" [, str "any" [, ...] ]) text
On 02/28/2016 02:30 AM, Andreas Kretschmer wrote:
Sterpu Victor wrote:
Hello
I have this concat:
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
On Sun, Feb 28, 2016 at 1:15 AM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Sat, Feb 27, 2016 at 10:36 PM, Adrian Klaver > wrote:
>
>> On 02/27/2016 09:19 PM, Aaron Christensen wrote:
>>
>>> There is somewhat a method to this madness :). There isn't a formula
>>> that determines
On Sun, Feb 28, 2016 at 12:36 AM, Adrian Klaver
wrote:
> On 02/27/2016 09:19 PM, Aaron Christensen wrote:
>
>> There is somewhat a method to this madness :). There isn't a formula
>> that determines outcome. They will just be arbitrary values that I
>> assign.
>>
>> Obviously, I'm new to SQL bu
The problem was from PG Admin that is not displaing cells with a high
amount of data.
In the application the query is working well.
-- Original Message --
From: "Sterpu Victor"
To: "PostgreSQL General"
Sent: 28/2/2016 12:02:47 PM
Subject: [GENERAL] CONCAT returns null
Hello
I have t
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 w
Sterpu Victor wrote:
> Hello
>
> I have this concat:
> 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,
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' ; 'PostgreSQL General'
>
> Subject: Re: [GENERAL] CONCAT returns n
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, '/', TO_CHAR(fd1.
Hello
I have this concat:
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, '/', TO_CHAR(fd1.validfrom, '-MM
21 matches
Mail list logo
