PostgreSQL
La base de données la plus sophistiquée au monde.

Ouverture de session

Navigation

Contactez-nous

Administration du site :
"equipe chez postgresqlfr point org"

Contact presse :
"fr chez postgresql point org"

Contact association :
"bureau chez postgresqlfr point org"

Questions PostgreSQL :
 IRC :
  serveur irc.freenode.net
  canal #postgresqlfr

Recherche

Accéder aux archives

« Octobre 2008  
Lun Mar Mer Jeu Ven Sam Dim
  1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31  

Syndication

Flux XML

Sondage

Quelle est la version de PostgreSQL la plus répandue sur vos serveurs ?
8.3
10%
8.2
42%
8.1
40%
8.0
2%
7.4
6%
7.3 ou antérieure
0%
Nombre de votes: 48
3 commentaires | anciens sondages
Accueil » forums » Technique - odbc

Export données Postgres vers SQL Server

Technique - odbc | Export données Postgres vers SQL Server

Par frafga le 07/12/2006 - 12:08

Bonjour,

Je souhaiterais savoir sous quel format (à part le fichier texte) il faut que j'exporte mes données Postgres pour pouvoir les importer rapidement dans SQL Server.
Je souhait réaliser cet export car j'ai des problèmes pour accéder aux données stockées dans Postgres. J'ai installé le dernier driver 08.02.02 et lorsque j'accède à mes données via SPSS (soft statistique) je visualise mes DB, mes tables mais lorsque je sélectionne une table, une fois sur 3 je ne visualise pas les colonnes.

Je vous remercie.

frafga

[ sujet précédent | sujet suivant ]

Options d'affichage des commentaires

Sélectionnez la méthode d'affichage des commentaires que vous préférez, puis cliquez sur "Sauvegarder les paramètres" pour activer vos changements.

Bonjour Je vous conseilera

Christophe Chauvet/ = 7 DĂ©cembre, 2006 - 15:47

Bonjour

Je vous conseilerais d'activer le log sur le driver ODBC et de verifier qu'il n'y ai pas d'erreur qui apparait, si il y'en as une alors poster la ici pour que l'on vous guide dans la détermination du problème.

Cordialement.

P.S. PostgreSQL fonctionne très bien avec Business Object et Crystal Report.

Christophe Chauvet
KrysKool.org


[ Vous devez vous connecter pour poster des commentaires ]

Log du driver Postgres

frafga/ = 14 DĂ©cembre, 2006 - 11:08

Bonjour,

Ci-dessous la log du driver Postgres :
conn = 02A13A10, PGAPI_Connect(DSN='NEOLANE', UID='neolane', PWD='xxxxx')
Global Options: Version='08.02.0200', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64
extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='OTHER'
[ PostgreSQL version string = '8.1.4' ]
[ PostgreSQL version number = '8.1' ]
conn=02A13A10, query='select oid, typbasetype from pg_type where typname = 'lo''
[ fetched 0 rows ]
[ Large Object oid = -999 ]
[ Client encoding = 'LATIN1' (code = 8) ]
CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1041, vParam=43720160', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1042, vParam=43720272', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1052, vParam=43720120', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
conn=02A13A10, query='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname like '%' and relname like '%' and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname'
[ fetched 358 rows ]
conn=02A13A10, query='SELECT * FROM public.nmstrackinglog'
CONN ERROR: func=CC_send_query, desc='', errnum=109, errmsg='Out of memory while reading tuples.'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=3, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=1460, buffer_filled_out=0, buffer_read_in=1287
STATEMENT ERROR: func=SC_execute, desc='(null)', errnum=7, errmsg='Error while executing the query'
------------------------------------------------------------
hdbc=02A13A10, stmt=02A18788, result=03CB37D8
prepare=3, internal=0
bindings=59407950, bindings_allocated=10
parameters=00000000, parameters_allocated=0
statement_type=0, statement='SELECT * FROM public.nmstrackinglog'
stmt_with_params='SELECT * FROM public.nmstrackinglog'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
cursor_name='SQL_CUR02A18788'
----------------QResult Info -------------------------------
fields=02A1B990, backend_tuples=00000000, tupleField=0, conn=02A13A10
fetch_count=0, num_total_rows=3276800, num_fields=10, cursor='(NULL)'
message='Out of memory while reading tuples.', command='(NULL)', notice='(NULL)'
status=7, inTuples=1
CONN ERROR: func=SC_execute, desc='(null)', errnum=109, errmsg='Out of memory while reading tuples.'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=1460, buffer_filled_out=0, buffer_read_in=1287
STATEMENT ERROR: func=PGAPI_NumResultCols, desc='', errnum=1, errmsg='No query has been executed with that handle'
------------------------------------------------------------
hdbc=02A13A10, stmt=02A18788, result=03CB37D8
prepare=3, internal=0
bindings=59407950, bindings_allocated=10
parameters=00000000, parameters_allocated=0
statement_type=0, statement='SELECT * FROM public.nmstrackinglog'
stmt_with_params='SELECT * FROM public.nmstrackinglog'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
cursor_name='SQL_CUR02A18788'
----------------QResult Info -------------------------------
fields=02A1B990, backend_tuples=00000000, tupleField=0, conn=02A13A10
fetch_count=0, num_total_rows=3276800, num_fields=10, cursor='(NULL)'
message='Out of memory while reading tuples.', command='(NULL)', notice='(NULL)'
status=7, inTuples=1
CONN ERROR: func=PGAPI_NumResultCols, desc='', errnum=109, errmsg='Out of memory while reading tuples.'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=1460, buffer_filled_out=0, buffer_read_in=1287
conn=02A13A10, query='select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like 'nmstrackinglog' and n.nspname like 'public') inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum'
conn=02A13A10, query='SELECT * FROM public.nmstrackinglog'
conn=02A13A10, query='SELECT * FROM public.nmstrackinglog'
conn=02A13A10, PGAPI_Disconnect


