Daniele Varrazzo avatar Daniele Varrazzo committed cfa5456

The prompt in psql must start with a non-blank character

Otherwise we are fooled by the arrows in the EXPLAIN output.

Comments (0)

Files changed (2)

pygments/lexers/postgres.py

         (r"[^\s]+", String.Symbol),
     ]
 
-re_prompt = re.compile(r'^.*?[=\-\(][#>]')
+re_prompt = re.compile(r'^(\S.*?)??[=\-\(][#>]')
 re_psql_command = re.compile(r'\s*\\')
 re_end_command = re.compile(r';\s*(--.*?)?$')
 re_psql_command = re.compile(r'(\s*)(\\.+?)(\s+)$')

tests/examplefiles/psql_session.txt

 regression=# ROLLBACK ;
 ROLLBACK
 
+=> EXPLAIN SELECT * FROM tenk1
+-> WHERE unique1 < 100;   -- Don't take -> in the plan as a prompt
+
+                                  QUERY PLAN
+------------------------------------------------------------------------------
+ Bitmap Heap Scan on tenk1  (cost=2.37..232.35 rows=106 width=244)
+   Recheck Cond: (unique1 < 100)
+   ->  Bitmap Index Scan on tenk1_unique1  (cost=0.00..2.37 rows=106 width=0)
+         Index Cond: (unique1 < 100)
+
+
 -- don't swallow the end of a malformed line
 test=> select 1,
 'this line must be emitted'
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.