Hi,
you can use the UNIQUE constraint with two columns: UNIQUE(CustID, Count).
regards,
Szymon Lipiński
On 1 September 2016 at 11:28, Michelle Konzack <linux4miche...@gmail.com>
wrote:
> Hello to all,
>
> after a period of silence from Debian, Courier, PHP and PostgreSQL I
On 21 May 2016 at 11:28, Chris Travers <chris.trav...@gmail.com> wrote:
>
>
> On Fri, May 20, 2016 at 10:43 PM, Guyren Howe <guy...@gmail.com> wrote:
>
>> On May 20, 2016, at 13:38 , Pierre Chevalier Géologue <
>> pierrechevalierg...@free.fr> wrote:
>
On 20 May 2016 at 22:43, Guyren Howe <guy...@gmail.com> wrote:
> On May 20, 2016, at 13:38 , Pierre Chevalier Géologue <
> pierrechevalierg...@free.fr> wrote:
> >
> > Le 04/05/2016 18:29, Szymon Lipiński a écrit :
> >> On the other hand, when I was trying t
On 21 May 2016 at 00:08, Steve Atkins <st...@blighty.com> wrote:
>
> > On May 20, 2016, at 1:43 PM, Guyren Howe <guy...@gmail.com> wrote:
> >
> > On May 20, 2016, at 13:38 , Pierre Chevalier Géologue <
> pierrechevalierg...@free.fr> wrote:
> >>
ase will
always be inconsistent" and "Indexes are useless, they don't give anything
except for slowing down the database". So, don't believe in everything
"wise" people say, just think, and check on your own.
--
regards Szymon Lipiński
There are
>> breakpoints and such in PGAdmin, but I'll be that doesn't work for
>> other languages.
>>
>>
> There is a unit test framework for Postgres
>
> http://pgtap.org/
>
>
>
Right, and it is quite painful to use compared to writing tests as some
external program.
--
regards Szymon Lipiński
ns when they could be making more money? But
> this is far to often the case and the root cause is they did not have the
> right tool (pun not intended) for the job.
>
> On Wed, May 4, 2016 at 1:33 PM, Szymon Lipiński <mabew...@gmail.com>
> wrote:
>
>>
>>
>> On
erson can pick up.
>
> On Wed, May 4, 2016 at 12:29 PM, Szymon Lipiński <mabew...@gmail.com>
> wrote:
>
>>
>>
>> On 4 May 2016 at 18:14, Will McCormick <wmccorm...@gmail.com> wrote:
>>
>>> I agree it's typically political but so are mos
se it is always simpler to migrate
a database treated like a CSV file, where all the logic (including
constraints) is in an external application. But do we really want that?
On the other hand, when I was trying to store all my logic in a database,
there was just one thing that made me hate it. Testing. Testing the
procedures inside the database was not easy, not funny, and too much time
consuming.
--
regards Szymon Lipiński
d be about something else, start from an ORM, and
show how to translate it to much better SQL, as ORMs are the things
programmers usually understand, and they really don't bother that using
them can be a bad idea.
--
regards Szymon Lipiński
logic to a database, then usually the
management said "no, that's not doable, as we will have trouble with
finding good sql programmers later", and we were still writing all the
logic outside the database.
--
regards Szymon Lipiński
11 matches
Mail list logo