[ Vous devez vous connecter pour poster des commentaires ]

Bonjour Avez vous dans vot

Christophe Chauvet/ = 14 DĂ©cembre, 2006 - 15:08

Bonjour

Avez vous dans votre connexion ODBC -> options datasource la case "Use Declare/Fecth" de cocher ? si oui essayé en la décochant.

Voir aussi en augmentant le paramètre Cache Size

Cordialement.

Christophe Chauvet
KrysKool.org


[ Vous devez vous connecter pour poster des commentaires ]

Bonjour, J'ai vérifié la

frafga/ = 14 DĂ©cembre, 2006 - 15:48

Bonjour,

J'ai vérifié la case "Use Declare/Fecth" n'était pas cochée.

Par contre j'ai nettement augmenté la "cache size", je suis passé de 100 à 512.

Malheureusement ce changement n'a eu aucun effet, j'accède toujours au table, mais pas aux colonnes de tables postgres.

Je vous mets ci-dessous ma nouvelle Log.

Merci de votre aide

Cdlt,

frafga

conn = 02A13A10, PGAPI_Connect(DSN='NEOLANE', UID='neolane', PWD='xxxxx')
Global Options: Version='08.02.0200', fetch=500, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64
extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='OTHER'
[ PostgreSQL version string = '8.1.4' ]
[ PostgreSQL version number = '8.1' ]
conn=02A13A10, query='select oid, typbasetype from pg_type where typname = 'lo''
[ fetched 0 rows ]
[ Large Object oid = -999 ]
[ Client encoding = 'LATIN1' (code = 8) ]
CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1041, vParam=43720160', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1042, vParam=43720272', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1052, vParam=43720120', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
conn=02A13A10, query='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname like '%' and relname like '%' and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname'
[ fetched 358 rows ]
conn=02A13A10, query='SELECT * FROM public.nmstrackinglog'
CONN ERROR: func=CC_send_query, desc='', errnum=109, errmsg='Out of memory while reading tuples.'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=3, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=1460, buffer_filled_out=0, buffer_read_in=1287
STATEMENT ERROR: func=SC_execute, desc='(null)', errnum=7, errmsg='Error while executing the query'
------------------------------------------------------------
hdbc=02A13A10, stmt=02A18788, result=03CB37D8
prepare=3, internal=0
bindings=59407950, bindings_allocated=10
parameters=00000000, parameters_allocated=0
statement_type=0, statement='SELECT * FROM public.nmstrackinglog'
stmt_with_params='SELECT * FROM public.nmstrackinglog'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
cursor_name='SQL_CUR02A18788'
----------------QResult Info -------------------------------
fields=02A1B990, backend_tuples=00000000, tupleField=0, conn=02A13A10
fetch_count=0, num_total_rows=3276800, num_fields=10, cursor='(NULL)'
message='Out of memory while reading tuples.', command='(NULL)', notice='(NULL)'
status=7, inTuples=1
CONN ERROR: func=SC_execute, desc='(null)', errnum=109, errmsg='Out of memory while reading tuples.'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=1460, buffer_filled_out=0, buffer_read_in=1287
STATEMENT ERROR: func=PGAPI_NumResultCols, desc='', errnum=1, errmsg='No query has been executed with that handle'
------------------------------------------------------------
hdbc=02A13A10, stmt=02A18788, result=03CB37D8
prepare=3, internal=0
bindings=59407950, bindings_allocated=10
parameters=00000000, parameters_allocated=0
statement_type=0, statement='SELECT * FROM public.nmstrackinglog'
stmt_with_params='SELECT * FROM public.nmstrackinglog'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
cursor_name='SQL_CUR02A18788'
----------------QResult Info -------------------------------
fields=02A1B990, backend_tuples=00000000, tupleField=0, conn=02A13A10
fetch_count=0, num_total_rows=3276800, num_fields=10, cursor='(NULL)'
message='Out of memory while reading tuples.', command='(NULL)', notice='(NULL)'
status=7, inTuples=1
CONN ERROR: func=PGAPI_NumResultCols, desc='', errnum=109, errmsg='Out of memory while reading tuples.'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=1460, buffer_filled_out=0, buffer_read_in=1287
conn=02A13A10, query='select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like 'nmstrackinglog' and n.nspname like 'public') inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum'
conn=02A13A10, query='SELECT * FROM public.nmstrackinglog'


