Forums / Install & configuration / Making PgSQL 7.3 work

Making PgSQL 7.3 work

Next topic

Author	Message
Christoph Nelles	Saturday 08 February 2003 6:15:29 am i haven´t tried it yet, but i think, probably you can make ezpublish work with pgsql 7.3 without changing the code of ezpublish. i don´t know know whether it really works, but i think you could use a trigger for every table which corrects the queries. unluckily i have no experience with triggers, all my tries ended with a syntax error :(

Author

Message

Saturday 08 February 2003 6:15:29 am

i haven´t tried it yet, but i think, probably you can make ezpublish work with pgsql 7.3 without changing the code of ezpublish.

i don´t know know whether it really works, but i think you could use a trigger for every table which corrects the queries. unluckily i have no experience with triggers, all my tries ended with a syntax error :(

eZ debug

Timing:

Jan 30 2025 07:29:51

Script start

Timing:

Jan 30 2025 07:29:51

Module start 'content'

Timing:

Jan 30 2025 07:29:51

Module end 'content'

Timing:

Jan 30 2025 07:29:51

Script end

Main resources:

Total runtime

0.3612 sec

Peak memory usage

8,192.0000 KB

Database Queries

141

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0112	587.9531	370.2969
Module start 'content'	0.0113	0.0160	958.2500	997.3281
Module end 'content'	0.0272	0.3339	1,955.5781	3,885.5703
Script end	0.3612		5,841.1484

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0112

587.9531

370.2969

Module start 'content'

0.0113

0.0160

958.2500

997.3281

Module end 'content'

0.0272

0.3339

1,955.5781

3,885.5703

Script end

0.3612

5,841.1484

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0045	1.2561	20	0.0002
Check MTime	0.0013	0.3693	20	0.0001
Mysql Total
Database connection	0.0014	0.3834	1	0.0014
Mysqli_queries	0.2546	70.4857	141	0.0018
Looping result	0.0016	0.4364	139	0.0000
Template Total	0.3335	92.3	1	0.3335
Template load	0.0011	0.3051	1	0.0011
Template processing	0.3324	92.0210	1	0.3324
Override
Cache load	0.0007	0.2027	1	0.0007
Sytem overhead
Fetch class attribute can translate value	0.0020	0.5429	1	0.0020
XML
Image XML parsing	0.0005	0.1345	1	0.0005
General
dbfile	0.0103	2.8627	20	0.0005
String conversion	0.0000	0.0020	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0045

1.2561

0.0002

Check MTime

0.0013

0.3693

0.0001

Mysql Total

Database connection

0.0014

0.3834

0.0014

Mysqli_queries

0.2546

70.4857

141

0.0018

Looping result

0.0016

0.4364

139

0.0000

Template Total

0.3335

92.3

0.3335

Template load

0.0011

0.3051

0.0011

Template processing

0.3324

92.0210

0.3324

Override

Cache load

0.0007

0.2027

0.0007

Sytem overhead

Fetch class attribute can translate value

0.0020

0.5429

0.0020

XML

Image XML parsing

0.0005

0.1345

0.0005

General

dbfile

0.0103

2.8627

0.0005

String conversion

0.0000

0.0020

0.0000

Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

Cache	Type	Packlevel	SourceFiles
	CSS	0	extension/community/design/community/stylesheets/ext/jquery.autocomplete.css extension/community_design/design/suncana/stylesheets/scrollbars.css extension/community_design/design/suncana/stylesheets/tabs.css extension/community_design/design/suncana/stylesheets/roadmap.css extension/community_design/design/suncana/stylesheets/content.css extension/community_design/design/suncana/stylesheets/star-rating.css extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css extension/community_design/design/suncana/stylesheets/buttons.css extension/community_design/design/suncana/stylesheets/tweetbox.css extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css extension/sevenx/design/simple/stylesheets/star_rating.css extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css extension/sevenx/design/simple/stylesheets/main.v02.css extension/sevenx/design/simple/stylesheets/main.v02.res.css
	JS	0	extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js extension/community_design/design/suncana/javascript/jquery.ui.core.min.js extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js extension/community_design/design/suncana/javascript/jquery.easing.1.3.js extension/community_design/design/suncana/javascript/jquery.ui.tabs.js extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js extension/community_design/design/suncana/javascript/jquery.popmenu.js extension/community_design/design/suncana/javascript/jScrollPane.js extension/community_design/design/suncana/javascript/jquery.mousewheel.js extension/community_design/design/suncana/javascript/jquery.cycle.all.js extension/sevenx/design/simple/javascript/jquery.scrollTo.js extension/community_design/design/suncana/javascript/jquery.cookie.js extension/community_design/design/suncana/javascript/ezstarrating_jquery.js extension/community_design/design/suncana/javascript/jquery.initboxes.js extension/community_design/design/suncana/javascript/app.js extension/community_design/design/suncana/javascript/twitterwidget.js extension/community_design/design/suncana/javascript/community.js extension/community_design/design/suncana/javascript/roadmap.js extension/community_design/design/suncana/javascript/ez.js extension/community_design/design/suncana/javascript/ezshareevents.js extension/sevenx/design/simple/javascript/main.js

Cache

Type

Packlevel

SourceFiles

CSS

extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css

extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Usage

Requested template

Template

Template loaded

Edit

Override

pagelayout.tpl

<No override>

extension/sevenx/design/simple/templates/pagelayout.tpl

Number of times templates used: 1
Number of unique templates used: 1

Time used to render debug report: 0.0001 secs