Thread: message issued by INSERT commands

message issued by INSERT commands

From
Elielson Fontanezi
Date:
Hi!

    Fot these INSERT commands

test=> INSERT INTO friend VALUES (
test(> 'Cindy',
test(> 'Anderson',
test(> 'Denver',
test(> 'CO',
test(> 23
test(> );
INSERT 19054 1
test=> INSERT INTO friend VALUES (
test(> 'Sam',
test(> 'Jackson',
test(> 'Allentown',
test(> 'PA',
test(> 22
test(> );
INSERT 19055 1

    what means the numbers 19054 and 19055?
    Is the transaction ids?


..............................................
A Question...
Since before your sun burned hot in space and before your race was born, I
have awaited a question.

Elielson Fontanezi
DBA Technical Support - PRODAM
+55 11 5080 9493



Re: message issued by INSERT commands

From
Bruce Momjian
Date:
Those numbers are object ids, unique values give to each inserted row.

---------------------------------------------------------------------------

Elielson Fontanezi wrote:
> Hi!
>
>     Fot these INSERT commands
>
> test=> INSERT INTO friend VALUES (
> test(> 'Cindy',
> test(> 'Anderson',
> test(> 'Denver',
> test(> 'CO',
> test(> 23
> test(> );
> INSERT 19054 1
> test=> INSERT INTO friend VALUES (
> test(> 'Sam',
> test(> 'Jackson',
> test(> 'Allentown',
> test(> 'PA',
> test(> 22
> test(> );
> INSERT 19055 1
>
>     what means the numbers 19054 and 19055?
>     Is the transaction ids?
>
>
> ..............................................
> A Question...
> Since before your sun burned hot in space and before your race was born, I
> have awaited a question.
>
> Elielson Fontanezi
> DBA Technical Support - PRODAM
> +55 11 5080 9493
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026