Postgres Pro
Downloads
Home   >   mailing lists

Thread: ecpg stuff

ecpg stuff

From
Michael Meskes
Date:
Could anyone please enable ecpg compilation in src/interfaces/Makefile again
as the CVS source now compiles flawlessly.

Anyway, I currently have a list of 5-6 open bugs in ecpg. So if anyone wants
to help, step forward. :-)

Joking aside, there is one bug or better missing feature that I need some
input on. Does anyone know what the standards say to the prepare command? Is
dynamic SQL a standard?

Michael
--
Dr. Michael Meskes, Project-Manager    | topsystem Systemhaus GmbH
meskes@topsystem.de                    | Europark A2, Adenauerstr. 20
meskes@debian.org                      | 52146 Wuerselen
Go SF49ers! Go Rhein Fire!             | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux!                  | Fax: (+49) 2405/4670-10

Re: [HACKERS] ecpg stuff

From
"Thomas G. Lockhart"
Date:
> Joking aside, there is one bug or better missing feature that I need some
> input on. Does anyone know what the standards say to the prepare command? Is
> dynamic SQL a standard?

Yes it is. I have the Date/Darwen book on the SQL standard, and can look up
answers in the book if you like...

                                                  - Tom

Re: [HACKERS] ecpg stuff

From
Michael Meskes
Date:
Thomas G. Lockhart writes:
> > Joking aside, there is one bug or better missing feature that I need some
> > input on. Does anyone know what the standards say to the prepare command? Is
> > dynamic SQL a standard?
>
> Yes it is. I have the Date/Darwen book on the SQL standard, and can look up
> answers in the book if you like...

Yes, I like that. Could you please also lookup:

- the whenever statement
- and check resp. tell me whether the cursor behaviour is correct. Currently
the declare statement is send to the backend via PQexec. The open statement
is ignored and the fetch is executed as fetch via PQexec. I think the data
shouldn't be processed before the cursor is opened. But I do not know
what PostgreSQL does with the declare command.

Michael

--
Dr. Michael Meskes, Project-Manager    | topsystem Systemhaus GmbH
meskes@topsystem.de                    | Europark A2, Adenauerstr. 20
meskes@debian.org                      | 52146 Wuerselen
Go SF49ers! Go Rhein Fire!             | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux!                  | Fax: (+49) 2405/4670-10

Re: [HACKERS] ecpg stuff

From
"Vadim B. Mikheev"
Date:
Michael Meskes wrote:
>
> - and check resp. tell me whether the cursor behaviour is correct. Currently
> the declare statement is send to the backend via PQexec. The open statement
> is ignored and the fetch is executed as fetch via PQexec. I think the data
> shouldn't be processed before the cursor is opened. But I do not know
> what PostgreSQL does with the declare command.

DECLARE: parser + optimizer + ExecutorStart (initializes plan nodes:
checks permissions, opens tables & indices).
Is OPEN statement in standard ?
If yes then we could call ExecutorStart() for the OPEN someday.

Vadim