| Author |
Error Dropping a Publication
|
|
| Chance 2005-05-12, 1:24 pm |
| if exec_sql( "IF EXISTS (SELECT * FROM sys.syspublication WHERE
publication_name ='Booklog') THEN DROP PUBLICATION Booklog ;END IF;" ) < 0
then Halt Close
I am having a problem dropping a publication. Here's my code. Background,
the function exec_sql takes a SQL string and executes it immediately. I am
getting this error:
Primary key for row in table 'SYSPUBLICATION' is referenced by foreign key
'SYSPUBLICATION' in table 'SYSYNC'
I don't understand. The help seems straightforward.(DROP PUBLICATION
Booklog) Can someone please let me know how to drop a publication?
tia,
chance.
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-05-12, 1:24 pm |
| There's a foreign key between SYSSYNC and SYSPUBLICATION. You can't drop a
publication while there are Synchronization subscriptions that point to the
publication.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
"Chance" <chance@booklog.com> wrote in message news:428397aa@forums
-1-dub...
> if exec_sql( "IF EXISTS (SELECT * FROM sys.syspublication WHERE
> publication_name ='Booklog') THEN DROP PUBLICATION Booklog ;END IF;" ) < 0
> then Halt Close
>
> I am having a problem dropping a publication. Here's my code. Background,
> the function exec_sql takes a SQL string and executes it immediately. I am
> getting this error:
>
> Primary key for row in table 'SYSPUBLICATION' is referenced by foreign key
> 'SYSPUBLICATION' in table 'SYSYNC'
>
> I don't understand. The help seems straightforward.(DROP PUBLICATION
> Booklog) Can someone please let me know how to drop a publication?
>
> tia,
> chance.
>
>
| |
| Chance 2005-05-12, 1:24 pm |
| Nevermind. I figuired it out. I didn't give it an owner name when I created
it.
"Chance" <chance@booklog.com> wrote in message news:428397aa@forums
-1-dub...
> if exec_sql( "IF EXISTS (SELECT * FROM sys.syspublication WHERE
> publication_name ='Booklog') THEN DROP PUBLICATION Booklog ;END IF;" ) < 0
> then Halt Close
>
> I am having a problem dropping a publication. Here's my code. Background,
> the function exec_sql takes a SQL string and executes it immediately. I am
> getting this error:
>
> Primary key for row in table 'SYSPUBLICATION' is referenced by foreign key
> 'SYSPUBLICATION' in table 'SYSYNC'
>
> I don't understand. The help seems straightforward.(DROP PUBLICATION
> Booklog) Can someone please let me know how to drop a publication?
>
> tia,
> chance.
>
>
| |
| Chance 2005-05-12, 1:24 pm |
| Do you mean that I have to drop the subscription first?
"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
wrote in message news:42839ad0$1@foru
ms-1-dub...
> There's a foreign key between SYSSYNC and SYSPUBLICATION. You can't drop
> a
> publication while there are Synchronization subscriptions that point to
> the
> publication.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> "Chance" <chance@booklog.com> wrote in message
> news:428397aa@forums
-1-dub...
>
>
|
|
|
|