[ppa-help] [ phppgadmin-Bugs-1088321 ] Uploading an sql script fails

[SourceForge.net <no...@so...>]

Bugs item #1088321, was opened at 2004-12-20 18:58
Message generated for change (Comment added) made by chriskl
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=1088321&group_id=37132

Category: Import/Export
Group: 3.5.1
>Status: Closed
>Resolution: Later
Priority: 5
Submitted By: arthur (arthur654)
Assigned to: Nobody/Anonymous (nobody)
Summary: Uploading an sql script fails

Initial Comment:
Uploading an sql script fails with the following script:

-------------
/**
* MailFormControl
* 2004-07-14
*/

/**
* "form_form"
*/
CREATE TABLE "form_form" (
	"form_id"		char(32) 		NOT NULL,
	"created"		timestamptz		DEFAULT NOW(),
	"name"			varchar(100)	NOT NULL,
	CONSTRAINT "form_id_pkey" PRIMARY KEY ("form_id")
);

/**
* "form_line"
*/
-------------
When I use the textarea to execute the same sql it does
not fail.

I get the following errors:

Query Results

Warning: pg_query(): Query failed: ERROR: Unterminated
/* comment in
/opt/guide/www.movenext.net/HTML/SQL/Postgres3/classes/database/Postgres.php
on line 4113

Warning: pg_query(): Query failed: ERROR: parser: parse
error at or near "*" in
/opt/guide/www.movenext.net/HTML/SQL/Postgres3/classes/database/Postgres.php
on line 4113

Warning: pg_query(): Query failed: ERROR: parser: parse
error at or near "*" in
/opt/guide/www.movenext.net/HTML/SQL/Postgres3/classes/database/Postgres.php
on line 4113

Warning: pg_query(): Query failed: ERROR: parser: parse
error at or near "*/" in
/opt/guide/www.movenext.net/HTML/SQL/Postgres3/classes/database/Postgres.php
on line 4113

Warning: pg_query(): Query failed: ERROR: Unterminated
/* comment in
/opt/guide/www.movenext.net/HTML/SQL/Postgres3/classes/database/Postgres.php
on line 4113

Warning: pg_query(): Query failed: ERROR: parser: parse
error at or near "*" in
/opt/guide/www.movenext.net/HTML/SQL/Postgres3/classes/database/Postgres.php
on line 4113

Warning: pg_query(): Query failed: ERROR: parser: parse
error at or near "*/" in
/opt/guide/www.movenext.net/HTML/SQL/Postgres3/classes/database/Postgres.php
on line 4113

Warning: pg_query(): Query failed: ERROR: parser: parse
error at or near "" in
/opt/guide/www.movenext.net/HTML/SQL/Postgres3/classes/database/Postgres.php
on line 4113

Warning: pg_query(): Query failed: ERROR: parser: parse
error at or near """ in
/opt/guide/www.movenext.net/HTML/SQL/Postgres3/classes/database/Postgres.php
on line 4113

Warning: pg_query(): Query failed: ERROR: parser: parse
error at or near """ in
/opt/guide/www.movenext.net/HTML/SQL/Postgres3/classes/database/Postgres.php
on line 4113

Warning: pg_query(): Query failed: ERROR: parser: parse
error at or near """ in
/opt/guide/www.movenext.net/HTML/SQL/Postgres3/classes/database/Postgres.php
on line 4113

Warning: pg_query(): Query failed: ERROR: parser: parse
error at or near "CONSTRAINT" in
/opt/guide/www.movenext.net/HTML/SQL/Postgres3/classes/database/Postgres.php
on line 4113

Warning: pg_query(): Query failed: ERROR: parser: parse
error at or near ")" in
/opt/guide/www.movenext.net/HTML/SQL/Postgres3/classes/database/Postgres.php
on line 4113

Warning: pg_query(): Query failed: ERROR: Unterminated
/* comment in
/opt/guide/www.movenext.net/HTML/SQL/Postgres3/classes/database/Postgres.php
on line 4113

Warning: pg_query(): Query failed: ERROR: parser: parse
error at or near "*" in
/opt/guide/www.movenext.net/HTML/SQL/Postgres3/classes/database/Postgres.php
on line 4113

Warning: pg_query(): Query failed: ERROR: parser: parse
error at or near "*/" in
/opt/guide/www.movenext.net/HTML/SQL/Postgres3/classes/database/Postgres.php
on line 4113

SQL executed.

Total runtime: 12.857 ms

----------------------------------------------------------------------

>Comment By: Christopher Kings-Lynne (chriskl)
Date: 2004-12-22 09:32

Message:
Logged In: YES 
user_id=82305

Yes you are correct.  If you have a look at the faq,
unfortunately the sql upload feature does not support
multi-line sql statements. (Whereas the text area will.)

This is for various complicated technical reasons :)

We intend to work on that one of these days...

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=1088321&group_id=37132