Thread: RE: RE: [INTERFACES] ODBC merge module for Microsoft Insta ller

> -----Original Message-----
> From: Ross J. Reedstrom [mailto:reedstrm@rice.edu]
> Sent: 17 August 2001 17:12
> To: Postgres Interface List; 'pgsql-odbc@postgresql.org'
> Subject: Re: [ODBC] RE: [INTERFACES] ODBC merge module for
> Microsoft Installer
>
>
> On Fri, Aug 17, 2001 at 08:17:49AM +0100, Dave Page wrote:
> >
> >
> > > -----Original Message-----
> > > From: Ashley Clark [mailto:aclark@ghoti.org]
> > > Sent: 16 August 2001 19:09
> > > To: Postgres Interface List
> > > Subject: [INTERFACES] ODBC merge module for Microsoft Installer
> > >
> > >
> > > Could the ODBC developers create a merge module for Microsoft
> > > Installer?
> >
> > I could but this would mean I have yet another package to
> maintain -
> > would anyone else find this useful?
>
> Hmm, depends. I have to support some users of my database on
> Windows, using the ODBC driver.  So, What's a merge module?
> Or is it one of those things that if I need to ask, I don't need it?

Probably :-) A merge module is a file or group of files that can be included
in an installation. In the case of the ODBC driver, the merge module would
contain the dll, dependency files (if there were any) and the registry
mods/API calls required to install the driver. Someone writing their own
installer for an application would then just include the merge module in
their installation and not have to worry about it.

In your case Ross, you can automate installations on your users machines
using the existing 'msi' download. From your network logon script, use a
command like:

msiexec /qn \\pdc\netlogon\psqlodbc.msi REBOOT="ReallySuppress"

If you're interested, I have some Kixtart code that we use to auto
install/upgrade the installer and a bunch of standard tools on >100 PC's.

Regards, Dave.

Hi,

I'm running 6.5.2-1 on a RedHat 6.1 and I'm having trouble dropping a
sequence.

I get the following error:

 ERROR:  mdopen: couldn't open scotty_scottyid_seq: No such file or
 directory

when I try to recreate the sequence I get the following:

 gsheet=> create sequence scotty_scottyid_seq;
 ERROR:  Relation 'scotty_scottyid_seq' already exists

Any suggestions would be appreciated...

Thanks in advance,

Killian May
InfoSport Inc
killian.may@infosport.com
(902)423-0662 fax(902)423-0390

Killian May <kmay@infosport.com> writes:
> I'm running 6.5.2-1 on a RedHat 6.1

It's *way* past time to update.  7.1.3 is current PG release, and the
list of bugs fixed since 6.5.* would fill a book.

In the meantime, try 'touch'-ing $PGDATA/base/yourdb/scotty_scottyid_seq
and then doing DROP SEQUENCE.

            regards, tom lane