message issued by INSERT commands

Started by Elielson Fontaneziover 23 years ago2 messagesgeneral
Jump to latest
#1Elielson Fontanezi
ElielsonF@prodam.sp.gov.br

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

#2Bruce Momjian
bruce@momjian.us
In reply to: Elielson Fontanezi (#1)
Re: message issued by INSERT commands

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