I am currently using postgresql 8.3 and whenever I want to get the last
inserted ID use :
Select currval(pg_get_serial_sequence(table, field))
Then, I had to downgrade a database for certain customer to use postgresql
8.1, and when I execute that same function I found that
pg_get_serial_sequence
quot;Richard Broersma" <[EMAIL PROTECTED]>
>To: "Sebastian Rychter" <[EMAIL PROTECTED]>
>Cc: pgsql-sql@postgresql.org
>Subject: Re: Extremely Low performance with ODBC
>Message-ID:
><[EMAIL PROTECTED]>
>
>On Mon, May 26, 2008 at 9:34 PM, Sebas
thing like that before.
Thanks once again,
Sebastian
-Mensaje original-
De: Richard Broersma [mailto:[EMAIL PROTECTED]
Enviado el: Martes, 27 de Mayo de 2008 01:14 a.m.
Para: Sebastian Rychter
CC: pgsql-sql@postgresql.org
Asunto: Re: [SQL] Extremely Low performance with ODBC
On Mon, M
Title_ID" AND
"Patient"."City_ID"=PatientCity."City_ID" AND
"Patient"."Province_ID"=PatientProvince."Province_ID" AND
"Patient"."Country_ID"=PatientCountry.
ows=1 loops=1)
Hash Cond: ("PatientDoctorProvince"."Province_ID" =
"Patient"."DoctorProvince_ID")
-> Seq Scan on "Province" "PatientDoctorProvince" (cost=0.00..1.78 rows=78
width=4) (actual time=0.005..0.150 rows=78 loops=1)
->
oins the query only
takes 3 seconds (as with PgAdmin). I still can't understand if the problem
resides on the ODBC driver, the Query Planner or it's just a mix of both.
-Mensaje original-
De: Richard Broersma [mailto:[EMAIL PROTECTED]
Enviado el: Viernes, 23 de Mayo de 2008 01
Hi, I'm executing a query through psql ODBC which is taking around 2 minutes
to complete. When I run it from PgAdmin it takes less than 3 seconds.
The query itself has :
. 15 inner joins (from just around 10 different tables - the other inner
joins are using different aliases for the same tables)
Select
“order” from Table1
Thanks again.
De: Medi Montaseri [mailto:[EMAIL PROTECTED]
Enviado el: jueves, 21 de febrero de 2008 16:43
Para: Sebastian Rychter
CC: pgsql-sql@postgresql.org
Asunto: Re: [SQL] Data layer migration from MSSQL
I think the grammer should help the parser to
Hi, I'm working on migrating a data layer from MS SQL Server to PostgreSQL
8.2 and found that some reserved words should only be written between quotes
and thus are case sensitive (actually only happened with a table field named
"order"). Is there any way to bypass this case sensitivity or at leas
