To: ISMTP@SFRA0046@Servers[<pgsql-interfaces-digest@hub.org>]
Cc:
Subject: pgsql-interfaces-digest V1 #246
Message not delivered to recipients below. Press F1 for help with VNM
error codes.
VNM3043: DE_VOLDER Fabrice@ATR_EXPL_LYON1@SFR_DO_CNTR_EST
VNM3043 -- MAILBOX IS FULL
The message cannot be delivered because the
recipient's mailbox contains the maximum number of
messages, as set by the system administrator. The
recipient must delete some messages before any
other messages can be delivered.
The maximum message limit for a user's mailbox is
10,000. The default message limit is 1000 messages.
Administrators can set message limits using the
Mailbox Settings function available in the
Manage User menu (MUSER).
When a user's mailbox reaches the limit, the
user must delete some of the messages before
the mailbox can accept any more incoming messages.
---------------------- Original Message Follows ----------------------
pgsql-interfaces-digest Tuesday, March 2 1999 Volume 01 : Number 246
Index:
How can I get more result fields in pgaccess visual query builder?
Re: passing variable between cgi
Re: [INTERFACES] How can I get more result fields in pgaccess visual query builder?
RE: [INTERFACES] passing variable between cgi
Re: [INTERFACES] mod_auth_pg95
Read-Only ODBC, MS/ACCESS
Persistent connection in PostGresSQL
Re: [INTERFACES] Read-Only ODBC, MS/ACCESS
RE: [INTERFACES] Foreign Keys
JDBC Will not compile Error 139?
JDBC Will not compile Error 139?
Re: [INTERFACES] Foreign Keys
RE: [INTERFACES] Foreign Keys
----------------------------------------------------------------------
Date: Mon, 1 Mar 1999 23:40:13 -0500 (EST)
From: "Stan Brown" <stanb@awod.com>
Subject: How can I get more result fields in pgaccess visual query builder?
I am doing some prtotyping on a new project, and I have a couple of
questions.
How can I get more result fieds in the pgaccess visual query builder?
Can someone give me a brief explantaion of, or point me to some
documentaion for using the forms builder in pgaccess?
Thanks.
- --
Stan Brown stanb@netcom.com 843-745-3154
Westvaco
Charleston SC.
- --
Windows 98: n.
useless extension to a minor patch release for 32-bit extensions and
a graphical shell for a 16-bit patch to an 8-bit operating system
originally coded for a 4-bit microprocessor, written by a 2-bit
company that can't stand for 1 bit of competition.
- -
(c) 1999 Stan Brown. Redistribution via the Microsoft Network is prohibited.
------------------------------
Date: Tue, 2 Mar 1999 08:27:37 +0200 (EET)
From: Razvan Marcus <marcus@twf2.twf.ro>
Subject: Re: passing variable between cgi
You can use <input typefrom a cgi to another.
Argus
On Mon, 1 Mar 1999, hoelc wrote:
> Hello,
> I am setting up PostgreSQL (postgresql-6.4.2) database in Linux (Linux 2.0.27)
> system, and want to access the database with cgi ( C program) through Apache
> (version 1.1) server. My application involve a few cgi programmes.
> I can not figure out how to pass varibles between cgi programmes.
>
> My application involve some thing like this:
> In a HTML page, when the user click a button, a cgi program will run and get
> some data from Postgres, then when the user click another button, the other cgi
> will be triggerred to process certain data got by the previous cgi, so, I will
> need to pass the data get by the first cgi to the second cgi according to the
> user choice ...
>
> I am using the embedded SQL (ecpg) method to write the cgi ( C program ) to get
> data from postgresql-6.4.2.
> How should I pass variable between these C program? What are the common methods
> to develop this kind of application?
> Please advice.
> Thank you.
> LCH
>
>
> -
> To unsubscribe from this list: send the line "unsubscribe linux-net" in
> the body of a message to majordomo@vger.rutgers.edu
>
------------------------------
Date: Tue, 02 Mar 1999 09:37:30 +0200
From: Constantin Teodorescu <teo@flex.ro>
Subject: Re: [INTERFACES] How can I get more result fields in pgaccess visual query builder?
Stan Brown wrote:
>
> How can I get more result fieds in the pgaccess visual query builder?
Just click on the result field area zone and drag it to the left or
right.
That will scroll the region and allows you to see more result fields
> Can someone give me a brief explantaion of, or point me to some
> documentaion for using the forms builder in pgaccess?
Unfortunately no.
There is a formdemo.sql dumped database in the .tar.gz that shows some
of the forms features.
I had not time to document forms module. I want to enhance it and maybe
I will write a small HOWTO.
All the best,
- --
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA
------------------------------
Date: Mon, 1 Mar 1999 17:15:55 -0000
From: Dave Page <dpage@vale-housing.co.uk>
Subject: RE: [INTERFACES] passing variable between cgi
When the first CGI program is run and generates the second HTML page with
the second form on it, have it include some form fields of type 'hidden'.
The values of these fields would be the data you wish pass to the second
cgi.
You can then retrieve the data in the same way as you do for your other
fields when the form is submitted.
Shameless plug: Check out libcgi at http://www.vale-it.demon.co.uk/freeware
for a relatively easy way to get the form data.
HTH
Dave.
- --
Dave Page, Network & Systems Manager, The Vale Housing Association Ltd.
dpage@vale-housing.co.uk
http://www.vale-housing.co.uk (Work)
http://www.vale-it.demon.co.uk/ (Home of pgAdmin)
Beer can be a permanent solution - but only if you have enough of it!
> -----Original Message-----
> From: owner-pgsql-interfaces@postgreSQL.org
> [mailto:owner-pgsql-interfaces@postgreSQL.org]On Behalf Of hoelc
> Sent: 01 March 1999 15:06
> To: linux-net@vger.rutgers.edu; PostgreSQL Interfaces
> Subject: [INTERFACES] passing variable between cgi
>
>
> Hello,
> I am setting up PostgreSQL (postgresql-6.4.2) database in
> Linux (Linux 2.0.27)
> system, and want to access the database with cgi ( C program)
> through Apache
> (version 1.1) server. My application involve a few cgi programmes.
> I can not figure out how to pass varibles between cgi programmes.
>
> My application involve some thing like this:
> In a HTML page, when the user click a button, a cgi
> program will run and get
> some data from Postgres, then when the user click another
> button, the other cgi
> will be triggerred to process certain data got by the
> previous cgi, so, I will
> need to pass the data get by the first cgi to the second cgi
> according to the
> user choice ...
>
> I am using the embedded SQL (ecpg) method to write the cgi
> C program ) to get
> data from postgresql-6.4.2.
> How should I pass variable between these C program? What are
> the common methods
> to develop this kind of application?
> Please advice.
> Thank you.
> LCH
>
>
>
------------------------------
Date: Tue, 02 Mar 1999 09:33:34 +0100
From: Giuseppe Tanzilli <g.tanzilli@eurolink.it>
Subject: Re: [INTERFACES] mod_auth_pg95
Hi,
sorry for the trouble
I was unable to update the record in the modules.apache.org.
Anyway it's at:
ftp://ftp.eurolink.it/pub/linux/postgreSQL/
bye
yves@asua.vlaanderen.net wrote:
> Hello,
>
> Does anyone have a port of the module mod_auth_pg95 for Apache 1.3.x ? I
> tried compiling it, had to change some function calls but it doesn't work
> :-(
>
> -Yves
- --
- -----------------------------------------------------------------
Giuseppe Tanzilli Flashnet S.p.A. Telecomunicazioni
mailto: g.tanzilli@flashnet.it Sede di Frosinone
Eurolink S.r.l. mailto: info.frosinone@flashnet.it
Tel: +39-0775-830012 http://www.flashnet.it
Fax: +39-0775-201321 EUnet Business Partner
http://www.eurolink.it AIIP and ANFOV associated
PGP Key: finger giuseppe@king.fr.flashnet.it
- -------------------------------------------------------------------
------------------------------
Date: Tue, 02 Mar 1999 11:59:25 +0200
From: Nicolas Boretos <nicolasb@maich.gr>
Subject: Read-Only ODBC, MS/ACCESS
Hello,
I am experimenting with the postdrv and seems to work in Excel, but as
read only in Acess97. Any ideas?
Thank you,
Nicolas Boretos
------------------------------
Date: Tue, 02 Mar 1999 12:11:10 +0200
From: CIMPOESU Teodor <teo@digiro.net>
Subject: Persistent connection in PostGresSQL
I have some questions for you all,
What is the difference between a persistent connection and a regular one
in postgres?
If I read /server-status after some queries with pg_pconnect() I see a
lot of active sessions there.
In which cases it is reasonable to use a persistent conection and in
which is not?
10x.
------------------------------
Date: Tue, 2 Mar 1999 07:04:44 -0600
From: "Mark A. Schwenk" <mas@wellthot.com>
Subject: Re: [INTERFACES] Read-Only ODBC, MS/ACCESS
It seems that the ODBC driver creates a read-only connection by default (at
least with Access). You need to turn this off as follows.
Try to create a new ODBC link from Access to PostgreSQL. When you see the
PostgreSQL Driver Setup dialog, click the Driver button in the the Options
(Advanced). This will open an Advanced Options (Driver) dialog. In this
dialog box, uncheck the ReadOnly (Default) checkbox.
I hope this solves your problem.
- -Mark Schwenk
WellThot Inc.
http://wellthot.com
- -----Original Message-----
From: Nicolas Boretos <nicolasb@maich.gr>
To: pgsql-interfaces@hub.org <pgsql-interfaces@hub.org>
Date: Tuesday, March 02, 1999 3:50 AM
Subject: [INTERFACES] Read-Only ODBC, MS/ACCESS
>Hello,
>
>I am experimenting with the postdrv and seems to work in Excel, but as
>read only in Acess97. Any ideas?
>Thank you,
>Nicolas Boretos
>
------------------------------
Date: Tue, 2 Mar 1999 12:09:26 -0600
From: Michael Davis <michael.davis@prevuenet.com>
Subject: RE: [INTERFACES] Foreign Keys
I have narrowed the problem down a little. Here is what I have discovered
so far:
- - sql.log (odbc trace facility) has no references to primary or
foreign keys
- - if I open the form on an exising record, it works great
- - if I open the form on a new record, an error occurs in a select
statement that basically locks up the subform
- - the error occurs on "select orderlineid from orderlines where
orderid Access gets the orderid of the current record, it is null. Access gets all
orderlineids associated with the orderid. This fails on the new record.
When the form is on a valid record, Access then gets the orderline record
for each orderlineid returned by the previous statement. This seems to be a
long way around getting data, but I don't have any control over this
interaction.
It appears that I cant add new records using Access97 with PostgreSQL as my
database engine. Has anyone used Access97 or other similar front end tools
to interface with a PostgreSQL database? Any suggestions on what I might
try next to work around this problem?
-----Original Message-----
From: Byron Nikolaidis [SMTP:byronn@insightdist.com]
Sent: Thursday, February 25, 1999 2:12 PM
To: Michael Davis
Cc: 'pgsql-interfaces@postgreSQL.org'
Subject: Re: [INTERFACES] Foreign Keys
Michael Davis wrote:
> I have created the following trigger on the parent/master table
(orders):
>
> CREATE TRIGGER Orderlines_fkey
> BEFORE DELETE OR UPDATE ON Orders FOR EACH ROW
> EXECUTE PROCEDURE check_foreign_key ();
>
> check_foreign_key() actually deletes rows from the orderlines
table when
> every a row is deleted from orders. This triggers works great.
Access,
> however, is still not recognizing the foreign key relationship
between
> orders and orderlines. Any other suggestions?
>
> Thanks, Michael
>
Yeah, there is more we can try. First of all, we need to verify
that Access
is actually calling SQLForeignKeys. Can you get a "trace" log of
the
session? This would be the "sql.log" file which contains all api
calls to
odbc. Make sure the file is clear beforehand. Then run the test.
Quit
Access, turn tracing off and there's your logfile. You can send it
to me.
It might also be helpful to have the commlog file (produced by the
driver)...usually "psqlodbc.log". It may have a process id number
appended
to the filename so make sure you get the right one.
Byron
------------------------------
Date: Tue, 2 Mar 1999 11:26:11 -0700 (MST)
From: tperry@grumpy.it.as.ex.state.ut.us
Subject: JDBC Will not compile Error 139?
I have tried to run javac on CallableStatement and it seems to work ok
manually, but when I use the make it gives me this error? Any ideas? I
am new to the JDK, I am using 1.1.7 installed in the /usr/local/java
directory. Any Help would be appreciated.
Tim
bash$ make
javac postgresql/CallableStatement.java
CLASSPATH is not set!
make: *** [postgresql/CallableStatement.class] Error 1
bash$ export CLASSPATHbash$ make
javac postgresql/CallableStatement.java
No library path set.
make: *** [postgresql/CallableStatement.class] Error 139
------------------------------
Date: Tue, 2 Mar 1999 11:26:11 -0700 (MST)
From: tperry@grumpy.it.as.ex.state.ut.us
Subject: JDBC Will not compile Error 139?
I have tried to run javac on CallableStatement and it seems to work ok
manually, but when I use the make it gives me this error? Any ideas? I
am new to the JDK, I am using 1.1.7 installed in the /usr/local/java
directory. Any Help would be appreciated.
Tim
bash$ make
javac postgresql/CallableStatement.java
CLASSPATH is not set!
make: *** [postgresql/CallableStatement.class] Error 1
bash$ export CLASSPATHbash$ make
javac postgresql/CallableStatement.java
No library path set.
make: *** [postgresql/CallableStatement.class] Error 139
------------------------------
Date: Tue, 02 Mar 1999 14:52:04 -0500
From: Byron Nikolaidis <byronn@insightdist.com>
Subject: Re: [INTERFACES] Foreign Keys
Michael Davis wrote:
> I have narrowed the problem down a little. Here is what I have discovered
> so far:
>
> - sql.log (odbc trace facility) has no references to primary or
> foreign keys
>
> - if I open the form on an exising record, it works great
>
> - if I open the form on a new record, an error occurs in a select
> statement that basically locks up the subform
>
> - the error occurs on "select orderlineid from orderlines where
> orderid > Access gets the orderid of the current record, it is null. Access gets all
> orderlineids associated with the orderid. This fails on the new record.
> When the form is on a valid record, Access then gets the orderline record
> for each orderlineid returned by the previous statement. This seems to be a
> long way around getting data, but I don't have any control over this
> interaction.
>
> It appears that I cant add new records using Access97 with PostgreSQL as my
> database engine. Has anyone used Access97 or other similar front end tools
> to interface with a PostgreSQL database? Any suggestions on what I might
> try next to work around this problem?
>
>
Logs, logs, logs (see my last response). I don't know how else to put it!
Its next to impossible to figure things out without the logs.
Byron
------------------------------
Date: Tue, 2 Mar 1999 14:51:44 -0600
From: Michael Davis <michael.davis@prevuenet.com>
Subject: RE: [INTERFACES] Foreign Keys
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
- ------_Content-Type: text/plain
Here is the psqlodbc.log file. The first time the form opens, it correctly
opens the first rentalorder. I immediately moved to the new record in
Access which opens a message box with an ODBC error (no description). I the
blank rental order looks okay but the rental order lines records all have
errors. Even if I move back to a valid record, the order lines will show
only errors.
<<psqlodbc_270.log>>
-----Original Message-----
From: Byron Nikolaidis [SMTP:byronn@insightdist.com]
Sent: Tuesday, March 02, 1999 12:52 PM
To: Michael Davis
Cc: 'pgsql-interfaces@postgreSQL.org'
Subject: Re: [INTERFACES] Foreign Keys
Michael Davis wrote:
> I have narrowed the problem down a little. Here is what I have
discovered
> so far:
>
> - sql.log (odbc trace facility) has no references to primary
or
> foreign keys
>
> - if I open the form on an exising record, it works great
>
> - if I open the form on a new record, an error occurs in a
select
> statement that basically locks up the subform
>
> - the error occurs on "select orderlineid from orderlines
where
> orderid record.
> Access gets the orderid of the current record, it is null. Access
gets all
> orderlineids associated with the orderid. This fails on the new
record.
> When the form is on a valid record, Access then gets the orderline
record
> for each orderlineid returned by the previous statement. This
seems to be a
> long way around getting data, but I don't have any control over
this
> interaction.
>
> It appears that I cant add new records using Access97 with
PostgreSQL as my
> database engine. Has anyone used Access97 or other similar front
end tools
> to interface with a PostgreSQL database? Any suggestions on what
I might
> try next to work around this problem?
>
>
Logs, logs, logs (see my last response). I don't know how else to
put it!
Its next to impossible to figure things out without the logs.
Byron
- ------_Content-Type: application/octet-stream;
nameContent-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filenameContent-Location: ATT-0-6389C710D9D0D211A1B4080009DCB9A8-P
S6BBE%7E1.LOG
conn=153237224, SQLDriverConnect(
in)='DSN=PostgreSQL;UID=Admin;PWD=;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS=;',
fDriverCompletion=0
DSN info: DSN='PostgreSQL',server='192.168.97.2',port='5432',dbase='mp',user='Admin',passwd=''
readonly='0',protocol='6.4',showoid='0',fakeoidindex='1',showsystable='1'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0004', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254,
max_longvarchar_size=4094
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=153237224, query=' '
conn=153237224, query='set DateStyle to 'ISO''
conn=153237224, query='set geqo to 'OFF''
conn=153237224, query='set ksqo to 'ON''
conn=153237224, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=153237224,
SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;UID=Admin;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS='
conn=153237224, query='SELECT Config, nValue FROM MSysConf'
ERROR from backend during send_query: 'ERROR: msysconf: Table does not exist.'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
- ------------------------------------------------------------
hdbc=153237224, stmt=153550944, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT Config, nValue FROM MSysConf'
stmt_with_params='SELECT Config, nValue FROM MSysConf'
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_CUR09270060'
----------------QResult Info - -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: msysconf: Table does not exist.'
- ------------------------------------------------------------
henv=153237168, conn=153237224, status=1, num_stmts=16
sock=153243592, stmts=153251960, lobj_type=-999
---------------- Socket Info - -------------------------------
socket=324, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=153243672, buffer_out=153247816
buffer_filled_in=42, buffer_filled_out=0, buffer_read_in=42
conn=153237224, query='SELECT "rentalorders"."rentalorderid" FROM "rentalorders" '
[ fetched 920 rows ]
conn=153632808, SQLDriverConnect(
in)='DSN=PostgreSQL;UID=Admin;PWD=;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS=;',
fDriverCompletion=0
DSN info: DSN='PostgreSQL',server='192.168.97.2',port='5432',dbase='mp',user='Admin',passwd=''
readonly='0',protocol='6.4',showoid='0',fakeoidindex='1',showsystable='1'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0004', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254,
max_longvarchar_size=4094
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=153632808, query=' '
conn=153632808, query='set DateStyle to 'ISO''
conn=153632808, query='set geqo to 'OFF''
conn=153632808, query='set ksqo to 'ON''
conn=153632808, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=153632808,
SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;UID=Admin;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS='
conn=153632808, query='SELECT
"rentalorderid","memberid","processedby","dateprocessed","shippedby","dateshipped","returnedby","shippinghandling","shownotes","notes","batchno"
FROM "rentalorders" WHERE "rentalorderid" = 1'
[ fetched 1 rows ]
conn=153723168, SQLDriverConnect(
in)='DSN=PostgreSQL;UID=Admin;PWD=;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS=;',
fDriverCompletion=0
DSN info: DSN='PostgreSQL',server='192.168.97.2',port='5432',dbase='mp',user='Admin',passwd=''
readonly='0',protocol='6.4',showoid='0',fakeoidindex='1',showsystable='1'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0004', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254,
max_longvarchar_size=4094
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=153723168, query=' '
conn=153723168, query='set DateStyle to 'ISO''
conn=153723168, query='set geqo to 'OFF''
conn=153723168, query='set ksqo to 'ON''
conn=153723168, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=153723168,
SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;UID=Admin;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS='
conn=153723168, query='SELECT "RentalOrders"."rentalorderlinesid" FROM "rentalorderlines" "RentalOrders" WHERE
("rentalorderid"= 1 ) '
[ fetched 10 rows ]
conn=153723168, SQLDisconnect
conn=153632808, query='SELECT
"rentalorderlinesid","rentalorderid","rentalid","quantity","cost","notinstock","nolongeravailable","returned","returneddate"
FROM "rentalorderlines" WHERE "rentalorderlinesid" = 1 OR "rentalorderlinesid" = 2 OR "rentalorderlinesid" = 3 OR
"rentalorderlinesid"= 4 OR "rentalorderlinesid" = 5 OR "rentalorderlinesid" = 6 OR "rentalorderlinesid" = 7 OR
"rentalorderlinesid"= 8 OR "rentalorderlinesid" = 9 OR "rentalorderlinesid" = 10'
[ fetched 10 rows ]
conn=153802280, SQLDriverConnect(
in)='DSN=PostgreSQL;UID=Admin;PWD=;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS=;',
fDriverCompletion=0
DSN info: DSN='PostgreSQL',server='192.168.97.2',port='5432',dbase='mp',user='Admin',passwd=''
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='1'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0004', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254,
max_longvarchar_size=4094
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=153802280, query=' '
conn=153802280, query='set DateStyle to 'ISO''
conn=153802280, query='set geqo to 'OFF''
conn=153802280, query='set ksqo to 'ON''
conn=153802280, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=153802280,
SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;UID=Admin;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS='
conn=153812792, SQLDriverConnect(
in)='DSN=PostgreSQL;UID=Admin;PWD=;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS=;',
fDriverCompletion=0
DSN info: DSN='PostgreSQL',server='192.168.97.2',port='5432',dbase='mp',user='Admin',passwd=''
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='1'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0004', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254,
max_longvarchar_size=4094
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=153812792, query=' '
conn=153812792, query='set DateStyle to 'ISO''
conn=153812792, query='set geqo to 'OFF''
conn=153812792, query='set ksqo to 'ON''
conn=153812792, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=153812792,
SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;UID=Admin;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS='
conn=153812792, query='SELECT "inventoryid" ,"inventoryname" ,"tapenum" FROM "inventory" ORDER BY "inventoryid" '
[ fetched 570 rows ]
conn=153802280, query='SELECT "rentalid" ,"inventoryid" ,"obsolete" FROM "rentals" ORDER BY "inventoryid" '
[ fetched 163 rows ]
conn=153812792, SQLDisconnect
conn=153802280, SQLDisconnect
conn=153944104, SQLDriverConnect(
in)='DSN=PostgreSQL;UID=Admin;PWD=;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS=;',
fDriverCompletion=0
DSN info: DSN='PostgreSQL',server='192.168.97.2',port='5432',dbase='mp',user='Admin',passwd=''
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='1'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0004', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254,
max_longvarchar_size=4094
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=153944104, query=' '
conn=153944104, query='set DateStyle to 'ISO''
conn=153944104, query='set geqo to 'OFF''
conn=153944104, query='set ksqo to 'ON''
conn=153944104, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=153944104,
SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;UID=Admin;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS='
conn=153944104, query='SELECT "logvalues"."id" FROM "logvalues" '
ERROR from backend during send_query: 'ERROR: logvalues: Permission denied.'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
- ------------------------------------------------------------
hdbc=153944104, stmt=153950776, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT "logvalues"."id" FROM "logvalues" '
stmt_with_params='SELECT "logvalues"."id" FROM "logvalues" '
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_CUR092D1A38'
----------------QResult Info - -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: logvalues: Permission denied.'
------------------------------------------------------------
henv=153237168, conn=153944104, status=1, num_stmts=16
sock=153797296, stmts=153646224, lobj_type=-999
---------------- Socket Info - -------------------------------
socket=356, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=153791272, buffer_out=153898984
buffer_filled_in=40, buffer_filled_out=0, buffer_read_in=40
conn=153944104, SQLDisconnect
conn=153944104, SQLDriverConnect(
in)='DSN=PostgreSQL;UID=Admin;PWD=;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS=;',
fDriverCompletion=0
DSN info: DSN='PostgreSQL',server='192.168.97.2',port='5432',dbase='mp',user='Admin',passwd=''
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='1'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0004', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254,
max_longvarchar_size=4094
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=153944104, query=' '
conn=153944104, query='set DateStyle to 'ISO''
conn=153944104, query='set geqo to 'OFF''
conn=153944104, query='set ksqo to 'ON''
conn=153944104, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=153944104,
SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;UID=Admin;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS='
conn=153944104, query='SELECT "memberid" ,"firstname" ,"lastname" FROM "membership" ORDER BY "lastname" ,"firstname"
'
ERROR from backend during send_query: 'ERROR: membership: Permission denied.'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
- ------------------------------------------------------------
hdbc=153944104, stmt=153950776, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT "memberid" ,"firstname" ,"lastname" FROM "membership" ORDER BY
"lastname","firstname" '
stmt_with_params='SELECT "memberid" ,"firstname" ,"lastname" FROM "membership" ORDER BY "lastname"
,"firstname" '
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_CUR092D1A38'
----------------QResult Info - -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: membership: Permission denied.'
- ------------------------------------------------------------
henv=153237168, conn=153944104, status=1, num_stmts=16
sock=153797296, stmts=153646224, lobj_type=-999
---------------- Socket Info - -------------------------------
socket=384, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=153791272, buffer_out=153898984
buffer_filled_in=41, buffer_filled_out=0, buffer_read_in=41
conn=153944104, SQLDisconnect
conn=153632808, query='SELECT
"rentalorderid","memberid","processedby","dateprocessed","shippedby","dateshipped","returnedby","shippinghandling","shownotes","notes","batchno"
FROM "rentalorders" WHERE "rentalorderid" = 1'
[ fetched 1 rows ]
conn=153944104, SQLDriverConnect(
in)='DSN=PostgreSQL;UID=Admin;PWD=;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS=;',
fDriverCompletion=0
DSN info: DSN='PostgreSQL',server='192.168.97.2',port='5432',dbase='mp',user='Admin',passwd=''
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='1'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0004', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254,
max_longvarchar_size=4094
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=153944104, query=' '
conn=153944104, query='set DateStyle to 'ISO''
conn=153944104, query='set geqo to 'OFF''
conn=153944104, query='set ksqo to 'ON''
conn=153944104, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=153944104,
SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;UID=Admin;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS='
conn=153944104, query='SELECT "memberid" ,"firstname" ,"middleinitial" ,"lastname" ,"surname" ,"birthdate" ,"statusid"
,"accountbalance","duesbalance" ,"seminarbalance" ,"selected" ,"otheritemsdiscoursesplusone" ,"originalcontactid"
,"gender","email" ,"optname" ,"recordtype" FROM "membership" '
ERROR from backend during send_query: 'ERROR: membership: Permission denied.'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
- ------------------------------------------------------------
hdbc=153944104, stmt=153950776, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT "memberid" ,"firstname" ,"middleinitial" ,"lastname" ,"surname"
,"birthdate","statusid" ,"accountbalance" ,"duesbalance" ,"seminarbalance" ,"selected" ,"otheritemsdiscoursesplusone"
,"originalcontactid","gender" ,"email" ,"optname" ,"recordtype" FROM "membership" '
stmt_with_params='SELECT "memberid" ,"firstname" ,"middleinitial" ,"lastname" ,"surname" ,"birthdate"
,"statusid","accountbalance" ,"duesbalance" ,"seminarbalance" ,"selected" ,"otheritemsdiscoursesplusone"
,"originalcontactid","gender" ,"email" ,"optname" ,"recordtype" FROM "membership" '
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_CUR092D1A38'
----------------QResult Info - -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: membership: Permission denied.'
- ------------------------------------------------------------
henv=153237168, conn=153944104, status=1, num_stmts=16
sock=153797296, stmts=153646224, lobj_type=-999
---------------- Socket Info - -------------------------------
socket=428, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=153791272, buffer_out=153890856
buffer_filled_in=41, buffer_filled_out=0, buffer_read_in=41
conn=153944104, SQLDisconnect
conn=153944104, SQLDriverConnect(
in)='DSN=PostgreSQL;UID=Admin;PWD=;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS=;',
fDriverCompletion=0
DSN info: DSN='PostgreSQL',server='192.168.97.2',port='5432',dbase='mp',user='Admin',passwd=''
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='1'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0004', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254,
max_longvarchar_size=4094
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=153944104, query=' '
conn=153944104, query='set DateStyle to 'ISO''
conn=153944104, query='set geqo to 'OFF''
conn=153944104, query='set ksqo to 'ON''
conn=153944104, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=153944104,
SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;UID=Admin;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS='
conn=153944104, query='SELECT "membership"."memberid" ,"membership"."firstname" ,"membership"."lastname"
,"memberservices"."serviceid" FROM "memberservices","membership" WHERE (("memberservices"."serviceid" IN (8 ,12 ) ) AND
("membership"."memberid"= "memberservices"."memberid" ) ) ORDER BY "membership"."lastname" ,"membership"."firstname" '
ERROR from backend during send_query: 'ERROR: memberservices: Permission denied.'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
- ------------------------------------------------------------
hdbc=153944104, stmt=153950776, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT "membership"."memberid" ,"membership"."firstname"
,"membership"."lastname","memberservices"."serviceid" FROM "memberservices","membership" WHERE
(("memberservices"."serviceid"IN (8 ,12 ) ) AND ("membership"."memberid" = "memberservices"."memberid" ) ) ORDER BY
"membership"."lastname","membership"."firstname" '
stmt_with_params='SELECT "membership"."memberid" ,"membership"."firstname" ,"membership"."lastname"
,"memberservices"."serviceid" FROM "memberservices","membership" WHERE (("memberservices"."serviceid" IN (8 ,12 ) ) AND
("membership"."memberid"= "memberservices"."memberid" ) ) ORDER BY "membership"."lastname" ,"membership"."firstname" '
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_CUR092D1A38'
----------------QResult Info - -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: memberservices: Permission denied.'
- ------------------------------------------------------------
henv=153237168, conn=153944104, status=1, num_stmts=16
sock=153797296, stmts=153646224, lobj_type=-999
---------------- Socket Info - -------------------------------
socket=348, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=153890856, buffer_out=153791272
buffer_filled_in=45, buffer_filled_out=0, buffer_read_in=45
conn=153944104, SQLDisconnect
conn=153944104, SQLDriverConnect(
in)='DSN=PostgreSQL;UID=Admin;PWD=;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS=;',
fDriverCompletion=0
DSN info: DSN='PostgreSQL',server='192.168.97.2',port='5432',dbase='mp',user='Admin',passwd=''
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='1'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0004', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254,
max_longvarchar_size=4094
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=153944104, query=' '
conn=153944104, query='set DateStyle to 'ISO''
conn=153944104, query='set geqo to 'OFF''
conn=153944104, query='set ksqo to 'ON''
conn=153944104, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=153944104,
SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;UID=Admin;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS='
conn=153944104, query='SELECT "memberid" ,"firstname" ,"middleinitial" ,"lastname" ,"surname" ,"birthdate" ,"statusid"
,"accountbalance","duesbalance" ,"seminarbalance" ,"selected" ,"otheritemsdiscoursesplusone" ,"originalcontactid"
,"gender","email" ,"optname" ,"recordtype" FROM "membership" '
ERROR from backend during send_query: 'ERROR: membership: Permission denied.'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
- ------------------------------------------------------------
hdbc=153944104, stmt=153950776, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT "memberid" ,"firstname" ,"middleinitial" ,"lastname" ,"surname"
,"birthdate","statusid" ,"accountbalance" ,"duesbalance" ,"seminarbalance" ,"selected" ,"otheritemsdiscoursesplusone"
,"originalcontactid","gender" ,"email" ,"optname" ,"recordtype" FROM "membership" '
stmt_with_params='SELECT "memberid" ,"firstname" ,"middleinitial" ,"lastname" ,"surname" ,"birthdate"
,"statusid","accountbalance" ,"duesbalance" ,"seminarbalance" ,"selected" ,"otheritemsdiscoursesplusone"
,"originalcontactid","gender" ,"email" ,"optname" ,"recordtype" FROM "membership" '
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_CUR092D1A38'
----------------QResult Info - -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: membership: Permission denied.'
- ------------------------------------------------------------
henv=153237168, conn=153944104, status=1, num_stmts=16
sock=153797296, stmts=153646224, lobj_type=-999
---------------- Socket Info - -------------------------------
socket=428, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=153890856, buffer_out=153791272
buffer_filled_in=41, buffer_filled_out=0, buffer_read_in=41
conn=153944104, SQLDisconnect
conn=153237224, query='SELECT "RentalOrders"."rentalorderlinesid" FROM "rentalorderlines" "RentalOrders" WHERE
("rentalorderid"= NULL ) '
ERROR from backend during send_query: 'ERROR: parser: parse error at or near "null"'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
- ------------------------------------------------------------
hdbc=153237224, stmt=153550944, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=153645616, parameters_allocated=1
statement_type=0, statement='SELECT "RentalOrders"."rentalorderlinesid" FROM "rentalorderlines"
"RentalOrders"WHERE ("rentalorderid" = ? ) '
stmt_with_params='SELECT "RentalOrders"."rentalorderlinesid" FROM "rentalorderlines" "RentalOrders"
WHERE("rentalorderid" = NULL ) '
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_CUR09270060'
----------------QResult Info - -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: parser: parse error at or near "null"'
- ------------------------------------------------------------
henv=153237168, conn=153237224, status=1, num_stmts=16
sock=153243592, stmts=153251960, lobj_type=-999
---------------- Socket Info - -------------------------------
socket=324, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=153243672, buffer_out=153247816
buffer_filled_in=48, buffer_filled_out=0, buffer_read_in=48
conn=153944104, SQLDriverConnect(
in)='DSN=PostgreSQL;UID=Admin;PWD=;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS=;',
fDriverCompletion=0
DSN info: DSN='PostgreSQL',server='192.168.97.2',port='5432',dbase='mp',user='Admin',passwd=''
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='1'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0004', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254,
max_longvarchar_size=4094
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=153944104, query=' '
conn=153944104, query='set DateStyle to 'ISO''
conn=153944104, query='set geqo to 'OFF''
conn=153944104, query='set ksqo to 'ON''
conn=153944104, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=153944104,
SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=mp;SERVER=192.168.97.2;PORT=5432;UID=Admin;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS='
conn=153944104, query='SELECT "inventoryid" ,"inventoryname" ,"tapenum" FROM "inventory" ORDER BY "inventoryid" '
[ fetched 570 rows ]
conn=153237224, query='SELECT "rentalid" ,"inventoryid" ,"obsolete" FROM "rentals" ORDER BY "inventoryid" '
[ fetched 163 rows ]
conn=153944104, SQLDisconnect
conn=153632808, query='SELECT
"rentalorderid","memberid","processedby","dateprocessed","shippedby","dateshipped","returnedby","shippinghandling","shownotes","notes","batchno"
FROM "rentalorders" WHERE "rentalorderid" = 847 OR "rentalorderid" = 848 OR "rentalorderid" = 849 OR "rentalorderid" =
850OR "rentalorderid" = 851 OR "rentalorderid" = 852 OR "rentalorderid" = 853 OR "rentalorderid" = 854 OR
"rentalorderid"= 855 OR "rentalorderid" = 856'
[ fetched 10 rows ]
conn=153632808, SQLDisconnect
conn=153237224, SQLDisconnect
- ------_
------------------------------
End of pgsql-interfaces-digest V1 #246
**************************************