[ Vous devez vous connecter pour poster des commentaires ]

J'ai poussé le vice en augme

frafga/ = 14 DĂ©cembre, 2006 - 16:54

J'ai poussé le vice en augmentant la cache size à 1500, mais le résultat ne varie pas.

Voici ma log:

conn = 02A13A10, PGAPI_Connect(DSN='NEOLANE', UID='neolane', PWD='xxxxx')
Global Options: Version='08.02.0200', fetch=1500, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64
extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='OTHER'
[ PostgreSQL version string = '8.1.4' ]
[ PostgreSQL version number = '8.1' ]
conn=02A13A10, query='select oid, typbasetype from pg_type where typname = 'lo''
[ fetched 0 rows ]
[ Large Object oid = -999 ]
[ Client encoding = 'LATIN1' (code = 8) ]
CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1041, vParam=43720160', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1042, vParam=43720272', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
CONN ERROR: func=PGAPI_SetConnectOption, desc='fOption=1052, vParam=43720120', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
conn=02A13A10, query='select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname like '%' and relname like '%' and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname'
[ fetched 358 rows ]
conn=02A13A10, query='SELECT * FROM public.nmstrackinglog'
CONN ERROR: func=CC_send_query, desc='', errnum=109, errmsg='Out of memory while reading tuples.'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=3, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=1460, buffer_filled_out=0, buffer_read_in=1287
STATEMENT ERROR: func=SC_execute, desc='(null)', errnum=7, errmsg='Error while executing the query'
------------------------------------------------------------
hdbc=02A13A10, stmt=02A18788, result=03CB37D8
prepare=3, internal=0
bindings=59407950, bindings_allocated=10
parameters=00000000, parameters_allocated=0
statement_type=0, statement='SELECT * FROM public.nmstrackinglog'
stmt_with_params='SELECT * FROM public.nmstrackinglog'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
cursor_name='SQL_CUR02A18788'
----------------QResult Info -------------------------------
fields=02A1B990, backend_tuples=00000000, tupleField=0, conn=02A13A10
fetch_count=0, num_total_rows=3276800, num_fields=10, cursor='(NULL)'
message='Out of memory while reading tuples.', command='(NULL)', notice='(NULL)'
status=7, inTuples=1
CONN ERROR: func=SC_execute, desc='(null)', errnum=109, errmsg='Out of memory while reading tuples.'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=1460, buffer_filled_out=0, buffer_read_in=1287
STATEMENT ERROR: func=PGAPI_NumResultCols, desc='', errnum=1, errmsg='No query has been executed with that handle'
------------------------------------------------------------
hdbc=02A13A10, stmt=02A18788, result=03CB37D8
prepare=3, internal=0
bindings=59407950, bindings_allocated=10
parameters=00000000, parameters_allocated=0
statement_type=0, statement='SELECT * FROM public.nmstrackinglog'
stmt_with_params='SELECT * FROM public.nmstrackinglog'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
cursor_name='SQL_CUR02A18788'
----------------QResult Info -------------------------------
fields=02A1B990, backend_tuples=00000000, tupleField=0, conn=02A13A10
fetch_count=0, num_total_rows=3276800, num_fields=10, cursor='(NULL)'
message='Out of memory while reading tuples.', command='(NULL)', notice='(NULL)'
status=7, inTuples=1
CONN ERROR: func=PGAPI_NumResultCols, desc='', errnum=109, errmsg='Out of memory while reading tuples.'
------------------------------------------------------------
henv=02A12160, conn=02A13A10, status=1, num_stmts=16
sock=02A12190, stmts=02A12258, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1588, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=44131672, buffer_out=44135776
buffer_filled_in=1460, buffer_filled_out=0, buffer_read_in=1287
conn=02A13A10, query='select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like 'nmstrackinglog' and n.nspname like 'public') inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum'
conn=02A13A10, PGAPI_Disconnect


[ Vous devez vous connecter pour poster des commentaires ]

bon ben vaut mieux rester sou

sparky/ = 14 DĂ©cembre, 2006 - 16:54

bon ben vaut mieux rester sous postgres alors :-)


[ Vous devez vous connecter pour poster des commentaires ]

© PostgreSQLFr, tous droits rĂ©servĂ©s.
Site déclaré à la CNIL sous le numéro 1074678, conformément à la Loi en vigueur.