Alvaro,
I am using VB.NET. How to enable locking from within VB.NET for PostgreSQL?
Which command need to be executed?
Alvaro Herrera-7 wrote:
>
>>Lock the table beforehand. Only one user can be getting the
>>max(ReceiptNo) that way.
>
>>Alternatively, you could use userlocks, so that you c
RPK wrote:
>
> Jorge,
>
> For other tables I have ID field which is incremented by sequence. But for
> this table, there is not ID field. Receipt No will be incremented by finding
> the max value from the existing Receipt Nos. corresponding to that Book No.
> This case has a drawback as compared
Jorge,
For other tables I have ID field which is incremented by sequence. But for
this table, there is not ID field. Receipt No will be incremented by finding
the max value from the existing Receipt Nos. corresponding to that Book No.
This case has a drawback as compared to the sequences in other
Em Sábado 24 Fevereiro 2007 03:28, RPK escreveu:
> First, can a primary key field be only one? I mean can I define a primary
> containing two fields.
>
> I have a table called "Payments" where there are two fields, "ReceiptNo"
> and "PaymentDate". If I take "ReceiptNo" only as a primary key then ch
RPK wrote:
> First, can a primary key field be only one? I mean can I define a primary
> containing two fields.
As many as you like :)
>
> I have a table called "Payments" where there are two fields, "ReceiptNo" and
> "PaymentDate". If I take "ReceiptNo" only as a primary key then chances are
>
First, can a primary key field be only one? I mean can I define a primary
containing two fields.
I have a table called "Payments" where there are two fields, "ReceiptNo" and
"PaymentDate". If I take "ReceiptNo" only as a primary key then chances are
of "primary key violation". Because in some pl
