[Gambas-user] DataSource Save and DataBrowser Find malfunktions
Gianluigi
gradobag at gradobag.it
Thu Aug 24 00:46:25 CEST 2023
Il 23/08/23 23:57, Benoît Minisini ha scritto:
>>
>> Thanks for the video. Can you try by setting 'DB.Debug = True' at
>> program start? I need that only for the MySQL case.
>>
>
> Can you try 'DB.Debug = True' with PostgreSQL too? Only when you save
> the date and you get the "Type mismatch error".
>
> Note that I don't have any error on my PostgreSQL here, strange!
>
> Regards,
>
Hi Benoit,
In addition to the mysql output, I also send you the postgres output,
see attachments.
The test user was created as follows:
CREATE ROLE test WITH CREATEDB CREATEROLE LOGIN ENCRYPTED PASSWORD 'test';
Since I'm doing the tests on a newly installed virtual machine, in
addition to the console output, I'm also attaching the bash history(*)
Now I'm going to sleep if we need more proof we'll update tomorrow
Good night
Gianluigi
(*)
tester at tester-VirtualBox:~$ history
1 sudo install dkms linux-headers-$(uname -r) build-essential
2 sudo adduser tester vboxsf
3 reboot
4 sudo adduser tester vboxsf
5 sudo apt install build-essential g++ automake autoconf libtool
libbz2-dev libzstd-dev libmysqlclient-dev unixodbc-dev libpq-dev
libsqlite0-dev libsqlite3-dev libglib2.0-dev libgtk2.0-dev
libcurl4-gnutls-dev libgtkglext1-dev libpcre3-dev libsdl-sound1.2-dev
libsdl-mixer1.2-dev libsdl-image1.2-dev libxml2-dev libxslt1-dev
librsvg2-dev libpoppler-dev libpoppler-private-dev libpoppler-glib-dev
libpoppler-cpp-dev libasound2-dev libdirectfb-dev libxtst-dev libffi-dev
libglew-dev libimlib2-dev libv4l-dev libsdl-ttf2.0-dev
libgdk-pixbuf2.0-dev linux-libc-dev libgstreamer1.0-dev
libgstreamer-plugins-base1.0-dev libcairo2-dev libgsl-dev
libncurses5-dev libgmime-3.0-dev llvm-dev llvm libalure-dev libgmp-dev
libgtk-3-dev libsdl2-dev libsdl2-mixer-dev libsdl2-ttf-dev
libsdl2-image-dev sane-utils libdumb1-dev libssl-dev libqt5opengl5-dev
libqt5svg5-dev libqt5webkit5-dev libqt5x11extras5-dev qtbase5-dev
qtwebengine5-dev libwebkit2gtk-4.0-dev git
6 git clone --depth=1 https://gitlab.com/gambas/gambas.git gambasdevel
7 cd gambasdevel
8 ./reconf-all && ./configure -C
9 make && LANG="C" sudo make install
10 sudo apt-get install postgresql postgresql-contrib
11 cd /etc/postgresql/14/main
12 sudo -u postgres vi pg_hba.conf
13 sudo service postgresql reload
14 psql -U postgres -d template1
15 sudo -u postgres vi pg_hba.conf
16 sudo service postgresql reload
17 psql -U postgres -d template1
18 sudo -u postgres vi pg_hba.conf (cambiato su md5)
19 sudo service postgresql reload
20 psql -U postgres -d template1
21 cd
22 sudo apt-get update
23 sudo apt-get upgrade
24 sudo apt-get install mysql-server
25 systemctl status mysql | grep 'Status' (Status: "Server is
operational")
26 sudo mysql
27 mysql -u root -p
28 cd gambasdevel
29 sudo make uninstall
30 cd
31 rm -rf olddevel/
32 mv gambasdevel olddevel
33 git clone --depth=1 https://gitlab.com/gambas/gambas.git gambasdevel
34 cd gambasdevel
35 ./reconf-all && ./configure -C
36 make && LANG="C" sudo make install
37 cd gambasdevel
38 sudo make uninstall
39 cd
40 rm -rf olddevel/
41 mv gambasdevel olddevel
42 git clone --depth=1 https://gitlab.com/gambas/gambas.git gambasdevel
43 cd gambasdevel
44 ./reconf-all && ./configure -C
45 make && LANG="C" sudo make install
46 history
-------------- next part --------------
Output della console:
2023-08-24 00:01:31.473 gb.db.mysql: 0x557fab135fe0: select version()
2023-08-24 00:01:31.478 gb.db.mysql: 0x557fab135fe0: set names 'utf8'
2023-08-24 00:01:31.479 gb.db.mysql: 0x557fab135fe0: show variables like 'character_set_client'
2023-08-24 00:01:31.489 gb.db.mysql: 0x557fab135fe0: drop database `dbflowers`
2023-08-24 00:01:31.539 gb.db.mysql: 0x557fab135fe0: create database `dbflowers`
2023-08-24 00:01:31.562 gb.db.mysql: 0x557fab138da0: select version()
2023-08-24 00:01:31.562 gb.db.mysql: 0x557fab138da0: set names 'utf8'
2023-08-24 00:01:31.562 gb.db.mysql: 0x557fab138da0: show variables like 'character_set_client'
2023-08-24 00:01:31.567 gb.db.mysql: 0x557fab138da0: START TRANSACTION
2023-08-24 00:01:31.567 gb.db.mysql: 0x557fab138da0: show tables
2023-08-24 00:01:31.570 gb.db.mysql: 0x557fab138da0: CREATE TABLE `t_flowers` ( `id_flower` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT , `name` VARCHAR(32), `date` DATETIME, PRIMARY KEY (`id_flower`) )
2023-08-24 00:01:31.645 gb.db.mysql: 0x557fab138da0: show full columns from `t_flowers`
2023-08-24 00:01:31.648 gb.db.mysql: 0x557fab138da0: INSERT INTO `t_flowers` ( `name`, `date` ) VALUES ( 'Akelei', '2019-06-04 00:00:00' )
2023-08-24 00:01:31.662 gb.db.mysql: 0x557fab138da0: INSERT INTO `t_flowers` ( `name`, `date` ) VALUES ( 'Augentrost', '1997-06-16 00:00:00' )
2023-08-24 00:01:31.678 gb.db.mysql: 0x557fab138da0: INSERT INTO `t_flowers` ( `name`, `date` ) VALUES ( 'Blutstroepfle', '2020-06-03 00:00:00' )
2023-08-24 00:01:31.695 gb.db.mysql: 0x557fab138da0: INSERT INTO `t_flowers` ( `name`, `date` ) VALUES ( 'Ranunkel', '2018-08-16 00:00:00' )
2023-08-24 00:01:31.705 gb.db.mysql: 0x557fab138da0: INSERT INTO `t_flowers` ( `name`, `date` ) VALUES ( 'Selaginella', '2009-09-02 00:00:00' )
2023-08-24 00:01:31.714 gb.db.mysql: 0x557fab138da0: INSERT INTO `t_flowers` ( `name`, `date` ) VALUES ( 'Sonnenblume', '2019-08-13 00:00:00' )
2023-08-24 00:01:31.723 gb.db.mysql: 0x557fab138da0: COMMIT
#Database successfully created!
Database is open = True
2023-08-24 00:01:31.746 gb.db.mysql: 0x557fab138da0: show tables
2023-08-24 00:01:31.748 gb.db.mysql: 0x557fab138da0: show index from `t_flowers`
2023-08-24 00:01:31.759 gb.db.mysql: 0x557fab138da0: SELECT COUNT(*) AS nRecord FROM `t_flowers`
2023-08-24 00:01:31.787 gb.db.mysql: 0x557fab138da0: SELECT COUNT(*) AS nRecord FROM `t_flowers`
2023-08-24 00:01:31.802 gb.db.mysql: 0x557fab138da0: SELECT `name`,`id_flower` FROM `t_flowers` ORDER BY `name`,`id_flower` LIMIT 256
2023-08-24 00:01:31.802 gb.db.mysql: 0x557fab138da0: SELECT * FROM `t_flowers` ORDER BY `name`,`id_flower` LIMIT 256
2023-08-24 00:01:55.880 gb.db.mysql: 0x557fab138da0: INSERT INTO `t_flowers` ( `name`, `date` ) VALUES ( 'Roses', NULL ) RETURNING `id_flower`
2023-08-24 00:02:21.855 gb.db.mysql: 0x557fab138da0: SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY `name`,`id_flower`) AS __index,* FROM `t_flowers`) AS __pg_sucks WHERE name = 'Ranunkel' LIMIT 1
Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM `t_flowers`) AS __pg_sucks WHERE name = 'Ranunkel' LIMIT 1' at line 1
Type mismatch: wanted Integer, got Function instead
Database is open = False
-------------- next part --------------
2023-08-24 00:15:55.880 gb.db.postgresql: 0x5579473f4e90: select version()
2023-08-24 00:15:55.889 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'bool'
2023-08-24 00:15:55.902 gb.db.postgresql: 0x5579473f4e90: --> 16
2023-08-24 00:15:55.902 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'int2'
2023-08-24 00:15:55.903 gb.db.postgresql: 0x5579473f4e90: --> 21
2023-08-24 00:15:55.903 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'int4'
2023-08-24 00:15:55.903 gb.db.postgresql: 0x5579473f4e90: --> 23
2023-08-24 00:15:55.903 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'int8'
2023-08-24 00:15:55.903 gb.db.postgresql: 0x5579473f4e90: --> 20
2023-08-24 00:15:55.903 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'numeric'
2023-08-24 00:15:55.904 gb.db.postgresql: 0x5579473f4e90: --> 1700
2023-08-24 00:15:55.904 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'float4'
2023-08-24 00:15:55.904 gb.db.postgresql: 0x5579473f4e90: --> 700
2023-08-24 00:15:55.904 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'float8'
2023-08-24 00:15:55.904 gb.db.postgresql: 0x5579473f4e90: --> 701
2023-08-24 00:15:55.904 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'abstime'
2023-08-24 00:15:55.904 gb.db.postgresql: 0x5579473f4e90: --> 0
2023-08-24 00:15:55.904 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'reltime'
2023-08-24 00:15:55.905 gb.db.postgresql: 0x5579473f4e90: --> 0
2023-08-24 00:15:55.905 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'date'
2023-08-24 00:15:55.905 gb.db.postgresql: 0x5579473f4e90: --> 1082
2023-08-24 00:15:55.905 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'time'
2023-08-24 00:15:55.905 gb.db.postgresql: 0x5579473f4e90: --> 1083
2023-08-24 00:15:55.906 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'timestamp'
2023-08-24 00:15:55.906 gb.db.postgresql: 0x5579473f4e90: --> 1114
2023-08-24 00:15:55.906 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'datetime'
2023-08-24 00:15:55.906 gb.db.postgresql: 0x5579473f4e90: --> 0
2023-08-24 00:15:55.906 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'timestamptz'
2023-08-24 00:15:55.906 gb.db.postgresql: 0x5579473f4e90: --> 1184
2023-08-24 00:15:55.906 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'bytea'
2023-08-24 00:15:55.907 gb.db.postgresql: 0x5579473f4e90: --> 17
2023-08-24 00:15:55.907 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'char'
2023-08-24 00:15:55.907 gb.db.postgresql: 0x5579473f4e90: --> 18
2023-08-24 00:15:55.907 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'bpchar'
2023-08-24 00:15:55.907 gb.db.postgresql: 0x5579473f4e90: --> 1042
2023-08-24 00:15:55.907 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'varchar'
2023-08-24 00:15:55.907 gb.db.postgresql: 0x5579473f4e90: --> 1043
2023-08-24 00:15:55.907 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'text'
2023-08-24 00:15:55.908 gb.db.postgresql: 0x5579473f4e90: --> 25
2023-08-24 00:15:55.908 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'name'
2023-08-24 00:15:55.908 gb.db.postgresql: 0x5579473f4e90: --> 19
2023-08-24 00:15:55.908 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'cash'
2023-08-24 00:15:55.908 gb.db.postgresql: 0x5579473f4e90: --> 0
2023-08-24 00:15:55.908 gb.db.postgresql: 0x5579473f4e90: show client_encoding
2023-08-24 00:15:55.909 gb.db.postgresql: 0x5579473f4e90: select datname from pg_database where (datallowconn = 't') and (datname = 'dbflowers')
2023-08-24 00:15:55.909 gb.db.postgresql: 0x5579473f4e90: select datname from pg_database where (datallowconn = 't') and (datname = 'dbflowers')
2023-08-24 00:15:55.910 gb.db.postgresql: 0x5579473f4e90: drop database "dbflowers"
2023-08-24 00:15:55.955 gb.db.postgresql: 0x5579473f4e90: select datname from pg_database where (datallowconn = 't') and (datname = 'dbflowers')
2023-08-24 00:15:55.961 gb.db.postgresql: 0x5579473f4e90: select datname from pg_database where (datallowconn = 't') and (datname = 'dbflowers')
2023-08-24 00:15:55.961 gb.db.postgresql: 0x5579473f4e90: create database "dbflowers"
2023-08-24 00:15:57.069 gb.db.postgresql: 0x5579473f4e90: select version()
2023-08-24 00:15:57.072 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'bool'
2023-08-24 00:15:57.073 gb.db.postgresql: 0x5579473f4e90: --> 16
2023-08-24 00:15:57.073 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'int2'
2023-08-24 00:15:57.074 gb.db.postgresql: 0x5579473f4e90: --> 21
2023-08-24 00:15:57.074 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'int4'
2023-08-24 00:15:57.075 gb.db.postgresql: 0x5579473f4e90: --> 23
2023-08-24 00:15:57.075 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'int8'
2023-08-24 00:15:57.075 gb.db.postgresql: 0x5579473f4e90: --> 20
2023-08-24 00:15:57.076 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'numeric'
2023-08-24 00:15:57.076 gb.db.postgresql: 0x5579473f4e90: --> 1700
2023-08-24 00:15:57.076 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'float4'
2023-08-24 00:15:57.077 gb.db.postgresql: 0x5579473f4e90: --> 700
2023-08-24 00:15:57.077 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'float8'
2023-08-24 00:15:57.077 gb.db.postgresql: 0x5579473f4e90: --> 701
2023-08-24 00:15:57.077 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'abstime'
2023-08-24 00:15:57.078 gb.db.postgresql: 0x5579473f4e90: --> 0
2023-08-24 00:15:57.078 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'reltime'
2023-08-24 00:15:57.078 gb.db.postgresql: 0x5579473f4e90: --> 0
2023-08-24 00:15:57.078 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'date'
2023-08-24 00:15:57.079 gb.db.postgresql: 0x5579473f4e90: --> 1082
2023-08-24 00:15:57.080 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'time'
2023-08-24 00:15:57.080 gb.db.postgresql: 0x5579473f4e90: --> 1083
2023-08-24 00:15:57.080 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'timestamp'
2023-08-24 00:15:57.080 gb.db.postgresql: 0x5579473f4e90: --> 1114
2023-08-24 00:15:57.080 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'datetime'
2023-08-24 00:15:57.080 gb.db.postgresql: 0x5579473f4e90: --> 0
2023-08-24 00:15:57.080 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'timestamptz'
2023-08-24 00:15:57.080 gb.db.postgresql: 0x5579473f4e90: --> 1184
2023-08-24 00:15:57.081 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'bytea'
2023-08-24 00:15:57.081 gb.db.postgresql: 0x5579473f4e90: --> 17
2023-08-24 00:15:57.081 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'char'
2023-08-24 00:15:57.081 gb.db.postgresql: 0x5579473f4e90: --> 18
2023-08-24 00:15:57.081 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'bpchar'
2023-08-24 00:15:57.081 gb.db.postgresql: 0x5579473f4e90: --> 1042
2023-08-24 00:15:57.082 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'varchar'
2023-08-24 00:15:57.082 gb.db.postgresql: 0x5579473f4e90: --> 1043
2023-08-24 00:15:57.082 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'text'
2023-08-24 00:15:57.082 gb.db.postgresql: 0x5579473f4e90: --> 25
2023-08-24 00:15:57.082 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'name'
2023-08-24 00:15:57.083 gb.db.postgresql: 0x5579473f4e90: --> 19
2023-08-24 00:15:57.083 gb.db.postgresql: 0x5579473f4e90: select oid from pg_type where typname = 'cash'
2023-08-24 00:15:57.083 gb.db.postgresql: 0x5579473f4e90: --> 0
2023-08-24 00:15:57.083 gb.db.postgresql: 0x5579473f4e90: show client_encoding
2023-08-24 00:15:57.083 gb.db.postgresql: 0x5579473f4e90: select datname from pg_database where datallowconn and (datname = 'dbflowers') and datistemplate
2023-08-24 00:15:57.084 gb.db.postgresql: 0x5579473f4e90: BEGIN
2023-08-24 00:15:57.084 gb.db.postgresql: 0x5579473f4e90: select relname from pg_class where (relkind in ('r', 'v', 'm', 'p')) and (relname = 't_flowers') and (relnamespace in (select oid from pg_namespace where nspname = 'public'))
2023-08-24 00:15:57.086 gb.db.postgresql: 0x5579473f4e90: CREATE TABLE "t_flowers" ( "id_flower" BIGSERIAL , "name" VARCHAR(32), "date" TIMESTAMP, PRIMARY KEY ("id_flower") )
2023-08-24 00:15:57.095 gb.db.postgresql: 0x5579473f4e90: select pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.atttypmod, pg_attribute.attnotnull, pg_get_expr(adbin, adrelid) AS adsrc, pg_attribute.atthasdef, pg_collation.collname from pg_class, pg_attribute LEFT JOIN pg_catalog.pg_attrdef ON (pg_attrdef.adnum = pg_attribute.attnum AND pg_attrdef.adrelid = pg_attribute.attrelid) LEFT JOIN pg_collation ON (pg_collation.oid = pg_attribute.attcollation) where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-24 00:15:57.098 gb.db.postgresql: 0x5579473f4e90: INSERT INTO "t_flowers" ( "date", "name" ) VALUES ( '2019-06-04 00:00:00', E'Akelei' )
2023-08-24 00:15:57.098 gb.db.postgresql: 0x5579473f4e90: INSERT INTO "t_flowers" ( "date", "name" ) VALUES ( '1997-06-16 00:00:00', E'Augentrost' )
2023-08-24 00:15:57.099 gb.db.postgresql: 0x5579473f4e90: INSERT INTO "t_flowers" ( "date", "name" ) VALUES ( '2020-06-03 00:00:00', E'Blutstroepfle' )
2023-08-24 00:15:57.099 gb.db.postgresql: 0x5579473f4e90: INSERT INTO "t_flowers" ( "date", "name" ) VALUES ( '2018-08-16 00:00:00', E'Ranunkel' )
2023-08-24 00:15:57.099 gb.db.postgresql: 0x5579473f4e90: INSERT INTO "t_flowers" ( "date", "name" ) VALUES ( '2009-09-02 00:00:00', E'Selaginella' )
2023-08-24 00:15:57.100 gb.db.postgresql: 0x5579473f4e90: INSERT INTO "t_flowers" ( "date", "name" ) VALUES ( '2019-08-13 00:00:00', E'Sonnenblume' )
2023-08-24 00:15:57.100 gb.db.postgresql: 0x5579473f4e90: COMMIT
#Database successfully created!
Database is open = True
2023-08-24 00:15:57.127 gb.db.postgresql: 0x5579473f4e90: select relname from pg_class where (relkind in ('r', 'v', 'm', 'p')) and (relname = 't_flowers') and (relnamespace in (select oid from pg_namespace where nspname = 'public'))
2023-08-24 00:15:57.130 gb.db.postgresql: 0x5579473f4e90: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-24 00:15:57.135 gb.db.postgresql: 0x5579473f4e90: select pg_attribute.attname from pg_class, pg_attribute where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-24 00:15:57.135 gb.db.postgresql: 0x5579473f4e90: select pg_attribute.attname from pg_class, pg_attribute where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'id_flower' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-24 00:15:57.136 gb.db.postgresql: 0x5579473f4e90: select pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.atttypmod, pg_attribute.attnotnull, pg_get_expr(adbin, adrelid) AS adsrc, pg_attribute.atthasdef, pg_collation.collname from pg_class, pg_attribute left join pg_attrdef on (pg_attrdef.adrelid = pg_attribute.attrelid and pg_attrdef.adnum = pg_attribute.attnum) left join pg_collation on (pg_collation.oid = pg_attribute.attcollation) where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'id_flower' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-24 00:15:57.138 gb.db.postgresql: 0x5579473f4e90: select pg_attribute.attname from pg_class, pg_attribute where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'name' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-24 00:15:57.139 gb.db.postgresql: 0x5579473f4e90: select pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.atttypmod, pg_attribute.attnotnull, pg_get_expr(adbin, adrelid) AS adsrc, pg_attribute.atthasdef, pg_collation.collname from pg_class, pg_attribute left join pg_attrdef on (pg_attrdef.adrelid = pg_attribute.attrelid and pg_attrdef.adnum = pg_attribute.attnum) left join pg_collation on (pg_collation.oid = pg_attribute.attcollation) where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'name' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-24 00:15:57.140 gb.db.postgresql: 0x5579473f4e90: select pg_attribute.attname from pg_class, pg_attribute where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'date' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-24 00:15:57.144 gb.db.postgresql: 0x5579473f4e90: select pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.atttypmod, pg_attribute.attnotnull, pg_get_expr(adbin, adrelid) AS adsrc, pg_attribute.atthasdef, pg_collation.collname from pg_class, pg_attribute left join pg_attrdef on (pg_attrdef.adrelid = pg_attribute.attrelid and pg_attrdef.adnum = pg_attribute.attnum) left join pg_collation on (pg_collation.oid = pg_attribute.attcollation) where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attname = 'date' and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-24 00:15:57.144 gb.db.postgresql: 0x5579473f4e90: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-24 00:15:57.146 gb.db.postgresql: 0x5579473f4e90: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-24 00:15:57.147 gb.db.postgresql: 0x5579473f4e90: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-24 00:15:57.151 gb.db.postgresql: 0x5579473f4e90: SELECT COUNT(*) AS nRecord FROM "t_flowers"
2023-08-24 00:15:57.153 gb.db.postgresql: 0x5579473f4e90: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-24 00:15:57.156 gb.db.postgresql: 0x5579473f4e90: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-24 00:15:57.168 gb.db.postgresql: 0x5579473f4e90: SELECT COUNT(*) AS nRecord FROM "t_flowers"
2023-08-24 00:15:57.178 gb.db.postgresql: 0x5579473f4e90: SELECT "name","id_flower" FROM "t_flowers" ORDER BY "name","id_flower" LIMIT 256
2023-08-24 00:15:57.179 gb.db.postgresql: 0x5579473f4e90: SELECT * FROM "t_flowers" ORDER BY "name","id_flower" LIMIT 256
2023-08-24 00:16:21.584 gb.db.postgresql: 0x5579473f4e90: select pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.atttypmod, pg_attribute.attnotnull, pg_get_expr(adbin, adrelid) AS adsrc, pg_attribute.atthasdef, pg_collation.collname from pg_class, pg_attribute LEFT JOIN pg_catalog.pg_attrdef ON (pg_attrdef.adnum = pg_attribute.attnum AND pg_attrdef.adrelid = pg_attribute.attrelid) LEFT JOIN pg_collation ON (pg_collation.oid = pg_attribute.attcollation) where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-24 00:16:21.586 gb.db.postgresql: 0x5579473f4e90: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
2023-08-24 00:16:21.589 gb.db.postgresql: 0x5579473f4e90: INSERT INTO "t_flowers" ( "date", "name" ) VALUES ( NULL, E'Roses' ) RETURNING "id_flower"
2023-08-24 00:16:21.611 gb.db.postgresql: 0x5579473f4e90: SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY "name","id_flower") AS __index,* FROM "t_flowers") AS __pg_sucks WHERE "id_flower" = 7 LIMIT 1
2023-08-24 00:16:21.613 gb.db.postgresql: 0x5579473f4e90: SELECT COUNT(*) AS nRecord FROM "t_flowers"
2023-08-24 00:16:21.614 gb.db.postgresql: 0x5579473f4e90: SELECT "name","id_flower" FROM "t_flowers" ORDER BY "name","id_flower" LIMIT 256
2023-08-24 00:16:21.614 gb.db.postgresql: 0x5579473f4e90: SELECT * FROM "t_flowers" ORDER BY "name","id_flower" LIMIT 256
2023-08-24 00:16:43.767 gb.db.postgresql: 0x5579473f4e90: SELECT * FROM "t_flowers" WHERE "id_flower" = 7
2023-08-24 00:16:43.768 gb.db.postgresql: 0x5579473f4e90: select pg_attribute.attname, pg_attribute.atttypid::int, pg_attribute.atttypmod, pg_attribute.attnotnull, pg_get_expr(adbin, adrelid) AS adsrc, pg_attribute.atthasdef, pg_collation.collname from pg_class, pg_attribute LEFT JOIN pg_catalog.pg_attrdef ON (pg_attrdef.adnum = pg_attribute.attnum AND pg_attrdef.adrelid = pg_attribute.attrelid) LEFT JOIN pg_collation ON (pg_collation.oid = pg_attribute.attcollation) where pg_class.relname = 't_flowers' and (pg_class.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_attribute.attnum > 0 and not pg_attribute.attisdropped and pg_attribute.attrelid = pg_class.oid
2023-08-24 00:16:43.770 gb.db.postgresql: 0x5579473f4e90: select pg_att1.attname, pg_att1.atttypid::int, pg_cl.relname from pg_attribute pg_att1, pg_attribute pg_att2, pg_class pg_cl, pg_index pg_ind, pg_class pg_table where pg_table.relname = 't_flowers' AND pg_table.oid = pg_att1.attrelid AND pg_cl.oid = pg_ind.indexrelid and (pg_cl.relnamespace in (select oid from pg_namespace where nspname = 'public')) and pg_ind.indisprimary and pg_att2.attrelid = pg_ind.indexrelid and pg_att1.attrelid = pg_ind.indrelid and pg_att1.attnum = pg_ind.indkey[pg_att2.attnum-1] order by pg_att2.attnum
Database is open = False
More information about the User
mailing list