Re: Help : Microsoft SQL Server equivalents in

Bruce Momjian schrieb:
> Sorry, I know of no way to get a status bar that shows how far the an
> INSERT or COPY has progressed.  People have asked for it, but no one has
> any idea how to implement it.

Well but thats aparently not the case here anyway. Fileupload is
something different from looking how far a single insert proceeds.
using lo and just counting the write chunks should at least work.
When using bytea or text, he could probably use a function to
send parts of the big string at a time where the function just
concenates whats in the field + whats sent in the chunk.
Probably not the performantest approach but should work.


>
> ---------------------------------------------------------------------------
>
> Benedict Faria wrote:
>> Hello,
>> my customer, ntl:Telewest is using an open source 'file upload progress
>> bar' called NeatUpload to help users to upload video files to a MS SQL
>> database. They want to replace the MS SQL database with
>> Solaris/PostgreSQL and ZFS.
>>
>> There is an extension to NeatUpload that enables this to work with MS
>> SQL Server. I emailed the author of this extension to ask how easy it
>> would be to replace MS SQL Server with PostgreSQL. His reply (below)
>> suggests that I need to use a postgreSQL equivalent for "Updatetext" and
>> "ReadText" in MS SQL Server. Any pointers on what the PostgreSQL
>> equivalent is?
>>
>> Many thanks.
>>
>> ------------------------------- forwarded email
>> ------------------------------------------------
>> Hi Benedict,
>> Re: NeatUpload SqlServerInputFile Extension with PostGres in Solaris 10.
>>
>> In my implementation of SqlServerInputFile I use the commands
>> "updatetext" and "readtext", which are as far as I know Microsoft SQL
>> Server specific. If there is an equivalent in postgresql you could use
>> that instead.
>>
>> If there is no equivalent commands, it is possible to use "standard" SQL
>> to do the same task (i.e. writing chunks of a file to a database) but
>> there is no such code in my code at this point.
>>
>> If you indend to rewrite the code so that it works, look at the
>> SqlServerBlobStream class, and the functions GenerateReadCommand and
>> GenerateWriteCommand. They aer the ones responsible, and has to be
>> rewritten using neutral SQL language. To make the file upload work you
>> really only need to fix "GenerateWriteCommand".
>>
>> If you manage to make it work I'd love to take a look at it! I've never
>> used postGreSQL, although I've read quite a lot about it. I think I even
>> have some 6 months old installation files here somewhere I never had
>> time to use... ;)
>> Any further questions, please ask.
>> Best regards / med v?nlig h?lsning
>> Joakim Wennergren, Hitone Nordic AB
>> Tel: +46 8 556 18 754, Fax: +46 8 556 18 755, Mobile: +46 70 191 42 59
>>
>>
>> On 1/17/07, *Benedict Faria* <Benedict.Faria@sun.com
>> <mailto:Benedict.Faria@sun.com>> wrote:
>>
>>     Joakim,
>>     I have a requirement to upload content to a PostGres database on Solaris
>>     10 instead of a Microsoft SQL database. PostGres is an open source SQL
>>     database. See  http://www.postgresql.org/ <http://www.postgresql.org/>
>>
>>      From the documentation at
>>     http://www.brettle.com/NeatUpload-1.2/docs/Manual.html#SqlServerInputFile
>>     I don't envisage any issues with doing this, but I though I'd email you
>>     to confirm. Could you help?
>>     Many thanks.
>>     Benedict.
>>
>>     ---------------------------------------------------------------------
>>     Benedict Faria
>>     Engagement Architect, Client Solutions - Comms & Media
>>     ---------------------------------------------------------------------
>>     Sun Microsystems Computers,  Tel  : +44 (0)207-256-3200 (Switchboard)
>>     Regis House,                      : +44 (0)207-469-9725 (Direct line)
>>     55 King William Street,      Fax  : +44 (0)207-469-9910
>>     London,                      Mob  : +44 (0)7711-053-822
>>     EC4R 9AD.                    Email: Benedict.Faria@sun.com
>>     <mailto:Benedict.Faria@sun.com>
>>     --------------------------------------------------------------------
>>     Network with peers, keep pace with technology :
>>     Technical community: http://www.sun.com/boardroom
>>     Executive community: http://www.sun.com/innercircle
>>     "The box said 'Windows Server 2003 or better', so I installed Solaris10"
>>
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 5: don't forget to increase your free space map settings
>