500, Kevin Duffy wrote:
> > [...]
> > I have run into a very frustrating problem.
> >
> > I have a database with some tables which were loaded from Excel
> spreadsheets
> > via a Perl script. Guess that does not really matter. The table
> > definitions
Hello:
I have run into a very frustrating problem.
I have a database with some tables which were loaded from Excel spreadsheets
via a Perl script. Guess that does not really matter. The table
definitions
are below.
Both tables contain 9,398,340 rows
On a machine running Windows 7 64Bit with
Hello:
I am try to get a function to return the count of the rows updated within
the function.
As in the following, I wan the number of rows updated to be returned.
This is a simple update, other update statements that I need to write will
be complicated.
CREATE OR REPLACE FUNCTION est_idio_retu
From: Jonathan Schindler
Sent: Wednesday, November 11, 2009 9:58 AM
To: Kevin Duffy
Subject: upgrade to 8.4 with new character set
To those that know,
We originally built our database with a character set of SQL_ASCII. We
now know the error of our
onstraints and allow the new table structure to be created and then
populated with new data.
I have not changed the keys of existing records so that existing
relationships should be restored.
Thanks for considering my issue.
Kevin Duffy
error message was produced.
Strange.
Any suggestions.
Thanks in advance for your kind assistance.
Kevin Duffy
If you wish to copy from the client machine you can use \copy within
psql.
b
Kevin Duffy wrote:
> Hello:
>
>
>
> A follow up question that may clear this all up:
>
>
>
> Is the 'filename' relative to the server machine or the client where
> pgAdmin is
Hello:
A follow up question that may clear this all up:
Is the 'filename' relative to the server machine or the client where
pgAdmin is running?
Kevin Duffy
WR Capital Management
40 Signal Rd
Stamford, CT
203-504-6221
File(s) 1,300,220 bytes
0 Dir(s) 40,459,689,984 bytes free
C:\>
I have tried many variations of slashes and back-slashes, but nothing
works.
I am working within pgAdmin under Windows XP.
Please help me preserve my sanity. I do not see that I am doing wrong.
But I am certain it is very simple.
Best Regards
Kevin Duffy
Hello:
I am move to a new production server and am testing my backup and
restore procedures.
Given a backup created with the follow command
C:\>C:\progFiles\PostgreSQL\8.2\bin\pg_dump -Fc -b -C -o -f
E:\backupPostgres\benchxx_c20080912.backup -U postgres benchxx_c
What is the best w
ot;Index Cond: ($0 = securitytypekey)"
So this proves it is using the index.
But I think the issue is in the interaction between the numbers of rows
returned from positions_gsco and security.
kd
-Original Message-
From: Klint Gore [mailto:[EMAIL PROTECTED]
Sent: Thurs
ce and thus
allowing the index on security to be used.
And of couse '5' makes things simple. The index on security is used.
Am I posting this in the right. If not please help me correct my error
and point me to the correct spot.
Thanks for taking a look at my issue.
Best Regards
Kevin Duffy
from securitytype
where position (upper('|' || sectype_in || '|' ) in
upper(securitytypeaka) ) > 0;
--
-- did not find a type above
if sectypekey is NULL then
select securitytypekey into sectypekey
from securitytype
where upper(securitytypeshort) = 'UNKNOWN';
end if;
return sectypekey;
end
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION getsectypekey(sectype_in bpchar) OWNER TO postgres;
Kevin Duffy
13 matches
Mail list logo
