Hi list,
I know that serials must be created like this.
Create the Serial
Create a field table and reffers to the pre-created serial.
Now I noticed that it is possible to use the default value. I am almost
quite sure that this is an alternative way and non polite.
I would like to know if I am
Yes you are right, I means sequences.
The second way is better for me that have Id (PK) fields not defined as
Sequences. Now it is much more difficult to change the type of my PK than
define a Default value. I am just concerned about the consistency of this
sequence. Could you make me more eas
Hi list,
I would like to know if an statement like.
Insert into foo values (1,'Brazil');
Makes an ACID transaction. I am wondered if i must have a Begin...Commit
statemnt to garantee my ACIDs transactions.
Regards ,
--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozill
On 3/11/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
Insert into foo values (1,'Brazil');
Assuming you're in psql or using the drivers in autocommit mode, then
yes, it's ACID compliant. Individual statements are treated as an
implicit transaction unless you create an explicit tra
Perfect. I just don't know what drivers you are talking about (odbc maybe).
More perfect is becouse you answare me in only 1 minute. What community
don't is ?
Ezequias
2007/3/11, Jonah H. Harris <[EMAIL PROTECTED]>:
On 3/11/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
> Insert i
On Sun, Mar 11, 2007 at 01:05:12PM -0300, Ezequias Rodrigues da Rocha wrote:
> I would like to know if an statement like.
>
> Insert into foo values (1,'Brazil');
>
> Makes an ACID transaction. I am wondered if i must have a Begin...Commit
> statemnt to garantee my ACIDs transactions.
http://ww
Sorry my mistake it was 32 minutes. I am confusing with gmail here.
Anyway today is sunday and it is more difficult to have a reply from
community. Anyway thanks.
Ezequias
2007/3/11, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]>:
Perfect. I just don't know what drivers you are talking about
am Sun, dem 11.03.2007, um 11:20:33 -0300 mailte Ezequias Rodrigues da Rocha
folgendes:
> nextval('mySerial_id'::regclass)
>
> What is regclass ?
An Object Identifier for relation names.
See http://www.postgresql.org/docs/8.1/interactive/datatype-oid.html
Andreas
--
Andreas Kretschmer
Konta
On 3/11/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
Perfect. I just don't know what drivers you are talking about (odbc maybe).
As the server no longer supports server-side autocommit, I believe all
of the drivers create an explicit transaction behind the scenes when
the user req
