Is there any way I can run the following code in the query
executer without creating a function for it?
FOR i IN 1..100 LOOP
PERFORM time_delay(1);
insert into worklist(startid, endid, cellid, campaignid,
status, claim, flastjob) values(1,2,3,4,5,\'mju\',CAST(1 as BIT));
END LOOP;
Just wondering if anyone has tried to use the MS Data Transformation
Services (DTS) to migrate data from other databases (Oracle etc) via ODBC. I
am considering looking into this as it looks promising due to the flexible
options it offers over the database migration wizard in PgAdmin.
thanks
dilan
Tom Lane wrote:
> > Charles Hornberger wrote:
> >> Just a quick follow-up to share one (!) data point, which looks to me
> >> like it indicates that SSL encryption/decryption is pretty expensive on
> >> one of our Sun Ultra 5 boxes. The following query ("select * from wp")
> >> generates ~270K o
> Charles Hornberger wrote:
>> Just a quick follow-up to share one (!) data point, which looks to me
>> like it indicates that SSL encryption/decryption is pretty expensive on
>> one of our Sun Ultra 5 boxes. The following query ("select * from wp")
>> generates ~270K of output. When executed vi
Charles Hornberger wrote:
> Bruce Momjian wrote:
> > Charles Hornberger wrote:
> >
> >>On Wed, 23 Jul 2003, Bruce Momjian wrote:
> >>
> >>>Charles Hornberger wrote:
> >>>
> Am I right in interpreting this to mean that I either have to use SSL
> all the time or none of the time? I'm espec
Bruce Momjian wrote:
Charles Hornberger wrote:
On Wed, 23 Jul 2003, Bruce Momjian wrote:
Charles Hornberger wrote:
Am I right in interpreting this to mean that I either have to use SSL
all the time or none of the time? I'm especially tempted to believe
this might be the case after seeing this
Hi,
I did'nt get any mail for this in pgsql-ports so mailing here.
I get the same error on 7.3.2 and on 7.3.3 .
Just tried to compile postgres 7.3.3 on Tru64 5.1 a pk 4
with
Compaq C V6.5-207 (dtk) on Compaq Tru64 UNIX V5.1A (Rev. 1885)
Compiler Driver V6.5-207 (dtk) (dtk) cc Driver
My co
hi everyone,
having read the online doc, and a book, i can't find precisely what i'm
looking for, but it's maybe normal here it is
I have a distant postgres database used to store networking info. This
database "may" be unavailable, so i need to have another postgres
database somewhere
> Whatever version of postgresql you WERE running is the same version you
> now need to BE running. I.e. if you were running 7.3.x, you should
> download 7.3.3 (or 7.3.4 if it's ready to go yet) and use THAT to get your
> database up and running. Postgresql won't run databases from different
