Re: Help : Microsoft SQL Server equivalents in

I don't think he's looking for progress information, I think he is
looking to be able to insert in chunks, which I don't know much about,
but I think the some of the binary types (bytea or blob) support this.
Anyone?

Bruce Momjian wrote:
> 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.
>
> ---------------------------------------------------------------------------
>
> 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(dot)Faria(at)sun(dot)com
>> <mailto:Benedict(dot)Faria(at)sun(dot)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(dot)Faria(at)sun(dot)com
>> <mailto:Benedict(dot)Faria(at)sun(dot)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
>