PostgreSQL installation errors [#204251]

Hi,
Not sure if this is a real bug, but I'll mention it. The first time I visited the url en/admin/settings/customfilter I got the following warnings:

warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT sid, name, description FROM customfilter_set WHERE 1=1 ORDER BY name in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT sid, name, description FROM customfilter_set WHERE 1=1 ORDER BY name in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.

I then proceeded to import the sample file and got these:

warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set_sid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_set_sid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set_sid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_set_sid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set_sid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_set_sid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: INSERT INTO customfilter_set (sid, name, cache, description, shorttips, longtips) VALUES(0, 'MediaWiki', 1, 'Allows user to use MediaWiki syntax (incomplete).', 'You can use MediaWiki syntax (incomplete).', 'You can use MediaWiki syntax. This filter is for demonstration purpose only, not a complete mediawiki parser.

You write	You get
''''italic''''	italic
''''''bold''''''	bold
''''''''''bold-italic''''''''''	*bold-italic*
=Heading 1= ==Heading 2== ===Heading 3===	Heading 1 Heading 2 Heading 3
(space)some preformatted text	some preformatted text
[http://drupal.org Drupal]	Drupal
* List 1 * List 2 ** List 2.1	List 1 List 2 List 2.1
# List 1 # List 2 ## List 2.1	List 1 List 2 List 2.1

'); in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: INSERT INTO customfilter_filter (fid, sid, parentid, name, description, matches, pattern, replacement, func, weight) VALUES(0, 0, 0, 'TOC', 'Table of Contents', 0, '/^/', 'if (is_array($vars->headings) && count($vars->headings) > 0) { $result = ''

''; $result .= ''

''; $lastlevel = 0; foreach ($vars->headings as $heading) { if ($heading[''level''] > $lastlevel) { for ($i = $heading[''level'']; $i > $lastlevel; $i--) { $result .= ''

''; } } elseif ($heading[''level''] < $lastlevel) { for ($i = $heading[''level'']; $i < $lastlevel; $i++) { $result .= ''

''; } } else { $result .= ''

''; } $result .= "

{$heading[''text'']}"; $lastlevel = $heading[''level'']; } for ($i = 0; $i < $lastlevel; $i++) $result .= ''

''; $result .= ''

''; } else $result = ''''; return $result;', 1, 10); in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.

The import did not warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set_sid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_set_sid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set_sid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_set_sid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set_sid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_set_sid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: INSERT INTO customfilter_set (sid, name, cache, description, shorttips, longtips) VALUES(0, 'MediaWiki', 1, 'Allows user to use MediaWiki syntax (incomplete).', 'You can use MediaWiki syntax (incomplete).', 'You can use MediaWiki syntax. This filter is for demonstration purpose only, not a complete mediawiki parser.

You write	You get
''''italic''''	italic
''''''bold''''''	bold
''''''''''bold-italic''''''''''	*bold-italic*
=Heading 1= ==Heading 2== ===Heading 3===	Heading 1 Heading 2 Heading 3
(space)some preformatted text	some preformatted text
[http://drupal.org Drupal]	Drupal
* List 1 * List 2 ** List 2.1	List 1 List 2 List 2.1
# List 1 # List 2 ## List 2.1	List 1 List 2 List 2.1

''; $result .= ''

''; $lastlevel = 0; foreach ($vars->headings as $heading) { if ($heading[''level''] > $lastlevel) { for ($i = $heading[''level'']; $i > $lastlevel; $i--) { $result .= ''

''; } } elseif ($heading[''level''] < $lastlevel) { for ($i = $heading[''level'']; $i < $lastlevel; $i++) { $result .= ''

''; } } else { $result .= ''

''; } $result .= "

{$heading[''text'']}"; $lastlevel = $heading[''level'']; } for ($i = 0; $i < $lastlevel; $i++) $result .= ''

''; $result .= ''

''; } else $result = ''''; return $result;', 1, 10); in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.

I didn't see any filter in the list after this.

Comment	File	Size	Author
#3	diff-5.x-1.2-dev.txt	3.02 KB	kohlerj

Comments

Comment #1

kohlerj commented 27 December 2007 at 19:45

Umm... apologies for the formatting. I'll use Preview in future :-/ .

Comment #2

arhip commented 1 January 2008 at 09:13

Please try again with the newest development snapshot.

Comment #3

kohlerj commented 5 January 2008 at 10:51

Status	File	Size
new	diff-5.x-1.2-dev.txt	3.02 KB

I tried the latest development snapshot on my existing db and didn't have any problems. However, before that I managed to modify the .install to add support for pgsql through trial and error. One difference between what I did and the dev version is CREATE SEQUENCE (see attached). I'll try to use dev on a clean db, but for now I'm content.

Comment #4

avpaderno

he/him

Italian

Brescia, 🇮🇹 🇪🇺

commented 1 July 2009 at 15:31

Status:

Active

» Fixed

I am setting this report as fixed because it has been fixed in the development snapshot.

Comment #5

avpaderno

he/him

Italian

Brescia, 🇮🇹 🇪🇺

commented 1 July 2009 at 15:31

Title:

First use warnings with pgsql

» PostgreSQL installation errors

Comment #6

15 July 2009 at 15:40

Status:

Fixed

» Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

PostgreSQL installation errors

Heading 2

Heading 3

Table of contents

Heading 2

Heading 3

Table of contents

Comments

Comment #1

Comment #2

Comment #3

Comment #4

Comment #5

Comment #6

News items

Our community

Documentation

Drupal code base

Governance of community