I managed to connect to a postgresql db through Access with ODBC. Does anyone know
what purpose the file $PGHOME/etc/odbcinst.ini serves? I removed it and all still
works. Everything it defines is more or less defined on the win side in the
configuration of the odbc driver.
TIA,
thalis
This returns an Attribute 'acquisition' not found error
SELECT trx_date,
store_id || rgstr_id || trx_num AS invoice,
substring(po_num from 1 for (position('/' in po_num) - 1)) AS po,
substring(po_num from (position('/' in po_num) + 1) for (char_length(po_num) -
Hi
On Thu, May 24, 2001 at 11:53:08AM -0400, Thalis A. Kalfigopoulos wrote:
http://www.ca.postgresql.org/ftpsite/odbc/versions/full/psqlodbc-07_01_0005.zip
Thanks for all, who helped me! But i have another quiestion - if i use ODBC interface,
will ERWin work with proprietary stuff of
Hi all,
I am running postgres7.1 and php4.0. When I do top while running my
query via browser I notice that the postmaster process takes up almost
100% of the CPU and this is just for one user. What would happen if
multiple users does the same search at the same time would the
postmaster die?
I have never had the postmaster die on me, although I have made is slow to
almost a halt ;)
Performance really depends what your doing. It is possible to write a
query that uses all system resources.
I recommend restarting postgres and take a look at the CPU utilization and
make sure at
Someone mentioned the OIDs are unique for every row for an entire database cluster. I
also notice that they are not being reused (like a sequence). Will they wrap around
as soon as the 2^32 boundary is hit?
TIA,
thalis
---(end of broadcast)---
Farid Hajji [EMAIL PROTECTED] writes:
How would you translate the following SELECT statements with
outer joins to PostgreSQL syntax?
SELECT ...
FROM tab1 alias_tab1, tab2 alias_tab2,
OUTER ot1 alias_ot1,
OUTER ot2 alias_ot2
WHERE ...
SELECT
FROM tab1 alias_tab1,
Hi,
I am trying to do a 2 joins between 3 tables.
ie)
select some field, coalesce(TRR.ABC, SOC.ABC) as newABC, ...
from A join (B join C on (..)) on (..)) as TRR
left join
(D join E on (..)) as SOC on (TRR.Field1=SOC.Field2)
When I run this it says that there is an ambiguous field.
I create the following table:
create table lala (id int,people varchar(10)[][]);
I insert as follows:
insert into lala values(1000,'{{1_1,1_2},{2_1,2_2}}');
Works just fine:
id | people
--+
1000 | {{1_1,1_2},{2_1,2_2}}
Then I insert:
Thalis A. Kalfigopoulos [EMAIL PROTECTED] writes:
Then I insert:
insert into lala values(1003,'{{1_1,1_2},{2_1}}');
IIRC, the array code is fairly buggy for non-rectangular arrays.
The array parser doesn't really do these correctly, and even if it
did, the *right* behavior IMHO would be to
Remembering past discussions: Yes OID's wrap around. When this happens,
they will not nesecarily be unique anymore. Apparently this should not
be a problem unless one has queries that specifically use OID's. INT8
OID's have been talked about and will probably be implemented some day.
Jeff
Hallo!
I made an debian update of postgresql, from 6.5.?? to 7.0.1. (?) ...
That worked fine. I then created my database and access user again,
started psql and created the database from the dump I have made some time
ago.
In fact, the database is created, all the table are there, empty, as I
datname datdbaencodingdatpath
courses 26 7 courses
Hum. Look ok to me.
I have tested with LATIN1 - LATIN5 and I haven't got any result...
I'd need the Spanish 'ñ' (that is what I insert)...
I'm still not understanding this, and it's vitally important to the
project I'm working on, so I have a question:
From my understanding, this:
UPDATE account SET value = 10 WHERE number = 99;
actually implies all of this:
BEGIN;
SELECT value FOR UPDATE FROM account WHERE number = 99;
UPDATE
Dr. Evil [EMAIL PROTECTED] writes:
From my understanding, this:
UPDATE account SET value = 10 WHERE number = 99;
actually implies all of this:
BEGIN;
SELECT value FOR UPDATE FROM account WHERE number = 99;
UPDATE account SET value = 10 WHERE number = 99;
COMMIT;
END;
Not really.
Hi everyone!
Thanks to various people for advice, including many answers from Vince
off-line while I was at home (whose address isn't a member of this mailing
list). I cleaned up my directories as best I could, downloaded the newest
versions of everything, and took various pieces of advice
Chris Bowlby [EMAIL PROTECTED] writes:
The configure script errors out looking
for _eprintf(), which apparently is a now deprecated GCC
attempt at a compatibility layer. This tells me I really
can't use the binary build made by the HP-UX porting archive
folks.
FWIW, I've seen eprintf link
On Thu, 24 May 2001, Abhimanyu_Bhola wrote:
check these links out for the odbc driver,
ftp://ftp.PostgreSQL.org/pub/odbc/
http://www.openlinksw.com.
Of course there's always http://odbc.postgresql.org
Vince.
--
==
18 matches
Mail list logo