pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC & v7.0(Rel) Errors with Users and Databases
3+ messages / 2 participants
[nested] [flat]
* ODBC & v7.0(Rel) Errors with Users and Databases
@ 2000-05-10 11:22 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Dave Page @ 2000-05-10 11:22 UTC (permalink / raw)
To: pgsql-interfaces
Hi,
First off, thanks to the developers for version 7!
I have a fairly major problem in the code for pgAdmin with CREATE/ALTER/DROP
USER/DATABASE. Any code that executes any of the SQL listed results in an
error along the lines of:
ERROR: DROP DATABASE: May not be called in a transaction block
The ODBC log shows that either ADO or the ODBC driver is automatically
wrapping the query in a transaction:
conn=47987408, query='BEGIN'
conn=47987408, query='DROP DATABASE "matt"'
ERROR from backend during send_query: 'ERROR: DROP DATABASE: May not be
called in a transaction block'
conn=47987408, query='COMMIT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while
executing the query'
------------------------------------------------------------
hdbc=47987408, stmt=49221232, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=6, statement='DROP DATABASE "matt"'
stmt_with_params='DROP DATABASE "matt"'
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_CUR02EF0E70'
----------------QResult Info
-------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: DROP
DATABASE: May not be called in a transaction block'
------------------------------------------------------------
henv=47987392, conn=47987408, status=1, num_stmts=16
sock=47980304, stmts=47980352, lobj_type=27904
---------------- Socket Info -------------------------------
socket=488, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=47993744, buffer_out=47997848
buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2
conn=47987408, SQLDisconnect
Any thoughts/suggestions would be welcomed!!
Regards,
Dave.
--
"I find an axe is the most satisfying, but really any good weapon will do."
- Sacha Roscoe, explaining basic systems administration.
http://www.vale-housing.co.uk/ (Work)
http://www.pgadmin.freeserve.co.uk/ (Home of pgAdmin)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [HACKERS] ODBC & v7.0(Rel) Errors with Users and Databases
@ 2000-06-13 13:30 Thomas Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 0 replies; 3+ messages in thread
From: Thomas Lockhart @ 2000-06-13 13:30 UTC (permalink / raw)
To: Dave Page <dpage@vale-housing.co.uk>; +Cc: pgsql-interfaces@hub.org
> > Just wondering if you managed to take a look at this problem yet?
>
> Hmm. No, and I'm still recovering from a less-than-ideal system
> upgrade which lost all of my email.
> Will look at it asap (in the next few days). The issue is the
> transaction wrapping in the ODBC interface, right? Zoltan has sent me
> some patches which should address this.
>
> - Thomas
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: [HACKERS] ODBC & v7.0(Rel) Errors with Users and Databases
@ 2000-06-17 17:02 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Dave Page @ 2000-06-17 17:02 UTC (permalink / raw)
To: 'Thomas Lockhart' <lockhart@alumni.caltech.edu>; +Cc: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>
> -----Original Message-----
> From: Thomas Lockhart [mailto:lockhart@alumni.caltech.edu]
> Sent: 13 June 2000 13:31
> To: Dave Page
> Cc: pgsql-interfaces@hub.org
> Subject: Re: [HACKERS] ODBC & v7.0(Rel) Errors with Users and
> Databases
>
>
> > > Just wondering if you managed to take a look at this problem yet?
> >
> > Hmm. No, and I'm still recovering from a less-than-ideal system
> > upgrade which lost all of my email.
> > Will look at it asap (in the next few days). The issue is the
> > transaction wrapping in the ODBC interface, right? Zoltan
> has sent me
> > some patches which should address this.
> >
> > - Thomas
Sorry for the lateness of my reply, I've been out all week.
Yes, it is the transaction wrapping in the ODBC interface.
Regards,
Dave.
--
Disclaimer: the above is the author's personal opinion and is not the
opinion or policy of his employer or of the little green men that have been
following him all day.
http://www.vale-housing.co.uk/ - http://www.pgadmin.freeserve.co.uk/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-06-17 17:02 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-10 11:22 ODBC & v7.0(Rel) Errors with Users and Databases Dave Page <dpage@vale-housing.co.uk>
2000-06-13 13:30 Re: [HACKERS] ODBC & v7.0(Rel) Errors with Users and Databases Thomas Lockhart <lockhart@alumni.caltech.edu>
2000-06-17 17:02 RE: [HACKERS] ODBC & v7.0(Rel) Errors with Users and Databases Dave Page <dpage@vale-housing.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox